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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Wed, 26 Sep 2001, Jens Nieschulze wrote:> 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 procedureYes, but is it available to dlopen? That does not use ld.so.conf AFAIK. Have you tried putting the location of libmysqlclient.so in LD_LIBRARY_PATH at R start time? I need to (but then I did with 1.2.1). [...] -- Brian D. Ripley, ripley at 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 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 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 failedconfigure 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._