Page 1 of 1

Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Wed Nov 06, 2013 6:53 pm
by msfhr
I am getting following error message when trying to login to NagiosXI.
DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed
CPU jumped to 80x normal usage, npcd process leading the pack.

Tried repairing the database as per http://assets.nagios.com/downloads/nagi ... tabase.pdf but no go. I didn't get SQL error message after I started Nagios again so I didn't proceed further.

Centos 6.4x64 (virtual), Nagios (latest one forgot the version and can't retrieve it now as it's down), MySQL (mysql-server-5.1.69-1.el6_4.x86_64)

Re: Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Thu Nov 07, 2013 10:46 am
by slansing
Can you run the following and try accessing the interface again?:

Code: Select all

service httpd restart
service postgresql restart

Re: Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Thu Nov 07, 2013 12:22 pm
by msfhr
Thanks for help slansing, that was it. It looks like postrgresql was stoppped. Does nagios uses two different db servers (mysql, postgresql)?

Re: Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Thu Nov 07, 2013 12:47 pm
by tmcdonald
That is correct. MySQL is used for object data, postgres is used for user data.

Re: Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Thu Nov 07, 2013 12:57 pm
by msfhr
thank you guys

Re: Nagios crashed: DB Connect Error [nagiosxi]:

Posted: Thu Nov 07, 2013 12:59 pm
by slansing
I'll close this as resolved!