Appliance Updated - But Still Updating?

[MattTheQuick]

Hey everyone,

I went in to update our Nagios XI virtual appliance today to 2024R1.1.3 and noticed that after it updated and the log says things are ready to go, the "Update in progress" notification kept spinning. I tried a few things including logging out and back in but it looks like whenever I go to "check for updates" the spinning persists. I could try to reboot the appliance from VMWare but I'm worried that there is some part of the update process still ongoing. Does anyone have any ideas?

[jsimon]

Hi @MattTheQuick,

This can happen sometimes when doing the upgrade from the Nagios XI UI. In order to fix this, please run the following command in your command line on your XI server:

Code: Select all

awk '/"nagiosxi" => array\(/{getline;print}' /usr/local/nagiosxi/html/config.inc.php

This will return one of two values letting us know which steps to take next. (Keep in mind you will need to enter your database password for the next step. If you don't know it, you can get it from here:

Code: Select all

vi /usr/local/nagiosxi/html/config.inc.php

You should see a "nagiosxi" segment that will have data like this:

Code: Select all

"nagiosxi" => array(
        "dbtype" => 'mysql',
        "dbserver" => '',
        "user" => 'nagiosxi',
        "pwd" => 'n@gweb',
        "db" => 'nagiosxi',

The "pwd" value is what we're looking for here.

If you get back

Code: Select all

"dbtype" => 'mysql',

run this:

Code: Select all

mysql -u'nagiosxi' -p'n@gweb' nagiosxi -e "update xi_commands set status_code = '2' where command = '1120';"

If you get back

Code: Select all

"dbtype" => 'pgsql',

run this instead:

Code: Select all

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

Running the correct command here will reset your upgrade status.

[MattTheQuick]

Looks like when I sign into the SSH Terminal as root and run that command I get the following returned

Code: Select all

"dbmaint_user" => 'dbmaint_nagiosxi',

EDIT: When I run

Code: Select all

vi /usr/local/nagiosxi/html/config.inc.php

I can see that the dbtype under the "nagiosxi" section is 'mysql'.

As such I ran the following and reset the update status to be correct once again

Code: Select all

mysql -u'nagiosxi' -p'n@gweb' nagiosxi -e "update xi_commands set status_code = '2' where command = '1120';"

Thanks for the help!

[jsimon]

No problem! Glad we were able to get that resolved, I'll go ahead and lock the thread.