RMySQL installation problem on FC4 x86_64

Wed, Sep 7, 2005 6:14 PM #

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:

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

Seth Falcon

Wed, Sep 7, 2005 9:39 PM #

On 7 Sep 2005, br44114 at gmail.com wrote:

I would have thought that you need to have a mysql-dev.x86_64 rpm
package installed in order to get the headers to be able to compile,
etc.  Not a redhat or yum user myself, so don't know.  But the error
message about unable to find header files is often solved by installed
the appropriate devel package that contains those headers.

+ seth