Page 1 of 1
Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 10:06 am
by 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?
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 10:42 am
by 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.
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 10:53 am
by 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
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 11:04 am
by 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.
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 11:09 am
by 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?
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 11:13 am
by avandemore
Backup and restore use the root user.
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 12:18 pm
by akepley
Ok the user will have to be changed too as RDS does not default to a root user.
thanks!
Re: Upgrade NagiosXI with remote database?
Posted: Tue Mar 28, 2017 12:41 pm
by akepley
Upgrade succeeded so no reason to worry about the restore. You can lock. Thanks.