problem upgrading to latest version

[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

Code: Select all

http://mirrorlist.repoforge.org/

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

[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.

[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

[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.

[dwhitfield]

Make sure you remove the old tarballs before upgrading. That error suggests you weren't actually installing 5.3.1.

[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

[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?

[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!

[avandemore]

What is the output from
# ls -la /tmp

[benhank]

herer you go. you might have missed my last edit to my post Ill readd it here:

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!