Page 1 of 2
Newly created users, SQL error
Posted: Mon Feb 22, 2016 3:33 pm
by GldRush98
We're on the latest release. We're adding users to XI and while they seem to add ok and we stick them in contact groups with hosts and services associated with them, all we're getting is this:
Capture.PNG
I've tried deleting/recreating user, running repair_tables.sh, assigning just hosts/services to the user instead of doing it via contact groups, but nothing seems to help.
If I check the "Can see all objects" option for the user, everything works of course, but we're wanting them to only see their hosts/services. It seems any new user is having this issue.
Re: Newly created users, SQL error
Posted: Mon Feb 22, 2016 3:52 pm
by hsmith
Any special characters or anything in the username? I couldn't replicate this one.
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 2:41 pm
by GldRush98
No, no weirdness there.
I wish I could see the whole query it was bombing out on.
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 3:05 pm
by hsmith
Anything in the MySQL log?
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 3:06 pm
by jolson
I'd like to see a screenshot or similar of one of the users you've added, in addition to any service/host definitions that the user is associated with.
I'd also like to see the following output:
Code: Select all
echo 'select * from xi_users \G;' | mysql -uroot -pnagiosxi nagiosxi
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 5:25 pm
by GldRush98
hsmith wrote:Anything in the MySQL log?
No, it looks pretty clean
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 5:27 pm
by GldRush98
jolson wrote:I'd like to see a screenshot or similar of one of the users you've added, in addition to any service/host definitions that the user is associated with.
I'd also like to see the following output:
Code: Select all
echo 'select * from xi_users \G;' | mysql -uroot -pnagiosxi nagiosxi
There are over 700 hosts and even more services associated via a contact group.
I think I've narrowed it down to something getting associated via the contact group though. I can take him out of that group and put him in another group and it works. Put him back in that contact group and boom, errors.
Trouble is I can't figure out what it is. None of the hosts or services have weird chars in their names.
Re: Newly created users, SQL error
Posted: Wed Feb 24, 2016 5:37 pm
by jolson
Interesting. Could we see what that contact group looks like?
Code: Select all
grep -A 5 <contactgroupname> /usr/local/nagios/var/objects.cache
Re: Newly created users, SQL error
Posted: Thu Feb 25, 2016 2:37 pm
by GldRush98
This
--
contact_groups HMMA-MES-CG
notification_period xi_timeperiod_24x7
initial_state o
importance 0
check_interval 5.000000
retry_interval 1.000000
--
Over and over a couple thousand times.
Re: Newly created users, SQL error
Posted: Thu Feb 25, 2016 4:02 pm
by GldRush98
Oddly enough (or maybe not?) the Core interface works and is showing everything like it should as far as I can tell.