Contacts box empty

[pvmadmin]

I was thinking the same thing. I haven't made many changes, just a bulk edit. So it really shouldn't be a big deal. I'll revert it and do the step by step upgrades. Although, I always use the command in the upgrade doc to install the latest XI release. Would it be too much trouble for you to give me the command to enter to pull down the 2012 release? After that I would assume I just run the latest XI command.

Thanks.

[sreinhardt]

Not a problem at all, to get the latest 2012 release, you would want:

wget http://assets.nagios.com/downloads/nagi ... 2.9.tar.gz

[pvmadmin]

Thanks. Upgraded to 2012 and everything looks good so far. Contacts can see hosts and services and the contacts box in the Wizards is populated. I will be upgrading to 2014 shortly.

[lmiltchev]

Great! Let us know if you run into some issues after the upgrade.

[pvmadmin]

I just finished the upgrade to 2014R1.4 and I have the same problems again. The Wizard contact box is empty and when a non-admin user logs on they cannot see any of the host or services that they are assigned.

Thanks,

Aaron

[abrist]

There were some case issues in previous versions, can you run a few queries to see if there are multiple copies of the same user or contact with different cases?

Code: Select all

echo "select contact_name from nagiosql.tbl_contact;" | mysql -pnagiosxi
echo "select username from xi_users;" | psql nagiosxi nagiosxi
grep authorized_for /usr/local/nagios/etc/cgi.cfg

[abrist]

Solved in remote. Was missing new "importance"/"minimum_importance" column in the historical nagios mysql database. This was breaking most queries. To others with this issue, check /var/log/messages for failed update queries due to missing *importance fields. It can be fixed with the following queries:

Code: Select all

mysql -pnagiosxi
use nagios;
alter table nagios_services add column importance int not null default 0;
alter table nagios_hosts add column importance int not null default 0;
alter table nagios_contacts add column minimum_importance int not null default 0;

Closing thread. Cheers!