NagiosXI 5.5 Upgrade (Fresh install)

[cdienger]

You'll want to modify a few files in the backup to point back to the local database instance before importing it with the restore script. Open the backup and the nagiosxi and nagios archives in it and modify:

/usr/local/nagiosxi/var/xi-sys.cfg/xi-sys.cfg to use the default credentials I've mentioned earlier
/usr/local/nagios/etc/ndo2db.cfg and /usr/local/nagiosxi/html/config.inc.php to use the default settings. These can be found in https://assets.nagios.com/downloads/nag ... Server.pdf

[russell.it]

Cheers.

I will give it ago

[scottwilkerson]

Cheers.

I will give it ago

Let us know if you need further assistance

[russell.it]

Next issue

Restore scripts starts running through and I get the following error after "Restoring Nagios XI MySQL database..."

ERROR 1046 (3D000) at line 8: No database seletec
Error restoring MySQL database 'nagiosxi' !

So I have backed up my install from the old NagiosXI 5.4.13 instance.
Modified the three files to point to the new localhost databases.
Re-tared everything backup.

Done a fresh install of XI 5.4.13 on a new RHEL 7 vm. Run the restore script pointing to the backup tarball. Thats the error I get.

[scottwilkerson]

Edit /usr/local/nagiosxi/html/config.inc.php

change this line

Code: Select all

"dbserver" => '',

to this

Code: Select all

"dbserver" => 'localhost',

[russell.it]

I just checked all three dbserver lines are set to localhost

[ssax]

Ok, I've updated the script to use a different IP address

First, make sure that the local database uses the same users/passwords as the old database.

Then transfer your backup file to the new server and replace this file with the one I've attached (unzip it first):

Code: Select all

/usr/local/nagiosxi/scripts/restore_xi.sh

Then run the restore script like this:

Code: Select all

cd /usr/local/nagiosxi/scripts
./restore_xi.sh /path/to/your/backupfile.tar.gz 127.0.0.1

Then when it's done, you will need to follow the section called Adjust Settings on Nagios XI Server from this guide to change the IP to your new DB:

Code: Select all

https://assets.nagios.com/downloads/nagiosxi/docs/Offloading_MySQL_to_Remote Server.pdf

Make sure to go to Admin > System Settings and update the Program URL and External URL as well.