Re: [SL] Ubuntu sql-ledger install

[John W. F. <joh...@ve...>]

On Sunday 31 December 2006 04:22 am, Oliver Devoogdt wrote:
> Hi,
>
>
> What I did:
> -installed sql-ledger with apt-get
> -installed postgresql-8.1 with apt-get
> -createuser -d sql-ledger
> -createlang plpgsql template1
>
> -changed /etc/postgresql/8.1/main/pg_hba.conf to reflect "local all all
> trust"
> -restarted postgresql-8.1
>
> I am still receiving "FATAL: IDENT authentication failed for user
> "sql-ledger"
>
> Can someone point me in the good direction ?
That resets your 'UNIX SOCKETS' locally so that PG recognizes them. You also 
need to set PG up to recognize you 'host' settings since it is a 'web app'
look for the line below in  /etc/postgresql/8.1/main/pg_hba.conf   edit to 
your needs and place and uncommented copy in 
your /etc/postgresql/8.1/main/pg_hba.conf 

#IPV4 style local connections
#host	all	all	127.0.0.1		255.255.255.255	trust

You may also need to restart your your webserver as well as PG after making 
this change.
Happy New Year!!

-- 
John W. Foster