Re: [rt-users] Permissions problem. Cannot view queues/tickets or make changes to config as super user
http://requesttracker.wikia.com/wiki/RecoverSuperUserRights Regards, Ruslan. From phone. 02.09.2011 0:18 пользователь "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-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. Can
Re: [rt-users] Permissions problem. Cannot view queues/tickets or make changes to config as super user
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-use
Re: [rt-users] Permissions problem. Cannot view queues/tickets or make changes to config as super user
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 Francis
[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