Page 1 of 1

Upgrade from 5.4.10 to 5.6.2 failure

Posted: Mon May 27, 2019 3:49 am
by thommyronnholm
Hi

I am trying to upgrade NagiosXI and getting this failure both in web interface and from command line upgrade.
Anyone know how to fix this issue?

INSTALL: Dashlets installed/updated OK.
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'

Re: Upgrade from 5.4.10 to 5.6.2 failure

Posted: Tue May 28, 2019 3:27 pm
by npolovenko
Hello, @thommyronnholm. Please run the following commands from the command line:

Code: Select all

cd /tmp/nagiosxi/
touch mysql.5600.updated
And then rerun the upgrade script:

Code: Select all

./upgrade
Let me know if the upgrade goes through this time.

Re: Upgrade from 5.4.10 to 5.6.2 failure

Posted: Tue Jun 04, 2019 4:38 am
by wbright
I am upgrading from 5.4.8 to 5.6.2 and getting the same error.
I have done the fix that was listed but it is still stopping at the same point.

Re: Upgrade from 5.4.10 to 5.6.2 failure

Posted: Wed Jun 05, 2019 4:45 pm
by npolovenko
@wbright, Please post the exact error you've got during the installation.

Re: Upgrade from 5.4.10 to 5.6.2 failure

Posted: Thu Jun 06, 2019 8:46 pm
by wbright
Below is the error that I am getting when upgrading from 5.4.8 to 5.6.2
Note: Mod_Gearman has upgraded to Version 3, and CORE upgraded to 4.4.3 without issue.

DASHLET NAME: rss_dashlet
CMD=grep register_dashlet /usr/local/nagiosxi/tmp/XHPFA/rss_dashlet/rss_dashlet. inc.php | wc -l
1
OUT=1
Dashlet looks ok...
CMD: cp -rf /usr/local/nagiosxi/tmp/XHPFA/rss_dashlet /usr/local/nagiosxi/html/i ncludes/dashlets/
CMD: rm -rf /usr/local/nagiosxi/tmp/XHPFA
CMD: . /usr/local/nagiosxi/var/xi-sys.cfg && chown -R $nagiosuser /usr/local/nag iosxi/html/includes/dashlets/rss_dashlet


Done!
INSTALL: Dashlets installed/updated OK.
<p><pre>SQL Error [nagiosxi] : ERROR: duplicate key value violates unique c onstraint "xi_mibs_mib_name_key"</pre></p>
chown: invalid user: `snmptt:nagios'

Re: Upgrade from 5.4.10 to 5.6.2 failure

Posted: Fri Jun 07, 2019 4:15 pm
by npolovenko
@wbright, Please run the following command:

Code: Select all

useradd snmptt
Rerun the upgrade script and then upload the /tmp/nagiosxi/upgrade.log in the ticket.