| 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: | Whole Thread | Raw Message | 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
| 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 |