Database Backend not running in Nagios xi

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Database Backend not running in Nagios xi

Post 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
Thanks & Regards,
I2MP Team.
Top
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Database Backend not running in Nagios xi

Post by RIDS_I2MP »

Adding more details.

Nagios xi Version: 5.6.14
OS : CentOS 7.8
Thanks & Regards,
I2MP Team.
Top
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Database Backend not running in Nagios xi

Post 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.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Top
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Database Backend not running in Nagios xi

Post 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
You do not have the required permissions to view the files attached to this post.
Thanks & Regards,
I2MP Team.
Top
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Database Backend not running in Nagios xi

Post 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
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Top

Return to “Nagios xi”