ports/130781: Database connection error when executing certain CLI scripts from rt-3.8.1_2

Tue Jan 20 15:10:04 UTC 2009

>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 at 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: