Re: php password authentication failed for user ...

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: php password authentication failed for user ...
Дата
Msg-id CA+bJJbzGa1D-dYxHZkA=Ht1RfMxzNg1iZkHpz_TB4r2EVxMcpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: php password authentication failed for user ...  (basti <basti@unix-solution.de>)
Список pgsql-general
Hi:

On Wed, Jul 9, 2014 at 2:37 PM, basti <basti@unix-solution.de> wrote:
> I don't know whats wrong there
> host    mydns      mydns        localhost                       trust
> works well and
> #host    all         all         0.0.0.0           0.0.0.0           md5
> did not work.

> I use Postgres 9.3.4-1.pgdg70+1.

Well, first line should be no password, user mydns, db mydns, host
localhost ( which USUALLY is 127.0.0.1 ), no credential checks, so if
you are not changing anything between ( or not showing the complete
file ) it means you have user, db, method ( tcp ) and origin host
right.

Second one is any user, any db, any IP, but checking password.

Giving that the only think the second line checks which the first one
does not, I'll vote for bad password in the script. I suppose php uses
libpq, like psql, so it should work. Anyway, check your paths and
constants,  isolate changes, test. This kind of problems are imposible
to diagnose without much more info than what you are giving, and
normally due to mystyped constants.

Francisco Olarte.


В списке pgsql-general по дате отправления:

Предыдущее
От: basti
Дата:
Сообщение: Standby Server and Barman Backup on production system
Следующее
От: Ken Tanzer
Дата:
Сообщение: Re: php password authentication failed for user ...