[rt-users] posts not making to the database
I am having a weird issue ... When I try to post to rt, the mail makes to the list and to the mail gateway and a response is sent to poster. But, it is not there in the database at all. But, if I restart apache, click on each receips (and save) for the list, it works .. but only for sometime. Could someone help me with this please ? I see these in the log: [Mon Jul 2 15:20:32 2007] [warning]: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 425. (/usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm:425) [Mon Jul 2 15:20:32 2007] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm:505) [Mon Jul 2 15:20:33 2007] [warning]: RT::Handle=HASH(0xb5b32a8) couldn't execute the query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1252 HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', ...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 466 ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Posts to queue not showing in database
I am having a weird issue ... When I try to post to rt, the mail makes to the list and to the mail gateway and a response is sent to poster. But, it is not there in the database at all. But, if I restart apache, click on each scrips (and save) for the list, it works .. but only for sometime. Could someone help me with this please ? I see these in the log: [Mon Jul 2 15:20:32 2007] [warning]: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 425. (/usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm:425) [Mon Jul 2 15:20:32 2007] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm:505) [Mon Jul 2 15:20:33 2007] [warning]: RT::Handle=HASH(0xb5b32a8) couldn't execute the query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.PrincipalType = 'Group' AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = AND ((ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 5) OR (ACL.ObjectType = 'RT::System')) AND ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' LIMIT 1' at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb5b32a8)', 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMember...') called at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 550 DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0xb5b32a8)', 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMember...') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 458 RT::Principal::_HasRight('RT::Principal=HASH(0xb8d4ca0)', 'Right', 'SeeQueue', 'EquivObjects', 'ARRAY(0xb8f88f0)', 'Object', 'RT::Queue=HASH(0xb9268c4)') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 369 RT::Principal::HasRight('RT::Principal=HASH(0xb8d4ca0)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/User_Overlay.pm line 1562 RT::User::HasRight('RT::User=HASH(0xb8d9240)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/CurrentUser.pm line 339 RT::CurrentUser::HasRight('RT::CurrentUser=HASH(0xb95d5c0)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1124 RT::Queue::HasRight('RT::Queue=HASH(0xb9268c4)', 'Principal', 'RT::CurrentUser=HASH(0xb95d5c0)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1090 RT::Queue::CurrentUserHasRight('RT::Queue=HASH(0xb9268c4)', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1066 RT::Queue::_Value('RT::Queue=HASH(0xb9268c4)', 'Name') called at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Record.pm line 425 DBIx::SearchBuilder::Record::__ANON__('RT::Queue=HASH(0xb9268c4)') called at /usr/share/rt3/html/REST/1.0/NoAuth/mail-gateway line 64 HTML::Mason::Commands::__ANON__('SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', 'message', 'From iskme-feature at sb.path.net Mon Jul 2 08:20:27 2007\x{a}Recei...') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb8c6f9 c)', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', 'message', 'From iskme-feature at sb.path.net Mon Jul 2 08:20:27 2007\x{a}Recei...', ...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1257 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1252 HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', ...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 466 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 466 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 418 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb8e26 08)') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandl er=HASH(0xb8e2608)') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH( 0xabbcf54)', 'Apache2::RequestRec=SCALAR(0xabc8cdc)') called at /usr/sbin/webmux.pl line 123
[rt-users] posts not making to the database
I am having a weird issue ... When I try to post to rt, the mail makes to the list and to the mail gateway and a response is sent to poster. But, it is not there in the database at all. But, if I restart apache, click on each receips (and save) for the list, it works .. but only for sometime. Could someone help me with this please ? I see these in the log: [Mon Jul 2 15:20:32 2007] [warning]: Use of uninitialized value in concatenation (.) or string at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 425. (/usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm:425) [Mon Jul 2 15:20:32 2007] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm:505) [Mon Jul 2 15:20:33 2007] [warning]: RT::Handle=HASH(0xb5b32a8) couldn't execute the query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'SeeQueue') AND Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0 AND Principals.id = Groups.id AND Principals.PrincipalType = 'Group' AND Principals.id = CachedGroupMembers.GroupId AND CachedGroupMembers.MemberId = AND ((ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 5) OR (ACL.ObjectType = 'RT::System')) AND ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' LIMIT 1' at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb5b32a8)', 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMember...') called at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Handle.pm line 550 DBIx::SearchBuilder::Handle::FetchResult('RT::Handle=HASH(0xb5b32a8)', 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMember...') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 458 RT::Principal::_HasRight('RT::Principal=HASH(0xb8d4ca0)', 'Right', 'SeeQueue', 'EquivObjects', 'ARRAY(0xb8f88f0)', 'Object', 'RT::Queue=HASH(0xb9268c4)') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Principal_Overlay.pm line 369 RT::Principal::HasRight('RT::Principal=HASH(0xb8d4ca0)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/User_Overlay.pm line 1562 RT::User::HasRight('RT::User=HASH(0xb8d9240)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/CurrentUser.pm line 339 RT::CurrentUser::HasRight('RT::CurrentUser=HASH(0xb95d5c0)', 'Object', 'RT::Queue=HASH(0xb9268c4)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1124 RT::Queue::HasRight('RT::Queue=HASH(0xb9268c4)', 'Principal', 'RT::CurrentUser=HASH(0xb95d5c0)', 'Right', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1090 RT::Queue::CurrentUserHasRight('RT::Queue=HASH(0xb9268c4)', 'SeeQueue') called at /usr/lib/perl5/vendor_perl/5.8.8/RT/Queue_Overlay.pm line 1066 RT::Queue::_Value('RT::Queue=HASH(0xb9268c4)', 'Name') called at /usr/lib/perl5/site_perl/5.8.6//DBIx/SearchBuilder/Record.pm line 425 DBIx::SearchBuilder::Record::__ANON__('RT::Queue=HASH(0xb9268c4)') called at /usr/share/rt3/html/REST/1.0/NoAuth/mail-gateway line 64 HTML::Mason::Commands::__ANON__('SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', 'message', 'From [EMAIL PROTECTED] Mon Jul 2 08:20:27 2007\x{a}Recei...') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb8c6f9 c)', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', 'message', 'From [EMAIL PROTECTED] Mon Jul 2 08:20:27 2007\x{a}Recei...', ...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1257 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 1252 HTML::Mason::Request::comp('undef', 'undef', 'undef', 'SessionType', 'REST', 'action', 'correspond', 'queue', 'iskme-feature', ...) called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 466 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 466 eval {...} called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/Request.pm line 418 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb8e26 08)') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandl er=HASH(0xb8e2608)') called at /usr/lib/perl5/site_perl/5.8.6//HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH( 0xabbcf54)', 'Apache2::RequestRec=SCALAR(0xabc8cdc)') called at /usr/sbin/webmux.pl line 123