
Hi, Can somebody please tell me how to adjust the max_allowed_packet setting please for MySQL, it is currently set to 0MB and I need to change it to 8MB Thanks Rosanna

use your my.cnf file that should be in /etc and put the line max_allowed_packet=20M in [mysqld] section. Then restart mysql On Tue, Sep 15, 2009 at 2:55 PM, Marretta, Rosanna < Rosanna.Marretta@yrclogistics.com> wrote:
Hi,
Can somebody please tell me how to adjust the max_allowed_packet setting please for MySQL, it is currently set to 0MB and I need to change it to 8MB
Thanks
Rosanna
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Hi
Thanks for your quick reply.
I don't know MySQL too well, can you please advise where I will find the
/etc folder please?
Thanks
Rosanna
________________________________
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Marco Vannini
Sent: 15 September 2009 13:59
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Max_Allowed_Packet
use your my.cnf file that should be in /etc and put the line
max_allowed_packet=20M
in [mysqld] section.
Then restart mysql
On Tue, Sep 15, 2009 at 2:55 PM, Marretta, Rosanna

Mmmm unix or windows ? On Tue, Sep 15, 2009 at 3:29 PM, Marretta, Rosanna < Rosanna.Marretta@yrclogistics.com> wrote:
Hi
Thanks for your quick reply.
I don't know MySQL too well, can you please advise where I will find the /etc folder please?
Thanks Rosanna
------------------------------ *From:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf Of *Marco Vannini *Sent:* 15 September 2009 13:59 *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Max_Allowed_Packet
use your my.cnf file that should be in /etc and put the line max_allowed_packet=20M
in [mysqld] section.
Then restart mysql
On Tue, Sep 15, 2009 at 2:55 PM, Marretta, Rosanna < Rosanna.Marretta@yrclogistics.com> wrote:
Hi,
Can somebody please tell me how to adjust the max_allowed_packet setting please for MySQL, it is currently set to 0MB and I need to change it to 8MB
Thanks
Rosanna
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
--------------------------------------------------------------------- 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
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/

Hi,
You don´t realy need to know where it is, just type in your console the
following 'vi /etc/my.cnf' and thean type 'i' and write the line in the
config file. Now close and write the file with ':wq'
Or you can do the following cd /etc to go to that dir. Than vi or nano
my.cnf
Mit freundlichen Grüßen / Kind regards
Markus Moj
IT Infrastructure & Services
TimoCom Soft- und Hardware GmbH
In der Steele 2
D-40599 Düsseldorf
Tel: +49 211 88 26 80 14
Fax: +49 211 88 26 70 14
eMail: MMoj@TimoCom.com
www.TimoCom.com
Geschäftsführer: Jens Thiermann, Gunther Matzaitis
Amtsgericht Düsseldorf, HRB 34489
From: "Marretta, Rosanna"

See the following... http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID=50 &CategoryID=4&ItemID=50 _____ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Tuesday, September 15, 2009 8:55 AM To: otrs@otrs.org Subject: [otrs] Max_Allowed_Packet Hi, Can somebody please tell me how to adjust the max_allowed_packet setting please for MySQL, it is currently set to 0MB and I need to change it to 8MB Thanks Rosanna

Thank you all, I have solved this now. Thanks you for your help. Rosanna ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of LQ Marshall Sent: 15 September 2009 14:35 To: 'User questions and discussions about OTRS.' Subject: Re: [otrs] Max_Allowed_Packet See the following... http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&CategoryID=4&ItemID= 50 ________________________________ From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Marretta, Rosanna Sent: Tuesday, September 15, 2009 8:55 AM To: otrs@otrs.org Subject: [otrs] Max_Allowed_Packet Hi, Can somebody please tell me how to adjust the max_allowed_packet setting please for MySQL, it is currently set to 0MB and I need to change it to 8MB Thanks Rosanna
participants (4)
-
LQ Marshall
-
Marco Vannini
-
Marretta, Rosanna
-
MMoj@timocom.com