Database Backend Is Not Running

[mcwhorts]

So I just upgraded Nagios XI to 2014R2.7 and now it says that the database backend isn't running. The VM was rebooted. I've tried manually starting the database and it still says the database backend isn't running. Any ideas?

[jolson]

It looks like mysql is running fine, but ndo2db might be stopped. Please try the following:

Code: Select all

service ndomod start

What is the output of that command?

I've tried manually starting the database and it still says the database backend isn't running.

Which database backend is not running, and how did you try to start it?

[mcwhorts]

service ndomod start
ndomod: unrecognized service

To restart the database I tried running
service mysqld restart
and
service ndo2db restart

returned
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
and
ndo2db was not running... could not stop
Starting ndo2db: done.

[tgriep]

service ndo2db restart
is the correct command.
Does the system recognize that the Database Backend is now running?

[mcwhorts]

No it still shows that it's not running from the GUI.

[mcwhorts]

I am seeing this in the system profile
"ndo2db is not running but subsystem locked"

[tgriep]

Try this to clear the lock file that could be left over during the upgrade.

Code: Select all

service ndo2db stop
rm /usr/local/nagios/var/ndo2db.lock
service ndo2db start
service nagios restart

[mcwhorts]

It is still showing that the database backend isn't running

[jolson]

Sorry, I posted the incorrect command.

It's also worth noting that there could be a hanging .sock file - check the following location for it:

Code: Select all

ls /usr/local/nagios/var/ndo.sock

If the socket remains and the program is not running, feel free to delete the socket and restart:

Code: Select all

rm /usr/local/nagios/var/ndo.sock
service ndo2db restart

[mcwhorts]

Unfortunately, nothing has changed. It still says DB backend isn't running.