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]

Reply via email to