Hi Chris, thanks a lot. This should solve the problem. I think this should be described in the installation instructions for otrs as I guess it is a common problem. Comments?
Lars > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Chris Salter > Sent: Tuesday, October 21, 2003 2:21 PM > To: 'User questions and discussions about OTRS.' > Subject: RE: [otrs] Problem with large attachment (3-4mb) > > > Lars, > > I ran into the same problem. It turned out to be a MySQL > setting problem. I'm including the message I sent when I > fixed it. It hasn't been a problem since. > > ------- > > I changed the max_allowed_packet setting in MySQL. It > apparently is set to > 1MB by default. I changed it to 10M. We'll see. > > I don't have a copy of the specific email that crashed it, > but I did send an > email with the same attachment that the other one had. It > picked it up > fine, no error message, no beeping. :-) > > ------- > > The problem is caused by OTRS trying to send too much data > at once to MySQL, which then chokes on it. By fixing the > max_allowed_packet setting, MySQL can handle more data at > once. Check the MySQL manual for where to put the setting. > > Hope this helps! > > -- > Chris Salter > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Lars Monsees > Sent: October 21, 2003 5:30 AM > To: Otrs (E-Mail) > Subject: [otrs] Problem with large attachment (3-4mb) > > > Hello, > > a customer sent a mail with a zip file attached. The file > is about 3-4mb and the maximum allowed upload size is the > default 5mb. > The cronjob PostmasterPOP3.pl sends the following message > (see below). > > As the mail wasn�t properly downloaded it got downloaded > every time the cronjob ran until I manually downloaded the mail. > > > Could this be a timeout problem with the mysql-server? > > Regards, > Lars > > > > DBD::mysql::db do failed: MySQL server has gone away at > /opt/otrs/Kernel/System/DB.pm line 172. > ERROR: OTRS-PM3-10 Perl: 5.8.0 OS: linux Time: Tue Oct 21 > 10:50:21 2003 > > Message: MySQL server has gone away, SQL: 'INSERT INTO > article_plain (article_id, body, create_time, create_by, > change_time, change_by) VALUES (648, 'Return-Path: > <[EMAIL PROTECTED]> > Received: from mailout08.sul.xxxxx.com > (mailout08.sul.t-online.com [194.25.134.20]) by xxxxxx.net > (8.10.2/8.10.2) with ESMTP id h9L87MM28500 for > <[EMAIL PROTECTED]>; Tue, 21 Oct 2003 10:07:22 +0200 > Received: from fwd00.aul.xxxxxx by mailout08.sul.xxxxx > with smtp id 1ABrZj-0005A8-00; Tue, 21 Oct 2003 10:09:07 +0200 > Received: from MMPWS04 > ([EMAIL PROTECTED] > 7.228.12.94]) by fmrl00.sul.xxxxx with smtp id > 1ABrUW-1b40OW0; Tue, 21 Oct 2003 10:03:44 +0200 > Message-Id: <[EMAIL PROTECTED]> > From: "xxxxx xxxx" <[EMAIL PROTECTED]> > To: "xxxxx" <[EMAIL PROTECTED]> > References: <[EMAIL PROTECTED]> > Subject: Re: [Ticket#: 2003102110000015] Re: Mailbox-Fehler > Date: Tue, 21 Oct 2003 10:01:40 +0200 > MIME-Version: 1.0 > Content-Type: multipart/mixed; > boundary="----=_NextPart_000_000B_01C397BA.52942E60" > X-Priority: 3 > X-Msmail-Priority: Normal > X-Mailer: Microsoft Outlook Express 6.00.2600.0000 > X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000 > X-Seen: false > X-Id: > [EMAIL PROTECTED] > Status: U > > This is a multi-part message in MIME format. > > ------=_NextPart_000_000B_01C397BA.52942E60 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: 8bit > > (snip) > > ----- Original Message ----- > From: "EasyBuyer" <[EMAIL PROTECTED]> > To: "Stratos Kamitsos" <[EMAIL PROTECTED]> > Sent: Tuesday, October 21, 2003 9:28 AM > Subject: [Ticket#: 2003102110000015] Re: Mailbox-Fehler > > > (snip) > > > ------=_NextPart_000_000B_01C397BA.52942E60 > Content-Type: application/x-zip-compressed; > name="mailbox.zip" > Content-Transfer-Encoding: base64 > Content-Disposition: attachment; > filename="mailbox.zip" > > UEsDBBQAAAAIAHRPVS+5P0Qt/voxAABwAwULAAAAbWFpbGJveC5tZGLsnQt > 0HNV5gP+ZnX3NPmYl > y8Iv4sXm6Vhm9cCWAdNdvbCFZFl+4Ch2bUnelb3osUKSjYyxJUxepOcktKE > NUAKlTZvQk6ShkJwS > > > (snip) > (the zip file) > > AhYLFAAAAAgAdE9VL7k/RC3++jEAAHADBQsAAAAAAAAAAAAgAICBAAAAAG1 > haWxib3gubWRiUEsF > BgAAAAABAAEAOQAAACf7MQAAAA== > > ------=_NextPart_000_000B_01C397BA.52942E60-- > > ', current_timestamp, 1, current_timestamp, 1)' > > Traceback (26066): > Module: > Kernel::System::Ticket::ArticleStorageDB::WriteArticlePlain > (v1.9.2.1) Line: 101 > Module: Kernel::System::PostMaster::FollowUp::Run > (v1.27.2.1) Line: 97 > Module: Kernel::System::PostMaster::Run (v1.31.2.3) Line: 178 > Module: main::FetchMail (v1.9.2.2) Line: 169 > Module: /opt/otrs/bin/PostMasterPOP3.pl (v1.9.2.2) Line: 106 > > DBD::mysql::db do failed: MySQL server has gone away at > /opt/otrs/Kernel/System/DB.pm line 172. > Invalid conversion in sprintf: "%\313" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%^" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\033" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\230" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\312" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\363" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\350" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\244" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%`" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\025" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%_" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%Z" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\341" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%+" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%$" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\236" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\371" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\357" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%W" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\375" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%?" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\277" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\331" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\246" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Use of uninitialized value in sprintf at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\375" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\217" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\217" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\217" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\377" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\217" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\235" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Invalid conversion in sprintf: "%\325" at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > Modification of a read-only value attempted at > /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Sys/Syslog.pm > line 287. > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support oder Consulting f�r Ihr OTRS System? >
<<winmail.dat>>
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting f�r Ihr OTRS System? => http://www.otrs.de/
