Nagios Support Forum

Posted: **Thu Jun 09, 2016 1:27 am**

Hi,

I'm having problem with running update from Nagios XI WEB UI. My configuration is attached.

I always get this error

---- Starting Nagios XI Backup ----
No entry for terminal type "unknown";
using dumb terminal settings.
Backing up Core Config Manager (NagiosQL)...
tar: Removing leading `/' from member names
tar: Removing leading `/' from member names
Backing up Nagios Core...
tar: Removing leading `/' from member names
tar: /usr/local/nagios/share/perfdata/secure.24x7.rs: file changed as we read it
tar: /usr/local/nagios/share/perfdata/VOLKSOB1: file changed as we read it
tar: /usr/local/nagios/var/rw/nagios.qh: socket ignored
tar: /usr/local/nagios/var/ndo.sock: socket ignored
tar: /usr/local/nagios/var: file changed as we read it
Backing up Nagios XI...
tar: Removing leading `/' from member names
Backing up MRTG...
tar: Removing leading `/' from member names
Backing up NRDP...
tar: Removing leading `/' from member names
Backing up Nagvis...
tar: Removing leading `/' from member names
Backing up MySQL databases...
mysqldump: Got error: 130: Incorrect file format 'nagios_systemcommands' when using LOCK TABLES
Error backing up MySQL database 'nagios' - check the password in this script!

I was checking database: mysqlcheck -r nagios -p*********
and it returned OK for all tables, i'm also able to connect with password provided in configuration files to mysql from console.

I ran command tail /var/log/mysqld.lg -n 100 > /tmp/myslqd_log.txt and did not find any errors in it.

I need help to make this WEB UI update work.

Best Regards

Milan Jaksic

Posted: **Thu Jun 09, 2016 10:01 am**

It is strange that the mysqld.log doesn't show any errors but the script gives you: "mysqldump: Got error: 130: Incorrect file format 'nagios_systemcommands' when using LOCK TABLES". Try running the repair on the database just in case the issue (for some reason) didn't show up in the log.

Code: Select all

cd /usr/local/nagiosxi/scripts
./repair_databases.sh

If this doesn't help, you could try a few other methods:

Code: Select all

mysqlcheck -r -f -u root -pnagiosxi --databases nagios

or:

Code: Select all

service mysqld stop
cd /var/lib/mysql/nagios
myisamchk -r -f *
service mysqld start
rm -f /usr/local/nagiosxi/var/dbmaint.lock
/usr/bin/php /usr/local/nagiosxi/cron/dbmaint.php

or:

Code: Select all

echo 'repair table nagios_systemcommands use_frm;' | mysql -t -u root -pnagiosxi nagios

Posted: **Thu Jun 16, 2016 1:31 am**

Hi,

i tried all. Nothing changed.

Anything else I could do?

Posted: **Thu Jun 16, 2016 9:08 am**

Is opening a new support ticket in our email ticketing system an option for you? We may need to schedule a remote to further troubleshoot this issue.

To open an email ticket, send you latest profile to [email protected]. Type "Nagios XI WEB UI update not working" in the subject field, and provide a URL link to this post in the email's body. Thank you!

Posted: **Tue Jul 19, 2016 9:11 am**

Closing this out as I see a ticket has arrived.

Nagios Support Forum

Nagios XI WEB UI update not working

Nagios XI WEB UI update not working

Re: Nagios XI WEB UI update not working

Re: Nagios XI WEB UI update not working

Re: Nagios XI WEB UI update not working

Re: Nagios XI WEB UI update not working