[request-tracker-maintainers] Bug#506487: request-tracker3.8: cannot configure remote mysql server
Antoine Beaupre
anarcat at shell.koumbit.net
Fri Nov 21 23:15:18 UTC 2008
Package: request-tracker3.8
Version: 3.8.1-1~experimental1~bpo40+1
Severity: important
It seems that this package has trouble configuring the database server through the dbconfig interface. During the dbc_go() step, we get an access denied:
DBI connect('dbname=rtdb;host=mysql.koumbit.net','rtuser',...) failed: Access denied for user 'rtuser'@'192.168.0.42' (using password: YES) at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 106
The problem, i think, is that it shouldn't try to connect with the `rtuser' user, but with the *censored* user prompted through debconf.
The other problem is that the GRANT is created with rtuser at localhost but we would need rtuser@% or something like that. At some point in the various attempts to
make it work, it seemed that the grant was created with a "shell.koumbit.net" host, but that's also wrong since we connect through an internal interface and the
DNS doesn't point there.
So, in summary, i think the problem is that the db init scripts do not create the GRANT properly.
Also note that I had to change the dbconfig-common file below to be able to see the error, otherwise debconf would just replace it and hide the error. I removed
the "exec" word and added a sleep 5 as last line of the script.
The change to Handler.pm will be described in a seperate issue.
-- Package-specific info:
Changed files:
usr/share/dbconfig-common/scripts/request-tracker3.8/install/mysql
usr/share/request-tracker3.8/lib/RT/Interface/Web/Handler.pm
-- System Information:
Debian Release: 4.0
APT prefers stable
APT policy: (500, 'stable'), (2, 'testing')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-6-xen-amd64
Locale: LANG=fr_CA.UTF-8, LC_CTYPE=fr_CA.UTF-8 (charmap=UTF-8)
Versions of packages request-tracker3.8 depends on:
ii dbconfig-c 1.8.39 common framework for packaging dat
ii debconf [d 1.5.11etch2 Debian configuration management sy
ii libapache- 1.81-1 Perl modules for keeping persisten
ii libcache-s 0.26-1 Perl module to cache and expire ke
ii libcalenda 1.17-2 Perl extension to create simple ca
ii libclass-r 0.53-1 A return-value object that lets yo
ii libcss-squ 0.07-1 Compact many CSS files into one bi
ii libdata-ic 0.13+dfsg-1 Perlmodule to generate and read iC
ii libdbi-per 1.53-1etch1 Perl5 database interface by Tim Bu
ii libdbix-se 1.54-1 Encapsulate SQL queries and rows i
ii libdevel-s 1.1902-1 Stack trace and stack trace frame
ii libemail-a 1.870-1 RFC 2822 Address Parsing and Creat
ii libfile-sh 0.05-1.2~bpo40+1 Locate per-dist and per-module sha
ii libgd-grap 1.43.08-2.1 Graph Plotting Module for Perl 5
ii libgd-text 0.86-3.1 Text utilities for use with GD
ii libgnupg-i 0.33-6 Perl interface to GnuPG
ii libgraphvi 2.02-1 Perl interface to the GraphViz gra
ii libhtml-ma 1:1.35-3 HTML::Mason Perl module
ii libhtml-pa 3.55-1 A collection of modules that parse
ii libhtml-re 0.03-1 concise attribute rewriting
ii libhtml-sc 0.08-3 Perl extension for scrubbing/sanit
ii libjs-prot 1.6.0.2-4 JavaScript Framework for dynamic w
ii libjs-scri 1.8.1-5 JavaScript library for dynamic web
ii liblocale- 0.02-2 Maketext from already interpolated
ii liblocale- 0.62-1 Lexicon-handling backends for "Loc
ii liblog-dis 2.11-1 Dispatches messages to multiple Lo
ii libmailtoo 1.74-1 Manipulate email in perl programs
ii libmime-pe 5.420-0.1 Perl5 modules for MIME-compliant m
ii libmime-ty 1.18-1 Perl extension for determining MIM
ii libmodule- 1.05-1 Report versions of all modules in
ii libperlio- 0.13-1 PerlIO layer for normalizing line
ii libregexp- 2.120-4 Provide commonly requested regular
ii libtext-au 1.13-1 Perl module for automatic text wra
ii libtext-qu 2.05-2 Extract the structure of a quoted
ii libtext-te 1.44-1.1 Text::Template perl module
ii libtext-wi 0.78-0.1 translates Wiki formatted text int
ii libtext-wr 1.000-2 Simple word wrapping routine
ii libtime-mo 2003.1126-2 Various Perl modules for time/date
ii libtimedat 1.1600-5 Time and date functions for Perl
ii libtree-si 1.17-1 A simple tree object
ii libunivers 0.10-1 Load modules from a variable
ii libxml-rss 1.05-1 Perl module for managing RSS (RDF
ii libxml-sim 2.14-5 Perl module for reading and writin
ii perl 5.8.8-7etch3 Larry Wall's Practical Extraction
ii postfix [m 2.3.8-2+etch1 A high-performance mail transport
ii rt3.8-apac 3.8.1-1~experimental1~bpo40+1 Apache 2 specific files for reques
ii rt3.8-clie 3.8.1-1~experimental1~bpo40+1 Mail gateway and command-line inte
ii rt3.8-db-m 3.8.1-1~experimental1~bpo40+1 MySQL database backend for request
ii sysklogd [ 1.4.1-18 System Logging Daemon
ii ucf 2.0020 Update Configuration File: preserv
Versions of packages request-tracker3.8 recommends:
pn speedy-cgi-perl <none> (no description available)
-- debconf information:
* request-tracker3.8/organization: shell.koumbit.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: ignore
* request-tracker3.8/correspondaddress: rt at rt38.koumbit.net
request-tracker3.8/dbconfig-remove:
* request-tracker3.8/mysql/method: tcp/ip
request-tracker3.8/upgrade-error: abort
* request-tracker3.8/mysql/admin-user: *censored*
* 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: retry
request-tracker3.8/pgsql/method: unix socket
* request-tracker3.8/dbconfig-install: true
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/db/basepath:
request-tracker3.8/internal/skip-preseed: false
request-tracker3.8/remote/newhost: mysql.koumbit.net
request-tracker3.8/pgsql/admin-user: postgres
* request-tracker3.8/db/app-user: rtuser
* request-tracker3.8/webbaseurl: https://rt38.koumbit.net
* request-tracker3.8/remote/host: mysql.koumbit.net
* request-tracker3.8/rtname: rt38.koumbit.net
request-tracker3.8/internal/reconfiguring: false
* request-tracker3.8/commentaddress: rt-comment at rt38.koumbit.net
request-tracker3.8/passwords-do-not-match:
* request-tracker3.8/database-type: mysql
More information about the pkg-request-tracker-maintainers
mailing list