http://www.emailcashpro.com

Nagios XI SQL Error


Error:
SQL: SQL Error [ndoutils]:Table './nagios/nagios_servicestatus' is marked as crashed and should be repaired

Solution:

Repairing MySQL Tables
First, login to your Nagios XI server as the
root user.
Next, stop the MySQL database server with the following command:
service mysqld stop
Run the Nagios XI database repair script with the following command:
/usr/local/nagiosxi/scripts/repairmysql.sh nagios
The script will check and repair all tables in the nagios MySQL database. This process may take several minutes to complete, depending on the size of your database.
Once the script has completed, start the MySQL database server with the following command:
Post a Comment