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

[Priddy, John]

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 at rt etc]$ cat /etc/my.cnf 
[mysqld]
set-variable = max_allowed_packet=16M


-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Raed El - Hames
Sent: Thursday, February 17, 2005 6:55 PM
To: Arnd Steinbrecher; rt-users at 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

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