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

[Karl Boyken]

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/20080219/5530a174/attachment.bin>