Page 1 of 4

failed upgrade again. 5.5.11 to 5.6.7

Posted: Mon Oct 21, 2019 7:55 am
by ppalmer
Hi,

We tried upgrading our test XI box to the latest version the other day and although it looked successful the gui states that it's still running 5.5.11 and requires updating to 5.6.7

An Update Is Available!

Your installation of Nagios XI 5.5.11 is outdated and should be upgraded. The latest version of Nagios XI is 5.6.7, which was released on 2019-09-26.

All of the components are 5.6.7

[nagios@smpnagios-kn-t100 ~]$ rpm -qa | grep -i nagios
nagiosxi-nsca-5.6.7-1.el6.x86_64
nagiosxi-nxti-5.6.7-1.el6.x86_64
nagiosxi-nagiosplugins-5.6.7-1.el6.x86_64
nagiosxi-wmic-5.6.7-1.el6.x86_64
nagiosxi-ndoutils-5.6.7-1.el6.x86_64
nagiosxi-wkhtmltox-5.6.7-1.el6.x86_64
nagiosxi-mrtg-5.6.7-1.el6.x86_64
nagiosxi-nagvis-5.6.7-1.el6.x86_64
nagiosxi-nrpe-5.6.7-1.el6.x86_64
nagiosxi-nagioscore-5.6.7-1.el6.x86_64
nagiosxi-5.6.7-1.el6.x86_64
perl-Nagios-Monitoring-Plugin-0.51-1.el6.noarch
nagiosxi-shellinabox-5.6.7-1.el6.x86_64
nagiosxi-nagiosmobile-5.6.7-1.el6.x86_64
nagiosxi-nrds-5.6.7-1.el6.x86_64
nagiosxi-pnp-5.6.7-1.el6.x86_64

Does anyone know what could be wrong here?

Thanks,

Paul

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Mon Oct 21, 2019 10:35 am
by benjaminsmith
Paul,

On occasion the GUI upgrade will hang. It's a known issue that we are planning to re-work. In the meantime, please try running the manual upgrade instead. Log into the terminal as root and run the following commands:

Code: Select all

cd /tmp
rm -rf nagiosxi xi*.tar.gz
wget http://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz
tar xzf xi-latest.tar.gz
cd nagiosxi
./upgrade
If you experience any errors, post the full output of the upgrade log. Also, please follow the guide to re-set the upgrade status.

Nagios XI - Reset Upgrade Status In Web Interface

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 3:37 am
by ppalmer
Hi,

Thanks for your reply. We upgraded from the command line as root rather than performing the upgrade from the GUI. Rather than using wget we downloaded the tar file from the web. The steps followed were the same as you suggested.

Regards,

Paul

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 9:37 am
by benjaminsmith
Hi Paul,

Glad to hear you got it upgraded. Did you have any other questions or may we close this thread?

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 9:41 am
by ppalmer
Hi Benjamin,

No, sorry, I was saying that is how we tried to upgrade it in the first place before it failed. It's still not displaying that it was upgraded.

Regards,

Paul

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 9:44 am
by benjaminsmith
Hi Paul,

Ok, let's get this worked out. Can you upload the entire upgrade log so we can review the errors? Thanks.

Also, the system profile would be helpful.

To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
Save the profile.zip file and share this in a private message and then reply to this post to bring it up in the queue.

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 10:11 am
by ppalmer
Hi Benjamin,

I have sent you the system profile file via private message. Where is the upgrade log located?

Thanks,

Paul

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Tue Oct 22, 2019 10:14 am
by benjaminsmith
Hi Paul,

Check this directory:

Code: Select all

/usr/local/nagiosxi/tmp/upgrade.log

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Wed Oct 23, 2019 5:34 am
by ppalmer
Hi Benjamin,

There are no logs in the tmp directory.

Regards,

Paul

Re: failed upgrade again. 5.5.11 to 5.6.7

Posted: Wed Oct 23, 2019 10:09 am
by benjaminsmith
Hi Paul,

Looking over the profile, there are some database errors which are likely the source of the failed upgrade. Let's try repair the tables and check the sizes.

1. Make a backup or take a VM snapshot.

2. Run the following command to force a repair on the tables.

Code: Select all

mysqlcheck -r -f -uroot -pnagiosxi --all-databases
3. Post the results of the following query.

Code: Select all

echo "SELECT table_name AS 'Table', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema IN ('nagios', 'nagiosql', 'nagiosxi');" | mysql -uroot -pnagiosxi --table
4. Try running the manual upgrade once more and post/screenshot any output errors to the thread.