Re: [Rd] installing RMySQL (PR#13633)

From: Wonsang You <you_at_ifn-magdeburg.de>
Date: Wed, 24 Nov 2010 04:06:53 -0800 (PST)

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.

______________________________________________
R-devel_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel
Received on Wed 24 Nov 2010 - 13:50:38 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 24 Nov 2010 - 16:20:26 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.

list of date sections of archive