Page 1 of 1
Database Backend not running in Nagios XI
Posted: Thu Nov 05, 2020 8:56 am
by RIDS_I2MP
Hi Team,
We are not able to start the Database Backend service from Nagios Xi GUI.
Also, we are getting below error while starting ndo2db service.
[root@eu1papu002 local]# service ndo2db status
Redirecting to /bin/systemctl status ndo2db.service
Unit ndo2db.service could not be found.
[root@eu1papu002 local]#
Could you please help us to fix this.
Thanks
Nitin Parate
Re: Database Backend not running in Nagios XI
Posted: Thu Nov 05, 2020 9:18 am
by RIDS_I2MP
Adding more details.
Nagios XI Version: 5.6.14
OS : CentOS 7.8
Re: Database Backend not running in Nagios XI
Posted: Thu Nov 05, 2020 6:24 pm
by benjaminsmith
Hi Nick,
Let's try to do a full restart and remove the lock files on the system.
Code: Select all
systemctl stop npcd
systemctl stop nagios
systemctl stop ndo2db
systemctl stop crond
pkill -9 -u nagios
systemctl restart mariadb
rm -f /usr/local/nagios/var/rw/nagios.cmd
rm -f /usr/local/nagios/var/nagios.lock
rm -f /var/run/nagios.lock
rm -f /usr/local/nagios/var/ndo.sock
rm -f /usr/local/nagios/var/ndo2db.lock
rm -f /var/lib/mrtg/mrtg_l
rm -f /usr/local/nagiosxi/var/*.lock
for i in `ipcs -q | grep nagios |awk '{print $2}'`; do ipcrm -q $i; done
pkill python
systemctl restart httpd
systemctl start ndo2db
systemctl start nagios
systemctl start npcd
systemctl start crond
If the issue persists, please send me your system profile to further troubleshoot. Thanks, Benjamin
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share in a private message or upload it to the post/ticket, and then reply to this post to bring it up in the queue.
Re: Database Backend not running in Nagios XI
Posted: Fri Nov 06, 2020 4:04 am
by RIDS_I2MP
Hi Team,
We tried above steps but the issue still persists.
PFA profile file as requested. Please check and update us.
Thanks
Nitin Parate
Re: Database Backend not running in Nagios XI
Posted: Fri Nov 06, 2020 1:51 pm
by benjaminsmith
HI Nitin,
The database log is showing crashed tables and that can cause issues with writes to the nagios database. Please log in as root and run the following command to repair the database:
Code: Select all
/usr/local/nagiosxi/scripts/repair_databases.sh
Since you are now running 5.7.4, the ndo2db service is no longer used. If you set up a check in Nagiso XI to monitor this process you can safely delete it or deactivate it.
Let me know if how the system is running after repairing the database. Also, if this is a VM I would recommend adding more CPUs to this instance.
Benjamin