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

[Kenneth Crocker]

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
>>
>