Nagios XI update to 5.6.1 - "Update in progress"

[robatwork]

This has been an issue in previous versions - upgrade from GUI and the check for updates box never finishes but shows upgrading. This is despite reboots and a manual upgrade.

The published fix is

Code: Select all

grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l


If the command above outputs the number 3, run this command:


echo "update xi_commands set status_code = '2' where command = '1120';" | mysql -uroot -pnagiosxi


If the command above outputs the number 2, run this command:


echo "update xi_commands set status_code = '2' where command = '1120';" | psql nagiosxi nagiosxi

However the command line isn't quite right if it's a 3. The line should be:

Code: Select all

echo "update xi_commands set status_code = '2' where command = '1120';" | mysql -uroot -pnagiosxi nagiosxi

Hope this helps someone else out

[lmiltchev]

We have a KB article on the topic here (FYI):

https://support.nagios.com/kb/article/n ... e-851.html

[robatwork]

That's great thanks, and I hope google will crawl and catch up with it soon so it's a front page hit - it certainly wasn't shown on any searching I did for "update in progress"

[scottwilkerson]

That's great thanks, and I hope google will crawl and catch up with it soon so it's a front page hit - it certainly wasn't shown on any searching I did for "update in progress"

I'm sure it will soon, it is a pretty new article.

[scrantic]

I followed the KB attempted to update from the GUI again and same result? Update in progress. Please wait. Update may take a few minutes.

Nothing comes up with regards to notifications or progress. Is there another step I'm missing or do I need to perform a manual upgrade

[robatwork]

Do it manually and run the last line of my OP

[scottwilkerson]

I followed the KB attempted to update from the GUI again and same result? Update in progress. Please wait. Update may take a few minutes.

Nothing comes up with regards to notifications or progress. Is there another step I'm missing or do I need to perform a manual upgrade

On certain system the manual upgrade is the only process that will work successfully.

[Nickjames2006]

Follow the above code in the post to stop the upgrade then run this

wget -O upgrade.sh https://assets.nagios.com/downloads/nagiosxi/upgrade.sh

sh ./upgrade.sh

Verifying Upgrade
Once the upgrade has completed you should see a message like the following:
Nagios XI Upgrade Complete!
------------------------------------
You can access the Nagios XI web interface by visiting:
http://<server_ip_address>/nagiosxi/
You should now login to the Nagios XI interface and verify everything is still working. If you are already logged
in from earlier, log out and back in again. The Nagios XI interface can be accessed using the URL provided in
the upgrade complete message

[scottwilkerson]

Follow the above code in the post to stop the upgrade then run this

wget -O upgrade.sh https://assets.nagios.com/downloads/nagiosxi/upgrade.sh

sh ./upgrade.sh

Verifying Upgrade
Once the upgrade has completed you should see a message like the following:
Nagios XI Upgrade Complete!
------------------------------------
You can access the Nagios XI web interface by visiting:
http://<server_ip_address>/nagiosxi/
You should now login to the Nagios XI interface and verify everything is still working. If you are already logged
in from earlier, log out and back in again. The Nagios XI interface can be accessed using the URL provided in
the upgrade complete message

thanks @Nickjames2006