[request-tracker-maintainers] Bug#644093: request-tracker4: rt-setup-fulltext-index has inappropriate hard-coded DBA param

[Dominic Hargreaves]

Package: request-tracker4
Version: 4.0.2-1
Severity: normal
X-Debbugs-CC: rt-users at lists.bestpractical.com

On Sat, Oct 01, 2011 at 04:12:01PM -0500, Adam Thompson wrote:
> > Using Ubuntu 11.10 beta, installed the request-tracker4 packages
> > (Thank you, Dominic!).
> > Apparently a whole bunch of magic happens behind the scenes during
> > database setup thanks to Debian's dbconfig-common, which I utterly
> > fail to understand at this time.
> >
> > After everything gets automagically configured, I wanted to add
> > fulltext searching support to the database, and ran rt-setup-
> > fulltext-index.  It detects I'm running postgres, asks me what
> > table and which index type I want, and then promptly fails with
> > this:
> >
> >       [Sat Oct  1 20:57:43 2011] [crit]: DBI
> > connect('dbname=rtdb;host=localhost','postgres',...) failed:
> > fe_sendauth:
> > no password supplied at /usr/sbin/rt-setup-fulltext-index line 600
> > (/usr/share/request-tracker4/lib/RT.pm:350)
> >       DBI connect('dbname=rtdb;host=localhost','postgres',...)
> > failed:
> > fe_sendauth: no password supplied at /usr/sbin/rt-setup-fulltext-
> > index line 600
> >
> [...]
> 
> Of course, I figured it out about 30 seconds after hitting 'send'.
> 
> The "rtuser" postgresql user has sufficient rights to alter the schema on 
> 'rtdb'.
> Therefore, /usr/sbin/rt-setup-fulltext-index can be run with "--dba 
> rtuser" and "--dba-password XXXX" options, where the password is whatever 
> you either A) selected during the initial debconf run, or b) whatever's 
> now contained in /etc/request-tracker4/RT_SiteConfig.d/51-dbconfig-common.

Ah, this is effectively another version of
<http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=637215>.

Looks like I need to revert e7f378895ec06e64bd056e1c966277aeee2ef6bd
too.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)