RMySQL compile

Jeff,

Thank you so much for responding. I am ready to do a lot of tweaking.

 From your message it looks like you are asking me to provide 
assignments on the same line as R CMD but precede the command. I am 
using bash and the usual thing would be to export those variables and 
then run R CMD.
I tried that and configure ignores the variables. If you know where is 
the actual makefile then I could try to finish this without using R CMD. 
calling ./configure directly works ( R CMD INSTALL is the problem and I 
do not know how to look into that)

Stephen C. Bond


On Mar 31, 2009, *jeff.horner at vanderbilt.edu* wrote:

    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