[R-sig-DB] RPostgreSQL installation Error - RPostgreSQL.so: undefined symbol: PQpass

[Prof Brian Ripley]

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