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