[rt-users] Problems with big attachments >1MB rt 3.4.1

[Arnd Steinbrecher]

If i send attachmants > 1MB to my rt system, it drops them.
I got in /var/log/messages:
>Feb 17 10:05:50 ticket RT: DBD::mysql::st execute failed: Got a packet bigger than 'max_allowed_packet' at
>/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 480.  (/opt/rt3/lib/RT.pm:277)
>Feb 17 10:05:50 ticket RT: RT::Handle=HASH(0x973b9a4) couldn't execute the query 'INSERT INTO Attachments (Subject, ContentType,
>Filename, Headers, Creator, Parent, Created, ContentEncoding, Content, TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
>/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 494.  (/opt/rt3/lib/RT.pm:277)
>Feb 17 10:05:50 ticket RT: Attachment insert failed - Got a packet bigger than 'max_allowed_packet'
>(/opt/rt3/lib/RT/Attachment_Overlay.pm:207)

I leaved untoched in RT_SiteConfig:
># For mysql and oracle, we set this size at 10 megabytes.
># If you're running a postgres version earlier than 7.1, you will need
># to drop this to 8192. (8k)
>
>Set($MaxAttachmentSize , 10000000);

Anyone know where to set the 'max_allowed_packet' option?
I guessed it may be a mysql option, but i can't find a configfile for
mysql (searched "my.cnf").
Got rpms MySQL-server-4.0.23-0.i386 and MySQL-shared-4.0.23-0.i386
installed and run it with "rcmysql start".

I use rt-3.4.1 on Suse 9.2 with Apache 1.3.33 and mod_perl 1.29


-- 
Mit freundlichen Grüßen
Arnd Steinbrecher
Invers GmbH