Page 3 of 3
Re: Contacts box empty
Posted: Fri Aug 22, 2014 4:09 pm
by 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.
Re: Contacts box empty
Posted: Mon Aug 25, 2014 9:59 am
by 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
Re: Contacts box empty
Posted: Mon Aug 25, 2014 11:27 am
by 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.
Re: Contacts box empty
Posted: Mon Aug 25, 2014 11:34 am
by lmiltchev
Great! Let us know if you run into some issues after the upgrade.
Re: Contacts box empty
Posted: Mon Aug 25, 2014 2:02 pm
by 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
Re: Contacts box empty
Posted: Tue Aug 26, 2014 10:48 am
by 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
Re: Contacts box empty
Posted: Fri Aug 29, 2014 11:31 am
by 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!