Nagios XI Backup intermittent failure

[nms]

Hi,

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

Code: Select all

/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?

[nms]

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

[benjaminsmith]

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.

[nms]

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

Rgds

[benjaminsmith]

Hi @nms,

Glad you got it working. Closing thread.

Thank you for using the Nagios Support Forum.