[R-SIG-Mac] installing RMySQL

[Scott Robert Schreckengaust]

Try adding the other two configure.args "--with-mysql-inc" and "--with-mysql-lib":

$ R CMD INSTALL --configure-args='--with-mysql-dir=/usr/local/mysql-5.6.17-osx10.7-x86_64 --with-mysql-inc=/usr/local/mysql-5.6.17-osx10.7-x86_64/include --with-mysql-lib=/usr/local/mysql-5.6.17-osx10.7-x86_64/lib' RMySQL_0.9-3.tar.gz.tar.gz

or

install.packages("RMySQL", configure.args="--with-mysql-dir=/usr/local//mysql-5.6.17-osx10.7x86_64 --with-mysql-inc=/usr/local/mysql-5.6.17-osx10.7-x86_64/include --with-mysql-lib=/usr/local/mysql-5.6.17-osx10.7-x86_64/lib")

Cheers,
Scott

On May 28, 2014, at 8:11 AM, Adrian Dușa <dusa.adrian at unibuc.ro> wrote:

> Hello everyone,
> 
> I am having some difficulties installing the RMySQL package from sources
> (not available via the R Package Installer GUI, probably for the same
> reasons). Just installed a fresh instance of MySQL, which I could find in:
> /usr/local/mysql-5.6.17-osx10.7-x86_64
> 
> 
> This is what I get:
> 
> $ R CMD INSTALL RMySQL_0.9-3.tar.gz.tar.gz
> ...
> 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.
> 
> 
> I tried:
> 
> $ export PKG_CPPFLAGS="/usr/local/mysql-5.6.17-osx10.7-x86_64/include/"
> $ export PKG_LIBS="/usr/local/mysql-5.6.17-osx10.7-x86_64/lib/"
> $ R CMD INSTALL RMySQL_0.9-3.tar.gz.tar.gz
> ...
> In file included from RS-MySQL.c:22:
> ./RS-MySQL.h:32:10: fatal error: 'mysql.h' file not found
> #include <mysql.h>
>         ^
> 1 error generated.
> 
> 
> Also tried:
> 
> $ R CMD INSTALL
> --configure-args='--with-mysql-dir=/usr/local/mysql-5.6.17-osx10.7-x86_64'
> RMySQL_0.9-3.tar.gz.tar.gz
> 
> (with the same result)
> 
> I'd be grateful for any hint, thanks in advance,
> Adrian
> 
> 
> -- 
> Adrian Dusa
> University of Bucharest
> Romanian Social Data Archive
> 1, Schitu Magureanu Bd.
> 050025 Bucharest sector 5
> Romania
> Tel.:+40 21 3126618 \
>        +40 21 3120210 / int.101
> Fax: +40 21 3158391
> 
> 	[[alternative HTML version deleted]]
> 
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>