trouble with connection

Поиск
Список
Период
Сортировка
Искать
От
Didier Gasser-Morlay
Тема
trouble with connection
Дата
Msg-id
608b66ce0907290236m4ef47856n1e0ec8d6e36f6f13@mail.gmail.com
Список
Дерево обсуждения
trouble with connection Didier Gasser-Morlay <didiergm@gmail.com>
Re: trouble with connection Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
Re: trouble with connection Didier Gasser-Morlay <didiergm@gmail.com>
Re: trouble with connection "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: trouble with connection Andreas Wenk <a.wenk@netzmeister-st-pauli.de>
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
Дата:
От: Andreas Wenk
Дата:
Сообщение: Re: trouble with connection
FAQ