Nagios Support Forum

Posted: **Fri Apr 15, 2016 1:52 am**

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

Posted: **Fri Apr 15, 2016 11:00 am**

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.

Posted: **Mon Apr 18, 2016 2:50 am**

Thank you,

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

Posted: **Mon Apr 18, 2016 8:45 am**

Hi again,

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

Nagios Support Forum

NagiosXI loses connection to MySQL

NagiosXI loses connection to MySQL

Re: NagiosXI loses connection to MySQL

Re: NagiosXI loses connection to MySQL

Re: NagiosXI loses connection to MySQL