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.
>>
>
>
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 |