Date: Tue, 20 Jan 2009 15:03:56 GMT From: Anthony Maszeroski <maszeroskia3@scranton.edu> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/130781: Database connection error when executing certain CLI scripts from rt-3.8.1_2 Message-ID: <200901201503.n0KF3uHg066940@www.freebsd.org> Resent-Message-ID: <200901201510.n0KFA3bd007221@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200901201503.n0KF3uHg066940>