How to upgrade XI with offloaded DB

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: How to upgrade XI with offloaded DB

Post by sreinhardt »

It should work just fine with altered or default passwords and offloaded dbs. As bandit pointed out, the user\password options are taken from config.inc.php. Since the intial output doesn't specify which portion you are failing on, could you run:

Code: Select all

./upgrade 2&> /tmp/upgrade.log
And send that over? I do realize this may cause some issues for you, and a backup should be done first. But without that log I cannot say where you are failing, and what is already being completed.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: How to upgrade XI with offloaded DB

Post by rajasegar »

sreinhardt wrote:It should work just fine with altered or default passwords and offloaded dbs. As bandit pointed out, the user\password options are taken from config.inc.php. Since the intial output doesn't specify which portion you are failing on, could you run:

Code: Select all

./upgrade 2&> /tmp/upgrade.log
And send that over? I do realize this may cause some issues for you, and a backup should be done first. But without that log I cannot say where you are failing, and what is already being completed.
Below are the only lines on the log file

Code: Select all

[root@nagiosprodxi1 nagiosxi]# cat /tmp/upgrade.log
PHP Warning:  mysql_pconnect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /tmp/raja/nagiosxi/nagiosxi/basedir/html/db/adodb/drivers/adodb-mysql.inc.php on line 383
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.<br /><br />Run the following from the CLI as root to attempt to repair the DB<br /><br /><pre>/usr/local/nagiosxi/scripts/repair_databases.sh</pre>Checking required prereqs...
Please wait...

Unknown option:  2
./upgrade: line 47: usage: command not found

BTW, after Nagios reboot all the Hostgroup Summary/Overview/Grid screens will show no groups.
Have to manually Apply Configurations for it to show up.
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
abrist
Red Shirt
Posts: 8334
Joined: Thu Nov 15, 2012 1:20 pm

Re: How to upgrade XI with offloaded DB

Post by abrist »

It looks like your instance is half-upgraded as the upgrade script is bailing out. Could you send an email to [email protected] to open a ticket?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
rajasegar
Posts: 1018
Joined: Sun Mar 30, 2014 10:49 pm

Re: How to upgrade XI with offloaded DB

Post by rajasegar »

abrist wrote:It looks like your instance is half-upgraded as the upgrade script is bailing out. Could you send an email to [email protected] to open a ticket?
Done.
5 x Nagios 5.6.9 Enterprise Edition
RHEL 6 & 7
rrdcached & ramdisk optimisation
Locked