No hosts on Nagios XI Interface?

[super_marino]

This morning, I logged into Nagios only to discover that under the Host Detail, there were no hosts...

I can't seem to retrieve these hosts even after a restart of the system.

Any ideas why this might have happened?

[scottwilkerson]

This sounds like a database problem.

Run the following

Code: Select all

cd /usr/local/nagiosxi/scripts/
./repairmysql.sh nagios
./repairmysql.sh nagiosql

[super_marino]

Scott,

thanks for your help. Is there any reason why this would have happened? Is this going to happen on a regular basis?

Can I trace the root cause somehow?

[scottwilkerson]

The most common cause of this happening is an improper shutdown of the system (ie. power failure)

If this is a VM, choosing to power down the VM before running the shutdown command from the command line, is the same as pulling the plug out of the wall on a physical server.

Being Nagios is CONSTANTLY writing to the database, it more than likely has a table open when the power is lost, and this crashes the table from mysql's point of view.