Nagios Support Forum

I ran the three commands and I still have the original problem.

Disappointing.

I'm starting over.

At this point, I need to know if it's worthwhile to start over: delete the virtual machine and create it again.

I am trying to demonstrate Nagios XI to my team and company. One of our sister companies uses Centreon but I'm inclined towards Nagios XI for various reasons.

@scottwilkerson Here is the result of the command you suggested: [root@mynagios~]# mysqlcheck --auto-repair -A -pnagiosxi mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.general_log Error : You can't use locks with log tables. status : OK mysql.help_category OK mysql.help_keywor...

@mguthrie

Adding the extension you mentioned did not work. Here is the result:

[root@mynagios nagios]# myisamchk -r -f nagios_programstatus.MYI
myisamchk: error: 'nagios_programstatus.MYI' is not a MyISAM-table

Here is the result of the command:

[root@mynagios ~]# echo "USE nagios;select instance_id,status_update_time,program_start_time,is_currently_running from nagios_programstatus" | mysql -pnagiosxi

ERROR 130 (HY000) at line 1: Incorrect file format 'nagios_programstatus'

Here is the result of the command:

[root@mynagios ~]# echo "USE nagios;show tables where Tables_in_nagios='nagios_programstatus';" | mysql -pnagiosxi

Tables_in_nagios
nagios_programstatus

Looks like there is a table named nagios_programstatus.

Thanks for the quick reply. I was hesitant to apply the suggestion because I didn't receive the kind of error you referenced. In any case, I tried to apply the suggestion but encountered the following error: [root@mynagios ~]# service mysqld stop Stopping mysqld: [ OK ] [root@mynagios ~]# cd /var/li...

1. CentOS 6.0 2. 32-bit 3. VMware image from Nagios 4. No special configurations. Nothing has been done on the machine after installing Nagios. After logging into Nagios XI, I receive an error message: SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_programstatus' SQL: SQL Error [ndoutils]...