[rt-users] Permissions problem. Cannot view queues/tickets or make changes to config as super user

[Ruslan Zakirov]

http://requesttracker.wikia.com/wiki/RecoverSuperUserRights

Regards, Ruslan. From phone.
02.09.2011 0:18 пользователь "josh.cole" <josh.cole at 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-bounces at lists.bestpractical.com [mailto:rt-users-
>>> bounces at lists.bestpractical.com] On Behalf Of josh.cole
>>> Sent: 01 September 2011 00:29
>>> To: rt-users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110904/827be486/attachment.htm>