Page 3 of 3
Re: Manage Users page SQL error
Posted: Wed Dec 14, 2016 11:36 am
by TBT
Yes, there was a failed upgrade in the past. Currently running 5.3.3, see attached upgrade log.
upgrade.log
Re: Manage Users page SQL error
Posted: Wed Dec 14, 2016 12:07 pm
by 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.
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:
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.
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.
Re: Manage Users page SQL error
Posted: Wed Dec 14, 2016 12:20 pm
by TBT
That did the trick. Thank you for your assistance.
Re: Manage Users page SQL error
Posted: Wed Dec 14, 2016 12:31 pm
by tgriep
Your welcome. If you don't have any other questions, shall I close the post as solved?
Re: Manage Users page SQL error
Posted: Wed Dec 14, 2016 12:36 pm
by TBT
tgriep wrote:Your welcome. If you don't have any other questions, shall I close the post as solved?
Issue appears to be resolved.