StorageDB configuration
Hi, Our OTRS system uses the default Kernel::System::Ticket::ArticleStorageDB (because apache does not run as otrs), and I would like to be able to store larger tickets than the default. OTRS doc says i have to use max_allowed_packet=8M in mysql configuration. I have created (following MySQL doc) a file named my.cnf containing : -- [mysql] set-variable = max_allowed_packet=8M -- The file is located in the mysql data dir. I have restarted mysqld and apache, but i still get a "Got a packet bigger than 'max_allowed_packet'" error in OTRS logs when i send a mail with a large attachement. I have tried to place the file in /etc/my.cnf , and in ~otrs/.my.cnf but I still get the same error. Has anyone tried to tweak this ? Is it a mysql or otrs issue ? Thanks, Brice
Hi Brice, On Wed, Feb 18, 2004 at 02:02:25PM +0100, Brice Levy wrote:
Our OTRS system uses the default Kernel::System::Ticket::ArticleStorageDB (because apache does not run as otrs), and I would like to be able to store larger tickets than the default. OTRS doc says i have to use max_allowed_packet=8M in mysql configuration. I have created (following MySQL doc) a file named my.cnf containing : -- [mysql] set-variable = max_allowed_packet=8M -- The file is located in the mysql data dir. I have restarted mysqld and apache, but i still get a "Got a packet bigger than 'max_allowed_packet'" error in OTRS logs when i send a mail with a large attachement. I have tried to place the file in /etc/my.cnf , and in ~otrs/.my.cnf but I still get the same error. Has anyone tried to tweak this ? Is it a mysql or otrs issue ?
Normally /etc/my.cnf works (in my cases). If not, maybe this helps you: http://www.mysql.com/documentation/mysql/bychapter/manual_Using_MySQL_Progra...
Thanks, Brice
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
Hi Martin,
Normally /etc/my.cnf works (in my cases). I found out that /etc/my.cnf works, and the other ways too. What's more, the default on my system is 16Mbytes, which is quote enough for our needs : -- $ mysql --help | grep packet max_allowed_packet current value: 16777216 --
Alas, I still get the 'packet bigger than' error in OTRS logs for a 2.6Mbytes file (the otrs-1.1.3-01.tar.gz archive, actually :) I have been trying with mysql : mysql Ver 12.17 Distrib 4.0.10-gamma, for portbld-freebsd4.8 (i386) mysql Ver 11.18 Distrib 3.23.56, for portbld-freebsd5.1 (i386) on different servers, both have a default value of 16777216 for max_allowed_packet, and both give the same error
Martin Edenhofer
Brice
participants (2)
-
Brice Levy -
Martin Edenhofer