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@(protected)
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html