Thread: help with programming

help with programming

From
Chris Hayner
Date:
hello all,
as (I think) shown on the libpq - C library page of the documentation, I
attempetd to connedt over ssl to a correctly compiled 7.1 database. Here
is the connection portion of my code:


PGconn          *conn;

...
       /* make a connection to the database */       conn = PQconnectdb( "host=shelob.temple.edu dbname=ldap_backend
user=usrrequiressl=1");
 

...


when run, the program dies with the following :

ERROR: Unknown conninfo option 'requiressl'

any help in this matter would be greatly appreciated.

thanks in advance,
--chris hayner




Re: help with programming

From
Chris Hayner
Date:
pgsql was compiled with ssl, and the backend is run with the -l option. i
successfully configured the keys with openssl, as it would not run without
me doing so. i took this as a successful SSL integration.. it was also
configured with odbc and with gnu ld. which config files
are you looking for, and are there mods that need to be done that i am not
aware of?

thanx in advance,
--chris hayner

On Wed, 16 May 2001,  wrote:

>
> Hello,
>
> Did you compile pgsql with ssl support and/or adjust the configuration?
> Just a thought. Usually if you get a message like this, it does not know the library is there or it is not installed.
Check
> your debug log from configure and see if it had a problem finding this library. It would be helpful to know the
configure
> flags, how pgsql was installed, and get a copy of your config files(with sensitive info, IP's etc, removed: ).
> thx,
> Neil
>
> ----Original Message Follows----
> From: Chris Hayner
> To:
> Subject: [INTERFACES] help with programming
> Date: Tue, 15 May 2001 16:32:10 -0400 (EDT)
> MIME-Version: 1.0
> Received: from [216.126.85.28] by hotmail.com (3.2) with ESMTP id MHotMailBCCC3678006940043754D87E551C066A0; Wed May
16
> 14:04:58 2001
> Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])by postgresql.org (8.11.3/8.11.1) with SMTP
id
> f4GL4wA13968;Wed, 16 May 2001 17:04:58 -0400 (EDT)(envelope-from pgsql-interfaces-owner+M1606@postgresql.org)
> Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])by postgresql.org (8.11.3/8.11.1) with SMTP
id
> f4GJtlA52091for ; Wed, 16 May 2001 15:55:47 -0400 (EDT)(envelope-from pgsql-interfaces-owner@postgresql.org)
> Received: from typhoon.ocis.temple.edu (typhoon.ocis.temple.edu [155.247.166.103])by postgresql.org (8.11.3/8.11.1)
with
> ESMTP id f4FKWFA88623for ; Tue, 15 May 2001 16:32:15 -0400 (EDT)(envelope-from hayner80@astro.ocis.temple.edu)
> Received: from localhost (hayner80@localhost)by typhoon.ocis.temple.edu (8.11.0/8.11.0) with ESMTP id f4FKWAe00410for
;Tue,
 
> 15 May 2001 16:32:10 -0400 (EDT)
> From pgsql-interfaces-owner Wed May 16 14:06:25 2001
> X-X-Sender:
> Message-ID:
> Precedence: bulk
> Sender: pgsql-interfaces-owner@postgresql.org
> hello all,
> as (I think) shown on the libpq - C library page of the documentation, I
> attempetd to connedt over ssl to a correctly compiled 7.1 database. Here
> is the connection portion of my code:
> PGconn *conn;
> ...
> /* make a connection to the database */
> conn = PQconnectdb( "host=shelob.temple.edu dbname=ldap_backend user=usr requiressl=1");
> ...
> when run, the program dies with the following :
> ERROR: Unknown conninfo option 'requiressl'
> any help in this matter would be greatly appreciated.
> thanks in advance,
> --chris hayner
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> http://www.postgresql.org/search.mpl
>
>
____________________________________________________________________________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
>



Re: help with programming

From
Peter Eisentraut
Date:
Chris Hayner writes:

> ERROR: Unknown conninfo option 'requiressl'

Be sure that your program is picking up the right libpq.  Try 'ldd
yourprog' to see which one it uses.  Maybe you have some other version
without SSL support lying around.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter