Re: SSL connection between PHP4 & PostgreSQL ???

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: mike(at)musicplace(dot)com
Cc: php-db(at)lists(dot)php(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: SSL connection between PHP4 & PostgreSQL ???
Date: 2004-10-05 21:07:35
Message-ID: 200410052107.i95L7aBg031912@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >From PHP4, how can I get the pg_connect function to negotiate an SSL connection?
>
> I gather from researching the issue that pg_connect uses the same libraries as psql, so that
> this should be possible. But I've tried every syntax I can think of... the "options" parameter to
> pg_connect is not well documented.
>
> I've played with all varieties of "requiressl" or "ssl", alone or as a boolean, e.g.,
> "requiressl=true", etc...

First, are you sure that SSL is linked into PHP? Use phpinfo() if you're
not sure.

Second, what are you using for a connect statement?

Here's a sanitized version of one that works for me:

DB::connect("pgsql://foobar:mypassword(at)tcp+99(dot)99(dot)99(dot)99/dbnm?requiressl=true");
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-10-05 21:13:11 Re: SSL connection between PHP4 & PostgreSQL ???
Previous Message Oliver Jowett 2004-10-05 20:57:15 Re: Postgres 8.0 + JDBC