gregory.betz at thesiorg
Jul 30, 2012, 7:47 AM
Post #2 of 2
(141 views)
Permalink
|
|
Re: EXTERNAL: Re: EXTERNAL: Re: Group not found
[In reply to]
|
|
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 [mailto:rt-users-bounces [at] lists] On Behalf Of Betz, Gregory
Sent: Monday, July 30, 2012 10:00 AM
To: Paul Tomblin
Cc: rt-users [at] lists
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<mailto:ptomblin [at] gmail> [mailto:ptomblin [at] gmail]<mailto:[mailto:ptomblin [at] gmail]> On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 1:19 PM
To: Betz, Gregory
Cc: rt-users [at] lists<mailto:rt-users [at] lists>
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<mailto:gregory.betz [at] thesiorg>> 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<mailto:rt-users-bounces [at] lists> [mailto:rt-users-bounces [at] lists<mailto:rt-users-bounces [at] lists>] On Behalf Of Betz, Gregory
Sent: Wednesday, July 25, 2012 10:29 AM
To: Paul Tomblin
Cc: rt-users [at] lists<mailto:rt-users [at] lists>
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<mailto:ptomblin [at] gmail> [mailto:ptomblin [at] gmail]<mailto:[mailto:ptomblin [at] gmail]> On Behalf Of Paul Tomblin
Sent: Wednesday, July 25, 2012 10:25 AM
To: Betz, Gregory
Cc: rt-users [at] lists<mailto:rt-users [at] lists>
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<mailto:gregory.betz [at] thesiorg>> 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
|
