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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
[EMAIL PROTECTED]
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.
_______________________________________________
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/
