Centos 5/32 bit/Virtual Machine/Image/Nagios XI 2012R2.5
Updated VM:
Centos 6/64 bit/Virtual Machine/Image/Nagios XI 2014
I was migrating the data from our current production 32-bit VM to a new 64-bit version.
1. Followed steps as posted in:
http://assets.nagios.com/downloads/nagi ... ios-XI.pdf
2. Took the backup file and restored it to the new vm. All things proceeded as expected.
3. Stopped/started services and rebooted.
4. Went to access the webpage and it was displaying blank after the "access nagios" link.
I checked the /var/log/httpd/error_log:
Code: Select all
[Wed Mar 25 15:24:33 2015] [error] [client 10.155.1.226] PHP Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Wed Mar 25 15:24:33 2015] [error] [client 10.155.1.226] PHP Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Wed Mar 25 15:26:31 2015] [error] [client 10.155.1.226] PHP Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
[Wed Mar 25 15:26:31 2015] [error] [client 10.155.1.226] PHP Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: YES) in /usr/local/nagiosxi/html/db/adodb/drivers/adodb-mysql.inc.php on line 383After checking the forums, I went ahead and repaired the database using repairmysql.sh.
Code: Select all
[root@spam scripts]# ./repairmysql.sh
Usage: ./repairmysql.sh <database> [table]
This script repairs one or more tables in a specific Nagios XI MySQL database.
Valid database names include:
nagios
nagiosql
If the [table] option is omitted, all tables in the database will be repaired.
Example Usage:
./repairmysql.sh nagios nagios_logentries
[root@spam scripts]# ./repairmysql.sh nagios
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /usr/local/nagiosxi/scripts
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 726
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_commands.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_commenthistory.MYI'
Data records: 11862
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_comments.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_configfiles.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_configfilevariables.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_conninfo.MYI'
Data records: 4230
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_contact_addresses.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactgroup_members.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods.MYI'
Data records: 115429
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_contactnotifications.MYI'
Data records: 58586
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_contactstatus.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_customvariables.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_customvariablestatus.MYI'
Data records: 8514
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with keycache) MyISAM-table 'nagios_dbversion.MYI'
Data records: 1
---------
- recovering (with sort) MyISAM-table 'nagios_downtimehistory.MYI'
Data records: 104
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_eventhandlers.MYI'
Data records: 70
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_externalcommands.MYI'
Data records: 13
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_flappinghistory.MYI'
Data records: 39548
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_hostchecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostdependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostgroup_members.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hostgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_host_parenthosts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_hosts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_hoststatus.MYI'
Data records: 506
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19
---------
- recovering (with sort) MyISAM-table 'nagios_instances.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_logentries.MYI'
Data records: 2844156
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_notifications.MYI'
Data records: 28167610
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_objects.MYI'
Data records: 14769
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
---------
- recovering (with sort) MyISAM-table 'nagios_processevents.MYI'
Data records: 6412
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'nagios_programstatus.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_runtimevariables.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicechecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
---------
- recovering (with sort) MyISAM-table 'nagios_service_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_service_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicedependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_serviceescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicegroup_members.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_servicegroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_services.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_servicestatus.MYI'
Data records: 8818
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19
---------
- recovering (with sort) MyISAM-table 'nagios_statehistory.MYI'
Data records: 1858146
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_systemcommands.MYI'
Data records: 234
- Fixing index 1
- Fixing index 2
- Fixing index 3
---------
- recovering (with sort) MyISAM-table 'nagios_timedeventqueue.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'nagios_timedevents.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
---------
- recovering (with sort) MyISAM-table 'nagios_timeperiods.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
Starting mysqld: [ OK ]
/usr/local/nagiosxi/scripts
===============
REPAIR COMPLETE
===============
You have new mail in /var/spool/mail/root
[root@spam scripts]# ./repairmysql.sh nagiosql
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql /usr/local/nagiosxi/scripts
Stopping mysqld: [ OK ]
- recovering (with sort) MyISAM-table 'tbl_command.MYI'
Data records: 75
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contactgroup.MYI'
Data records: 27
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contact.MYI'
Data records: 30
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_contacttemplate.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_domain.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostdependency.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostescalation.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hostgroup.MYI'
Data records: 87
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_host.MYI'
Data records: 506
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_hosttemplate.MYI'
Data records: 15
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_info.MYI'
Data records: 218
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContactgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactgroupToContact.MYI'
Data records: 62
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandHost.MYI'
Data records: 2
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToCommandService.MYI'
Data records: 2
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContactgroup.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToContacttemplate.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContacttemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandHost.MYI'
Data records: 52
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService.MYI'
Data records: 52
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate.MYI'
Data records: 29
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition.MYI'
Data records: 30
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHostgroup_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostdependencyToHost_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostescalationToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHostgroup.MYI'
Data records: 8
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost.MYI'
Data records: 528
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContactgroup.MYI'
Data records: 4
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHostgroup.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToHosttemplate.MYI'
Data records: 12
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup.MYI'
Data records: 474
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact.MYI'
Data records: 120
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup.MYI'
Data records: 312
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost.MYI'
Data records: 266
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate.MYI'
Data records: 505
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition.MYI'
Data records: 478
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_DH.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHostgroup_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToHost_H.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_DS.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicedependencyToService_S.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContactgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceescalationToService.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToServicegroup.MYI'
Data records: 1
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService.MYI'
Data records: 555
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup.MYI'
Data records: 3
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContact.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHostgroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToHost.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicegroup.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToServicetemplate.MYI'
Data records: 30
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition.MYI'
Data records: 2
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup.MYI'
Data records: 3264
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact.MYI'
Data records: 885
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup.MYI'
Data records: 56
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost.MYI'
Data records: 8276
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup.MYI'
Data records: 211
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate.MYI'
Data records: 8232
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition.MYI'
Data records: 7960
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_lnkTimeperiodToTimeperiod.MYI'
Data records: 0
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_logbook.MYI'
Data records: 44
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_mainmenu.MYI'
Data records: 7
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_servicedependency.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_serviceescalation.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_serviceextinfo.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_servicegroup.MYI'
Data records: 49
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_service.MYI'
Data records: 8277
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_servicetemplate.MYI'
Data records: 34
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_settings.MYI'
Data records: 12
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_submenu.MYI'
Data records: 29
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_timedefinition.MYI'
Data records: 223
- Fixing index 1
---------
- recovering (with sort) MyISAM-table 'tbl_timeperiod.MYI'
Data records: 35
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_user.MYI'
Data records: 2
- Fixing index 1
- Fixing index 2
---------
- recovering (with sort) MyISAM-table 'tbl_variabledefinition.MYI'
Data records: 10325
- Fixing index 1
Starting mysqld: [ OK ]
/usr/local/nagiosxi/scripts
===============
REPAIR COMPLETE
===============