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'
