Your message dated Sun, 1 Aug 2010 14:13:19 +0100
with message-id <[email protected]>
and subject line Closing due to silence from submitter
has caused the Debian Bug report #506487,
regarding request-tracker3.8: cannot configure remote mysql server
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
506487: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=506487
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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 rtu...@localhost but we
would need rtu...@% 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: [email protected]
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: [email protected]
request-tracker3.8/passwords-do-not-match:
* request-tracker3.8/database-type: mysql
--- End Message ---
--- Begin Message ---
I'm closing this bug, as no response has been forthcoming from the
submitter for more than a year. It can of course be reopened if this
changes.
Dominic.
--
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)
--- End Message ---
