[R] installing RMySQL

Jens Nieschulze jniesch at gwdg.de
Wed Sep 26 11:45:18 CEST 2001

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 

> library(RMySQL)
Error in dyn.load(x, as.logical(local), as.logical(now)) : 
        unable to load shared library
  libmysqlclient.so.10: cannot load shared object file: No such file or
Error in library(RMySQL) : .First.lib failed

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
root at ufobig:/home/downloads > find / -name *mysqlclient.so*

jniesch at ufobig:~/R_HOME > R CMD INSTALL
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
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  
 >>> Building/Updating help pages for package `RMySQL'
     Formats: text html latex example 
  MySQL                             text    html    latex   example

> version 
platform i686-pc-linux-gnu
arch     i686             
os       linux-gnu        
system   i686, linux-gnu  
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

More information about the R-help mailing list