Re: php password authentication failed for user ...

Yes, there is the same problem.
postgres logs also:

"Connection matched pg_hba.conf line 93
„host all all 127.0.0.1/32 md5“"

Am 09.07.2014 13:14, schrieb Bill Moran:
> On Wed, 09 Jul 2014 13:04:19 +0200 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
>>
>> When I try to use PHP to connect to the Database I get
>>
>> "postgres password authentication failed for user ..."
>>
>> The PHP-code looks like
>>
>>
>> global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn;
>>
>> if ($use_pgsql)
>> {
>> $connect = "host=$dbhost user=$dbuser password=$dbpass
>> dbname=$dbname";
>> echo $connect;
>> if (!($dbconn = pg_connect($connect)))
>> {
>> open_page();
>> ErrSQL("Unable to connect to database.");
>> }
>>
>> When I try to connect via
>> psql -U user -h localhost -W database
>> I can connect without error.
>>
>> I also use SSL connections, is this the problem? or in other words is
>> there a way to connect php via (postgres) ssl?
>
> Have you tried using sslmode or requiressl in the $connect string?
>