Problems with big attachments >1MB rt 3.4.1

RT Users
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

2

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

RoyFrom: “Arnd Steinbrecher” arnd@invers.com
To: rt-users@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@bestpractical.com
for details.

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

3

I don’t know about suse, but on RHEL3 after a rpm -e and install of the mysql4 my.cnf had to be manually created under /etc. Have you tried creating that file restarting mysql?

[jpriddy@rt etc]$ cat /etc/my.cnf
[mysqld]
set-variable = max_allowed_packet=16MFrom: rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Raed El - Hames
Sent: Thursday, February 17, 2005 6:55 PM
To: Arnd Steinbrecher; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Problems with big attachments >1MB rt 3.4.1

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

From: “Arnd Steinbrecher” arnd@invers.com
To: rt-users@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

4

I am using FC3 and the config file is located in /etc.

/etc/my.cnf
[mysqld]
set-variable = max_allowed_packet=16M

I think you may use “rpm -ql MySQL-server” to locate your my.cnf file.

Arnd Steinbrecher wrote: