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

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@lists.bestpractical.com [mailto:rt-users-
bounces@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

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@lists.bestpractical.com [mailto:rt-users-
bounces@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 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

Regards, Ruslan. From phone.

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@lists.bestpractical.com [mailto:rt-users-
bounces@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 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