From: Adam Witney <awitney@sghms.ac.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Witney <awitney@sghms.ac.uk>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: Connecting R to PostgreSQL
Date: Fri, 20 Sep 2002 14:18:10 +0100
Message-ID: <B9B0DEA2.7F2F%a.witney@sghms.ac.uk> (raw)
In-Reply-To: <2075.1032028213@sss.pgh.pa.us>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: awitney@sghms.ac.uk, tgl@sss.pgh.pa.us
Subject: Re: Connecting R to PostgreSQL
In-Reply-To: <B9B0DEA2.7F2F%a.witney@sghms.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox