[R] RMySQL compile

[Jeffrey Horner]

Try this:

PKG_CPPFLAGS="-I/usr/mysql/5.0/include/mysql -I/opt/csw/include 
-I/usr/sfw/include -I/usr/X11/include-I/usr/lib/gtk-2.0/include 
               -I/usr/local/include" PKG_LIBS="-L/usr/sfw/lib 
-L/usr/lib  -L/usr/local/lib  -L/opt/csw/lib -lmysqlclient" R CMD 
INSTALL RMySQL

I had to refresh my memory from the inst/INSTALL file on how to do this. 
You might have to tweak it a bit, and also please send the full output 
of the command next time.

Best,

Jeff

stenka1 at go.com wrote:
>      I am trying to install RMySQL on OpenSolaris and need to pass some options
>       to configure.
>       Tried the 3 recommended ways of doing it and nothing works, configure
>    cannot
>       find the headers and the libs.
>       I ran configure manually and that worked fine
>       ./configure    CC=cc    CFLAGS="-dalign    -KPIC    -xlic_lib=sunperf"
>       LDFLAGS="-L/usr/sfw/lib  -L/usr/lib  -L/usr/local/lib  -L/opt/csw/lib"
>       CPPFLAGS="-I/usr/local/lib/R/include    -I/usr/mysql/5.0/include/mysql
>       -I/opt/csw/include        -I/usr/sfw/include        -I/usr/X11/include
>       -I/usr/lib/gtk-2.0/include                       -I/usr/local/include"
>       --with-mysql-inc="/usr/mysql/include/mysql"
>       --with-mysql-lib="/usr/mysql/lib/mysql"
>       checking mysql.h usability... yes
>       checking mysql.h presence... yes
>       checking for mysql.h... yes
>       configure: creating ./config.status
>       config.status: creating src/Makevars
>       but then there is no makefile. Pls advise how to run make manually or
>    help
>       with the syntax: I tried with quotes after the second = and the first =
>    and
>       neither worked
>       R CMD INSTALL --configure-args=CC=cc --configure-args=CFLAGS="-dalign
>    -KPIC
>       -xlic_lib=sunperf" --configure-args=LDFLAGS="-L/usr/sfw/lib -L/usr/lib
>       -L/usr/local/lib -L/opt/csw/lib"
>       --configure-args=CPPFLAGS="-I/usr/local/lib/R/include
>       -I/usr/mysql/5.0/include/mysql  -I/opt/csw/include  -I/usr/sfw/include
>       -I/usr/X11/include   -I/usr/lib/gtk-2.0/include  -I/usr/local/include"
>       --configure-args="--with-mysql-inc=/usr/mysql/include/mysql"
>       --configure-args="--with-mysql-lib=/usr/mysql/lib/mysql"
>       RMySQL_0.7-3.tar.gz   ## does not work
>    Stephen C. Bond
> ______________________________________________
> R-help at 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.


-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner