pgsql and php with ssl mode.

[babu-2]

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.

[Michael Fuhr]

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[alvherre]

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"

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster