[rt-users] Upgraded to 3.6.6 and superuser functionality missing

[Karl Boyken]

Yes, I've poked around a bit in the database.  I haven't seen anything 
glaringly wrong yet, but that could be more a statement about my 
ignorance of the RT schema than anything else.  The 'root' user is in 
Users, and it looks like it has all the settings it would have from 
creating the initial db.  There are two SuperUser rights entries in the 
ACL table, one for RT_System and one for root.

Karl

Kenneth Crocker wrote:
> Karl,
> 
> 
>     Have you gone into the DataBase with SQL and looked at what is in 
> the table records? especially for root? That might help, especially if 
> you see something glaringly odd. Then you could find out what you need 
> to change and modify that particular record. Normally, I wouldn't 
> recommend modifying the RT DataBasee directly, but if you need to "fix" 
> something, sometimes that's the only way to do it. I'd look at the USERS 
> table to get the ID number and then the PRINCIPALS table and asee if the 
> Id is disabled or not. If that doesn't indicate anything, then look at 
> the ACL table. There must be something there that would give you a clue. 
> Hope this helps.
> 
> Kenn
> LBNL


-- 
Karl Boyken, system administrator 
karl-boyken at uiowa.edu
303A MLH, Dept. of Comp. Sci. 
http://www.cs.uiowa.edu/~boyken/
The U. of Iowa, Iowa City, IA  52242   319-335-2730 (voice) 
319-335-3668 (fax)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3257 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080219/9e5b30f0/attachment.bin>