Nagios WebUI Update not working

[IMTECH]

Of course.

There is no upgrade.log in this directory.
All there is is the following.

Code: Select all

-rwxrwxr-- 1 nagios nagios  5770 Aug  8 11:25 components_api_versions.xml
-rw-r--r-- 1 nagios nagios 10014 Aug  8 11:25 configwizard-passivecheck.zip
-rw-r--r-- 1 nagios nagios 66523 Aug  8 11:26 configwizard-radiusserver.zip
-rwxrwxr-- 1 nagios nagios  8836 Aug  8 11:26 configwizards_api_versions.xml

Code: Select all

echo 'select * from  xi_options  WHERE name="last_update_check_succeeded";' |mysql -t -u root -pnagiosxi nagiosxi
+-----------+-----------------------------+-------+
| option_id | name                        | value |
+-----------+-----------------------------+-------+
|        16 | last_update_check_succeeded | 1     |
+-----------+-----------------------------+-------+

echo 'desc  xi_options;' |mysql -t -u root -pnagiosxi nagiosxi
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| option_id | int(11)      | NO   | PRI | NULL    | auto_increment |
| name      | varchar(128) | NO   | MUL | NULL    |                |
| value     | text         | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+

[tgriep]

Can you run the following as root and PM me the /tmp/options.txt file?

Code: Select all

 echo 'select * from xi_options;' |mysql -t -u root -pnagiosxi nagiosxi >/tmp/options.txt

That will dump all of the settings in to one file so we can see all of the settings at once.
You don't want to post the file as it will have licensing and other info you don't want others to see.
Have you tried just rebooting the server and see if that fixes the issue?

[IMTECH]

Just sent you the options.txt by PM.

Server has already been rebooted, but it didnt change something.

[tgriep]

I received your PM but the file was not attached, can you send it again?

[skostmayer]

I have executed the commands as requested

Code: Select all

echo 'UPDATE xi_options SET value=1 WHERE name="last_update_check_succeeded";' |mysql -u root -pnagiosxi nagiosxi

and restarted the service but this did not correct the issue.

[tgriep]

@skostmayer, can you run the following as root and PM me the /tmp/options.txt file?

Code: Select all

echo 'select * from xi_options;' |mysql -t -u root -pnagiosxi nagiosxi >/tmp/options.txt

You don't want to post the file as it will have licensing and other info you don't want others to see.
Thanks

[skostmayer]

I have sent the file in a PM as requested.

Thanks

[tgriep]

The data in the SQL dump is showing that the system did not update even after the manual upgrade.
Can you run the following on the Nagios server and post the output?

Code: Select all

grep xiver  /usr/local/nagiosxi/var/xi-sys.cfg

If should show the current version of XI that is installed.
If it says, 5.4.7, try the manual install again.
Make sure to delete the existing downloaded files and start over.
The downloaded files could of been the older version.

[skostmayer]

Code: Select all

grep xiver  /usr/local/nagiosxi/var/xi-sys.cfg
xiver='5.4.7'

The manual install completed successfully. But the WebUI does not reflect this other than displaying the correct version in the bottom left of the window.

[tgriep]

If the manual upgrade files are still on the system then can you run the following command?

Code: Select all

grep full  /tmp/nagiosxi/nagiosxi/basedir/var/xiversion

If it says 5.4.8 then we will need to see the /tmp/nagiosxi/upgrade.log file to see if there are any errors on why the manual upgrade did not work.

If it says 5.4.7 then the wrong package has been downloaded.