| 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: | Whole Thread | Raw Message | 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
| 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 |