Re: [SL] Ubuntu sql-ledger install

[Seneca C. <te...@gm...>]

On Sun, Dec 31, 2006 at 11:22:46AM +0100, Oliver Devoogdt wrote:
> 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 ?

The local line in pg_hba.conf only applies to connections through Unix
sockets, not TCP/IP.  My recommendation is to convert your local line 
to "md5" or "ident sameuser" and add a host line for 127.0.0.1/32 that 
sets md5 auth as a permissible manner with which you can connect to the
SL database and as the SL db user.  My dislike for trust is for security
and data preservation reasons... don't see why non-dba Joe User or his 
confused cron job should be able to access the entire cluster.

Also, if you have postgresql-server-7.4 installed, you could be querying
the wrong cluster, so check the port numbers involved.

Read the PostgreSQL documentation chapter about client authentication[1]
for more details about how it works and how to correctly configure it 
for your needs.

[1] <http://www.postgresql.org/docs/8.1/static/client-authentication.html>

-- 
Seneca
te...@gm...