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