The error message from Mysql suggests a timeout when running the sql. It could be that otrs starts a transfer, then does something else (like smtp) and then finnishes off the sql bits. - Are -

-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Laurent GALAIS Sent: 7. desember 2005 21:02 To: User questions and discussions about OTRS.org; User questions and discussions about OTRS.org Subject: RE: [otrs] Mysql error when trying to attach file to an outgoing email

Thanks for responding Chris,

Well easy, I try to answer a case or Create a new ticket email and 'browse' to find my so called 'big' attachement. When I click to 'attach', the page refreshes and the attachement is added, no error message on the current. If I go to system log, I see the error message ...

It is very annoying but I'm not desperate ... I just need to remember not to use an attachment that is more than 1.36 :o)

Maybe a limitation of Mysql as on my test server I have Mysql 3.23 ... Thanks again !

Laurent

At 01:40 PM 12/7/2005, Christopher Machler wrote:

...

I wouldn't call it a lie, I would call it a feature I did not know. How do you do it?

Chris Machler Systems Administrator 7 Entin Road Parsippany, NJ 07054 Office (800) 840-1035 x426 Fax 973-206-0805 www.castlepointmortgage.com

-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Laurent GALAIS Sent: Tuesday, December 06, 2005 6:15 PM To: otrs@otrs.org Subject: [otrs] Mysql error when trying to attach file to an outgoing email

Hello,

When I try to attach the following file to an email I'm writing: dec_runner.tgz -> 1.36 Mo

I'm getting the following error from OTRS syslog:

Tue Dec 6 16:34:05 2005 error OTRS-CGI-10 MySQL server has gone away, SQL: 'INSERT INTO web_upload_cache (form_id, filename, content_type, content_size, content, create_time_unix) VALUES ('1133908128.9245177.63404565', 'dec_runner.tgz', 'application/x-compressed', '1433600', ?, 1133908445)'

I've configured OTRS to send email using SMTP instead of sendmail even though I'm using Linux, but when I send a test email using the same SMTP config from my email client, it works ... so I know it is not a limitation on that part. I've tried enough different file size and type to make sure it is a size limitation pb apparently ...

I've been through the documentation, sysconfig setup and google Search and haven't found any equivalent errors or parameter.

Does someone has any idea ?

Laurent GALAIS Four J's Development Tools 866 314 7300 x305 www.fourjs.com

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

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

---

...

CONFIDENTIALITY NOTICE: This e-mail contains privileged and

confidential

...

information intended only for the use of the individual named above or Castle Point Mortgage, Inc. If the reader of this e-mail is not the intended recipient, you are hereby notified that any retention, dissemination or copying of this e-mail is strictly prohibited. If you have received this notice in error, please immediately notify the sender by telephone at the above number and delete the original e-mail from your system.

Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.

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

Laurent GALAIS Four J's Development Tools 866 314 7300 x305 www.fourjs.com

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