Dear R users I have a problem installing RMySQL_0.5-5 in that ld skips incompatible libmysqlclient as shown below. Can someone help?
Thanks Einar Arnason I am on a Red Hat Enterprise Linux ES (v. 3 for AMD64/Intel EM64T) 2.4.21-15.EL #1 SMP Thu Apr 22 running mysql Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686) using EditLine wrapper distributed under xampp (www.apachefriends.org) including development package and R compiled from source > version _ platform x86_64-unknown-linux-gnu arch x86_64 os linux-gnu system x86_64, linux-gnu status major 2 minor 1.1 year 2005 month 06 day 20 language R R 2.1.1 (2005-06-20). I export paths: # export PKG_CPPFLAGS="-I/opt/lampp/include/mysql" containing: errmsg.h my_dir.h my_semaphore.h my_sys.h sslopt- longopts.h keycache.h my_getopt.h mysql_com.h my_xml.h sslopt- vars.h m_ctype.h my_global.h mysqld_error.h raid.h typelib.h m_string.h my_list.h mysql_embed.h readline.h my_alloc.h my_net.h mysql.h sql_common.h my_config.h my_no_pthread.h mysql_time.h sql_state.h my_dbug.h my_pthread.h mysql_version.h sslopt-case.h # export PKG_LIBS="-L/opt/lampp/lib/mysql -lmysqlclient" containing: libdbug.a libmysqlclient libmysqlclient.so libnisam.a libheap.a libmysqlclient.14 libmysqlclient.so.14 libvio.a libmerge.a libmysqlclient.14.0.0 libmysqlclient.so.14.0.0 libmyisam.a libmysqlclient.a libmystrings.a libmyisammrg.a libmysqlclient.la libmysys.a and get the following: # R CMD INSTALL RMySQL_0.5-5.tar.gz * Installing *source* package 'RMySQL' ... creating cache ./config.cache checking how to run the C preprocessor... cc -E checking for compress in -lz... yes checking for getopt_long in -lc... yes checking for mysql_init in -lmysqlclient... no checking for mysql.h... no updating cache ./config.cache creating ./config.status creating src/Makevars ** libs gcc -I/usr/local/lib/R/include -I/opt/lampp/include/mysql - I/usr/local/include -fPIC -g -O2 -c RS-DBI.c -o RS-DBI.o gcc -I/usr/local/lib/R/include -I/opt/lampp/include/mysql - I/usr/local/include -fPIC -g -O2 -c RS-MySQL.c -o RS-MySQL.o gcc -shared -L/usr/local/lib -o RMySQL.so RS-DBI.o RS-MySQL.o - L/opt/lampp/lib/mysql -lmysqlclient -lz /usr/bin/ld: skipping incompatible /opt/lampp/lib/mysql/libmysqlclient.so when searching for - lmysqlclient /usr/bin/ld: skipping incompatible /opt/lampp/lib/mysql/libmysqlclient.a when searching for -lmysqlclient /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: *** [RMySQL.so] Error 1 ERROR: compilation failed for package 'RMySQL' ** Removing '/usr/local/lib/R/library/RMySQL' ** Restoring previous '/usr/local/lib/R/library/RMySQL' ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html