How about you include a thread like "Problem with R 2.3.0 and MySQL on Mandriva-2007".
Bests, milton On Mon, Mar 30, 2009 at 7:07 AM, ankhee dutta <ankheedu...@gmail.com> wrote: > Hi, All > 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 but facing > the problem mentioned below . > > > > * 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' > > > > > > Any help will be great. > Thankyou in advance. > > -- > Ankhee Dutta > project trainee, > JNU,New Delhi-67 > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
