XI DB Connection Error on OPS Screen

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
blariv
Posts: 190
Joined: Wed Sep 26, 2012 11:55 am

XI DB Connection Error on OPS Screen

Post by blariv »

hi getting this error intermittently, not sure what is happening.

Could not connect to the database!

it automatically reconnects though.

Brian
dwasswa

Re: XI DB Connection Error on OPS Screen

Post by dwasswa »

Hi @blariv,

Are you monitoring the DB locally or its a remote?

The reason why i am asking is to see if its a network issue or not because you mentioned that it disconnects and reconnects itself right?
blariv
Posts: 190
Joined: Wed Sep 26, 2012 11:55 am

Re: XI DB Connection Error on OPS Screen

Post by blariv »

it is local. this is the actual db for the ops screen, not something I am monitoring.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: XI DB Connection Error on OPS Screen

Post by scottwilkerson »

you may need it increase your max-connection for mysqld

If you edit your /etc/my.cnf

You can add the following under the [mysqld] sectio

Code: Select all

max-connections=500
Then restart mysqld

Code: Select all

service mysqld restart
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
dwasswa

Re: XI DB Connection Error on OPS Screen

Post by dwasswa »

blariv
Posts: 190
Joined: Wed Sep 26, 2012 11:55 am

Re: XI DB Connection Error on OPS Screen

Post by blariv »

added, I will monitor today and let you know if its fixed.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: XI DB Connection Error on OPS Screen

Post by scottwilkerson »

blariv wrote:added, I will monitor today and let you know if its fixed.
Sounds great let us know if the error returns.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
Locked