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

[Kenneth Crocker]

Karl,


	Go to the PRINCIPALS table and look up the correct UserID in the and 
see if it is enabled/disabled. The USers table doesn't have that info.


Kenn
LBNL

On 2/19/2008 11:10 AM, Karl Boyken wrote:
> 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
> 
>