Want to Reset Upgrade Status In Nagios Web Interface? We can help you.

Generally, when we upgrade Nagios XI using the web interface, we come across the message “Upgrade in progress”.

As part of our Server Management Services, we assist our customers with several Nagios queries.

Today, let us see how we can reset the upgrade status.

Reset Upgrade Status In Nagios Web Interface

With the “Upgrade in progress,” message the upgrade may stall. In such a case, we need to clear this message manually due to unforeseen circumstances.

In order to reset the status, we require two pieces of information to execute the command:

• Database Type

To store the Nagios XI preferences they use either a PostgreSQL database or MySQL/MariaDB. It depends on the versions.

To determine which we use, we execute the following command in the Nagios XI server:

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

Out output will look similar to either of the following:

“dbtype” => ‘pgsql’,
OR
“dbtype” => ‘mysql’,

• Database Password

Generally, there is a username and password associated with the “nagiosxi” database. The default username is “nagiosxi” and the password is “n@gweb”.

We need to refer to the config.inc.php file to see if we changed it t any point.

In order to check, open the file in any text editor.

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

Then we locate the following nagiosxi section:

“nagiosxi” => array(
“dbtype” => ‘mysql’,
“dbserver” => ”,
“user” => ‘nagiosxi’,
“pwd” => ‘n@gweb’,
“db” => ‘nagiosxi’,

From the output, we can see the user and pwd fields contain the values we require for further procedures.

Reset Upgrade Status

Moving ahead, let us see how to reset the upgrade status on Nagios XI. With the default username and password above, we run:

• MySQL/MariaDB:

mysql -u’nagiosxi’ -p’n@gweb’ nagiosxi -e “update xi_commands set status_code = ‘2’ where command = ‘1120’;”

• PostgreSQL:

psql -U nagiosxi -W -d nagiosxi -c “update xi_commands set status_code = ‘2’ where command = ‘1120’”

There will be a prompt for the password at the command line.

Once we execute the command, we can navigate to the web interface Admin > System Information > Check For Updates.

Eventually, we can see the upgrade status will now be reset.

[Need help with the reset? We are here for you]

Conclusion

In short, we saw how our Support Techs Reset Upgrade Status In Nagios Web Interface.