[R] installing RMySQL

[Torsten Hothorn]

> Hi, I have struggled to re-implement the RMySQL package after upgrading
> from SuSe 6.3 to 7.2 and from R 1.2.1 to R 1.3.1,
> to no avail
> It compiles happily but when loading the package I get the following 
> error
> 
> > library(RMySQL)
> Error in dyn.load(x, as.logical(local), as.logical(now)) : 
>         unable to load shared library
> "/home/jniesch/R_HOME/lib/R/library/RMySQL/libs/RMySQL.so":
>   libmysqlclient.so.10: cannot load shared object file: No such file or
> directory
> Error in library(RMySQL) : .First.lib failed

configure seems to find it in the correct place and the linker does as
well. Try

ldconfig -v | grep mysql

maybe this helps,

Torsten

> 
> //////////////////////////////////////////////////////////
> I don't understand why, the shared library hasn't moved
> and the path has been added to /etc/ld.so.conf
> it even seems to me that the library is found  during
> the installation procedure
> 
> I have tried for two days now and would be very delighted
> if somebody could give me a hint.
> 
> thanks in advance
> 		Jens
> //////////////////////////////////////////////////////////
> root at ufobig:/home/downloads > find / -name *mysqlclient.so*
> /usr/local/lib/mysql/libmysqlclient.so.10.0.0
> /usr/local/lib/mysql/libmysqlclient.so.10
> /usr/local/lib/mysql/libmysqlclient.so
> /usr/local/MySQL/libmysql/.libs/libmysqlclient.so.10.0.0
> /usr/local/MySQL/libmysql/.libs/libmysqlclient.so.10
> /usr/local/MySQL/libmysql/.libs/libmysqlclient.so
> /home/libmysqlclient.so
> /home/libmysqlclient.so.10
> /home/libmysqlclient.so.3.21.33b
> /home/libmysqlclient.so.4
> 
> 
> /////////////////////////////////////////////////////////////
> jniesch at ufobig:~/R_HOME > R CMD INSTALL
> /home/downloads/RMySQL_0.4-2.tar.gz 
> Installing source package `RMySQL' ...
> creating cache ./config.cache
> checking how to run the C preprocessor... cc -E
> checking for mysql_init in -lmysqlclient... no
> checking for mysql_init in -lmysqlclient... yes
> checking for /usr/include/mysql.h... no
> checking for /usr/include/mysql/mysql.h... no
> checking for /usr/local/include/mysql.h... no
> checking for /usr/local/include/mysql/mysql.h... yes
> updating cache ./config.cache
> creating ./config.status
> creating src/Makevars
>  libs
> gcc -I/home/jniesch/R_HOME/lib/R/include -I/usr/local/include/mysql
> -I/usr/local/include -mieee-fp -D__NO_MATH_INLINES  -fPIC  -g -O2 -c
> RS-DBI.c -o RS-DBI.o
> gcc -I/home/jniesch/R_HOME/lib/R/include -I/usr/local/include/mysql
> -I/usr/local/include -mieee-fp -D__NO_MATH_INLINES  -fPIC  -g -O2 -c
> RS-MySQL.c -o RS-MySQL.o
> gcc -shared  -o RMySQL.so RS-DBI.o RS-MySQL.o -L/usr/local/lib/mysql
> -lmysqlclient -lz -L/usr/local/lib  
>  R
>  inst
>  help
>  >>> Building/Updating help pages for package `RMySQL'
>      Formats: text html latex example 
>   MySQL                             text    html    latex   example
> [snip]
>  DONE (RMySQL)
> 
> DONE (INSTALL)
> /////////////////////////////////////////////////////////////
> > version 
>          _                
> platform i686-pc-linux-gnu
> arch     i686             
> os       linux-gnu        
> system   i686, linux-gnu  
> status                    
> major    1                
> minor    3.1              
> year     2001             
> month    08               
> day      31               
> language R                
> 
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._