Update in progress. Please wait...

[DennisPR]

Hi,

I'm having problems upgrading 2 Nagios XI Servers from 5.5.11 to 5.6.
When I run the upgrade from the UI is see the message "Update in progress. Please wait. Update may take a few minutes." but noting appears in the command line box below.

Rebooting the servers didn't help.
Performing the upgrade from the command line worked but in the UI I still see the "Update in progress" message.

Code: Select all

cat /usr/local/nagiosxi/var/xiversion
###################################
# DO NOT DELETE THIS FILE!
# Nagios XI version information
###################################
full=5.6.0
major=5
minor=6.0
releasedate=2018-04-18
release=5600

How can I get rid of the message an be sure that the upgrades went fine ?

[scottwilkerson]

You can just click the "Go back" button on that page

The cat of the file above show me the system have been updated already

[DennisPR]

Hi Scott

Whenever I go back to the check for updates page I it keeps stating "Update in progress. Please wait. Update may take a few minutes."

Nagios update.PNG

Even if I open the page in another browser or after a reboot of the server.

[scottwilkerson]

Underneath the textarea box is there a "Go back" button?

[DennisPR]

Sorry I don't see it.

Nagios update 2.PNG

[scottwilkerson]

That is strange, Can I have you go to this url in the browser

Code: Select all

/nagiosxi/admin/updates.php?acknowledge=true

and then return to the page and it should be reset

[GldRush98]

I had my Dev box choke on the 5.6.0 autoupgrade too. I had upgraded that box through the gui since 2016 and this was the first time it failed me.
I also had the same issue of the hung upgrade in progress message.
This was how I fixed mine:

Run this command:
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

[scottwilkerson]

I had my Dev box choke on the 5.6.0 autoupgrade too. I had upgraded that box through the gui since 2016 and this was the first time it failed me.
I also had the same issue of the hung upgrade in progress message.
This was how I fixed mine:

Run this command:
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

Thanks!

[DennisPR]

That is strange, Can I have you go to this url in the browser

Code: Select all

/nagiosxi/admin/updates.php?acknowledge=true

and then return to the page and it should be reset

If I browse to that URL I get : {"success":1}
If i go back to "Check for updates" it still says " Update in progress."

The commands from GldRush98 fixed the issue on 1 server. Thx !

Code: Select all

[root@myserver ~]# grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l
2
[root@myserver  ~]# echo "update xi_commands set status_code = '2' where command = '1120';" | psql nagiosxi nagiosxi
UPDATE 1

The second server was running mysql and I had to add the database name nagiosxi to the command

Code: Select all

[root@my2ndserver ~]# grep mysql /usr/local/nagiosxi/html/config.inc.php | wc -l
3
[root@my2ndserver  ~]# echo "update xi_commands set status_code = '2' where command = '1120';" | mysql -uroot -pnagiosxi
ERROR 1046 (3D000) at line 1: No database selected

[root@my2ndserver  ~]# echo "update xi_commands set status_code = '2' where command = '1120';" | mysql -uroot -pnagiosxi nagiosxi

[scottwilkerson]

The commands from GldRush98 fixed the issue on 1 server. Thx !

great!

Glad it was resolved!