Server Reboot - NagiosXI doesnt come up - MySQL Errors

[veeravamsi]

We are evaluating Nagios as part of IT Monitoring and today I ran into issues while rebooting the server , as I noticed NagiosXI UI is not coming up due to httpd service not able to start.

Here is what I see in error logs :

Jan 30 02:10:40 xxxxxxxxxxxxx ndo2db[53979]: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/m
Jan 30 02:10:40 xxxxxxxxxxxxx ndo2db[53980]: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/m
Jan 30 02:10:40 xxxxxxxxxxxxx ndo2db[53979]: Error: Could not connect to MySQL database: Can't connect to local MySQL server through socket '/var/lib/m
Jan 30 02:10:40 xxxxxxxxxxxxx nagios[52004]: ndomod: Error writing to data sink! Some output may get lost. 137 queued items to flush.
Jan 30 02:10:41 xxxxxxxxxxxxx check_nrpe[53985]: Error: (nerrs = 0)(!log_opts) Could not complete SSL handshake with 129.172.241.186: rc=-1 SSL-error=5

Thank you !

--Vamsi

[scottwilkerson]

The looks like mysql isn't started, not httpd

On CentOS 6

Code: Select all

service mysqld start

On CentOS 7

Code: Select all

systemctl start mariadb

[veeravamsi]

Thanks Scott. That worked. I find some strange behaviour after this as some of the Devices which were running or responding to snmpwalk has stopped working. Would there be any Database Corruption or Stale Sessions ?

[scottwilkerson]

Thanks Scott. That worked. I find some strange behaviour after this as some of the Devices which were running or responding to snmpwalk has stopped working. Would there be any Database Corruption or Stale Sessions ?

There is no session state kept in Nagios for snmpwalk commands.

Did the community string or user/password change on the devices?