failed upgrade again. 5.5.11 to 5.6.7

[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

[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

[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

[benjaminsmith]

Hi Paul,

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

[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

[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.

[ppalmer]

Hi Benjamin,

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

Thanks,

Paul

[benjaminsmith]

Hi Paul,

Check this directory:

Code: Select all

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

[ppalmer]

Hi Benjamin,

There are no logs in the tmp directory.

Regards,

Paul

[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.