> 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.
-Adam Thompson
[email protected]
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* San Francisco, CA, USA October 18 & 19, 2011
* Washington DC, USA October 31 & November 1, 2011
* Melbourne VIC, Australia November 28 & 29, 2011
* Barcelona, Spain November 28 & 29, 2011
