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

[Stephen Fung]

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