Re: Connecting R to PostgreSQL

On 14/9/02 7:30 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Adam Witney <awitney(at)sghms(dot)ac(dot)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