Re: php password authentication failed for user ...

From: basti <basti(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: php password authentication failed for user ...
Date: 2014-07-09 12:37:23
Message-ID: 53BD3783.8040206@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Am 09.07.2014 14:04, schrieb basti:
> Here is the output of the echo.
>
> host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns
>
> I have also try host=localhost and sslmode=require
>
>
> Am 09.07.2014 13:47, schrieb Francisco Olarte:
>> Hi:
>>
>> On Wed, Jul 9, 2014 at 1:04 PM, basti <mailinglist(at)unix-solution(dot)de> wrote:
>>> Hello my pg_hab.conf has this entry:
>>> host all all 127.0.0.1/32 md5
>> ....
>>> global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn;
>> ...
>>> $connect = "host=$dbhost user=$dbuser password=$dbpass
>>> dbname=$dbname";
>> ...
>>> When I try to connect via
>>> psql -U user -h localhost -W database
>>
>> Which is the value of $dbhost ? is it localhost, to be coherent with
>> your psql line? ( or the output of the echo you put in the sample
>> script? )
>>
>> If $dbhost is not localhost a name which resolves to 127.0.0.1 or a
>> literal 127.0.0.1 you are not getting in ( if the machine is 3.4.5.6
>> and you connect to machine.name.com which resolves to 3.4.5.6 your
>> usually get this kind of problems.
>>
>> Francisco Olarte.
>>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2014-07-09 12:53:43 Re: BAKUP ISSUE
Previous Message M Tarkeshwar Rao 2014-07-09 12:25:01 Re: Insert query hangs