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

Raed El - Hames r at elhames.co.uk
Thu Feb 17 18:55:21 EST 2005


>Got a packet bigger than 'max_allowed_packet' at

This is mysql error, you can adjust the allowed attachement size in my.cnf
usually in /etc/mysql

Roy

----- Original Message ----- 
From: "Arnd Steinbrecher" <arnd at invers.com>
To: <rt-users at lists.bestpractical.com>
Sent: Thursday, February 17, 2005 12:57 PM
Subject: [rt-users] Problems with big attachments >1MB rt 3.4.1


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

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

RT Administrator and Developer training is coming to your town soon!
(Boston, San Francisco, Austin, Sydney) Contact training at bestpractical.com
for details.

Be sure to check out the RT Wiki at http://wiki.bestpractical.com




More information about the rt-users mailing list