http://requesttracker.wikia.com/wiki/RecoverSuperUserRights
Regards, Ruslan. From phone. 02.09.2011 0:18 пользователь "josh.cole" <josh.c...@fresno.edu> написал: > > Roy, > > I very much appreciate your response, especially considering it must have > been a careless mistake that > I made that put me in this position. Thanks so much. > > > > Raed El-Hames-4 wrote: >> >> Josh, >> >> As far as I know your only fix is through the database directly. >> Login in to your RT database and >> >> select id from Users where Name = 'root'; #on my system the id of root == >> 12 >> >> select id from Groups where Name = 'User 12'; #on my system this id = 13 >> >> select id from Principals where ObjectId = 13 and PrincipalType = 'Group'; >> #most likely this should be the same as above in my case 13 >> >> select * from ACL where PrincipalId = 13 and PrincipalType = 'Group'; >> #This should return a row with >> +----+---------------+-------------+-----------+------------+----------+-------------+---------------+ >> | id | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | >> DelegatedBy | DelegatedFrom | >> +----+---------------+-------------+-----------+------------+----------+-------------+---------------+ >> | 3 | Group | 13 | SuperUser | RT::System | 1 | >> 0 | 0 | >> +----+---------------+-------------+-----------+------------+----------+-------------+---------------+ >> >> But in your case most likely it wont , so you will need to insert a new >> row into your ACL table to match the above. >> (Remember that the id field is auto increment so you don't include it in >> your insert statement). >> >> Hope that helps; >> >> Regards; >> Roy >> >>> >> Visit our website today www.daisygroupplc.com >> >> Registered Office: Daisy House, Lindred Road Business Park, Nelson, >> Lancashire BB9 5SR >> Company Registration Number: 4145329 | VAT Number: 722471355 >> Daisy Communications Limited is a company registered in England and Wales. >> DISCLAIMER >> >> This email (including any attachments) is strictly confidential and may >> also be legally privileged. If the recipient has received this email in >> error please notify the sender and do not read, print, re-transmit, store >> or act in reliance on the email or its attachments and immediately delete >> this email and its attachments from the recipient's system. Daisy >> Communications Limited cannot accept liability for any breaches of >> confidence arising through use of email. Employees of Daisy Communications >> Limited are expressly required not to make any defamatory statements and >> not to infringe or authorise any infringement of copyright or any other >> legal right by email communications. Any such communication is contrary to >> the company's policy and outside the scope of the employment of the >> individual concerned. Daisy Communications Limited will not accept any >> liability in respect of such a communication, and the employee responsible >> will be personally liable for any damages or other liabi >> lity arising. >> >> If you are the intended recipient of this email please ensure that neither >> the email nor any attachments are copied to third parties outside your >> organisation or saved without the written permission of the sender. In >> the event of any unauthorised copying or forwarding, the recipient will be >> required to indemnify Daisy Communications Limited against any claim for >> loss or damage caused by any viruses or otherwise. >> >> WARNING: Computer viruses can be transmitted by email. The recipient >> should check this email and any attachments for the presence of viruses. >> Daisy Communications Limited accepts no liability for any damage caused by >> any virus transmitted by this email or any attachments. >> NOTICE TO CUSTOMERS >> If you have ordered a telephone number from Daisy Communications Limited >> (non-geographic or new line installation) please do NOT arrange for any >> form of advertising until the number is live and tested. >> >> >> -----Original Message----- >>> From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users- >>> boun...@lists.bestpractical.com] On Behalf Of josh.cole >>> Sent: 01 September 2011 00:29 >>> To: rt-users@lists.bestpractical.com >>> Subject: [rt-users] Permissions problem. Cannot view queues/tickets or >>> make changes to config as super user >>> >>> >>> Permissions problem. Cannot view queues/tickets or make changes to config >>> as >>> super user. I am logging in as root. Not sure what I did to cause this >>> problem but if anyone is willing to tell me how to resolve this problem >>> that >>> would be great. >>> >>> -Josh >>> -- >>> View this message in context: http://old.nabble.com/Permissions-problem.- >>> Cannot-view-queues-tickets-or-make-changes-to-config-as-super-user- >>> tp32376364p32376364.html >>> Sent from the Request Tracker - User mailing list archive at Nabble.com. >>> >>> -------- >>> RT Training Sessions (http://bestpractical.com/services/training.html) >>> * Chicago, IL, USA September 26 & 27, 2011 >>> * San Francisco, CA, USA October 18 & 19, 2011 >>> * Washington DC, USA October 31 & November 1, 2011 >>> * Melbourne VIC, Australia November 28 & 29, 2011 >>> * Barcelona, Spain November 28 & 29, 2011 >> >> -------- >> RT Training Sessions (http://bestpractical.com/services/training.html) >> * Chicago, IL, USA September 26 & 27, 2011 >> * San Francisco, CA, USA October 18 & 19, 2011 >> * Washington DC, USA October 31 & November 1, 2011 >> * Melbourne VIC, Australia November 28 & 29, 2011 >> * Barcelona, Spain November 28 & 29, 2011 >> >> > > -- > View this message in context: http://old.nabble.com/Permissions-problem.-Cannot-view-queues-tickets-or-make-changes-to-config-as-super-user-tp32376364p32382357.html > Sent from the Request Tracker - User mailing list archive at Nabble.com. > > -------- > RT Training Sessions (http://bestpractical.com/services/training.html) > * Chicago, IL, USA September 26 & 27, 2011 > * San Francisco, CA, USA October 18 & 19, 2011 > * Washington DC, USA October 31 & November 1, 2011 > * Melbourne VIC, Australia November 28 & 29, 2011 > * Barcelona, Spain November 28 & 29, 2011
-------- RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October 18 & 19, 2011 * Washington DC, USA October 31 & November 1, 2011 * Melbourne VIC, Australia November 28 & 29, 2011 * Barcelona, Spain November 28 & 29, 2011