Corrupted tables now no notifications

[tcanthonyii]

I have a lot of

"SMTP Error: Could not connect to SMTP host. (method=smtp;host=mail.cretecarrier.$rrier.com;port=25;security=none"

This looks to be a corruption to me. Should be mail.cretecarrier.com

The other log entry is:
"the following from address failed: [email protected]"

here is the repair:

Code: Select all

[root@NagiosXIMon ~]# /usr/local/nagiosxi/scripts/repair_databases.sh
mysqld (pid  1805) is running...
mysqld (pid  1805) is running...
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 221
- Fixing index 1
- Fixing index 2

---------

myisamchk: error: 'nagios_commands.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_commenthistory.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_comments.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_configfiles.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_configfilevariables.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo.MYI'
Data records: 1115
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

myisamchk: error: 'nagios_contactgroup_members.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_contactgroups.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_contact_notificationcommands.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods.MYI'
Data records: 2938
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications.MYI'
Data records: 21095
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

myisamchk: error: 'nagios_contacts.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_contactstatus.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_customvariables.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus.MYI'
Data records: 1979
- 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: 3278
- Fixing index 1
- Fixing index 2

---------

myisamchk: error: 'nagios_eventhandlers.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_externalcommands.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory.MYI'
Data records: 12741
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

myisamchk: error: 'nagios_host_contactgroups.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_host_contacts.MYI' is not a MyISAM-table

---------

- 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

---------

myisamchk: error: 'nagios_hostgroup_members.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_hostgroups.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_host_parenthosts.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_hosts.MYI'
Data records: 264
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus.MYI'
Data records: 264
- 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: 54862
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_notifications.MYI'
Data records: 9473
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_objects.MYI'
Data records: 3797
- 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: 5127
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

myisamchk: error: 'nagios_runtimevariables.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_scheduleddowntime.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

myisamchk: error: 'nagios_service_contactgroups.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_service_contacts.MYI' is not a MyISAM-table

---------

- 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_service_parentservices.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services.MYI'
Data records: 2182
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus.MYI'
Data records: 2182
- 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

---------

myisamchk: error: 'nagios_statehistory.MYI' is not a MyISAM-table

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands.MYI'
Data records: 90
- 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

---------

myisamchk: error: 'nagios_timeperiods.MYI' is not a MyISAM-table

---------

myisamchk: error: 'nagios_timeperiod_timeranges.MYI' is not a MyISAM-table
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============
mysqld (pid  31722) is running...
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql ~
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'tbl_command.MYI'
Data records: 129
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contactgroup.MYI'
Data records: 9
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_contact.MYI'
Data records: 18
- 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: 21
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_host.MYI'
Data records: 271
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_hosttemplate.MYI'
Data records: 50
- 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: 16
- 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: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToCommandService.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContactgroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToContacttemplate.MYI'
Data records: 18
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkContactToVariabledefinition.MYI'
Data records: 0
- 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: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostgroupToHost.MYI'
Data records: 5
- 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: 0
- 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: 48
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHosttemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContactgroup.MYI'
Data records: 387
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToContact.MYI'
Data records: 3
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHostgroup.MYI'
Data records: 262
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHost.MYI'
Data records: 13
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToHosttemplate.MYI'
Data records: 260
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkHostToVariabledefinition.MYI'
Data records: 259
- 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: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicegroupToService.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToContactgroup.MYI'
Data records: 1
- 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: 81
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServicetemplateToVariabledefinition.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContactgroup.MYI'
Data records: 957
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToContact.MYI'
Data records: 37
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHostgroup.MYI'
Data records: 105
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToHost.MYI'
Data records: 895
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicegroup.MYI'
Data records: 0
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToServicetemplate.MYI'
Data records: 702
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_lnkServiceToVariabledefinition.MYI'
Data records: 688
- 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: 0
- 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: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'tbl_service.MYI'
Data records: 797
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_servicetemplate.MYI'
Data records: 83
- 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: 165
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'tbl_timeperiod.MYI'
Data records: 25
- 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: 947
- Fixing index 1
Starting mysqld:                                           [  OK  ]
~

===============
REPAIR COMPLETE
===============

Could not open input file: nagiosxi_dbtype.php
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...
Stopping nagios:. done.
Starting nagios: done.

[tcanthonyii]

The PDF you posted I already ran though. it's how I got the server fixed enough to atleast allow me to view some data

[tgriep]

I have a few questions for you.
Has the MYSQL server been offloaded to a remote server or is it still being used locally on the XI server?
This error message

myisamchk: error: 'nagios_commenthistory.MYI' is not a MyISAM-table

Means that the MYSQL tables are in the wrong format and they need to be converted.
Before you convert them, do a full backup of the server in case there are any issues.
To convert all InnoDB Tables to MyISAM (all databases)
Login to the mysql server with this command

Code: Select all

mysql -u root -pnagiosxi

Then run the following to convert all of the tables.

Code: Select all

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';

To exit the database type

Code: Select all

quit

After this, you can run the following to repair the MYSQL databases.

Code: Select all

mysqlcheck -f -r -u root -pnagiosxi --all-databases

One more thing I will need to see is to check the settings in this file.

Code: Select all

/usr/local/nagiosxi/html/config.inc.php

Can you upload that so we can view it?

[tcanthonyii]

Here is the contents of that file. I will wait to proceed on the earlier instructions until you say go.

The db is still local to this box and has not been moved.

<?php
//
// Copyright (c) 2008-2010 Nagios Enterprises, LLC. All rights reserved.
//
// $Id: config.inc.php 202 2010-07-13 21:22:57Z egalstad $

// base url
$cfg['base_url'] = "/nagiosxi"; // do not include http(s) or host name - this is the base from "http://localhost"

// base root directory where XI is installed
$cfg['root_dir'] = "/usr/local/nagiosxi";

// directory where scripts are installed
$cfg['script_dir'] = "/usr/local/nagiosxi/scripts";

$cfg['xidpe_dir'] = '/usr/local/nagios/var/spool/xidpe/';
$cfg['perfdata_spool'] = '/usr/local/nagios/var/spool/perfdata/';

// nom checkpoints
$cfg['nom_checkpoints_dir'] = "/usr/local/nagiosxi/nom/checkpoints/nagioscore/";

// force http/https
$cfg['use_https'] = false; // determines whether cron jobs and other scripts will force the use of HTTPS instead of HTTP

// allow for different http port for subsystem calls
$cfg['port_number'] = false;

// default server, db, connection settings
$cfg['dbtype'] = ''; // this setting is no longer used - use settings below
$cfg['dbserver'] = 'localhost'; // this setting is no longer used - use settings below

// db-specific connection information
$cfg['db_info'] = array(
"nagiosxi" => array(
"dbtype" => 'mysql',
"dbserver" => '',
"user" => 'nagiosxi',
"pwd" => 'n@gweb',
"db" => 'nagiosxi',
"dbmaint" => array( // variables affecting maintenance of db
"max_auditlog_age" => 30, // max time (in DAYS) to keep audit log entries
"max_commands_age" => 480, // max time (minutes) to keep commands
"max_events_age" => 480, // max time (minutes) to keep events
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
"ndoutils" => array(
"dbtype" => 'mysql',
"dbserver" => 'localhost',
"user" => 'ndoutils',
"pwd" => 'n@gweb',
"db" => 'nagios',
"dbmaint" => array( // variables affecting maintenance of ndoutils db

"max_externalcommands_age" => 7, // max time (in DAYS) to keep external commands
"max_logentries_age" => 90, // max time (in DAYS) to keep log entries
"max_statehistory_age" => 730, // max time (in DAYS) to keep state history information
"max_notifications_age" => 90, // max time (in DAYS) to keep notifications
"max_timedevents_age" => 5, // max time (minutes) to keep timed events
"max_systemcommands_age" => 5, // max time (minutes) to keep system commands
"max_servicechecks_age" => 5, // max time (minutes) to keep service checks
"max_hostchecks_age" => 5, // max time (minutes) to keep host checks
"max_eventhandlers_age" => 5, // max time (minutes) to keep event handlers
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
"nagiosql" => array(
"dbtype" => 'mysql',
"dbserver" => 'localhost',
"user" => 'nagiosql',
"pwd" => 'n@gweb',
"db" => 'nagiosql',
"dbmaint" => array( // variables affecting maintenance of db
"max_logbook_age" => 480, // max time (minutes) to keep log book records
"optimize_interval" => 60, // time (in minutes) between db optimization runs
"repair_interval" => 0, // time (in minutes) between db repair runs
),
),
);

// db-specific table prefixes
$cfg['db_prefix'] = array(
"ndoutils" => "nagios_", // prefix for NDOUtils tables
"nagiosxi" => "xi_", // prefix for XI tables
"nagiosql" => "tbl_", // prefix for NagiosQL tables
);

// component info
$cfg['component_info'] = array(
"nagioscore" => array(
"cgi_dir" => "/usr/local/nagios/sbin",
"import_dir" => "/usr/local/nagios/etc/import",
"plugin_dir" => "/usr/local/nagios/libexec",
"cgi_config_file" => "/usr/local/nagios/etc/cgi.cfg",
"cmd_file" => "/usr/local/nagios/var/rw/nagios.cmd",
"log_file" => "/usr/local/nagios/var/nagios.log",
"nom_checkpoint_interval" => 1440, // time (in minutes) between nom checkpoints
),
"pnp" => array(
"perfdata_dir" => "/usr/local/nagios/share/perfdata",
"share_dir" => "/usr/local/nagios/share/pnp",
"direct_url" => "/nagios/pnp",
"username" => 'nagiosxi', // don't change this!
"password" => 'nagiosadmin', // this gets reset when security credentials are reset after installation
),
"perfdata" => array(
"rrdtool_path" => "/usr/bin/rrdtool",
),
"nagiosql" => array(
"dir" => "/var/www/html/nagiosql",
"direct_url" => "/nagiosql",
"username" => 'nagiosxi', // don't change this!
"password" => 'n@gweb', // this gets reset when security credentials are reset after installation
),
"nagvis" => array(
"share_dir" => "/usr/local/nagios/share/nagvis",
"direct_url" => "/nagios/nagvis",
"username" => 'nagiosadmin', // don't change this!
"password" => 'nagiosadmin', // this gets reset when security credentials are reset after installation
),
);

$cfg['demo_mode'] = false; // is this in demo mode

$cfg['dashlet_refresh_multiplier'] = 1000; // milliseconds (1 second = 1000)

// REFRESH RATES FOR VARIOUS DASHLETS (IN SECONDS UNLESS THE MULTIPLIER IS CHANGED)
$cfg['dashlet_refresh_rates'] = array(
"available_updates" => 24 * 60 * 60, // 24 hours
"systat_eventqueuechart" => 5,
"sysstat_monitoringstats" => 30,
"systat_monitoringperf" => 30,
"sysstat_monitoringproc" => 30,
"perfdata_chart" => 60, // performance graphs
"network_outages" => 30,
"host_status_summary" => 60,
"service_status_summary" => 60,
"hostgroup_status_overview" => 60,
"hostgroup_status_grid" => 60,
"servicegroup_status_overview" => 60,
"servicegroup_status_grid" => 60,
"hostgroup_status_summary" => 60,
"servicegroup_status_summary" => 60,
"sysstat_componentstates" => 7,
"sysstat_serverstats" => 5,
"network_outages_summary" => 30,
"network_health" => 30,
"host_status_tac_summary" => 30,
"service_status_tac_summary" => 30,
"feature_status_tac_summary" => 30,
"admin_tasks" => 60,
"getting_started" => 60,
"pagetop_alert_content" => 30, // not a dashlet yet, sits in page header
"tray_alert" => 30, // sites in page footer
);


// MEMCACHED SETUP
$cfg['memcached_enable'] = false; // should we use memcached or not?
$cfg['memcached_hosts'] = array('127.0.0.1', '192.168.1.3'); // one or more memcached servers
$cfg['memcached_port'] = 11211; // default memcached port
$cfg['memcached_compress'] = false; // use true to store items compressed
$cfg['memcached_ttl'] = 10; // max number of seconds data (from SELECT statements) should be cached


// HTTP BASIC AUTHENTICATION INFO -- USED BY SUBSYSTEM
$cfg['use_basic_authentication'] = false; // is HTTP Basic authentication being used? if so, set the two variables below...
$cfg['subsystem_basic_auth_username'] = 'nagiosxi'; // subsystem credentials
$cfg['subsystem_basic_auth_password'] = 'somepassword';

$cfg['default_language'] = 'en_US'; // default language
$cfg['default_theme'] = ''; // default theme

// available languages
$cfg['languages'] = array(
"en_US" => "English",
);


/********* DO NOT MODIFY ANYTHING BELOW THIS LINE **********/

$cfg['default_instance_id'] = 1; // default ndoutils instance to read from
$cfg['default_result_records'] = 100000; // max number of records to return by default

$cfg['online_help_url'] = "https://support.nagios.com/"; // comment this out to disable online help links
$cfg['feedback_url'] = "https://api.nagios.com/feedback/";
$cfg['privacy_policy_url'] = "https://www.nagios.com/legal/privacypolicy/";

//$cfg['db_version']=101;
$cfg['db_version'] = 113;
//$cfg['product_version']='2009RC1';

$cfg['subsystem_ticket'] = "12345"; // default - this gets reset...

$cfg['htaccess_file'] = "/usr/local/nagiosxi/etc/htpasswd.users";
$cfg['htpasswd_path'] = "/usr/bin/htpasswd";

$cfg['enable_analytics'] = 1;

// Secure notification %responseurl%
// setting this to 1 will force users to login in the response URL
// $cfg['secure_response_url']=1;

// Globally disable in page help system
// $cfg['disable_helpsystem']=1;

///////// keep these in order /////////

// include generic db defs
require_once(dirname(__FILE__) . '/includes/db.inc.php');

// include generic definitions
require_once(dirname(__FILE__) . '/db/common.inc.php');

[rkennedy]

The config file looks fine, Tom wanted to see if you were running postgres and where the database is hosted - which is local, and everything is on mysql. You'll want to take a backup / snapshot of the XI machine, and then run the commands posted.

[tcanthonyii]

Here is the results of the work. No change.

Code: Select all

[root@NagiosXIMon ~]# mysql -u root -pnagiosxi
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8049
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';
Empty set (0.00 sec)

mysql> SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';
Empty set (0.00 sec)

mysql> quit
Bye
You have new mail in /var/spool/mail/root

Code: Select all

[root@NagiosXIMon ~]# mysqlcheck -f -r -u root -pnagiosxi --all-databases
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  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                                     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
Error    : Incorrect file format 'nagios_commenthistory'
error    : Corrupt
nagios.nagios_comments
Error    : Incorrect file format 'nagios_comments'
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_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
Error    : Incorrect file format 'nagios_customvariables'
error    : Corrupt
nagios.nagios_customvariablestatus                 OK
nagios.nagios_dbversion                            OK
nagios.nagios_downtimehistory                      OK
nagios.nagios_eventhandlers
Error    : Incorrect file format 'nagios_eventhandlers'
error    : Corrupt
nagios.nagios_externalcommands
Error    : Incorrect file format 'nagios_externalcommands'
error    : Corrupt
nagios.nagios_flappinghistory                      OK
nagios.nagios_host_contactgroups
Error    : Incorrect file format 'nagios_host_contactgroups'
error    : Corrupt
nagios.nagios_host_contacts
Error    : Incorrect file format 'nagios_host_contacts'
error    : Corrupt
nagios.nagios_host_parenthosts
Error    : Incorrect file format 'nagios_host_parenthosts'
error    : Corrupt
nagios.nagios_hostchecks                           OK
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                                OK
nagios.nagios_hoststatus                           OK
nagios.nagios_instances                            OK
nagios.nagios_logentries                           OK
nagios.nagios_notifications                        OK
nagios.nagios_objects                              OK
nagios.nagios_processevents                        OK
nagios.nagios_programstatus                        OK
nagios.nagios_runtimevariables
Error    : Incorrect file format 'nagios_runtimevariables'
error    : Corrupt
nagios.nagios_scheduleddowntime
Error    : Incorrect file format 'nagios_scheduleddowntime'
error    : Corrupt
nagios.nagios_service_contactgroups
Error    : Incorrect file format 'nagios_service_contactgroups'
error    : Corrupt
nagios.nagios_service_contacts
Error    : Incorrect file format 'nagios_service_contacts'
error    : Corrupt
nagios.nagios_service_parentservices               OK
nagios.nagios_servicechecks                        OK
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                             OK
nagios.nagios_servicestatus                        OK
nagios.nagios_statehistory
Error    : Incorrect file format 'nagios_statehistory'
error    : Corrupt
nagios.nagios_systemcommands                       OK
nagios.nagios_timedeventqueue                      OK
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                               OK
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
nagiosxi.xi_auditlog
Error    : Incorrect file format 'xi_auditlog'
error    : Corrupt
nagiosxi.xi_commands
Error    : Incorrect file format 'xi_commands'
error    : Corrupt
nagiosxi.xi_events                                 OK
nagiosxi.xi_incidents                              OK
nagiosxi.xi_meta
Error    : Incorrect file format 'xi_meta'
error    : Corrupt
nagiosxi.xi_options                                OK
nagiosxi.xi_sysstat                                OK
nagiosxi.xi_usermeta                               OK
nagiosxi.xi_users                                  OK
[root@NagiosXIMon ~]#

[dwhitfield]

From MySQL, what's the output of SELECT ENGINE FROM information_schema.TABLES;? There will be something like 211 rows. Just dump all of that in code block.

There's also XtraDB, Arias, Falcon, TokuDB, and I think some others (you could write a query with OR statements but I think this is quicker with just 211 to parse). InnoDB is the normal choice. Once we know what we're looking for, you can use the CONCAT statement tgriep gave you.

[tcanthonyii]

Code: Select all

mysql> SELECT ENGINE FROM information_schema.TABLES;
+--------+
| ENGINE |
+--------+
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MyISAM |
| MyISAM |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MEMORY |
| MyISAM |
| MEMORY |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| CSV    |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| CSV    |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
| MyISAM |
+--------+
208 rows in set (0.01 sec)

[dwhitfield]

Well, there you go. I'm glad I didn't write an OR query. So, it looks like you have two CONCAT statements to run.

***Before you convert them, do a full backup of the server in case there are any issues.***

Code: Select all

SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'MEMORY';
SELECT CONCAT('ALTER TABLE ', TABLE_SCHEMA, '.', TABLE_NAME, ' engine=MyISAM;') FROM information_schema.TABLES WHERE ENGINE = 'CSV';

[tcanthonyii]

Also while trying to save a config change I got the attached error.