Your message dated Sun, 31 Jan 2010 14:28:19 +0000
with message-id <[email protected]>
and subject line Re: Bug#316192: request-tracker3.4: automate db user creation
for postgres
has caused the Debian Bug report #316192,
regarding request-tracker3.4: automate db user creation for postgres
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.)
--
316192: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=316192
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: request-tracker3.4
Version: 3.4.1-2
Severity: minor
The setup procedure currently requires the dedicated database user to be
created manually. For PostgreSQL (both in upstream and downstream
default config) this can be done, after login details etc. have been
picked, with a command along the following lines:
su postgres -c "psql template1 -c \
\"CREATE USER rtuser WITH PASSWORD 'wibble' CREATEDB\""
(Also, the CREATEDB privilege could be omitted if the setup script also
ran, under the postgres user,
createdb -E unicode -O rtuser rtdb "request-tracker database"
...instead of logging into the default database as rtuser and creating the
database from there, as is currently the case.)
-- Package-specific info:
Changed files:
etc/request-tracker3.4/RT_SiteConfig.pm
-- System Information:
Debian Release: 3.1
APT prefers unstable
APT policy: (50, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.11-1-686-smp
Locale: LANG=en_US, LC_CTYPE=en_US (charmap=ISO-8859-1)
Versions of packages request-tracker3.4 depends on:
hi apache2-mpm-prefork [apache2 2.0.54-4 traditional model for Apache2
ii libapache-dbi-perl 0.94-2 Connect apache server to database
ii libapache-session-perl 1.60-2 Perl modules for keeping persisten
hi libapache2-mod-perl2 1.999.21-1 Integration of perl with the Apach
ii libcache-cache-perl 1.04-1 Managed caches of persistent infor
ii libcache-simple-timedexpiry- 0.21-1 Perl module to cache and expire ke
ii libclass-returnvalue-perl 0.52-1 A return-value object that lets yo
ii libdbd-mysql-perl 2.9006-1 A Perl5 database interface to the
ii libdbd-pg-perl 1.41-3 a PostgreSQL interface for Perl 5
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libdbix-searchbuilder-perl 1.26-1 Encapsulate SQL queries and rows i
ii libexception-class-perl 1.20-1 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.45-2 A collection of modules that parse
ii libhtml-scrubber-perl 0.08-1 Perl extension for scrubbing/sanit
ii liblocale-maketext-fuzzy-per 0.02-1 Maketext from already interpolated
ii liblocale-maketext-lexicon-p 0.49-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.417-1 Perl5 modules for MIME-compliant m
ii libmldbm-perl 2.01-1 Store multidimensional hash struct
ii libmodule-versions-report-pe 1.02-1 Report versions of all modules in
ii libparams-validate-perl 0.76-1 validate parameters to Perl method
ii libregexp-common-perl 2.120-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 libtree-simple-perl 1.14-1 A simple tree object
ii libxml-rss-perl 1.05-1 Perl module for managing RSS (RDF
hi perl 5.8.4-8 Larry Wall's Practical Extraction
ii postfix [mail-transport-agen 2.1.5-9 A high-performance mail transport
ii rt3.4-clients 3.4.1-2 Mail gateway and command-line inte
ii sysklogd [system-log-daemon] 1.4.1-17 System Logging Daemon
-- no debconf information
--- End Message ---
--- Begin Message ---
On Wed, Jun 29, 2005 at 10:02:53AM +0700, Jeroen Vermeulen wrote:
> The setup procedure currently requires the dedicated database user to be
> created manually. For PostgreSQL (both in upstream and downstream
> default config) this can be done, after login details etc. have been
> picked, with a command along the following lines:
>
> su postgres -c "psql template1 -c \
> \"CREATE USER rtuser WITH PASSWORD 'wibble' CREATEDB\""
>
> (Also, the CREATEDB privilege could be omitted if the setup script also
> ran, under the postgres user,
>
> createdb -E unicode -O rtuser rtdb "request-tracker database"
>
> ...instead of logging into the default database as rtuser and creating the
> database from there, as is currently the case.)
Hi Jeroen,
Current versions of the RT packages use dbconfig-common to accomplish
all this and more. request-tracker3.4 will not receive any more updates,
so I am marking this bug as done.
Regards,
Dominic.
--
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)
--- End Message ---
