Re: php password authentication failed for user ... - Mailing list pgsql-general

From Francisco Olarte
Subject Re: php password authentication failed for user ...
Date
Msg-id CA+bJJbzGa1D-dYxHZkA=Ht1RfMxzNg1iZkHpz_TB4r2EVxMcpQ@mail.gmail.com
Whole thread Raw
In response to Re: php password authentication failed for user ...  (basti <basti@unix-solution.de>)
List 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 by date:

Previous
From: basti
Date:
Subject: Standby Server and Barman Backup on production system
Next
From: Ken Tanzer
Date:
Subject: Re: php password authentication failed for user ...