User missing from "Everyone" group

Can anyone think of a reason why a user in the RT database would not appear in
the “Everyone” group?

The user id is 709157
The “Everyone” group id is 3

This query returns no rows:

select * from groupmembers where groupid = 3 and memberid = 709157;

I’ve arrived at this point trying to track down why this user gets the message
"No permissions to create ticket in ‘queue-x’ " when in fact queue-x allows
SeeQueue and CreateTicket to Everyone.

The user is allowed access to RT but is not privileged. His Membership screen
shows no memberships - other users with these permissions show “Everyone” and
"Unprivileged" in the membership. This smells like data corruption.

Thanks,
Steve

Can anyone think of a reason why a user in the RT database would
not appear in
the “Everyone” group?

The user id is 709157
The “Everyone” group id is 3

This query returns no rows:

select * from groupmembers where groupid = 3 and memberid = 709157;

I’ve arrived at this point trying to track down why this user gets
the message
"No permissions to create ticket in ‘queue-x’ " when in fact queue-
x allows
SeeQueue and CreateTicket to Everyone.

The user is allowed access to RT but is not privileged. His
Membership screen
shows no memberships - other users with these permissions show
"Everyone" and
"Unprivileged" in the membership. This smells like data corruption.

It sure does.

PGP.sig (186 Bytes)

At Friday 10/12/2007 01:13 PM, Jesse Vincent wrote:>On Oct 11, 2007, at 5:03 PM, Stephen Turner wrote:

This smells like data corruption.

It sure does.

I thank you!

This affected about 5 user accounts and coincidentally they were all
created on the day we did our mysql -> Oracle migration back in 2005.
A while back we found that this migration caused some corruption of
attachments (it hooked some up to the wrong transactions) and I’m
guessing it also caused this problem with the user accounts. Anyway,
this problem was easily rectified.

Thanks,
Steve