Upgrade NagiosXI with remote database?
Upgrade NagiosXI with remote database?
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?
-
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: Upgrade NagiosXI with remote database?
Just a backup, full system/db are sometimes easiest to work with. IIRC, there aren't any DB changes in your upgrade versions though.
Previous Nagios employee
Re: Upgrade NagiosXI with remote database?
I see in the backup/restore documentation, it mentions the following:
I do not see a mysqlpass= line in the backup_xi.sh script
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.
-
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: Upgrade NagiosXI with remote database?
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.
Previous Nagios employee
Re: Upgrade NagiosXI with remote database?
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?
-
- Posts: 1597
- Joined: Tue Sep 27, 2016 4:57 pm
Re: Upgrade NagiosXI with remote database?
Backup and restore use the root user.
Previous Nagios employee
Re: Upgrade NagiosXI with remote database?
Ok the user will have to be changed too as RDS does not default to a root user.
thanks!
thanks!
Re: Upgrade NagiosXI with remote database?
Upgrade succeeded so no reason to worry about the restore. You can lock. Thanks.