1. Home
  2. Knowledge Base
  3. Problems (EN)
  4. Pandora FMS shuts down and I get errors with “MySQL has gone away” in my logs

Pandora FMS shuts down and I get errors with “MySQL has gone away” in my logs

Edit your my.cnf (Main config file of MySQL) and alter the following parameters:

 wait_timeout = 40000
 connect_timeout = 40000
 interactive_timeout = 40000
 max_allowed_packet =32M

If you’re using PHP 4.3 or higher (or you’re not sure), with the console, edit config_process.php‘, and alter the mysql_pconnect() line statement to mysql_connect()‘.

For some reason PHP 5.3 DOES NOT LIKE persistent connections and this makes MySQL act very silly when it comes to timeouts, resulting in errors with “has gone away”.

In some systems with several physical servers or a lot of threads the tserver table could generate some lock downs. To avoid that, just alter the type of table, using this SQL syntax:

UPDATE tserver engine = MyISAM;
Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support