[rt-users] EXTERNAL: Re: EXTERNAL: Re: Group not found

Betz, Gregory gregory.betz at thesiorg.com
Mon Jul 30 10:47:18 EDT 2012 

To add to this, I'm positive that it is conflict with the old root account.

I just created another queue and the Roles section is there and watchers can be added.

Is there somewhere in the db that I can fix this or would it be best to just recreate the queues?

Thanks,
Greg

From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Betz, Gregory
Sent: Monday, July 30, 2012 10:00 AM
To: Paul Tomblin
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] EXTERNAL: Re: EXTERNAL: Re: Group not found

I came back to this issue this morning and am still at a loss.

I created a group Admin and added the root user to it. I added full rights for the Admin group and specifically for the user 'root' for one of the queues with the issue and I am still receiving the same error.


I failed to mention that I converted an old MySQL DB from another RT server to the current RT server with PostgreSQL DB.  I only imported specific fields from the old database to the new database but everything else appears to be functioning correctly.

The tables (along with their sequences) I imported were: attachments, cachedgroupmembers, groupmembers, groups, principals, tickets, topics, transactions, users.

Could this have been an issue?

Thanks,
Greg

From: ptomblin at gmail.com<mailto:ptomblin at gmail.com> [mailto:ptomblin at gmail.com]<mailto:[mailto:ptomblin at gmail.com]> On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 1:19 PM
To: Betz, Gregory
Cc: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Subject: EXTERNAL: Re: [rt-users] EXTERNAL: Re: Group not found

That's just a consequence of the other error:
%if ($Members->Count == 0 ) {

$Members->Count returns an undef because of the error, which leads to the second error.

On Wed, Jul 25, 2012 at 1:13 PM, Betz, Gregory <gregory.betz at thesiorg.com<mailto:gregory.betz at thesiorg.com>> wrote:
Also, I noticed the following message after the aforementioned warning message in the log.

Use of uninitialized value in numeric eq (==) at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 3. (/opt/rt4/local/html/Admin/Elements/EditQueueWatchers:3)

Thanks,
Greg

From: rt-users-bounces at lists.bestpractical.com<mailto:rt-users-bounces at lists.bestpractical.com> [mailto:rt-users-bounces at lists.bestpractical.com<mailto:rt-users-bounces at lists.bestpractical.com>] On Behalf Of Betz, Gregory
Sent: Wednesday, July 25, 2012 10:29 AM
To: Paul Tomblin
Cc: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Subject: Re: [rt-users] EXTERNAL: Re: Group not found

Hey Paul,

Thanks for the quick response.

I use the root account when attempting to put watchers on the queues, so I don't think this is the issue

Thanks,
Greg

From: ptomblin at gmail.com<mailto:ptomblin at gmail.com> [mailto:ptomblin at gmail.com]<mailto:[mailto:ptomblin at gmail.com]> On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Subject: EXTERNAL: Re: [rt-users] Group not found

I've seen this exact thing happen when the person trying to add the watchers didn't have permissions to the queues in question.  Rather than handling it properly, RT sticks a null queue name into the query, which the query doesn't like much.
On Wed, Jul 25, 2012 at 10:18 AM, Betz, Gregory <gregory.betz at thesiorg.com<mailto:gregory.betz at thesiorg.com>> wrote:
Hello all,

I am having issues trying to add watchers to most of my queues.  When I try to add a user or group I receive the error message "Group not found".

I can set watchers for 2 queues (one is the General queue) out of 9 total queues.

Also, I noticed that the 2 queues that I can set watchers has items under Roles in Group Rights while the queues that I cannot set the watchers does not.

The following error message is displayed in /var/log/httpd/error_log

======================================================================================================================================================

[Wed Jul 25 12:05:06 2012] [warning]: DBD::Pg::st execute failed: ERROR:  syntax error at or near ")"

LINE 1: ...nt(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.GroupId = )

                                                                     ^ at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 587. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:587)





[Wed Jul 25 12:05:06 2012] [warning]: RT::Handle=HASH(0x7fbc4de27b10) couldn't execute the query 'SELECT count(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.GroupId = ) ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 600.

        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x7fbc4de27b10)', 'SELECT count(main.id<http://main.id>) FROM GroupMembers main  WHERE (main.Gro...') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 291

        DBIx::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 331

        RT::SearchBuilder::_DoCount('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1407

        DBIx::SearchBuilder::Count('RT::GroupMembers=HASH(0x7fbc4febdfb8)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatchers line 48

        HTML::Mason::Commands::__ANON__('QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febff68)', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Elements/EditQueueWatcherGroup line 55

        HTML::Mason::Commands::__ANON__('Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4febca88)', 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, 'Label', 'AdminCc', 'QueueObj', 'RT::Queue=HASH(0x7fbc4feb6a28)', 'Watchers', 'RT::Group=HASH(0x7fbc5000f3f0)') called at /opt/rt4/local/html/Admin/Queues/People.html line 65

        HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4feaff30)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 955

        HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'UserString', '', ...) called at /opt/rt4/local/html/Admin/autohandler line 49

        HTML::Mason::Commands::__ANON__('GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', 'Queue-AddWatcher-Principal-30', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4ea48560)', 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', 'GroupString', '', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1302

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'GroupField', 'Name', 'UserOp', 'LIKE', 'GroupOp', 'LIKE', ...) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 548

        RT::Interface::Web::ShowRequestedPage('HASH(0x7fbc4feafc00)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 295

        RT::Interface::Web::HandleRequest('HASH(0x7fbc4feafc00)') called at /opt/rt4/local/html/autohandler line 53

        HTML::Mason::Commands::__ANON__('UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', 'GroupString', ...) called at /usr/local/share/perl5/HTML/Mason/Component.pm line 135

        HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fbc4e16e7c0)', 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', 'LIKE', ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1297

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 1292

        HTML::Mason::Request::comp(undef, undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, ...) called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 481

        eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm line 433

        HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

        eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 85

        HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x7fbc4fa53370)') called at /usr/local/share/perl5/HTML/Mason/Interp.pm line 342

        HTML::Mason::Interp::exec(undef, undef, 'UserOp', 'LIKE', 'Queue-AddWatcher-Principal-30', 'AdminCc', 'id', 5, 'GroupOp', ...) called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

        eval {...} called at /usr/local/share/perl5/HTML/Mason/PSGIHandler.pm line 48

        HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x7fbc4d42e258)', 'HTML::Mason::FakeApache=HASH(0x7fbc5000a380)', 'HASH(0x7fbc4fec58c0)') called at /usr/local/share/perl5/HTML/Mason/PSGIHandler/Streamy.pm line 52

        HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x7fbc50014e68)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 255

        RT::Interface::Web::Handler::__ANON__('CODE(0x7fbc50014e68)') called at /usr/local/share/perl5/Plack/Util.pm line 324

        Plack::Util::__ANON__('CODE(0x7fbc4febe048)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 68

        Plack::Handler::Apache2::call_app('Plack::Handler::Apache2', 'Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)', 'CODE(0x7fbc4cd08338)') called at /usr/local/share/perl5/Plack/Handler/Apache2.pm line 91

        Plack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x7fbc4fbb9fb8)') called at -e line 0

        eval {...} called at -e line 0 (/usr/local/share/perl5/Carp.pm:103)
 ======================================================================================================================================================

Any help would be greatly appreciated!

Thanks,
Greg




--
http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin



--
http://www.linkedin.com/in/paultomblin
http://careers.stackoverflow.com/ptomblin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120730/6fd9e6bc/attachment.htm>

More information about the rt-users mailing list