[ndoutils] : Incorrect file format 'nagios_servicestatus' SQ

[intelXIadmin]

Hello,

I am getting this error message after logging into our server today. No servers are showing up under any of the active views, like tactical overiew.

[ndoutils] : Incorrect file format 'nagios_servicestatus' SQL: SQL Error [ndoutils] : Incorrect file format 'nagios_servicestatus' SQL: SQL Error

Regards,

Randy.

[abrist]

1. Did this machine experience an unexpected loss of power?
2. Do you have backups?
3. Have you tried running the sql repair script?

[intelXIadmin]

oops, I fogot to mention versions:

1. OS - Redhat 6.4
2. NagiosXI - 2012R1.8

1. Did this machine experience an unexpected loss of power? Yes
2. Do you have backups? Not of the database
3. Have you tried running the sql repair script? Yes

Now, if I was to lose all the historical data it wouldn't be a problem at all. I just don't want to lose the configurations.

[scottwilkerson]

By default XI systems have this DB backed up in
/store/backups/mysql/daily/nagios
/store/backups/mysql/weekly/nagios
/store/backups/mysql/monthly/nagios

Do you have these?

[intelXIadmin]

Yes.

[intelXIadmin]

I see the files. I did not create them using the backup script. Are they tar files, or just gzip files? How are they restored?

Regards,

Randy.

[scottwilkerson]

they are just gzip, and are created on a daily cron, here is an example restore of the nagios DB

Code: Select all

[root@localhost nagios]# cd /store/backups/mysql/daily/nagios
[root@localhost nagios]# ls -l
total 28264
-rw-r--r-- 1 root root 4421384 Apr 12 07:00 nagios_2013-04-12_07h00m.Friday.sql.gz
-rw-r--r-- 1 root root 4692986 Apr 17 07:00 nagios_2013-04-17_07h00m.Wednesday.sql.gz
-rw-r--r-- 1 root root 4789457 Apr 18 07:00 nagios_2013-04-18_07h00m.Thursday.sql.gz
-rw-r--r-- 1 root root 4941059 Apr 21 07:00 nagios_2013-04-21_07h00m.Sunday.sql.gz
-rw-r--r-- 1 root root 4998263 Apr 22 07:00 nagios_2013-04-22_07h00m.Monday.sql.gz
-rw-r--r-- 1 root root 5084448 Apr 23 07:00 nagios_2013-04-23_07h00m.Tuesday.sql.gz
[root@localhost nagios]# gunzip nagios_2013-04-23_07h00m.Tuesday.sql.gz
[root@localhost nagios]# cat nagios_2013-04-23_07h00m.Tuesday.sql | mysql -pnagiosxi nagios

[intelXIadmin]

Hello,

I was able to resolve this using a Nagiosxi backup. I run the restore procedure.

[slansing]

Excellent, thank you for letting us know.