[rt-users] RT_SiteConfig and Postgres

Alex Moore asmoore at edge.net
Thu Oct 27 22:10:55 EDT 2005


On Thu, 27 Oct 2005 02:47:01 -0600 (MDT)
"Greg Talbot" <gtalbot at centerone.com> wrote:

> I am having a hard time getting RT to connect to my Postgres install.
> My pg_hba.conf is set to,
> local   all     all     trust
> As I was instructed to do so for another app.
> 
> My question is what do I use for,
> 
> Set($DatabaseHost   , '');
> Set($DatabaseRTHost , '');
> 
> I have tried everything and I always get,
> [error] Connect Failed FATAL:  no pg_hba.conf entry for host
> "127.0.0.1", user "rt_user", database "rt3", SSL off\n\n
> at /opt/RT//lib/RT.pm line 176\n
> 

The $DatabaseHost and $DatabaseRTHost should be correct as is.

I would think that connecting to 'host 127.0.0.1' is not a connection to
a Unix socket, which is what 'local' means.  Try adding additional
lines to pg_hba.conf like: 
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust

Alex



More information about the rt-users mailing list