Nagios Support Forum

Posted: **Tue May 28, 2019 12:44 am**

Hi,

Tried upgrading from web interface and manually from console but without luck.
Getting these errors in log, anyone know how to fix the upgrade?
Thanks"

psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql:6: ERROR: type "e_mib_type" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql:12: ERROR: relation "xi_mibs_mib_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql:23: ERROR: relation "xi_mibs" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_05.sql:25: ERROR: column "trapdata_parent_mib_name" of relation "xi_cmp_trapdata" already exists
No entry for terminal type "unknown";
using dumb terminal settings.
<p><pre>SQL Error [nagiosxi] : ERROR: duplicate key value violates unique constraint "xi_mibs_mib_name_key"</pre></p>
chown: invalid user: `snmptt:nagios'

/Thommy

Posted: **Tue May 28, 2019 12:52 pm**

Hello, @thommyronnholm. Please back up your XI first, or take a snapshot of the VM. Then follow these instructions:

Code: Select all

cd /tmp
rm -rf nagiosxi xi*.tar.gz
wget http://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz
tar xzf xi-latest.tar.gz
cd nagiosxi
touch mysql.5600.updated
./upgrade

If you already extracted the nagiosxi folder in /tmp/, just cd into nagios xi and run:

Code: Select all

touch mysql.5600.updated

And rerun the upgrade script:

Code: Select all

./upgrade

Posted: **Wed May 29, 2019 5:04 am**

Hi

Thanks for information but found this in another post and tried all solutions I could find regarding upgrading.
All solutions failed so then I tried restoring all backups I had but the all failed with upgrade.

Ended up with removing everything from system and making a new clean installation with latest version.

/Thommy

Posted: **Wed May 29, 2019 2:02 pm**

Ended up with removing everything from system and making a new clean installation with latest version.
/Thommy

Hi Thommy,

Thanks for the update and It looks like you have it worked out. Let us know if you have any other questions or need any assistance.

Nagios Support Forum

Upgrade from 5.4.10 to 5.6.2 failure

Upgrade from 5.4.10 to 5.6.2 failure

Re: Upgrade from 5.4.10 to 5.6.2 failure

Re: Upgrade from 5.4.10 to 5.6.2 failure

Re: Upgrade from 5.4.10 to 5.6.2 failure