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

[Kenneth Crocker]

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

On 2/19/2008 9:45 AM, Karl Boyken wrote:
> Yep, did all that.
> 
> I rolled back to 3.6.5, and still have the same problem.  I suspect I 
> may at some point have screwed up the rt3 database somehow.  I use 
> rtx-shredder and at one point, last December, after I first began using 
> it, I inadvertently deleted root, but I restored it and was able to 
> login and everything seemed fine--had full superuser functionality.  But 
> who knows?
> 
> I just now tried the restore-superuser-privileges tip from the Wiki, but 
> that didn't work, either.  So, now, I'm thinking I'll recreate the 
> database--start over with a new, pristine db--and suck over values from 
> the current one.  Any idea if that's just a big waste of time?
> 
> Karl
> 
> Ruslan Zakirov wrote:
>> Have you updated deps, cleaned mason cache and restarted apache server?
>>
>> On Feb 19, 2008 8:19 PM, Karl Boyken <boyken at divms.uiowa.edu> wrote:
>>> I don't see even Preferences in the menu bar.  I was expecting to be
>>> able to manipulate rights--that's gone.  All I see in the menu bar are:
>>>
>>>      *    Home
>>>      * · Simple Search
>>>      * · Tickets
>>>      * · Tools
>>>      * · Approval
>>>
>>> In other words, root seems to have the same functionality in the GUI as
>>> a regular user here.
>>>
>>> Karl
>>>
>>> Todd Chapman wrote:
>>>> What are you expecting to see?
>>>>
>>>> On 2/19/08, Karl Boyken <boyken at divms.uiowa.edu> wrote:
>>>>> Yesterday, I upgraded RT from 3.6.5 to 3.6.6 and now when I login as
>>>>> root, I don't see any superuser functions available.  I don't remember
>>>>> the last time I logged in as root, but it could only have been a month
>>>>> or two ago.  We're using MySQL 5.0.22 as the backend on RedHat
>>>>> Enterprise Server Release 5.  I've checked the database, and we still
>>>>> have the root user, it still is in the superuser group.  I'd 
>>>>> appreciate
>>>>> any ideas--thanks.
>>>>>
>>>>> Karl Boyken
>>>>>
>>>>> -- 
>>>>> 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)
>>>>>
>>>>> _______________________________________________
>>>>> 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)
>>>
>>> _______________________________________________
>>> 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
>>>
>>
>>
>>
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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