Max_allowed_packets automatically resetting

Hi all, I may be throwing a hail mary here, but I am pulling my hair out.

First, the setup:
Ubuntu14.04
MySQL 5.6.x
Lucee 4.5.3.018
Apache
Tomcat
Mura CMS

The problem:
MySQL’s max_allowed_packet is randomly resetting to 1024 every day or so,
which is taking down the site I have it set to a much higher value in
my.conf. I have googled until my head began to explode, and most posts on
this topic come down to being hacked and changing the root password. Done.
No luck. Someone asked if there might be something in Lucee that is
resetting it, so I am bringing this to this group.

Any ideas?

Hi,

How are you setting the max_allowed_packet size? If you are not setting in
your my.cnf then it will not last past a restart or reload of the MySQL
config. In the [mysqld] section of your my.cnf file add:

max_allowed_packet=[size-you-want]

That should sort it.
Kind regards,

Andrew
about.me http://about.me/andrew_dixon - mso http://www.mso.net - Lucee
Association Member http://lucee.orgOn 27 June 2016 at 07:21, <@sd1> wrote:

Hi all, I may be throwing a hail mary here, but I am pulling my hair out.

First, the setup:
Ubuntu14.04
MySQL 5.6.x
Lucee 4.5.3.018
Apache
Tomcat
Mura CMS

The problem:
MySQL’s max_allowed_packet is randomly resetting to 1024 every day or so,
which is taking down the site I have it set to a much higher value in
my.conf. I have googled until my head began to explode, and most posts on
this topic come down to being hacked and changing the root password.
Done. No luck. Someone asked if there might be something in Lucee that
is resetting it, so I am bringing this to this group.

Any ideas?


Win a ticket to dev.objective from Lucee via Twitter, see
http://bit.ly/1UbTMWj for details, good luck and see you there…

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/ce99047d-5983-4059-8043-8b4f7df11022%40googlegroups.com
https://groups.google.com/d/msgid/lucee/ce99047d-5983-4059-8043-8b4f7df11022%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.