As root I cannot remove a watcher from a queue -

To replicate this issue:
Configuration -> Queues -> -> Watchers -> Check the box next to
the group (Systems) -> Save Changes

*Results *

  • Could not remove that principal as a Cc for this queue

The log file at /opt/rt3/var/log/rt.log says:
[Fri Aug 12 21:13:21 2011] [warning]: User not loaded.
(/opt/rt3/bin/…/lib/RT/User_Overlay.pm:1490)
[Fri Aug 12 21:13:21 2011] [warning]: Unable to revoke delegated rights for
principal 2746 (/opt/rt3/bin/…/lib/RT/GroupMember_Overlay.pm:342)
[Fri Aug 12 21:13:21 2011] [error]: Failed to delete 44 as a member of group
28: Member not deleted (/opt/rt3/bin/…/lib/RT/Queue_Overlay.pm:955)

I’ve tried this every way I can think of. I even specifically granted a
user with ModifyQueueWatchers for that queue and tried that. It doesn’t
work.

I found a two discussions about this but neither of them were conclusive:

The SuperUser (root) should not have a problem doing this. The “User not
loaded” error in the logs confuses me as well. I checked to make sure that
all the users within the group called ‘Systems’ actually exist and are
granted rights. Not sure what user its talking about in that error
message. The Systems user is a Watcher for both CC and AdminCC (I don’t
know why someone set it to both, but I want to remove it from at least one
of those if not both).

Thanks for reading and in advance for any help anyone can provide.

Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net

Hi,

Last time I looked into such error it was a problem with revoking
delegated rights. RT 4.0 drops support for personal groups and
delegations. I recommend you to walk through ACL table and check all
records where Delegated* columns are not zero or NULL.

If you don’t have delegated rights then it’s something else.

Other idea is inconsistent database. Use rt-validator in recent 3.8
releases to check consistency.On Sat, Aug 13, 2011 at 1:20 AM, Landon Stewart lstewart@superb.net wrote:

To replicate this issue:
Configuration -> Queues -> -> Watchers -> Check the box next to
the group (Systems) -> Save Changes

Results

Could not remove that principal as a Cc for this queue

The log file at /opt/rt3/var/log/rt.log says:
[Fri Aug 12 21:13:21 2011] [warning]: User not loaded.
(/opt/rt3/bin/…/lib/RT/User_Overlay.pm:1490)
[Fri Aug 12 21:13:21 2011] [warning]: Unable to revoke delegated rights for
principal 2746 (/opt/rt3/bin/…/lib/RT/GroupMember_Overlay.pm:342)
[Fri Aug 12 21:13:21 2011] [error]: Failed to delete 44 as a member of group
28: Member not deleted (/opt/rt3/bin/…/lib/RT/Queue_Overlay.pm:955)

I’ve tried this every way I can think of. I even specifically granted a
user with ModifyQueueWatchers for that queue and tried that. It doesn’t
work.

I found a two discussions about this but neither of them were conclusive:

The SuperUser (root) should not have a problem doing this. The “User not
loaded” error in the logs confuses me as well. I checked to make sure that
all the users within the group called ‘Systems’ actually exist and are
granted rights. Not sure what user its talking about in that error
message. The Systems user is a Watcher for both CC and AdminCC (I don’t
know why someone set it to both, but I want to remove it from at least one
of those if not both).

Thanks for reading and in advance for any help anyone can provide.


Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net


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

Best regards, Ruslan.

Thanks Ruslan for your reply.

I did attempt an upgrade to 4.0 but reverted to a prior database copy after
the upgrade failed. The issues on the upgrade are moot at this point.

After checking for those entries should I ensure they are zero or NULL or
make sure they are not zero or NULL?On 14 August 2011 14:20, Ruslan Zakirov ruz@bestpractical.com wrote:

Hi,

Last time I looked into such error it was a problem with revoking
delegated rights. RT 4.0 drops support for personal groups and
delegations. I recommend you to walk through ACL table and check all
records where Delegated* columns are not zero or NULL.

If you don’t have delegated rights then it’s something else.

Other idea is inconsistent database. Use rt-validator in recent 3.8
releases to check consistency.

On Sat, Aug 13, 2011 at 1:20 AM, Landon Stewart lstewart@superb.net wrote:

To replicate this issue:
Configuration -> Queues -> -> Watchers -> Check the box next
to
the group (Systems) -> Save Changes

Results

Could not remove that principal as a Cc for this queue

The log file at /opt/rt3/var/log/rt.log says:
[Fri Aug 12 21:13:21 2011] [warning]: User not loaded.
(/opt/rt3/bin/…/lib/RT/User_Overlay.pm:1490)
[Fri Aug 12 21:13:21 2011] [warning]: Unable to revoke delegated rights
for
principal 2746 (/opt/rt3/bin/…/lib/RT/GroupMember_Overlay.pm:342)
[Fri Aug 12 21:13:21 2011] [error]: Failed to delete 44 as a member of
group
28: Member not deleted (/opt/rt3/bin/…/lib/RT/Queue_Overlay.pm:955)

I’ve tried this every way I can think of. I even specifically granted a
user with ModifyQueueWatchers for that queue and tried that. It doesn’t
work.

I found a two discussions about this but neither of them were conclusive:

The SuperUser (root) should not have a problem doing this. The “User not
loaded” error in the logs confuses me as well. I checked to make sure
that
all the users within the group called ‘Systems’ actually exist and are
granted rights. Not sure what user its talking about in that error
message. The Systems user is a Watcher for both CC and AdminCC (I don’t
know why someone set it to both, but I want to remove it from at least
one
of those if not both).

Thanks for reading and in advance for any help anyone can provide.


Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net


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


Best regards, Ruslan.

Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net

Hi,

Last time I looked into such error it was a problem with revoking
delegated rights. RT 4.0 drops support for personal groups and
delegations. I recommend you to walk through ACL table and check all
records where Delegated* columns are not zero or NULL.

Seems OK…
mysql> select * from ACL WHERE DelegatedBy != “0” OR DelegatedFrom != “0”;
Empty set (0.00 sec)

If you don’t have delegated rights then it’s something else.

Other idea is inconsistent database. Use rt-validator in recent 3.8
releases to check consistency.

This did it!

Thanks again Ruslan.

Landon Stewart LStewart@SUPERB.NET
SuperbHosting.Net by Superb Internet Corp.
Toll Free (US/Canada): 888-354-6128 x 4199
Direct: 206-438-5879
Web hosting and more “Ahead of the Rest”: http://www.superbhosting.net