From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | basti <basti(at)unix-solution(dot)de> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: php password authentication failed for user ... |
Date: | 2014-07-10 11:53:46 |
Message-ID: | CA+bJJbzGa1D-dYxHZkA=Ht1RfMxzNg1iZkHpz_TB4r2EVxMcpQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
On Wed, Jul 9, 2014 at 2:37 PM, basti <basti(at)unix-solution(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Tanzer | 2014-07-10 12:03:10 | Re: php password authentication failed for user ... |
Previous Message | basti | 2014-07-10 09:24:03 | Standby Server and Barman Backup on production system |