RT3 - Pg database connection - authentication failed

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’,’’);
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