[rt-users] Loosing >1Mb attachments

[Len Rose]

Hi.. 

Make sure you add an option to mysql startup defining this
option: -O max_allowed_packet=4M (whatever you need) otherwise
mysql will reject the transaction.

See the mysql manual for more details.


On Thu, Jul 25, 2002 at 01:18:59PM -0600, Nathan Evans wrote:
> Hello All.
> I'm running RT 2.0.13 on a RedHat 7.0. Whenever an attachment over 1MB
> is sent, it gets silently stripped off of the email (or Update.html
> page).
> 
> According to config.pm, attachments up to 10Mb should be accepted and
> not silently stripped:
> $MaxAttachmentSize = 10000000;
> $TruncateLongAttachments = undef;
> $DropLongAttachments = undef;
> 
> 
> Here is what I see in the RT logs
> 
> 
> Error Log snippet
> ------------------------------------------------------------
> RT::Action::Notify=HASH(0x9b25458): To is
> <ticketOwner>@fedex.comRT::Action::Notify=HASH(0x9b25458): Cc is
> RT::Action::Notify=HASH(0x9b
> 25458): Bcc is RT::Transaction=HASH(0x9a02598): Prepared NotifyOwner
> RT::Transaction=HASH(0x9a02598): Committed NotifyOwner
> DBD::mysql::st execute failed: MySQL server has gone away at
> /usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 3
> 20.
> RT::Handle=HASH(0x981c8c0) couldn't execute the query 'INSERT INTO
> Attachments (Creator, ContentEncoding, Filename, ContentType
> , Subject, TransactionId, Headers, Content, Created, Parent) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?)'MySQL server has gone away
> now requiring RT::Condition::AnyTransaction
> RT::Transaction=HASH(0x9933a38): Checking condition OnComment...
> ------------------------------------------------------------
> 
> Any Ideas?
> 
> Nathan Evans
> FedEx Services, InfoSec
> 
>  
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 185 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20020725/48a15512/attachment.sig>