thr3ads.net - R devel - [Rd] installing RMySQL (PR#13633) [Mar 2009]

If this information is useful, please help other people find it:
Share via:

ankheedutta at gmail.com

2009-Mar-31 04:30 UTC

[Rd] installing RMySQL (PR#13633)

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'

Uwe Ligges

2009-Mar-31 17:06 UTC

head link

[Rd] installing RMySQL (PR#13633)

ankheedutta at gmail.com wrote:> Full_Name: Ankhee Dutta
> Version: 2.3

1. 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

Wonsang You

2010-Nov-24 12:06 UTC

head link

[Rd] installing RMySQL (PR#13633)

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.

Dirk Eddelbuettel

2010-Nov-24 14:26 UTC

head link

[Rd] installing RMySQL (PR#13633)

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

Reasonably Related Threads

Search for more possibly parallel threads

R devel - Mar 2009 - installing RMySQL (PR#13633)

[Rd] installing RMySQL (PR#13633)

[Rd] installing RMySQL (PR#13633)

[Rd] installing RMySQL (PR#13633)

[Rd] installing RMySQL (PR#13633)

Reasonably Related Threads