Search found 7 matches

by lucasnap
Wed Jan 17, 2018 6:45 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

Found it, I only needed to set use_https back to true in this file:

Code: Select all

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

Code: Select all

$cfg['use_https']=true;
Now all works fine again, thanks for all the help.
by lucasnap
Tue Jan 16, 2018 8:45 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

Hi,

This fixed the mysql database! great!

I still have some issues (not able to apply new configuration) but my configuration is back.
by lucasnap
Mon Jan 15, 2018 5:19 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

Hi, I've found the init-mysql script in the Nagios XI installer and run the import command that I thought would do the trick: I took a pretty old backup, but the config should be good: gunzip /store/backups/mysql/daily/mysql_2017-07-11_07h00m.Tuesday.sql.gz mysql -pnagiosxi < /store/backups/mysql/da...
by lucasnap
Sat Jan 13, 2018 5:20 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

OK, great.

I'll check it out next week, i'll ask questions here when I don't understand.

Thanks a lot.
by lucasnap
Thu Jan 11, 2018 4:01 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

Hi,

Yes I have a backups in /store/backup/mysql. Not in nagiosxi.

Would that be sufficient?

I am a customer but only with maintenance, not with support (doh!)

Thanks
by lucasnap
Wed Jan 10, 2018 5:11 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

Re: SQL Error [ndoutils] : Incorrect file format 'nagios_hos

I've run the command's but with no success: [root@nagios ~]# mysql -u root -pnagiosxi Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 46918 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type...
by lucasnap
Tue Jan 09, 2018 8:40 am
Forum: Nagios XI
Topic: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa
Replies: 12
Views: 5299

SQL Error [ndoutils] : Incorrect file format 'nagios_hoststa

Hi, After updating Nagios XI and CentOS 7 and a reboot I get this error in my dashboard: SQL Error [ndoutils] : Incorrect file format 'nagios_hoststatus' I've tried to repair the database with this command: /usr/local/nagiosxi/scripts/repair_databases.sh Output: nagios database repair FAILED, please...