SQL error message after logging into new installation

[aakhtar]

@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_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.servers OK
mysql.slow_log
Error : You can't use locks with log tables.
status : OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
nagios.nagios_acknowledgements OK
nagios.nagios_commands
Error : Incorrect file format 'nagios_commands'
error : Corrupt
nagios.nagios_commenthistory OK
nagios.nagios_comments OK
nagios.nagios_configfiles
Error : Incorrect file format 'nagios_configfiles'
error : Corrupt
nagios.nagios_configfilevariables
Error : Incorrect file format 'nagios_configfilevariables'
error : Corrupt
nagios.nagios_conninfo OK
nagios.nagios_contact_addresses OK
nagios.nagios_contact_notificationcommands
Error : Incorrect file format 'nagios_contact_notificationcommands'
error : Corrupt
nagios.nagios_contactgroup_members
Error : Incorrect file format 'nagios_contactgroup_members'
error : Corrupt
nagios.nagios_contactgroups
Error : Incorrect file format 'nagios_contactgroups'
error : Corrupt
nagios.nagios_contactnotificationmethods OK
nagios.nagios_contactnotifications OK
nagios.nagios_contacts
Error : Incorrect file format 'nagios_contacts'
error : Corrupt
nagios.nagios_contactstatus
Error : Incorrect file format 'nagios_contactstatus'
error : Corrupt
nagios.nagios_customvariables OK
nagios.nagios_customvariablestatus OK
nagios.nagios_dbversion OK
nagios.nagios_downtimehistory OK
nagios.nagios_eventhandlers OK
nagios.nagios_externalcommands OK
nagios.nagios_flappinghistory OK
nagios.nagios_host_contactgroups
Error : Incorrect file format 'nagios_host_contactgroups'
error : Corrupt
nagios.nagios_host_contacts OK
nagios.nagios_host_parenthosts OK
nagios.nagios_hostchecks
Error : Incorrect file format 'nagios_hostchecks'
error : Corrupt
nagios.nagios_hostdependencies OK
nagios.nagios_hostescalation_contactgroups OK
nagios.nagios_hostescalation_contacts OK
nagios.nagios_hostescalations OK
nagios.nagios_hostgroup_members
Error : Incorrect file format 'nagios_hostgroup_members'
error : Corrupt
nagios.nagios_hostgroups
Error : Incorrect file format 'nagios_hostgroups'
error : Corrupt
nagios.nagios_hosts
Error : Incorrect file format 'nagios_hosts'
error : Corrupt
nagios.nagios_hoststatus
Error : Incorrect file format 'nagios_hoststatus'
error : Corrupt
nagios.nagios_instances OK
nagios.nagios_logentries
Error : Incorrect file format 'nagios_logentries'
error : Corrupt
nagios.nagios_notifications OK
nagios.nagios_objects
Error : Incorrect file format 'nagios_objects'
error : Corrupt
nagios.nagios_processevents OK
nagios.nagios_programstatus
Error : Incorrect file format 'nagios_programstatus'
error : Corrupt
nagios.nagios_runtimevariables
Error : Incorrect file format 'nagios_runtimevariables'
error : Corrupt
nagios.nagios_scheduleddowntime OK
nagios.nagios_service_contactgroups
Error : Incorrect file format 'nagios_service_contactgroups'
error : Corrupt
nagios.nagios_service_contacts OK
nagios.nagios_servicechecks
Error : Incorrect file format 'nagios_servicechecks'
error : Corrupt
nagios.nagios_servicedependencies OK
nagios.nagios_serviceescalation_contactgroups OK
nagios.nagios_serviceescalation_contacts OK
nagios.nagios_serviceescalations OK
nagios.nagios_servicegroup_members OK
nagios.nagios_servicegroups OK
nagios.nagios_services
Error : Incorrect file format 'nagios_services'
error : Corrupt
nagios.nagios_servicestatus
Error : Incorrect file format 'nagios_servicestatus'
error : Corrupt
nagios.nagios_statehistory OK
nagios.nagios_systemcommands
Error : Incorrect file format 'nagios_systemcommands'
error : Corrupt
nagios.nagios_timedeventqueue
Error : Incorrect file format 'nagios_timedeventqueue'
error : Corrupt
nagios.nagios_timedevents OK
nagios.nagios_timeperiod_timeranges
Error : Incorrect file format 'nagios_timeperiod_timeranges'
error : Corrupt
nagios.nagios_timeperiods
Error : Incorrect file format 'nagios_timeperiods'
error : Corrupt
nagiosql.tbl_command OK
nagiosql.tbl_contact OK
nagiosql.tbl_contactgroup OK
nagiosql.tbl_contacttemplate OK
nagiosql.tbl_domain OK
nagiosql.tbl_host OK
nagiosql.tbl_hostdependency OK
nagiosql.tbl_hostescalation OK
nagiosql.tbl_hostextinfo OK
nagiosql.tbl_hostgroup OK
nagiosql.tbl_hosttemplate OK
nagiosql.tbl_info OK
nagiosql.tbl_lnkContactToCommandHost OK
nagiosql.tbl_lnkContactToCommandService OK
nagiosql.tbl_lnkContactToContactgroup OK
nagiosql.tbl_lnkContactToContacttemplate OK
nagiosql.tbl_lnkContactToVariabledefinition OK
nagiosql.tbl_lnkContactgroupToContact OK
nagiosql.tbl_lnkContactgroupToContactgroup OK
nagiosql.tbl_lnkContacttemplateToCommandHost OK
nagiosql.tbl_lnkContacttemplateToCommandService OK
nagiosql.tbl_lnkContacttemplateToContactgroup OK
nagiosql.tbl_lnkContacttemplateToContacttemplate OK
nagiosql.tbl_lnkContacttemplateToVariabledefinition OK
nagiosql.tbl_lnkHostToContact OK
nagiosql.tbl_lnkHostToContactgroup OK
nagiosql.tbl_lnkHostToHost OK
nagiosql.tbl_lnkHostToHostgroup OK
nagiosql.tbl_lnkHostToHosttemplate OK
nagiosql.tbl_lnkHostToVariabledefinition OK
nagiosql.tbl_lnkHostdependencyToHost_DH OK
nagiosql.tbl_lnkHostdependencyToHost_H OK
nagiosql.tbl_lnkHostdependencyToHostgroup_DH OK
nagiosql.tbl_lnkHostdependencyToHostgroup_H OK
nagiosql.tbl_lnkHostescalationToContact OK
nagiosql.tbl_lnkHostescalationToContactgroup OK
nagiosql.tbl_lnkHostescalationToHost OK
nagiosql.tbl_lnkHostescalationToHostgroup OK
nagiosql.tbl_lnkHostgroupToHost OK
nagiosql.tbl_lnkHostgroupToHostgroup OK
nagiosql.tbl_lnkHosttemplateToContact OK
nagiosql.tbl_lnkHosttemplateToContactgroup OK
nagiosql.tbl_lnkHosttemplateToHost OK
nagiosql.tbl_lnkHosttemplateToHostgroup OK
nagiosql.tbl_lnkHosttemplateToHosttemplate OK
nagiosql.tbl_lnkHosttemplateToVariabledefinition OK
nagiosql.tbl_lnkServiceToContact OK
nagiosql.tbl_lnkServiceToContactgroup OK
nagiosql.tbl_lnkServiceToHost OK
nagiosql.tbl_lnkServiceToHostgroup OK
nagiosql.tbl_lnkServiceToServicegroup OK
nagiosql.tbl_lnkServiceToServicetemplate OK
nagiosql.tbl_lnkServiceToVariabledefinition OK
nagiosql.tbl_lnkServicedependencyToHost_DH OK
nagiosql.tbl_lnkServicedependencyToHost_H OK
nagiosql.tbl_lnkServicedependencyToHostgroup_DH OK
nagiosql.tbl_lnkServicedependencyToHostgroup_H OK
nagiosql.tbl_lnkServicedependencyToService_DS OK
nagiosql.tbl_lnkServicedependencyToService_S OK
nagiosql.tbl_lnkServiceescalationToContact OK
nagiosql.tbl_lnkServiceescalationToContactgroup OK
nagiosql.tbl_lnkServiceescalationToHost OK
nagiosql.tbl_lnkServiceescalationToHostgroup OK
nagiosql.tbl_lnkServiceescalationToService OK
nagiosql.tbl_lnkServicegroupToService OK
nagiosql.tbl_lnkServicegroupToServicegroup OK
nagiosql.tbl_lnkServicetemplateToContact OK
nagiosql.tbl_lnkServicetemplateToContactgroup OK
nagiosql.tbl_lnkServicetemplateToHost OK
nagiosql.tbl_lnkServicetemplateToHostgroup OK
nagiosql.tbl_lnkServicetemplateToServicegroup OK
nagiosql.tbl_lnkServicetemplateToServicetemplate OK
nagiosql.tbl_lnkServicetemplateToVariabledefinition OK
nagiosql.tbl_lnkTimeperiodToTimeperiod OK
nagiosql.tbl_logbook
Error : Incorrect file format 'tbl_logbook'
error : Corrupt
nagiosql.tbl_mainmenu OK
nagiosql.tbl_service OK
nagiosql.tbl_servicedependency OK
nagiosql.tbl_serviceescalation OK
nagiosql.tbl_serviceextinfo OK
nagiosql.tbl_servicegroup OK
nagiosql.tbl_servicetemplate OK
nagiosql.tbl_settings OK
nagiosql.tbl_submenu OK
nagiosql.tbl_timedefinition OK
nagiosql.tbl_timeperiod OK
nagiosql.tbl_user OK
nagiosql.tbl_variabledefinition OK

Repairing tables
nagios.nagios_commands
Error : Incorrect file format 'nagios_commands'
error : Corrupt
nagios.nagios_configfiles
Error : Incorrect file format 'nagios_configfiles'
error : Corrupt
nagios.nagios_configfilevariables
Error : Incorrect file format 'nagios_configfilevariables'
error : Corrupt
nagios.nagios_contact_notificationcommands
Error : Incorrect file format 'nagios_contact_notificationcommands'
error : Corrupt
nagios.nagios_contactgroup_members
Error : Incorrect file format 'nagios_contactgroup_members'
error : Corrupt
nagios.nagios_contactgroups
Error : Incorrect file format 'nagios_contactgroups'
error : Corrupt
nagios.nagios_contacts
Error : Incorrect file format 'nagios_contacts'
error : Corrupt
nagios.nagios_contactstatus
Error : Incorrect file format 'nagios_contactstatus'
error : Corrupt
nagios.nagios_host_contactgroups
Error : Incorrect file format 'nagios_host_contactgroups'
error : Corrupt
nagios.nagios_hostchecks
Error : Incorrect file format 'nagios_hostchecks'
error : Corrupt
nagios.nagios_hostgroup_members
Error : Incorrect file format 'nagios_hostgroup_members'
error : Corrupt
nagios.nagios_hostgroups
Error : Incorrect file format 'nagios_hostgroups'
error : Corrupt
nagios.nagios_hosts
Error : Incorrect file format 'nagios_hosts'
error : Corrupt
nagios.nagios_hoststatus
Error : Incorrect file format 'nagios_hoststatus'
error : Corrupt
nagios.nagios_logentries
Error : Incorrect file format 'nagios_logentries'
error : Corrupt
nagios.nagios_objects
Error : Incorrect file format 'nagios_objects'
error : Corrupt
nagios.nagios_programstatus
Error : Incorrect file format 'nagios_programstatus'
error : Corrupt
nagios.nagios_runtimevariables
Error : Incorrect file format 'nagios_runtimevariables'
error : Corrupt
nagios.nagios_service_contactgroups
Error : Incorrect file format 'nagios_service_contactgroups'
error : Corrupt
nagios.nagios_servicechecks
Error : Incorrect file format 'nagios_servicechecks'
error : Corrupt
nagios.nagios_services
Error : Incorrect file format 'nagios_services'
error : Corrupt
nagios.nagios_servicestatus
Error : Incorrect file format 'nagios_servicestatus'
error : Corrupt
nagios.nagios_systemcommands
Error : Incorrect file format 'nagios_systemcommands'
error : Corrupt
nagios.nagios_timedeventqueue
Error : Incorrect file format 'nagios_timedeventqueue'
error : Corrupt
nagios.nagios_timeperiod_timeranges
Error : Incorrect file format 'nagios_timeperiod_timeranges'
error : Corrupt
nagios.nagios_timeperiods
Error : Incorrect file format 'nagios_timeperiods'
error : Corrupt
nagiosql.tbl_logbook
Error : Incorrect file format 'tbl_logbook'
error : Corrupt

[aakhtar]

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]

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.

Depending on your configuration it may be easier to start over, but I will offer another possible fix for your tables...

Code: Select all

mysqlcheck --auto-repair -A -pnagiosxi
cd /usr/local/nagiosxi/scripts
./reconfigure_nagios.sh

On an additional note.... When using the Nagios VM, one really needs to try to never "pause" or "stop" the VM, if you need to turn it off you should issue a shutdown command from the terminal so the databases can exit properly.

[aakhtar]

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

Disappointing.

I'm starting over.