Page 1 of 1

Error configuring SSH Proxy Monitoring Wizard

Posted: Mon Jun 11, 2018 4:59 am
by Roally
Hi,

I'm running a virtual environment with PfSense and Nagios. I've can connect to my PfSense with SSH on Nagios.
Now I'm configuring the SSH Proxy Monitoring Wizard on the Nagios GUI, but I get the following error message after finishing the Wizard:

SQL Error [nagiosxi] : Incorrect file format 'xi_meta'

SQL Error [nagiosxi] : Incorrect file format 'xi_commands'

Does someone know what this means or how to fix this problem?

Re: Error configuring SSH Proxy Monitoring Wizard

Posted: Mon Jun 11, 2018 12:04 pm
by mcapra
Have you manually altered the database in any way recently? Restored an older version of XI to MySQL by hand? That sort of stuff?

I would also make sure this machine isn't running out of disk space. That can often lead to database tables getting messed up.

Try running the following script and see if it fixes the problem:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
If that script produces any errors or warnings, please share them in this thread.

Re: Error configuring SSH Proxy Monitoring Wizard

Posted: Mon Jun 11, 2018 3:20 pm
by scottwilkerson
I agree with @mcapra