From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Jan 20 15:10:03 2009 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 9445C1065675 for ; Tue, 20 Jan 2009 15:10:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 6E8A38FC1F for ; Tue, 20 Jan 2009 15:10:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.3/8.14.3) with ESMTP id n0KFA3pO007226 for ; Tue, 20 Jan 2009 15:10:03 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.3/8.14.3/Submit) id n0KFA3bd007221; Tue, 20 Jan 2009 15:10:03 GMT (envelope-from gnats) Resent-Date: Tue, 20 Jan 2009 15:10:03 GMT Resent-Message-Id: <200901201510.n0KFA3bd007221@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Anthony Maszeroski Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id EBFED106568E for ; Tue, 20 Jan 2009 15:03:56 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id D83048FC23 for ; Tue, 20 Jan 2009 15:03:56 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.3/8.14.3) with ESMTP id n0KF3uUx066941 for ; Tue, 20 Jan 2009 15:03:56 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id n0KF3uHg066940; Tue, 20 Jan 2009 15:03:56 GMT (envelope-from nobody) Message-Id: <200901201503.n0KF3uHg066940@www.freebsd.org> Date: Tue, 20 Jan 2009 15:03:56 GMT From: Anthony Maszeroski To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/130781: Database connection error when executing certain CLI scripts from rt-3.8.1_2 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 20 Jan 2009 15:10:04 -0000 >Number: 130781 >Category: ports >Synopsis: Database connection error when executing certain CLI scripts from rt-3.8.1_2 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: maintainer-update >Submitter-Id: current-users >Arrival-Date: Tue Jan 20 15:10:03 UTC 2009 >Closed-Date: >Last-Modified: >Originator: Anthony Maszeroski >Release: 7.0-RELEASE >Organization: University of Scranton >Environment: FreeBSD rose.netsvs.scranton.edu 7.0-RELEASE-p6 FreeBSD 7.0-RELEASE-p6 #0: Mon Dec 8 11:52:53 EST 2008 root@rose.netsvs.scranton.edu:/usr/obj/usr/src/sys/ROSE i386 >Description: Executing certain command-line scripts that are included in rt-3.8.1_2 results in a database connection error. Other scripts execute without error. I haven't been able to determine why this is so. Broken: rt-email-dashboards rt-email-digest Work: rt-email-group-admin rt-clean-sessions rt-dump-database rt-shredder rt-setup-database rt-test-dependencies Not-tested: rt-server Output of "sudo ./rt-test-dependencies --with-mysql" : perl: >=5.8.3(5.8.9)...found users: rt group (rt)...found bin owner (root)...found libs owner (root)...found libs group (wheel)...found web owner (www)...found web group (www)...found CLI dependencies: Term::ReadKey...found Getopt::Long >= 2.24...found HTTP::Request::Common...found Term::ReadLine...found Text::ParseWords...found LWP...found CORE dependencies: Class::ReturnValue >= 0.40...found Text::Quoted >= 2.02...found CSS::Squish >= 0.06...found Encode >= 2.13...found Module::Versions::Report >= 1.05...found MIME::Entity >= 5.425...found DBI >= 1.37...found Locale::Maketext::Lexicon >= 0.32...found Devel::StackTrace >= 1.19...found Digest::base...found Time::ParseDate...found File::Temp >= 0.18...found Locale::Maketext >= 1.06...found Tree::Simple >= 1.04...found Text::Template...found Scalar::Util...found HTML::Scrubber >= 0.08...found File::Spec >= 0.8...found Calendar::Simple...found DBIx::SearchBuilder >= 1.54...found Mail::Mailer >= 1.57...found File::ShareDir...found Regexp::Common...found Digest::MD5 >= 2.27...found HTML::Entities...found Cache::Simple::TimedExpiry...found File::Glob...found Locale::Maketext::Fuzzy...found Time::HiRes...found Text::Wrapper...found Log::Dispatch >= 2.0...found UNIVERSAL::require...found Email::Address...found DASHBOARDS dependencies: HTML::RewriteAttributes >= 0.02...found MIME::Types...found GD dependencies: GD::Text...found GD...found GD::Graph...found GPG dependencies: PerlIO::eol...found GnuPG::Interface...found ICAL dependencies: Data::ICal...found MAILGATE dependencies: Pod::Usage...found HTML::TreeBuilder...found Getopt::Long...found HTML::FormatText...found LWP::UserAgent...found MASON dependencies: Storable >= 2.08...found CSS::Squish >= 0.06...found Apache::Session >= 1.53...found Errno...found Devel::StackTrace >= 1.19...found CGI::Cookie >= 1.20...found Text::WikiFormat >= 0.76...found XML::RSS >= 1.05...found HTML::Mason >= 1.36...found Digest::MD5 >= 2.27...found MYSQL dependencies: DBD::mysql >= 2.1018...found SMTP dependencies: Net::SMTP...found STANDALONE dependencies: Net::Server::PreFork...MISSING Net::Server...MISSING HTTP::Server::Simple >= 0.34...MISSING HTTP::Server::Simple::Mason >= 0.09...MISSING SOME DEPENDENCIES WERE MISSING. STANDALONE missing dependencies: Net::Server::PreFork...MISSING HTTP::Server::Simple >= 0.34...MISSING HTTP::Server::Simple::Mason >= 0.09...MISSING Net::Server...MISSING I'm using mysql-server-5.0.75, apache+mod_ssl-1.3.41+2.8.31, mod_perl-1.30, p5-DBD-mysql-4.006, and p5-HTML-Mason-1.39_1. >How-To-Repeat: sudo /usr/local/sbin/rt-email-digest -m daily -p [Tue Jan 20 15:02:20 2009] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm:505) [Tue Jan 20 15:02:20 2009] [warning]: RT::Handle=HASH(0x8765350) couldn't execute the query 'SELECT main.* FROM Transactions main WHERE (main.ObjectType = 'RT::Ticket') AND (main.Created > '2009-01-19 15:01:50') ORDER BY main.Created ASC, main.id ASC ' at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8765350)', 'SELECT main.* FROM Transactions main WHERE (main.ObjectType ...') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 238 DBIx::SearchBuilder::_DoSearch('RT::Transactions=HASH(0x9badfac)') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 498 DBIx::SearchBuilder::Next('RT::Transactions=HASH(0x9badfac)') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Transactions_Overlay.pm line 133 RT::Transactions::Next('RT::Transactions=HASH(0x9badfac)') called at /usr/local/sbin/rt-email-digest line 262 main::find_transactions('daily') called at /usr/local/sbin/rt-email-digest line 128 main::run('daily', 1) called at /usr/local/sbin/rt-email-digest line 119 (/usr/local/lib/perl5/5.8.9/Carp.pm:47) sudo /usr/local/sbin/rt-email-dashboards [Tue Jan 20 15:03:01 2009] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm:505) [Tue Jan 20 15:03:01 2009] [warning]: RT::Handle=HASH(0x904e458) couldn't execute the query 'SELECT * FROM Groups WHERE Type = ? AND Domain = ?' at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x904e458)', 'SELECT * FROM Groups WHERE Type = ? AND Domain = ?', 'Privileged', 'SystemInternal') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Record.pm line 1207 DBIx::SearchBuilder::Record::_LoadFromSQL('RT::Group=HASH(0x9e13954)', 'SELECT * FROM Groups WHERE Type = ? AND Domain = ?', 'Privileged', 'SystemInternal') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Record.pm line 1126 DBIx::SearchBuilder::Record::LoadByCols('RT::Group=HASH(0x9e13954)', 'Type', 'Privileged', 'Domain', 'SystemInternal') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Record/Cachable.pm line 119 DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::Group=HASH(0x9e13954)', 'Domain', 'SystemInternal', 'Type', 'Privileged') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Record.pm line 350 RT::Record::LoadByCols('RT::Group=HASH(0x9e13954)', 'Domain', 'SystemInternal', 'Type', 'Privileged') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 291 RT::Group::LoadSystemInternalGroup('RT::Group=HASH(0x9e13954)', 'Privileged') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 218 RT::Users::LimitToPrivileged('RT::Users=HASH(0x9e93d90)') called at /usr/local/sbin/rt-email-dashboards line 130 (/usr/local/lib/perl5/5.8.9/Carp.pm:47) [Tue Jan 20 15:03:01 2009] [crit]: Couldn't find a privileged users group (/usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm:220) [Tue Jan 20 15:03:01 2009] [warning]: DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 505. (/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm:505) [Tue Jan 20 15:03:01 2009] [warning]: RT::Handle=HASH(0x904e458) couldn't execute the query 'SELECT DISTINCT main.* FROM Users main JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) WHERE (Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') ORDER BY main.Name ASC ' at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder/Handle.pm line 518 DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x904e458)', 'SELECT DISTINCT main.* FROM Users main JOIN Principals Princi...') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 238 DBIx::SearchBuilder::_DoSearch('RT::Users=HASH(0x9e93d90)') called at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 133 RT::Users::_DoSearch('RT::Users=HASH(0x9e93d90)') called at /usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 498 DBIx::SearchBuilder::Next('RT::Users=HASH(0x9e93d90)') called at /usr/local/sbin/rt-email-dashboards line 132 (/usr/local/lib/perl5/5.8.9/Carp.pm:47) >Fix: >Release-Note: >Audit-Trail: >Unformatted: