Package: request-tracker3 Version: 3.0.12-3 Severity: important Tags: patch
The rt-setup-database fails to initialize the data in the init action. It does in the insert action. Note: I am using SQLite driver, but the fix below indicates it's driver-independent. Symptoms: It dies like this: Now inserting RT data [Thu Jan 13 09:14:51 2005] [crit]: prepare on an inactive database handle at /usr/share/perl5/DBD/SQLite.pm line 73. (/usr/share/request-tracker3/lib/RT.pm:255) Workaround: Calling with --action insert afterwards. Problem: The insert_initial_data function opens $RT::Handle and closes it at the end. Then insert_data calls RT::Init to open it, but RT::Init sees it exists (not checking it's disconnected) and does not reconnect it. The handle either needs to be undefined (following patch does that) at the end of insert_initial_data, or RT::Init needs to check whether $RT::Handle is actualy connected. Fix: Following patch for the rt-setup-database-3.0 file fixes the problem by actualy undefining the handle so RT::Init will reopen. --- rt-setup-database-3.0.orig 2005-01-13 10:32:30.000000000 +0100 +++ rt-setup-database-3.0 2005-01-13 10:27:27.000000000 +0100 @@ -395,6 +395,7 @@ } print "done.\n"; $RT::Handle->Disconnect(); + undef $RT::Handle; } @@ -594,6 +595,7 @@ print "done.\n"; } $RT::Handle->Disconnect(); + undef $RT::Handle; } -- Package-specific info: Changed files: etc/request-tracker3/RT_SiteConfig.pm usr/sbin/rt-setup-database-3.0 ##Note: It has the above patch applied. -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.8-1-686 Locale: LANG=C, LC_CTYPE=cs_CZ (charmap=ISO-8859-2) Versions of packages request-tracker3 depends on: ii apache2 2.0.52-3 Next generation, scalable, extenda ii apache2-mpm-worker [apache2] 2.0.52-3 High speed threaded model for Apac ii exim4 4.34-10 An MTA (Mail Transport Agent) ii exim4-daemon-light [mail-tra 4.34-10 Lightweight version of the Exim (v ii libapache-dbi-perl 0.94-2 Connect apache server to database ii libapache-session-perl 1.60-2 Perl modules for keeping persisten ii libapache2-mod-perl2 1.99.14-4 Integration of perl with the Apach ii libcache-cache-perl 1.03-1 Managed caches of persistent infor ii libclass-returnvalue-perl 0.52-1 A return-value object that lets yo ii libdbd-sqlite-perl 0.29-1 Perl DBI driver with a self-contai ii libdbi-perl 1.45-1 The Perl5 Database Interface by Ti ii libdbix-searchbuilder-perl 1.16-1 Encapsulate SQL queries and rows i ii libexception-class-perl 1.19-2 A module that allows you to declar ii libfcgi-perl 0.67-1 FastCGI Perl module ii libfreezethaw-perl 0.43-2 converting Perl structures to stri ii libhtml-mason-perl 1:1.26-1 HTML::Mason Perl module ii libhtml-parser-perl 3.36-1 A collection of modules that parse ii liblocale-maketext-fuzzy-per 0.02-1 Maketext from already interpolated ii liblocale-maketext-lexicon-p 0.46-1 Lexicon-handling backends for "Loc ii liblog-dispatch-perl 2.10-1 Dispatches messages to multiple Lo ii libmailtools-perl 1.62-1 Manipulate email in perl programs ii libmime-perl 5.415-1 Perl5 modules for MIME-compliant m ii libmldbm-perl 2.01-1 Store multidimensional hash struct ii libparams-validate-perl 0.74-0.1 Validate parameters to Perl method ii libregexp-common-perl 2.118-1 Provide commonly requested regular ii libterm-readkey-perl 2.21-1.3 A perl module for simple terminal ii libtest-inline-perl 0.16-1 Embed tests and code examples in P ii libtext-autoformat-perl 1.12-3 Perl module for automatic text wra ii libtext-quoted-perl 1.8-1 Extract the structure of a quoted ii libtext-template-perl 1.44-1.1 Text::Template perl module ii libtext-wrapper-perl 1.000-2 Simple word wrapping routine ii libtime-modules-perl 2003.1126-2 Various Perl modules for time/date ii perl 5.8.4-5 Larry Wall's Practical Extraction ii rt3-clients 3.0.12-3 Mail gateway and command-line inte ii sysklogd [system-log-daemon] 1.4.1-16 System Logging Daemon -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]