Manage Users page SQL error

[TBT]

Yes, there was a failed upgrade in the past. Currently running 5.3.3, see attached upgrade log.

upgrade.log

[tgriep]

Thanks for the upgrade.log files, it didn't show any errors from before.

Lets add the missing tables to the postgress database manually but make a full backup of the server in case something doesn't work

Follow this procedure by logging in to the server as root.

Code: Select all

cd /tmp

Make sure you delete the /tmp/nagiosxi/ directory and any old “tar.gz” files the exist. You can do this by running the following command:

Code: Select all

rm -rf nagiosxi xi*.tar.gz

Next, download the latest stable release to the /tmp/ directory on the Nagios XI server. To download run the following command:

Code: Select all

wget http://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz

Unpack the updated tarball you just downloaded.

Code: Select all

tar xzf xi-latest.tar.gz

Then run the following to add the missing tabled to the Postgress database.
psql nagiosxi nagiosxi -f /tmp/nagiosxi/nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql

After this, lets restart the nagios and apache processes by running

Code: Select all

service httpd restart
service nagios restart

Login to the XI GUI and see if the error is gone now.

[TBT]

That did the trick. Thank you for your assistance.

[tgriep]

Your welcome. If you don't have any other questions, shall I close the post as solved?

[TBT]

Your welcome. If you don't have any other questions, shall I close the post as solved?

Issue appears to be resolved.