[R-sig-DB] RPostgreSQL installation Error - RPostgreSQL.so: undefined symbol: PQpass
NISHIYAMA Tomoaki
tomo@k|n @end|ng |rom @t@||@k@n@z@w@-u@@c@jp
Fri May 23 15:18:21 CEST 2014
Hi,
Because Manoj G wrote:
>>> ERROR: loading failed
>>>
>>> * removing ‘/usr/lib64/R/library/RPostgreSQL’
there may be no /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so
left there.
$ svn checkout http://rpostgresql.googlecode.com/svn/trunk/ rpostgresql-read-only
$ cd rpostgresql-read-only
$ R CMD INSTALL RPostgreSQL
$ R CMD ldd RPostgreSQL/src/RPostgreSQL.so
or
$ tar zxvf RPostgreSQL_0.4.tar.gz
$ R CMD INSTALL RPostgreSQL
$ R CMD ldd RPostgreSQL/src/RPostgreSQL.so
would be necessary to investigate which library is used.
In addition, I would see
whether psql works fine,
response of
$ pg_config
and
$ ldd `which psql`
best regards.
Tomoaki
On 2014/05/23, at 20:32, Prof Brian Ripley wrote:
> On 23/05/2014 10:41, NISHIYAMA Tomoaki wrote:
>> Hi,
>>
>>> All the library files are in the directory
>>> /usr/lib64/pgsql/
>>
>>
>> Is this directory specified in LD_LIBRARY_PATH or /etc/ld.so.conf?
>
> That is not the message I would expect if the library was not being
> found. Try
>
> R CMD ldd /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so
>
> to see which library is being found.
>
>>
>>
>>
>> On 2014/05/23, at 18:16, Manoj G wrote:
>>
>>> Hi,
>>>
>>> I am trying to install R-Package RPostgreSQL, but getting the following
>>> error,
>>>
>>> Error in dyn.load(file, DLLpath = DLLpath, ...) :
>>>
>>> unable to load shared object
>>> '/usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so':
>>>
>>> /usr/lib64/R/library/RPostgreSQL/libs/RPostgreSQL.so: undefined symbol:
>>> PQpass
>>>
>>> Error: loading failed
>>>
>>> Execution halted
>>>
>>> ERROR: loading failed
>>>
>>> * removing ‘/usr/lib64/R/library/RPostgreSQL’
>>>
>>> I have libpq and postgresql-dev installed. All the library files are in the
>>> directory
>>>
>>> /usr/lib64/pgsql/ and all header files are in the directory
>>>
>>> /usr/include/pgsql/
>>>
>>> Postgre Version - 9.3.4 R Version - 3.0.2 Operating System - CentOS-6.4
>>>
>>> I am missing some small thing, but unable to find out why this is happening.
>>>
>>> What am I doing wrong? How to correct this?
>>>
>>>
>>>
>>> Thanks and Regards,
>>>
>>> Manoj G
>>>
>>> [[alternative HTML version deleted]]
>>>
>>> _______________________________________________
>>> R-sig-DB mailing list -- R Special Interest Group
>>> R-sig-DB using r-project.org
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using r-project.org
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
>
> --
> Brian D. Ripley, ripley using stats.ox.ac.uk
> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, Tel: +44 1865 272861 (self)
> 1 South Parks Road, +44 1865 272866 (PA)
> Oxford OX1 3TG, UK Fax: +44 1865 272595
More information about the R-sig-DB
mailing list