trouble with connection

Поиск
Список
Период
Сортировка
От Didier Gasser-Morlay
Тема trouble with connection
Дата
Msg-id 608b66ce0907290236m4ef47856n1e0ec8d6e36f6f13@mail.gmail.com
обсуждение исходный текст
Ответы Re: trouble with connection  (Andreas Wenk <a.wenk@netzmeister-st-pauli.de>)
Список 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 по дате отправления:

Предыдущее
От: Lacey Powers
Дата:
Сообщение: Re: Synchronizing the schema of two PostgreSQL databases
Следующее
От: Andreas Wenk
Дата:
Сообщение: Re: trouble with connection