From: 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: Sat, 14 Sep 2002 14:30:13 -0400
Message-ID: <2075.1032028213@sss.pgh.pa.us> (raw)
In-Reply-To: <B9A9066B.7985%a.witney@sghms.ac.uk>
References: <B9A9066B.7985%a.witney@sghms.ac.uk>
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.
regards, tom lane
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: tgl@sss.pgh.pa.us, awitney@sghms.ac.uk
Subject: Re: Connecting R to PostgreSQL
In-Reply-To: <2075.1032028213@sss.pgh.pa.us>
* 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