Date: Fri, 20 Sep 2002 14:18:10 +0100
From: Adam Witney <awitney@sghms.ac.uk>
Subject: Re: Connecting R to PostgreSQL
In-reply-to: <2075.1032028213@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>, Adam Witney <awitney@sghms.ac.uk>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Message-id: <B9B0DEA2.7F2F%a.witney@sghms.ac.uk>
MIME-version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
User-Agent: Microsoft-Entourage/10.1.0.2006

On 14/9/02 7:30 pm, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:

> Adam Witney <awitney@sghms.ac.uk> writes:
>> The driver installs ok, however when I try to load it in R I get the
>> following error
> 
>>> library(Rdbi.PgSQL)
>> Error in dyn.load(x, as.logical(local), as.logical(now)) :
>>         unable to load shared library "/Users/adam/Projects/R
>> stuff/rlibs/Rdbi.PgSQL/libs/Rdbi.PgSQL.so":
>>   dlcompat: dyld: /sw/lib/R/bin/R.bin Undefined symbols:
>> _ERR_get_error
>> _ERR_reason_error_string
>> _SSL_CTX_new
>> _SSL_connect
>> _SSL_free
>> _SSL_library_init
> 
> It looks like the dynamic loader is failing to find the SSL library
> (libssl.so), which is required by your PG client library.  I don't know
> enough about OSX to know how library searching is handled, but on other
> Unixen you'd need to mess with ldconfig or LD_LIBRARY_PATH ... or
> perhaps easier, put libssl.so into a more standard location than
> wherever it is now.
> 
> Alternatively, you could rebuild PG omitting SSL support.

Hmm, I downloaded the non ssl version of postgresql from fink. Again fink
does all the compiling so I am not sure how it did it. Is there a way of
testing for sure if the ssl was or not compiled in?

Thanks

adam