trouble with connection

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: trouble with connection
Date: 2009-07-29 09:36:47
Message-ID: 608b66ce0907290236m4ef47856n1e0ec8d6e36f6f13@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Wenk 2009-07-29 10:29:13 Re: trouble with connection
Previous Message Lacey Powers 2009-07-28 22:28:01 Re: Synchronizing the schema of two PostgreSQL databases