Full_Name: Ankhee Dutta
Version: 2.3
OS: LINUX
Submission from: (NULL) (202.141.12.97)
I have a linux system of Mandriva-2007 with R version 2.3.0 and MySQL with
5.0.0. I have also got DBI-R database interface version-0.1-11 installed on
my Linux system.While installing RMySQL package version 0.5-11 i am facing
problem .
while installation the error report which is coming is as follows:
* 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
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 '/usr/lib/R/library/RMySQL'
ankheedutta at gmail.com wrote:> Full_Name: Ankhee Dutta > Version: 2.31. Please read the FAQs on how to report bugs: Always use a recent version of R, your version has been released roughly 36 months ago! R-2.9.0 is to be released in April. Hence please check bugs with the current pre-release version! 2. This is about package RMySQL, hence again, please read the FAQs on how to report bugs: Bug reports on contributed packages should go to the package maintainer, not to the R bug tracking system. 3. This is probably not even a bug in RMySQL. You obviously have not installed the MySQL header files (i.e. devel files). Uwe Ligges> OS: LINUX > Submission from: (NULL) (202.141.12.97) > > > > > I have a linux system of Mandriva-2007 with R version 2.3.0 and MySQL with > 5.0.0. I have also got DBI-R database interface version-0.1-11 installed on > my Linux system.While installing RMySQL package version 0.5-11 i am facing > problem . > > while installation the error report which is coming is as follows: > > > > * 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 > 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 '/usr/lib/R/library/RMySQL' > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel
I guess that you already solved the error in installing the R package RMySQL. Recently, I also suffered from the same problem in Ubuntu 10.10. I would like to report my solution. I just installed a linux package "libmysqlclient-dev" which contains MySQL database development files and headers. Then, I attempted to install the RMySQL package again, and there was no error. ankhee dutta wrote:> > Full_Name: Ankhee Dutta > Version: 2.3 > OS: LINUX > Submission from: (NULL) (202.141.12.97) > > > > > I have a linux system of Mandriva-2007 with R version 2.3.0 and MySQL with > 5.0.0. I have also got DBI-R database interface version-0.1-11 installed > on > my Linux system.While installing RMySQL package version 0.5-11 i am > facing > problem . > > while installation the error report which is coming is as follows: > > > > * 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 > 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 '/usr/lib/R/library/RMySQL' > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel > >----- Wonsang You Leibniz Institute for Neurobiology -- View this message in context: http://r.789695.n4.nabble.com/installing-RMySQL-PR-13633-tp923014p3057139.html Sent from the R devel mailing list archive at Nabble.com.
On 24 November 2010 at 04:06, Wonsang You wrote:
|
| I guess that you already solved the error in installing the R package RMySQL.
| Recently, I also suffered from the same problem in Ubuntu 10.10. I would
| like to report my solution.
|
| I just installed a linux package "libmysqlclient-dev" which contains
MySQL
| database development files and headers. Then, I attempted to install the
| RMySQL package again, and there was no error.
What was wrong with
sudo apt-get install r-cran-rmysql
that make you compile locally?
Dirk
--
Dirk Eddelbuettel | edd at debian.org | http://dirk.eddelbuettel.com