RE: [otrs] StorageDB configuration
Try adding the following to you my.cnf set-variable = max_allowed_packet=20M That's what we use (on a Windows MySQL 4.x installation). Thomas
-----Original Message----- From: Brice Levy [mailto:brice.levy@6wind.com] Sent: Thursday, February 19, 2004 2:08 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] StorageDB configuration
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
_______________________________________________ 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/
DISCLAIMER: This message contains information that may be privileged or confidential and is the property of the Roxar Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorised to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
Hi Thomas,
Try adding the following to you my.cnf set-variable = max_allowed_packet=20M
I've added the following lines to /etc/my.cnf [mysql] set-variable = max_allowed_packet=20M It seems to be ok for mysql : $ mysql --help | grep packet max_allowed_packet current value: 20970496 But it looks like otrs does not take this parameter in count. I don't know how I could test it with another application that uses mysql client.
Thomas
Thanks for help, Brice
Hi Brice, On Thu, Feb 19, 2004 at 02:31:40PM +0100, Brice Levy wrote:
Try adding the following to you my.cnf set-variable = max_allowed_packet=20M
I've added the following lines to /etc/my.cnf [mysql] set-variable = max_allowed_packet=20M
It seems to be ok for mysql : $ mysql --help | grep packet max_allowed_packet current value: 20970496
But it looks like otrs does not take this parameter in count. I don't know how I could test it with another application that uses mysql client.
No, OTRS tries to insert the attachment but the database returnes the error. However, max_allowed_packet is working in any other cases (I never heard that this isn't working). Maybe you have 2 mysql server or it's the wrong machine or something like that.
Thanks for help, Brice
Martin Edenhofer -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
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
participants (3)
-
Brice Levy -
Martin Edenhofer -
Thomas Nilsen