[rt-users] Upgraded to 3.6.6 and superuser functionality missing
Kenneth Crocker
KFCrocker at lbl.gov
Tue Feb 19 13:54:23 EST 2008
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
More information about the rt-users
mailing list