[R] installing RMySQL

[Jens Nieschulze]

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

//////////////////////////////////////////////////////////
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._