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

[josh.cole]

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.