From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | basti <mailinglist(at)unix-solution(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: php password authentication failed for user ... |
Date: | 2014-07-09 13:06:08 |
Message-ID: | 53BD3E40.3050903@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/09/2014 04:04 AM, basti wrote:
> Hello my pg_hab.conf has this entry:
>
> host all all 127.0.0.1/32 md5
Is that the only entry?
If not remember first matching entry wins, so is there another line
above this?
>
> When I try to use PHP to connect to the Database I get
>
> "postgres password authentication failed for user ..."
Is the password correct?
>
> 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?
From:
http://www.postgresql.org/docs/9.3/interactive/auth-pg-hba-conf.html
host
This record matches connection attempts made using TCP/IP. host
records match either SSL or non-SSL connection attempts.
>
> Regards,
> basti
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | basti | 2014-07-09 13:10:55 | Re: php password authentication failed for user ... |
Previous Message | Adrian Klaver | 2014-07-09 12:59:28 | Re: Insert query hangs |