php password authentication failed for user ...

From: basti <mailinglist(at)unix-solution(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: php password authentication failed for user ...
Date: 2014-07-09 11:04:19
Message-ID: 53BD21B3.7040307@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Regards,
basti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2014-07-09 11:12:29 Re: Insert query hangs
Previous Message Ramesh T 2014-07-09 10:45:01 BAKUP ISSUE