Page 1 of 1

Server Reboot - NagiosXI doesnt come up - MySQL Errors

Posted: Wed Jan 30, 2019 10:39 am
by 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

Re: Server Reboot - NagiosXI doesnt come up - MySQL Errors

Posted: Wed Jan 30, 2019 1:31 pm
by 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

Re: Server Reboot - NagiosXI doesnt come up - MySQL Errors

Posted: Wed Feb 06, 2019 8:32 am
by 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 ?

Re: Server Reboot - NagiosXI doesnt come up - MySQL Errors

Posted: Wed Feb 06, 2019 9:42 am
by scottwilkerson
veeravamsi wrote: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?