SSL connection between PHP4 & PostgreSQL ???

**Mike Nolan** · Nov 23 '05, 02:25 AM

Re: SSL connection between PHP4 & PostgreSQL ???

> >From PHP4, how can I get the pg_connect function to negotiate an SSL connection?[color=blue]
>
> 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=tru e", etc...[/color]

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("pg sql://foobar:mypasswo rd@tcp+99.99.99 .99/dbnm?requiressl =true");
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

**Joshua D. Drake** · Nov 23 '05, 02:25 AM

Re: SSL connection between PHP4 & PostgreSQL ???

Mike Morris wrote:[color=blue]
> Hi,
>
> I've setup a postgres server (7.4) and confirmed that SSL is enabled - I can successfully
> connect via tcp socket over SSL using the psql client.
>[color=green]
>>From PHP4, how can I get the pg_connect function to negotiate an SSL connection?[/color][/color]

Hello,

Have not done this in a while but I believe you have to compile PHP with
openssl support.

Sincerely,

Joshua D. Drake

[color=blue]
>
> 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=tru e", etc...
>
> If not possible in PHP4, is it in PHP5?
>
> Any help greatly appreciated!
>
> MikeM
> Mike Morris
> The Music Place
> 1617 Willowhurst Avenue
> San Jose, CA 95125
> (408) 445-ARTS (2787)
> ------------------------------------
> Your Free Historical Quote:
> Above all, I know there is a Supreme Being who rules the affairs of men and
> whose goodness and mercy have always followed the American people, and I know
> He will not turn from us now if we humbly and reverently seek His powerful aid.
> - Grover Cleveland, Second Inaugural Address, March 4, 1893
> ------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html[/color]

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)

SSL connection between PHP4 & PostgreSQL ???

SSL connection between PHP4 & PostgreSQL ???

Comment

Comment