nagiosxi status is not updating compared to nagios-core

[story]

we have a situation where nagios xi status does not match nagios-core status. What is the best way to resolve this?

- We have rebooted the server
- Verified that nagios core is responding to "force immediate check"
- did the repair database script

im assuming the DB is connected since we are seeing nagiosxi web page, but is there another db connection we need to verify?

Screenshot 2025-03-31 112924.png

Screenshot 2025-03-31 112950.png

[jsimon]

Hi @story,

It does sound like there is an issue with your Nagios XI database. What version of Nagios XI are you running? We added a script in version 2024R1.2.2 called "repair_crashed_databases.sh", which may fix this issue for you. You can find the script here, if you're on version 2024R1.2.2 or higher:

Code: Select all

/usr/local/nagiosxi/scripts/repair_crashed_databases.sh

Let us know if you're on an older version and I'll work on getting you a version of this that you can run locally.

[story]

we are version 1.1.2.

[story]

we are looking to upgrade but our change management process can be difficult. Doing this repair with the script, we can do as an emergency.

if the script would be ok for my version, I can extract it from the newer update package...

thanks.

[story]

the /usr/local/nagios/etc/ndo.cfg file had bogus characters in it. restored it from backup...

we did a MD5SUM on every file from a backup against all the files in the current filesystem, this was one that came back different...

dunno why it was able to read and we got no errors on mysql updates or reads. (we monitored for mysql connection failures and query failures in the logs.. didnt see any..)

[jsimon]

Hi @story,

I believe you should be okay to extract the script from a newer tarball and run it locally to repair your databases. I'd advise backing up your system before doing this generally, however from your most recent post it sounds like you were able to solve your issue. Please let me know if you have any other questions or issues, otherwise I'll go ahead and lock this topic.