[R] RMySQL installation problem on FC4 x86_64

bogdan romocea br44114 at gmail.com
Thu Sep 8 03:14:54 CEST 2005


Dear useRs,

I'm having a hard time installing RMySQL on a FC4 x86_64 box (R 2.1.0
and MySQL 4.1.11-2 installed through yum). After an initial
configuration error ("could not find the MySQL installation include
and/or library directories") I managed to install RMySQL with
   # export PKG_LIBS="-L</usr/lib64/mysql> -lmysqlclient"
   # R CMD INSTALL RMySQL_0.5-5.tar.gz

However, when I load the package I get this error:
> require(RMySQL)
Loading required package: RMySQL
Loading required package: DBI
Error in dyn.load(x, as.logical(local), as.logical(now)) :
        unable to load shared library
'/usr/lib64/R/library/RMySQL/libs/RMySQL.so':
  /usr/lib64/R/library/RMySQL/libs/RMySQL.so: undefined symbol:
mysql_field_count
[1] FALSE

Can anyone offer a suggestion, or perhaps email me a precompiled binary?
Thank you,
b.

platform "x86_64-redhat-linux-gnu"
arch     "x86_64"
os       "linux-gnu"
system   "x86_64, linux-gnu"
status   ""
major    "2"
minor    "1.0"
year     "2005"
month    "04"
day      "18"
language "R"

# yum list installed mysql
Installed Packages
mysql.i386            4.1.11-2               installed
mysql.x86_64       4.1.11-2               installed




More information about the R-help mailing list