[R] RMySQL compile

[stenka1 at go.com]

   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
     http://www.R-project.org/posting-guide.html
     > and provide commented, minimal, self-contained, reproducible code.
     --
     http://biostat.mc.vanderbilt.edu/JeffreyHorner