
Try something like this in /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_allowed_packet=32M You may also need to adjust the otrs config variables to match (example from 1.3.2): $Self->{PostMasterPOP3MaxEmailSize} = 1024 * 8; -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Varsani, Rajendrakumar (PSD) Sent: Friday, December 16, 2005 9:09 AM To: User questions and discussions about OTRS.org Subject: [otrs] MySQL Max Packet Size Apologies for asking a MySQL question, but it's what we use on the back end of OTRS 1.2.3. How do we set the MaxPacketSize to be greater than the default 1Mb and persist after bootup? Otherwise, anything over 1Mb gets stuck in the Mailbox. We did increase it but on a recent reboot, it's defaulted to 1Mb again. Sorry, I'm not a MySQL nor a Linux expert. Rajendrakumar Premji Varsani BSc (Hons) ____________________________________ Database & Application Support Team Telephone: 01904 45 5805 Mobile: 07968 243125 rajendrakumar.varsani@psd.defra.gsi.gov.uk Room134, Mallard House, PSD, Kings Pool, York, YO1 7PX PSD Website: http://www.pesticides.gov.uk 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/ This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
participants (1)
-
Seigafuse, Mike