[request-tracker-maintainers] Bug#603247: request-tracker3.8: loading 3.6 database in 3.8 fails with "namespace error : Failed to parse QName 'Pref-RT:'"
James Andrewartha
jandrewartha at ccgs.wa.edu.au
Fri Nov 12 07:42:43 UTC 2010
Package: request-tracker3.8
Version: 3.8.8-5
Severity: important
I've installed request-tracker3.8 and it's working, now I'm trying to import
the db from 3.6. I dumped it with 'rt-dump-database-3.6 0 > rt-db-3.6.dump'
then tried to load it with
'rt-setup-database-3.8 --action insert --datafile rt-db-3.6.dump'
which gives the following output:
In order to create or update your RT database, this script needs to connect to your mysql instance on localhost as request-tracker3
Please specify that user's database password below. If the user has no database
password, just press return.
Password:
Working with:
Type: mysql
Host: localhost
Name: rtdb
User: request-tracker3
DBA: request-tracker3
[Fri Nov 12 07:21:53 2010] [error]: The RTAddressRegexp option is not set in the config. Not setting this option results in additional SQL queries to check whether each address belongs to RT or not. It is especially important to set this option if RT recieves emails on addresses that are not in the database or config. (/usr/share/request-tracker3.8/lib/RT/Config.pm:343)
Now inserting data
Couldn't finish 'insert' step.
ERROR: Couldn't load data from 'rt-db-3.6.dump' for import:
ERROR::122461: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:122471: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:122504: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:122515: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:122540: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:122614: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:122711: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:122722: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:124621: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:124631: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:126975: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:126987: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:127411: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:127423: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
:128029: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-1>
^
:128039: namespace error : Failed to parse QName 'Pref-RT:'
<Pref-RT::Attribute-2>
^
Compilation failed in require at /usr/share/request-tracker3.8/lib/RT/Handle.pm line 738.
The relevant part of the dump looks like:
<Pref-RT::Attribute-1>
<Format>'<a>__id__</a>/TITLE:#',
'<a href="/rt/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject',
'__ExtendedStatus__',
'__LastUpdatedBy__',
'__LastUpdated__'</Format>
<Order>ASC|ASC|ASC|ASC</Order>
<OrderBy>LastUpdated</OrderBy>
<RowsPerPage>0</RowsPerPage>
</Pref-RT::Attribute-1>
<Pref-RT::Attribute-2>
<Format>'<a HREF="/rt/Ticket/Display.html?id=__id__">__id__</a>/TITLE:Id',
'<a HREF="/rt/Ticket/Display.html?id=__id__">__Subject__</a>/TITLE:Subject',
'__QueueName__',
'__ExtendedStatus__',
'__CreatedRelative__',
'<a>__loc(Take)__</a>/TITLE:&nbsp; '</Format>
<Order>ASC|ASC|ASC|ASC</Order>
<OrderBy>Created</OrderBy>
<RowsPerPage>0</RowsPerPage>
</Pref-RT::Attribute-2>
-- Package-specific info:
Changed files:
There are locally modified files in /usr/local/share/request-tracker3.8/,
these may (or may not) be the source of the problem.
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages request-tracker3.8 depends on:
ii dbconfig-common 1.8.46 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.36 Debian configuration management sy
ii exim4 4.72-1 metapackage to ease Exim MTA (v4)
ii exim4-daemon-light [mail-tr 4.72-1 lightweight Exim MTA (v4) daemon
ii libapache-session-perl 1.87-1 Perl modules for keeping persisten
ii libcache-simple-timedexpiry 0.27-2 Perl module to cache and expire ke
ii libcalendar-simple-perl 1.21-1 module for producing simple calend
ii libcgi-fast-perl 5.10.1-15 CGI::Fast Perl module
ii libcgi-pm-perl 3.49-1 module for Common Gateway Interfac
ii libclass-returnvalue-perl 0.55-1 A return-value object that lets yo
ii libcss-squish-perl 0.09-1 module to compact many CSS files i
ii libdata-ical-perl 0.16+dfsg-1 Perl module for manipulating iCale
ii libdbi-perl 1.612-1 Perl Database Interface (DBI)
ii libdbix-searchbuilder-perl 1.56-1 Perl implementation of a simple OR
ii libdevel-stacktrace-perl 1.2100-1 Perl module containing stack trace
ii libemail-address-perl 1.889-2 RFC 2822 Address Parsing and Creat
ii libfcgi-procmanager-perl 0.18-2 Functions for managing FastCGI app
ii libfile-sharedir-perl 1.00-0.1 Locate per-dist and per-module sha
ii libgd-graph-perl 1.44-3 Graph Plotting Module for Perl 5
ii libgd-text-perl 0.86-5 Text utilities for use with GD
ii libgnupg-interface-perl 0.42-3 Perl interface to GnuPG
ii libgraphviz-perl 2.04-1 Perl interface to the GraphViz gra
ii libhtml-mason-perl 1:1.44-1 HTML::Mason Perl module
ii libhtml-parser-perl 3.66-1 collection of modules that parse H
ii libhtml-rewriteattributes-p 0.03-1 concise attribute rewriting
ii libhtml-scrubber-perl 0.08-4 Perl extension for scrubbing/sanit
ii libipc-run-safehandles-perl 0.02-1 Use IPC::Run and IPC::Run3 safely
ii libjs-prototype 1.6.1-1 JavaScript Framework for dynamic w
ii libjs-scriptaculous 1.8.3-1 JavaScript library for dynamic web
ii liblocale-maketext-fuzzy-pe 0.10-1 Maketext from already interpolated
ii liblocale-maketext-lexicon- 0.82-1 lexicon-handling backends for Loca
ii liblog-dispatch-perl 2.22-1 Dispatches messages to multiple Lo
ii libmailtools-perl 2.06-1 Manipulate email in perl programs
ii libmime-perl 5.427-2 transitional dummy package
ii libmime-tools-perl [libmime 5.428-1 Perl5 modules for MIME-compliant m
ii libmime-types-perl 1.30-1 Perl extension for determining MIM
ii libmodule-versions-report-p 1.06-1 Report versions of all modules in
ii libperlio-eol-perl 0.14-1+b1 PerlIO layer for normalizing line
ii libregexp-common-perl 2010010201-1 module with common regular express
ii libtext-autoformat-perl 1.669002-1 module for automatic text wrapping
ii libtext-quoted-perl 2.06-1 Perl module to extract the structu
ii libtext-template-perl 1.45-1 Text::Template perl module
ii libtext-wikiformat-perl 0.78-1 translates Wiki formatted text int
ii libtext-wrapper-perl 1.02-1 Simple word wrapping routine
ii libtime-modules-perl 2006.0814-2 Various Perl modules for time/date
ii libtimedate-perl 1.2000-1 collection of modules to manipulat
ii libtree-simple-perl 1.18-1 A simple tree object
ii libuniversal-require-perl 0.13-1 Load modules from a variable
ii libxml-rss-perl 1.48-1 Perl module for managing RSS (RDF
ii libxml-simple-perl 2.18-3 Perl module for reading and writin
ii perl 5.10.1-15 Larry Wall's Practical Extraction
ii perl-modules [libcgi-pm-per 5.10.1-15 Core Perl modules
ii rsyslog [system-log-daemon] 4.6.4-1 enhanced multi-threaded syslogd
ii rt3.8-apache2 3.8.8-5 Apache 2 specific files for reques
ii rt3.8-clients 3.8.8-5 mail gateway and command-line inte
ii rt3.8-db-mysql 3.8.8-5 MySQL database backend for request
ii rt3.8-db-sqlite 3.8.8-5 SQLite database backend for reques
ii ucf 3.0025+nmu1 Update Configuration File: preserv
Versions of packages request-tracker3.8 recommends:
ii libdatetime-locale-perl 1:0.45-1 Perl extension providing localizat
ii libdatetime-perl 2:0.6100-2 module for manipulating dates, tim
ii speedy-cgi-perl 2.22-13 speed up perl scripts by making th
Versions of packages request-tracker3.8 suggests:
pn rt3.8-rtfm <none> (no description available)
-- debconf information:
request-tracker3.8/mysql/admin-pass: (password omitted)
request-tracker3.8/pgsql/app-pass: (password omitted)
request-tracker3.8/pgsql/admin-pass: (password omitted)
request-tracker3.8/mysql/app-pass: (password omitted)
request-tracker3.8/password-confirm: (password omitted)
request-tracker3.8/app-password-confirm: (password omitted)
* request-tracker3.8/initial-root-password: (password omitted)
* request-tracker3.8/mysql/method: unix socket
request-tracker3.8/dbconfig-reinstall: false
* request-tracker3.8/db/dbname: rtdb
* request-tracker3.8/dbconfig-install: true
request-tracker3.8/remote/newhost:
* request-tracker3.8/db/app-user: request-tracker3
* request-tracker3.8/rtname: ccgs.wa.edu.au
request-tracker3.8/internal/reconfiguring: false
request-tracker3.8/passwords-do-not-match:
request-tracker3.8/pgsql/no-empty-passwords:
* request-tracker3.8/handle-siteconfig-permissions: true
* request-tracker3.8/correspondaddress: helpdesk at ccgs.wa.edu.au
request-tracker3.8/dbconfig-upgrade: true
request-tracker3.8/purge: false
* request-tracker3.8/webpath: /rt
request-tracker3.8/upgrade-backup: true
request-tracker3.8/db/basepath: /var/lib/dbconfig-common/sqlite3/request-tracker3.8
request-tracker3.8/internal/skip-preseed: false
* request-tracker3.8/commentaddress: helpdesk-comment at ccgs.wa.edu.au
* request-tracker3.8/organization: ccgs.wa.edu.au
request-tracker3.8/pgsql/authmethod-user: password
request-tracker3.8/install-error: retry
request-tracker3.8/dbconfig-remove:
request-tracker3.8/missing-db-package-error: abort
request-tracker3.8/remove-error: abort
request-tracker3.8/warn-sqlite-file:
request-tracker3.8/pgsql/admin-user: postgres
request-tracker3.8/remote/host:
* request-tracker3.8/database-type: mysql
* request-tracker3.8/install-cronjobs: true
request-tracker3.8/upgrade-error: abort
* request-tracker3.8/mysql/admin-user: root
request-tracker3.8/remote/port:
request-tracker3.8/pgsql/changeconf: false
request-tracker3.8/pgsql/method: unix socket
request-tracker3.8/pgsql/authmethod-admin: ident
request-tracker3.8/pgsql/manualconf:
* request-tracker3.8/webbaseurl: http://helpdesk.ccgs.wa.edu.au/rt
More information about the pkg-request-tracker-maintainers
mailing list