I had the same issue for quite a while, I finally figured out that I was using the wrong syntax in my my.cnf file. Once I got that right the problem was cured. Since it seems others may have the same problem, here is what my file looks like:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = max_allowed_packet=8M [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid My error was that I wasn't using the set-variable part. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brice Levy Sent: Thursday, February 19, 2004 10:06 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] StorageDB configuration Hi again, I finally found out why it did not work, and how to have it work. It seems (on both systems I've tried) that options files are read by mysql client, but not by mysql server. Hence, mysql --help reported the value I wanted to set, but mysql server still used the default 1Mbyte value ... don't ask me why :-) running mysqld_safe with --max_allowed_value=8M in the command line did the trick : # mysqladmin -p variables | grep packet Enter password: | max_allowed_packet | 8387584 and sending a bigger file now works, though I can't use an option file to achieve it. Brice _______________________________________________ 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/ _______________________________________________ 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/
