Home » Categories » Multiple Categories

Nagios XI - Reset Upgrade Status In Web Interface

Problem Description

When upgrading Nagios XI using the web interface the upgrade progress may stall with the message "Upgrade in progress". Sometimes you will need to clear this message manually due to unforeseen circumstances, this KB article explains how to clear the message.

 

 

Requirements

There are two pieces of information you require to execute the command in this KB article:

  1. Database Type
  2. Database Password

 

Database Type

Nagios XI versions before 5.x used a PostgreSQL database for storing the Nagios XI preferences. In Nagios XI 5.x this was moved over to the MySQL/MariaDB database. The command you will execute in this KB article differs between PostgreSQL and MySQL/MariaDB. To determine which one you are using execute the following command your Nagios XI server:

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

Which should output one of the following:


"dbtype" => 'pgsql',

or

"dbtype" => 'mysql',

 

Database Password

The "nagiosxi" database has a username and password associated with it. The default username is "nagiosxi" and the default password is "n@gweb". If you have changed the password you will need to refer to the config.inc.php file, open it in the vi editor with the following command:

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

 

Locate the following nagiosxi section:

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

 

You can see the user and pwd fields contain the values you will require in the following command.

 

 

Reset Upgrade Status

The following command will reset the upgrade status on Nagios XI (using the default username and password listed above):

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'"

You will be prompted for the password at the command line.

 

Once the command has been executed you can navigate to the web interface Admin > System Information > Check For Updates and the upgrade status will now be reset.

 

 

Final Thoughts

For any support related questions please visit the Nagios Support Forums at:

http://support.nagios.com/forum/

3 (2)
Article Rating (2 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - How To Test Check Commands From The Command-line
Viewed 25191 times since Tue, Jan 26, 2016
Nagios XI - Configuration Applies, but still get "Configuration File Is Out Of Date" Error
Viewed 2503 times since Tue, Jan 26, 2016
Nagios XI - SNMP MIB Upload Problems
Viewed 4963 times since Mon, Apr 10, 2017
Nagios XI - MSSQL Query Wizard - Invalid characters in the username
Viewed 2806 times since Thu, Aug 3, 2017
ERROR: Please add the ’Optional’ channel to your Red Hat systems subscriptions
Viewed 17146 times since Tue, Jan 26, 2016
Nagios XI - Bandwidth Graphs Showing 0Mb/s in Non-English Systems
Viewed 3732 times since Fri, Dec 19, 2014
Nagios XI - Configuration Applies, No Changes Take Place
Viewed 3492 times since Tue, Jan 27, 2015
Nagios XI - Disabling Database UTF8 Connectivity
Viewed 2742 times since Thu, Mar 8, 2018
Nagios XI - Display All Scheduled Reports
Viewed 2582 times since Wed, Oct 12, 2016
Nagios XI - Unable To Login Using Two Factor Authentication
Viewed 3093 times since Tue, Apr 10, 2018