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’
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