[R] Problem installing RMySQL_0.5-5

[Einar Arnason]

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'