Newly created users, SQL error

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

[hsmith]

Any special characters or anything in the username? I couldn't replicate this one.

[GldRush98]

No, no weirdness there.
I wish I could see the whole query it was bombing out on.

[hsmith]

Anything in the MySQL log?

[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

[GldRush98]

Anything in the MySQL log?

No, it looks pretty clean

[GldRush98]

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.

[jolson]

Interesting. Could we see what that contact group looks like?

Code: Select all

grep -A 5 <contactgroupname> /usr/local/nagios/var/objects.cache

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

[GldRush98]

Oddly enough (or maybe not?) the Core interface works and is showing everything like it should as far as I can tell.