Nagios crashed: DB Connect Error [nagiosxi]:

[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)

[slansing]

Can you run the following and try accessing the interface again?:

Code: Select all

service httpd restart
service postgresql restart

[msfhr]

Thanks for help slansing, that was it. It looks like postrgresql was stoppped. Does nagios uses two different db servers (mysql, postgresql)?

[tmcdonald]

That is correct. MySQL is used for object data, postgres is used for user data.

[msfhr]

thank you guys

[slansing]

I'll close this as resolved!