trouble with connection - Mailing list pgsql-novice

From Didier Gasser-Morlay
Subject trouble with connection
Date
Msg-id 608b66ce0907290236m4ef47856n1e0ec8d6e36f6f13@mail.gmail.com
Whole thread Raw
Responses Re: trouble with connection
List pgsql-novice
Hello,

I am confused with the users configuration:

I have created a user called webstar; granted it all on one database
(called webstar).
I want the user webstar to provide a password

so I have the following pg_hba.conf


# "local" is for Unix domain socket connections only
local   all         webstar                            md5
local   all         all                                ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32           ident sameuser
# IPv6 local connections:
host    all         all         ::1/128                ident sameuser

this work fine from the command line where i can use pgsql with

pgsql -U webstar -W

I am prompted for a password and I can connect.

Now when I try to connect from php I get

pg_connect(): Unable to connect to PostgreSQL server: FATAL: Ident
authentication failed for user "webstar"

it clearly says that the user webstar is trying for an ident
connection, not a password one. and I do not understand why.

can you enlighten me ?

thanks in advance

Didier

pgsql-novice by date:

Previous
From: Lacey Powers
Date:
Subject: Re: Synchronizing the schema of two PostgreSQL databases
Next
From: Andreas Wenk
Date:
Subject: Re: trouble with connection