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?
No hosts on Nagios xi Interface?
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
Re: No hosts on Nagios xi Interface?
This sounds like a database problem.
Run the following
Run the following
Code: Select all
cd /usr/local/nagiosxi/scripts/
./repairmysql.sh nagios
./repairmysql.sh nagiosql-
super_marino
- Posts: 6
- Joined: Mon May 14, 2012 9:49 am
Re: No hosts on Nagios xi Interface?
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?
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
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
Re: No hosts on Nagios xi Interface?
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.
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.