[R] RMySQL

[Arend P. van der Veen]

HI,

I have been having trouble installing RMySQL under Redhat Linux 9.0.  I
am using R 1.8.0 and MySQL 4.0.13.  MySQL is install in /opt/mysql.  I
try to install RMySQL using configure-args to specify the path of mysql
but it does not work.  Does any body have any suggestions.

Thanks,
Arend van der Veen


The command that I am using is:

# R CMD INSTALL --configure-args='--with-mysql-dir=/opt/mysql' \
> RMySQL_0.5-2.tar.gz

I get the following response:

* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... cc -E
checking for mysql_init in -lmysqlclient... no
checking for mysql.h... no
checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmysqlclient... no
checking for mysql_init in -lmysqlclient... no
checking for /usr/local/include/mysql/mysql.h... no
checking for /usr/include/mysql/mysql.h... no
checking for /usr/local/mysql/include/mysql/mysql.h... no
checking for /opt/include/mysql/mysql.h... no
checking for /include/mysql/mysql.h... no
 
Configuration error:
  could not find the MySQL installation include and/or library
  directories.  Manually specify the location of the MySQL
  libraries and the header files and re-run R CMD INSTALL.
 
INSTRUCTIONS:
 
1. Define and export the 2 shell variables PKG_CPPFLAGS and
   PKG_LIBS to include the directory for header files (*.h)
   and libraries, for example (using Bourne shell syntax):
 
      export PKG_CPPFLAGS="-I<MySQL-include-dir>"
      export PKG_LIBS="-L<MySQL-lib-dir> -lmysqlclient"
 
   Re-run the R INSTALL command:
 
      R CMD INSTALL RMySQL_<version>.tar.gz
 
2. Alternatively, you may pass the configure arguments
      --with-mysql-dir=<base-dir> (distribution directory)
   or
      --with-mysql-inc=<base-inc> (where MySQL header files reside)
      --with-mysql-lib=<base-lib> (where MySQL libraries reside)
   in the call to R INSTALL --configure-args='...'
 
   R CMD INSTALL --configure-args='--with-mysql-dir=DIR'
RMySQL_<version>.tar.gz
 
ERROR: configuration failed for package 'RMySQL'
** Removing '/opt/r-1.8.0/lib/R/library/RMySQL'