Page 1 of 1
No hosts on Nagios XI Interface?
Posted: Wed May 16, 2012 8:01 am
by 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?
Re: No hosts on Nagios XI Interface?
Posted: Wed May 16, 2012 8:52 am
by scottwilkerson
This sounds like a database problem.
Run the following
Code: Select all
cd /usr/local/nagiosxi/scripts/
./repairmysql.sh nagios
./repairmysql.sh nagiosql
Re: No hosts on Nagios XI Interface?
Posted: Wed May 16, 2012 9:54 am
by 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?
Re: No hosts on Nagios XI Interface?
Posted: Wed May 16, 2012 1:50 pm
by 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.