Oops! I mangled the line from my Config.pm. It's actually:

$Self->{TicketStorageModule} = 'Kernel::System::Ticket::ArticleStorageFS';

(as it would need to be) On Dec 4, 2008, at 2:44 PM, Ari Epstein wrote:

Hi,

I wanted to switch from using ArticleStorageDB to ArticleStorageFS to reduce the size of my Mysql database and support arbitrarily large e-mails. I follow the instructions and add the following to / etc/otrs/Kernel/Config.pm:

[...] $Self->{TicketStorageModule} = 'Kernel::System::Ticket::ArticleStorageDB'; [...]

Then I try sending a large file and this appears in the syslog:

Dec 4 13:23:13 xen1 OTRS-PM-10[20223]: [Error] [Kernel::System::Ticket::ArticleStorageDB::ArticleWritePlain][Line: 203]: Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO article_plain (article_id, body, create_time, create_by, change_time, change_by) VALUES (4039, ?, current_timestamp, 1, current_timestamp, 1)' Dec 4 13:23:14 xen1 OTRS-PM-10[20223]: [Error] [Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment] [Line:265]: Got a packet bigger than 'max_allowed_packet' bytes, SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content_size, content, create_time, create_by, change_time, change_by) VALUES (4039, '20081023.mp3', 'audio/mpeg \; name=20081023.mp3', '19000240', ?, current_timestamp, 1, current_timestamp, 1)'

Any idea why ArticleStorageDB is still being used? I'm stumped.

-Ari

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs