Nagios Support Forum

We had a /var/ filesystem fill up and we were getting the below messages:
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.br /br /Run the following from the CLI as root to attempt to repair the DBbr /br /pre/usr/local/nagiosxi/scripts/repair_databases.sh/preMessage: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.br /br /Run the following from the CLI as root to attempt to repair the DBbr /br /pre/usr/local/nagiosxi/scripts/repair_databases.sh/preMessage: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.br /br /Run the following from the CLI as root to attempt to repair the DBbr /br /pre/usr/local/nagiosxi/scripts/repair_databases.sh/pre?xml version=1.0 encoding=utf-8?


I ran the repair_databases.sh, but it says repaired failed and I see the below message:
myisamchk: error: 'nagios_servicestatus.MYI' is not a MyISAM

It looks like a DBA or someone must have changed the table types from InnoDB to MyISAM. Check out pages 5 and 6 of this doc for the conversion procedure: https://assets.nagios.com/downloads/nag ... tabase.pdf

I would also advise against modifications of the database for this reason.