Nagios Support Forum

Posted: **Fri Jan 11, 2019 5:53 am**

Hi,

I run the backup every day at 04:00 GMT+1 using the backup script provided

/usr/local/nagiosxi/scripts/backup_xi.sh

I noticed that sometimes, the backup fails due to MySQL database 'nagios' user password.

Here's the log:

Code: Select all

Running configuration check...
 Stopping nagios:. done.
 Starting nagios: done.
 Backing up Core Config Manager (NagiosQL)...
 Backing up Nagios Core...
 Backing up Nagios XI...
 Backing up MRTG...
 Backing up NRDP...
 Backing up Nagvis...
 Backing up MySQL databases...
Error backing up MySQL database 'nagios' - check the password in this script!

We never changed the default password, and if we run the backup again it will work fine meaning that password is ok. It just seems to be happening sporadically.

Any ideas?

Posted: **Fri Jan 11, 2019 5:57 am**

Sorry I missed telling that Nagios XI version is currently 5.4.13 running on CentOS 6.10

Posted: **Fri Jan 11, 2019 3:21 pm**

Hi @nms,

It's possible you have crashed tables in your database. Log in as root and run the following command:

Code: Select all

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

Repairing the Nagios XI Database
https://assets.nagios.com/downloads/nag ... tabase.pdf

Let me know if that resolves the issue for you.

Posted: **Fri Jan 18, 2019 8:12 am**

Thanks. Repaired DB as per procedure and till now I did encounter any issues.
You can lock the thread for now.

Rgds

Posted: **Fri Jan 18, 2019 10:29 am**

Hi @nms,

Glad you got it working. Closing thread.

Thank you for using the Nagios Support Forum.

Nagios Support Forum

Nagios XI Backup intermittent failure

Nagios XI Backup intermittent failure

Re: Nagios XI Backup intermittent failure

Re: Nagios XI Backup intermittent failure

Re: Nagios XI Backup intermittent failure

Re: Nagios XI Backup intermittent failure