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.gzI 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'
Do you actually have the MySQL client libraries installed? They are in a separate RPM, if you used RPMs, something like MySQL-client-4.0.16-0.i386.rpm. On 12 Nov 2003, Arend P. van der Veen wrote:> 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.-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595