[request-tracker-maintainers] Bug#550278: upgrade-mysql-schema.pl suggests slightly confusing command

Marcus Better marcus at better.se
Thu Oct 8 19:31:33 UTC 2009


Package: request-tracker3.8
Version: 3.8.5-1
Severity: minor

upgrade-mysql-schema.pl prints a message with a suggested command for
applying the schema changes to the database. The command uses the
script name "queries.sql", whereas the UPGRADING.mysql document uses
"sql.queries". These should agree to lessen chances of error or
confusion.

~$ sudo perl /usr/share/request-tracker3.8/etc/upgrade/upgrade-mysql-schema.pl db:host user pass > sql.queries
-- ** NOTICE: No database changes have been made. **
-- Please review the generated SQL, ensure you have a full backup of your database
-- and apply it to your database using a command like:
-- mysql -u rt -p rt < queries.sql";

See also UPGRADING.mysql steps 4-6.

-- Package-specific info:
Changed files:

-- System Information:
Debian Release: squeeze/sid
  APT prefers stable
  APT policy: (990, 'stable'), (400, 'testing'), (300, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.26-1-openvz-amd64 (SMP w/4 CPU cores)
Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages request-tracker3.8 depends on:
ii  dbconfig-common          1.8.39          common framework for packaging dat
ii  debconf [debconf-2.0]    1.5.27          Debian configuration management sy
ii  libapache-session-perl   1.86-1          Perl modules for keeping persisten
ii  libcache-simple-timedexp 0.27-2          Perl module to cache and expire ke
ii  libcalendar-simple-perl  1.20-1          Perl extension to create simple ca
ii  libclass-returnvalue-per 0.55-1          A return-value object that lets yo
ii  libcss-squish-perl       0.07-1          Compact many CSS files into one bi
ii  libdata-ical-perl        0.13+dfsg-1     Perlmodule to generate and read iC
ii  libdbi-perl              1.605-1         Perl5 database interface by Tim Bu
ii  libdbix-searchbuilder-pe 1.54-1          Encapsulate SQL queries and rows i
ii  libdevel-stacktrace-perl 1.1902-1        Stack trace and stack trace frame 
ii  libemail-address-perl    1.889-2         RFC 2822 Address Parsing and Creat
ii  libfile-sharedir-perl    0.05-1.2        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.36-1          Perl interface to GnuPG
ii  libgraphviz-perl         2.03-2          Perl interface to the GraphViz gra
ii  libhtml-mason-perl       1:1.39-1        HTML::Mason Perl module
ii  libhtml-parser-perl      3.56-1+b1       A collection of modules that parse
ii  libhtml-rewriteattribute 0.03-1          concise attribute rewriting
ii  libhtml-scrubber-perl    0.08-4          Perl extension for scrubbing/sanit
ii  libipc-run-safehandles-p 0.02-1          Use IPC::Run and IPC::Run3 safely
ii  libjs-prototype          1.6.0.2-4       JavaScript Framework for dynamic w
ii  libjs-scriptaculous      1.8.1-5         JavaScript library for dynamic web
ii  liblocale-maketext-fuzzy 0.02-3          Maketext from already interpolated
ii  liblocale-maketext-lexic 0.66-1          Lexicon-handling backends for "Loc
ii  liblog-dispatch-perl     2.18-1          Dispatches messages to multiple Lo
ii  libmailtools-perl        2.03-1          Manipulate email in perl programs
ii  libmime-tools-perl [libm 5.427-1         Perl5 modules for MIME-compliant m
ii  libmime-types-perl       1.24-1          Perl extension for determining MIM
ii  libmodule-versions-repor 1.05-1          Report versions of all modules in 
ii  libperlio-eol-perl       0.14-1+b1       PerlIO layer for normalizing line 
ii  libregexp-common-perl    2.122-1         Provide commonly requested regular
ii  libtext-autoformat-perl  1.14.0-1        Perl module for automatic text wra
ii  libtext-quoted-perl      2.05-2          Extract the structure of a quoted 
ii  libtext-template-perl    1.44-1.2        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.1600-9        Time and date functions for Perl
ii  libtree-simple-perl      1.18-1          A simple tree object
ii  libuniversal-require-per 0.11-1          Load modules from a variable
ii  libxml-rss-perl          1.33-1          Perl module for managing RSS (RDF 
ii  libxml-simple-perl       2.18-1          Perl module for reading and writin
ii  nullmailer [mail-transpo 1:1.04-1.1      simple relay-only mail transport a
ii  perl                     5.10.0-19lenny2 Larry Wall's Practical Extraction 
ii  rsyslog [system-log-daem 3.18.6-4        enhanced multi-threaded syslogd
ii  rt3.8-apache2            3.8.5-1         Apache 2 specific files for reques
ii  rt3.8-clients            3.8.5-1         mail gateway and command-line inte
ii  rt3.8-db-mysql           3.8.5-1         MySQL database backend for request
ii  ucf                      3.0016          Update Configuration File: preserv

Versions of packages request-tracker3.8 recommends:
ii  speedy-cgi-perl               2.22-10    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/organization: web.int.ajaxweb.net
  request-tracker3.8/pgsql/no-empty-passwords:
  request-tracker3.8/pgsql/authmethod-user: password
* request-tracker3.8/handle-siteconfig-permissions: true
  request-tracker3.8/install-error: abort
  request-tracker3.8/correspondaddress: rt at web.int.ajaxweb.net
  request-tracker3.8/dbconfig-remove:
  request-tracker3.8/mysql/method: unix socket
  request-tracker3.8/upgrade-error: abort
  request-tracker3.8/mysql/admin-user: root
  request-tracker3.8/remote/port:
  request-tracker3.8/dbconfig-reinstall: false
  request-tracker3.8/db/dbname: rtdb
  request-tracker3.8/pgsql/changeconf: false
  request-tracker3.8/dbconfig-upgrade: true
  request-tracker3.8/missing-db-package-error: abort
  request-tracker3.8/pgsql/method: unix socket
* request-tracker3.8/dbconfig-install: false
  request-tracker3.8/purge: false
  request-tracker3.8/pgsql/authmethod-admin: ident
  request-tracker3.8/pgsql/manualconf:
  request-tracker3.8/webpath: /rt
  request-tracker3.8/remove-error: abort
  request-tracker3.8/upgrade-backup: true
  request-tracker3.8/warn-sqlite-file:
  request-tracker3.8/db/basepath:
  request-tracker3.8/internal/skip-preseed: true
  request-tracker3.8/remote/newhost:
  request-tracker3.8/pgsql/admin-user: postgres
  request-tracker3.8/db/app-user: rtuser
  request-tracker3.8/webbaseurl: http://web.int.ajaxweb.net
  request-tracker3.8/remote/host:
* request-tracker3.8/rtname: Bindows Support
  request-tracker3.8/internal/reconfiguring: false
  request-tracker3.8/commentaddress: rt-comment at web.int.ajaxweb.net
  request-tracker3.8/passwords-do-not-match:
  request-tracker3.8/database-type:





More information about the pkg-request-tracker-maintainers mailing list