Re: php password authentication failed for user ...

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.

In response to

Browse pgsql-general by date

  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