Hi, see this lists for answers on your mysql-question. I think you have to increase max_allowed_packet within /etc/my.cfg, but see the mysql-docs for details. Bye, Alex Varsani, Rajendrakumar (PSD) schrieb:
OK I worked out how to increase the limits in OTRS by utilising the following chat contents:
# PostMasterPOP3MaxSize # (max. email size) $Self->{PostMasterPOP3MaxEmailSize} = 1024 * 12;
But now I seem have reached the limits of the defaults in MySQL. How do I permenantly set the limit of max_allowed_packet to be larger?
Thu Jun 22 15:50:38 2006 error OTRS-PM3-10 Got a packet bigger than 'max_allowed_packet', SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content, create_time, create_by, change_time, change_by) VALUES (33135, 'RAM FAA2v4.104.pdf', 'application/octet -stream\; name="RAM FAA2v4.104.pdf"', '%PDF-1.3
Thanks again!
======================================================================== =====
I'm very confused. Some things get through that are 9Mb or so big but when I send an item that is 5Mb I get this in the system log and OTRS refuses to collect it:
Thu Jun 22 14:56:02 2006 error OTRS-PM3-10 Can't fetch email 3 from OTRSHelp@exchange. Email to big (8032 KB - max 6144 KB)!
Any help appreciated
Rajendrakumar Varsani Tel: 01904 455805 Department for Environment, Food and Rural Affairs (Defra)
This email and any attachments is intended for the named recipient only. If you have received it in error you have no authority to use, disclose, store or copy any of its contents and you should destroy it and inform the sender. Whilst this email and associated attachments will have been checked for known viruses whilst within Defra systems we can accept no responsibility once it has left our systems. Communications on Defra's computer systems may be monitored and/or recorded to secure the effective operation of the system and for other lawful purposes. _______________________________________________ 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 orr consulting for your OTRS system? =http://www.otrs.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 orr consulting for your OTRS system? =http://www.otrs.com/