We have been seeing our Nagios XI crash lately and searching all support forurms have yet to yield results.
Linux Distribution and version = Red Hat Enterprise Linux Server release 7.9 (Maipo) 64 bit
VMware Image or Manual Install of XI = Manual Install
We have noticed in the nagios.log the following:
Code: Select all
[1689628278] NDO-3: mysql_ping: Unknown error. Is the database running?
...
[1689628398] NDO 3.1.0 (c) Copyright 2009-2023 Nagios - Nagios Core Development TeamWe following instructions for repair of database: https://support.nagios.com/kb/article/n ... es-24.html. Did not work.
We then truncated as per other forums a few databases and still not resolved.
Code: Select all
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_notifications'
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_statehistory'
mysql -u ndoutils -pn@gweb nagios -e 'TRUNCATE TABLE nagios_logentries'Many thanks,
Charles