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

[Karl Boyken]

Yes, I've poked around a bit in the database. I haven't seen anything glaringly wrong yet, but that could be more a statement about my ignorance of the RT schema than anything else. The 'root' user is in Users, and it looks like it has all the settings it would have from creating the initial db. There are two SuperUser rights entries in the ACL table, one for RT_System and one for root.

Karl

Kenneth Crocker wrote:

Karl,




Kenn
LBNL

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.

--

Karl Boyken, system administrator [EMAIL PROTECTED] 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)

smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com