[rt-users] Re: [ADMIN] RT3 - Pg database connection - authentication failed

[Gary Stainburn]

On Wednesday 08 August 2007 17:45, you wrote:
> I'm guessing the problem is your pg_hba.conf and the fact that RT is
> trying to connect from a different IP than the one that hits 127.0.0.1
>
> When you run psql, is it on the same machine that RT3 is on?  Or the
> server?  It means little if you're not coming in from the same address
> as RT3 is.
>
> Edit your pg_hba.conf file on the postgresql server to let the RT3
> machine connect.  The file's pretty self explanatory.

Hi Scott

Everything is running on the same server. I've even tried changing localhost 
to 127.0.0.1 but didn't think that'd matter. It didn't.

The following program even works. This means that the problem must be related 
to RT3 or the perl installation, but I'm at a loss as to what

Gary

#!/usr/bin/perl -w

use DBI;

my 
$dbh=DBI->connect('dbi:Pg:dbname=rt3;host=127.0.0.1','rt_user','<password>');
die $DBI::errstr unless ($dbh);

$dbh->disconnect;
-- 
Gary Stainburn
 
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000