[rt-users] Installation pain...

[Jay R. Ashworth]

On Thu, Jun 09, 2005 at 06:04:26PM -0400, Francois Meehan wrote:
> Feels like I am in a bit of a dead end. For one, trying to use postgress,
> I have all kinds of error just to get postgress running. I have create a
> postgres user: rt with password: rt
> 
> Run rt  ./configure with:
> 
> --with-db-type=Pg --with-db-dba postgres   --with-db-rt-user=rt
> --with-db-rt-pass=rt
> 
> ran make and make install
> 
> Get error:
> DBI connect('dbname=template1;host=localhost','yes',...) failed: FATAL: 
> no pg_hba.conf entry for host "127.0.0.1", user "yes", database
> "template1", SSL off
>  at //opt/rt3/sbin/rt-setup-database line 101
> Failed to connect to dbi:Pg:dbname=template1;host=localhost as yes: FATAL:
>  no pg_hba.conf entry for host "127.0.0.1", user "yes", database
> "template1", SSL off
> make: *** [initialize-database] Error 255
> 
> So, looks like we would have to invest time in learning Postgres, not
> trivial as we thought

Nope.  Not really.  That's a common failing, and 

[ looks around ]

a quick google://rt+pg_hba turns up

http://web.mit.edu/afs/sipb/service/rt/lore/rt-postgres-user-creation

as the fourth or fifth hit, which might solve your problem.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me