max_allowed_packets automatically resetting

[s...@retrose.org]

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?

[Andrew Dixon]

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 - mso - Lucee Association Member

--
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/ce99047d-5983-4059-8043-8b4f7df11022%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.