Error configuring SSH Proxy Monitoring Wizard

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
Roally
Posts: 2
Joined: Mon Jun 11, 2018 4:51 am

Error configuring SSH Proxy Monitoring Wizard

Post 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?
User avatar
mcapra
Posts: 3739
Joined: Thu May 05, 2016 3:54 pm

Re: Error configuring SSH Proxy Monitoring Wizard

Post 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.
Former Nagios employee
https://www.mcapra.com/
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Error configuring SSH Proxy Monitoring Wizard

Post by scottwilkerson »

I agree with @mcapra
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
Locked