Upgrade from 5.4.10 to 5.6.2 failure

[thommyronnholm]

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

[npolovenko]

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

[thommyronnholm]

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

[benjaminsmith]

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.