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

From basti
Subject Re: php password authentication failed for user ...
Date
Msg-id 53BD2FC9.50501@unix-solution.de
Whole thread Raw
In response to Re: php password authentication failed for user ...  (Francisco Olarte <folarte@peoplecall.com>)
Responses Re: php password authentication failed for user ...  (basti <basti@unix-solution.de>)
List pgsql-general
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@unix-solution.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.
>


pgsql-general by date:

Previous
From: basti
Date:
Subject: Re: php password authentication failed for user ...
Next
From: M Tarkeshwar Rao
Date:
Subject: Re: Insert query hangs