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

[Karl Boyken]

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

-- 
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/20080220/d15091a2/attachment.bin>