Page 2 of 3
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 11:38 am
by benhank
Well good and bad news.
I tested the links in the mirrors-rpmforge and they failed. so I got a list of fresh mirrors from
and they worked.
But now im getting this at the end of the update:
Code: Select all
Attempting to read global hard/soft nofile limits failed. Check /etc/security/limits.conf and try again!
I downloaded the ver5.3.0 tarball and tried to do a manual upgrade.
when will I ever learn to never say"just upgrade it will be easy, there wont be any problems..." lol
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 11:44 am
by avandemore
Ok great progress. That's a known issue with 5.3.0. Please
download 5.3.1 here and use the same process to upgrade.
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 2:59 pm
by benhank
almost there....
Code: Select all
Done!
Dashlets installed/updated OK
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:2: ERROR: column "api_key" o f relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:3: ERROR: column "api_enable d" of relation "xi_users" already exists
UPDATE 96
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:8: ERROR: column "login_atte mpts" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:9: ERROR: column "last_attem pt" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:10: ERROR: column "last_pass word_change" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:13: ERROR: column "last_logi n" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:14: ERROR: column "last_edit ed" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:15: ERROR: column "last_edit ed_by" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:16: ERROR: column "created_b y" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:17: ERROR: column "created_t ime" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:24: ERROR: relation "xi_even tqueue_eventqueue_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:33: ERROR: relation "xi_even tqueue" already exists
ERROR 1060 (42S21) at line 39: Duplicate column name 'exclude'
ran it again and
Code: Select all
Done!
Dashlets installed/updated OK
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:2: ERROR: column "api_key" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:3: ERROR: column "api_enabled" of relation "xi_users" already exists
UPDATE 96
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:8: ERROR: column "login_attempts" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:9: ERROR: column "last_attempt" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:10: ERROR: column "last_password_change" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:13: ERROR: column "last_login" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:14: ERROR: column "last_edited" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:15: ERROR: column "last_edited_by" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:16: ERROR: column "created_by" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:17: ERROR: column "created_time" of relation "xi_users" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:24: ERROR: relation "xi_eventqueue_eventqueue_id_seq" already exists
psql:nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql:33: ERROR: relation "xi_eventqueue" already exists
ERROR 1060 (42S21) at line 39: Duplicate column name 'exclude'
also, niether upgrade works my system still is at
Code: Select all
Nagios XI Installation Profile
System:
Nagios XI Version : 5.2.9
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 3:45 pm
by avandemore
In the upgrade file at /tmp/nagiosxi/upgrade(will be at this location if you followed the directions explicitly), comment out lines 824 - 832 with a #. Save the file and rerun the upgrade. The upgrade with generate a file called upgrade.log. Please attach it.
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 4:13 pm
by dwhitfield
Make sure you remove the old tarballs before upgrading. That error suggests you weren't actually installing 5.3.1.
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 4:20 pm
by benhank
here yah go
i edited the lines:
Code: Select all
# Do not re-run the MySQL upgrades if they have already been applied
#if [ "$cfg__db_info__nagiosxi__dbserver" == "" ]; then
# cfg__db_info__nagiosxi__dbserver="localhost";
# fi
# if [ "$cfg__db_info__nagiosql__dbserver" == "" ]; then
# cfg__db_info__nagiosql__dbserver="localhost";
#fi
# if [ "$cfg__db_info__nagiosxi__dbtype" == "pgsql" ]; then
# psql $cfg__db_info__nagiosxi__db $cfg__db_info__nagiosxi__user -f nagiosxi/nagiosxi-db/mods/pgsql/schema_01.sql
# else
# mysql -h $cfg__db_info__nagiosxi__dbserver -u $cfg__db_info__nagiosxi__user --password="$cfg__db_info__nagiosxi__pwd" --database=$cfg__db_info__nagiosxi__db < nagiosxi/nagiosxi-db/mods/mysql/schema_01.sql
# fi
# # Update nagiosql database structure (session locking / negation)
# mysql -h $cfg__db_info__nagiosql__dbserver -u $cfg__db_info__nagiosql__user --password="$cfg__db_info__nagiosql__pwd" --database=$cfg__db_info__nagiosql__db < subcomponents/nagiosql/mods/schema_01.sql
# fi
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 4:34 pm
by avandemore
What version is XI reporting now? From the login page, check the lower left hand corner of the screen.
From the log it appears you successfully upgraded to 5.3.0. Do you agree?
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 4:55 pm
by benhank
no its reporting 5.2.9 i even cleared the cache and tried again and I opened it in IE which i never use, in both cases thats the version reported and I am still getting the message sayingt an upgrade is available
also at the end of the upgrade to 5.3.1 I still get this error:
Code: Select all
Done!
Dashlets installed/updated OK
Attempting to read global hard/soft nofile limits failed. Check /etc/security/limits.conf and try again!
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 5:00 pm
by avandemore
What is the output from
# ls -la /tmp
Re: problem upgrading to latest version
Posted: Tue Oct 25, 2016 5:04 pm
by benhank
herer you go. you might have missed my last edit to my post Ill readd it here:
benhank wrote:no its reporting 5.2.9 i even cleared the cache and tried again and I opened it in IE which i never use, in both cases thats the version reported and I am still getting the message sayingt an upgrade is available
also at the end of the upgrade to 5.3.1 I still get this error:
Code: Select all
Done!
Dashlets installed/updated OK
Attempting to read global hard/soft nofile limits failed. Check /etc/security/limits.conf and try again!