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

[Kenneth Crocker]

Karl,


	I'm at a loss. I can only recommend that you try to get more detailed 
info on the error thru logs, etc. Sorry.

Kenn
LBNL

On 2/20/2008 7:02 AM, Karl Boyken wrote:
> Nope not disabled:
> 
> mysql> select * from Principals where ObjectID=12;
> +----+---------------+----------+----------+
> | id | PrincipalType | ObjectId | Disabled |
> +----+---------------+----------+----------+
> | 12 | User          |       12 |        0 |
> +----+---------------+----------+----------+
> 1 row in set (0.00 sec)
> 
> 
> Kenneth Crocker wrote:
>> Karl,
>>
>>
>>     Now see if the Id number is disabled in the PRINCIPALS Tables.
>>
>>
>> Kenn
>> LBNL
>>
>> On 2/19/2008 12:39 PM, Karl Boyken wrote:
>>> Kenn, is this what you mean?
>>>
>>> mysql> select * from Groups where Description='ACL equiv. for user 12';
>>> +----+---------+------------------------+----------------+-----------+----------+ 
>>>
>>> | id | Name    | Description            | Domain         | Type      
>>> | Instance |
>>> +----+---------+------------------------+----------------+-----------+----------+ 
>>>
>>> | 13 | User 12 | ACL equiv. for user 12 | ACLEquivalence | UserEquiv 
>>> | 12       |
>>> +----+---------+------------------------+----------------+-----------+----------+ 
>>>
>>> 1 row in set (0.01 sec)
>>>
>>> Karl
>>>
>>> Kenneth Crocker wrote:
>>>> Karl,
>>>>
>>>>     What do you get from the "GROUPS" table? There could be an 
>>>> "equivilancy ID" for that userID.
>>>>
>>>> Kenn
>>>> LBNL
>>>>
>>>> On 2/19/2008 11:30 AM, Karl Boyken wrote:
>>>>> One additional bit of info:
>>>>>
>>>>> When I run the Perl code from Wiki that's supposed to restore 
>>>>> superuser, I get "Principal 12 not found."  root has id 12 in the 
>>>>> Users table. Here's the Perl code:
>>>>>
>>>>> /usr/bin/perl -I/opt/rt3/lib -MRT -e'RT::LoadConfig; RT::Init;
>>>>>  >   my $u=RT::User->new($RT::SystemUser);
>>>>>  >   $u->Load("root");
>>>>>  >   ($val,$msg) = $u->PrincipalObj->GrantRight(Object=> 
>>>>> $RT::System, Right => "SuperUser");
>>>>>  >   print "$msg\n"'
>>>>>
>>>>> In mysql, a "select * from Principals where id='12';" yields an 
>>>>> entry for root:
>>>>>
>>>>> +----+---------------+----------+----------+
>>>>> | id | PrincipalType | ObjectId | Disabled |
>>>>> +----+---------------+----------+----------+
>>>>> | 12 | User          |       12 |        0 |
>>>>> +----+---------------+----------+----------+
>>>>>
>>>>> Karl
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------ 
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>>>>
>>>>> Community help: http://wiki.bestpractical.com
>>>>> Commercial support: sales at bestpractical.com
>>>>>
>>>>>
>>>>> Discover RT's hidden secrets with RT Essentials from O'Reilly 
>>>>> Media. Buy a copy at http://rtbook.bestpractical.com
>>>>
>>>
>>
>