pgsql and php with ssl mode.

Started by babuover 20 years ago3 messagesgeneral
Jump to latest
#1babu
garavindbabu@yahoo.co.uk

HI all,

I am trying to use ssl mode when connecting to pgsql via php.
i have used the method pg_conncet with sslmode and require option.
But it gets an error "Unable to connect to PostgreSQL server: sslmode value "require" invalid when SSL support is not compiled in ".

thanks
babu

---------------------------------
To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre.

#2Michael Fuhr
mike@fuhr.org
In reply to: babu (#1)
Re: pgsql and php with ssl mode.

On Wed, Aug 10, 2005 at 02:09:55PM +0100, babu wrote:

I am trying to use ssl mode when connecting to pgsql via php.
i have used the method pg_conncet with sslmode and require option.
But it gets an error "Unable to connect to PostgreSQL server: sslmode value "require" invalid when SSL support is not compiled in ".

Looks like the underlying libpq wasn't compiled with SSL support.
If you built PostgreSQL yourself then do a fresh build and configure
it with the --with-openssl option. If you installed from a package
then complain to whoever made the package.

--
Michael Fuhr

#3Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: babu (#1)
Re: pgsql and php with ssl mode.

On Wed, Aug 10, 2005 at 02:09:55PM +0100, babu wrote:

I am trying to use ssl mode when connecting to pgsql via php.
i have used the method pg_conncet with sslmode and require option.
But it gets an error "Unable to connect to PostgreSQL server: sslmode
value "require" invalid when SSL support is not compiled in ".

You have to recompile PostgreSQL with SSL support (or get packages with
SSL support compiled in.)

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"No reniegues de lo que alguna vez cre�ste"