Upgrade NagiosXI with remote database?

[akepley]

I just want to make sure there are no special instructions for upgrading NagiosXI (5.4.2 to 5.4.3) when the MySQL server is on a separate host. Are there any changes or settings to configure to make sure the upgrade goes smoothly?

[avandemore]

Just a backup, full system/db are sometimes easiest to work with. IIRC, there aren't any DB changes in your upgrade versions though.

[akepley]

I see in the backup/restore documentation, it mentions the following:

Code: Select all

NOTE 2:
 If you changed your MySQL root password to something different than “nagiosxi” (the default), you will need to edit the script 
and change the 
mysqlpass=
 definition found in the first few lines of the script.

I do not see a mysqlpass= line in the backup_xi.sh script

[avandemore]

It's in /usr/local/nagiosxi/scripts/restore_xi.sh and in /usr/local/nagiosxi/var/xi-sys.cfg. I believe those are both in the nested archive nagiosxi.tar.gz.

[akepley]

This is where I get more confused. In the migration of the database documentation, it has me create three separate mysql users: nagiosxi, nagiosql, and nagios. Am I just using nagiosxi in this script?

[avandemore]

Backup and restore use the root user.

[akepley]

Ok the user will have to be changed too as RDS does not default to a root user.

thanks!

[akepley]

Upgrade succeeded so no reason to worry about the restore. You can lock. Thanks.