Personally, I agree. I know there have been at least 3 people know who've been affected by it. It seems like a relatively simple item to mention; in the MySQL configuration section, it should take no more than a paragraph to explain it, and it would likely make everyone's life a little easier. :-) -- Chris Salter -----Original Message----- From: Lars Monsees [mailto:otrs-bounces@otrs.org]On Behalf Of Lars Monsees Sent: October 21, 2003 8:49 AM To: User questions and discussions about OTRS. Subject: RE: [otrs] Problem with large attachment (3-4mb) 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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On 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: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org]On 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: 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 ; 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 (bdBNZYZvYe23tR-gZx-z4vMrASSq+9O8bOOcYf9RshVZqIqckCfD8I@[21 7.228.12.94]) by fmrl00.sul.xxxxx with smtp id 1ABrUW-1b40OW0; Tue, 21 Oct 2003 10:03:44 +0200 Message-Id: <000e01c397a9$93207170$fe78a8c0@MMPWS04> From: "xxxxx xxxx" To: "xxxxx" References: <1066721282.876073.298426512.168.2@www.xxxxx.de> 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: bdBNZYZvYe23tR-gZx-z4vMrASSq+9O8bOOcYf9RshVZqIqckCfD8I@t-dialin.net 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" To: "Stratos Kamitsos" 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?