Upgrade in Progress - keeps spinning

[jdulac]

All,

I have done a few NagiosXI upgrades manually via CLI without issues. On the most recent upgrade to 5.6.2 I elected to try it through the web GUI and it didn't work. I went ahead and upgraded via CLI and am now running 5.6.2 but the update in progress is still spinning. I know this is a known issue, but it's been a known issue for two years now. Will this ever get resolved?

I have tried the update xi_commands set status_code = '2' where command = '1120' command and the CLI accepts it but it won't clear out the spinning update in progress.

Any thoughts on this?

Thanks

[npolovenko]

Hello, @jdulac. Please run these manual upgrade commands from the command line, and if you see any errors, please upload the /tmp/nagiosxi/upgrade.log file in the thread:

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

But if the upgrade shows no errors, please rerun the DB query one more time.
For postgresql:

Code: Select all

psql nagiosxi nagiosxi -c "update xi_commands set status_code = '2' where command = '1120'"

For mysql:

Code: Select all

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

PS: It doesn't matter if you see the latest version in the gui(5.6.2), run the manual upgrade steps one more time.

[jdulac]

Thanks, that worked. I was running the wrong command and needed to do the psql command.

[npolovenko]

@jdulac, Thanks for the update! I'll be closing this ticket as resolved.