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

[Raed El-Hames]

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 liability 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