NagiosXI loses connection to MySQL

[KPoulsen]

Hi,
After upgrading to 5.2.7 my Nagios loses connection to MySQL every few minutes.
I tried running the repair_databases.sh pr request of GUI when connection is lost, but to no prevail.

I would rather not have to roll back to an earlier backup, but I am at a loss on how to proceed.

I attached the profile from admin -> system profile.

Hope any of you have any idea how to get the system stable again

Regards
Kevin

[ssax]

Looks like you're getting too many connections:

Code: Select all

mysql_pconnect(): Too many connections

Try editing your /etc/my.cnf and under the [mysqld] section set:

Code: Select all

max_connections=500

Restart the services:

Code: Select all

service nagios stop
service ndo2db stop
service mysqld restart
service ndo2db start
service nagios start

Let us know if that resolves the issue for you.

[KPoulsen]

Thank you,

I have implemented the changes and so far so good.
I'll be back later with a final verdict

[KPoulsen]

Hi again,

Nagios have been running all day with no missing connection to MySQL.
Thank you and this topic can be marked as resolved