[rt-users] Twist on "User could not be created: Email address in use"

[Mike Patterson]

I'm very fortunate to have had our old ticketing system crash so I can 
quickly bring RT into production :-)

The problem is a few bugs in the build RT 3.03 (RedHat 7.3, Perl 5.61, 
Apache2, FastCGI, MySql 4.013)
Yes I know, I should update Perl and RT (which is in progress on a 
FreeBSD machine) but I need a work around now.

So I have a common problem of trying to transform someone who submitted 
an email into a privelged user. 
The typical fix for this is Configuration:Users:Select Users and check 
the "include disabled users in search" box.
However this doesn't seem to work in my particular build.  You search 
and it doesn't display anything.

Because the typical fix doesn't work for me I started browsing the db 
tables:
Users, GroupMembers, CachedGroupMembers, and I can't figure out what 
flags allow a user to be priveleged.
Do they need become a member of a priveleged users group (which ID?)  
What's the deal with CachedGroupMembers?  If I modify GroupMembers
what needs to restart for the update to happen?

Thanks,
Mike