[R] Problem installing RMySQL_0.5-5

From: Einar Arnason <einararn_at_hi.is>
Date: Wed 06 Jul 2005 - 01:54:07 EST


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 ssloptlongopts. 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 Received on Wed Jul 06 02:11:09 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:16 EST