[rt-users] Re: RT_SiteConfig and Postgres

[Luis Moreno]

Alex

The comment from gtalbot at centerone.com is correct, but I think is a little
bit insecure, I will suggest the following:
RT_Config.pm
Set($DatabaseUser , 'your_rt_database_user');
Set($DatabasePassword , 'your_rt_user_database_password'); 
Set($DatabaseType , 'Pg')
Set($DatabaseHost   , 'localhost'); or Set($DatabaseHost   , '127.0.0.1');
Set($DatabaseRTHost , 'localhost'); or Set($DatabaseRTHost , '127.0.0.1');

pg_hba.conf
host    rtx         your_rt_user     127.0.0.1         255.255.255.255   md5
Where rtx is the database name of your rt database.

Best regards, and hope it helps.

-luis

> ----------------------------------------------------------------------
> ------------------------------
> 
> Message: 2
> Date: Thu, 27 Oct 2005 21:10:55 -0500
> From: Alex Moore <asmoore at edge.net>
> Subject: Re: [rt-users] RT_SiteConfig and Postgres
> To: rt-users at lists.bestpractical.com
> Message-ID: <20051027211055.0000741e at sws602>
> Content-Type: text/plain; charset=US-ASCII
> 
> 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