RMySQL compile

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

RMySQL compile

stephenb-2

     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
______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: 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

[hidden email] 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
> ______________________________________________
> [hidden email] 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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: RMySQL compile

stephenb-2
In reply to this post by stephenb-2

   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, [hidden email] 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
     [hidden email] 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
     > ______________________________________________
     > [hidden email] 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
______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: RMySQL compile

Jeffrey Horner
[hidden email] wrote on 03/31/2009 08:11 AM:

> 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)


bash is perfectly capable of running commands preceded with shell
variables. Show the output, please. Otherwise I'm of no help.

Best,

Jeff

> Stephen C. Bond
>
>
> On Mar 31, 2009, *[hidden email]* 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
>
>     [hidden email] 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
>      > ______________________________________________
>      > [hidden email] 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
>


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

______________________________________________
[hidden email] 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.
Reply | Threaded
Open this post in threaded view
|

Re: RMySQL compile

stephenb-2
In reply to this post by stephenb-2

   Jeff,
   it still cannot find mysql.h
   * Installing to library '/export/home/scb/R/i386-pc-solaris2.11-library/2.8'
   * Installing *source* package 'RMySQL' ...
   checking for gcc... gcc
   checking for C compiler default output file name... a.out
   checking whether the C compiler works... yes
   checking whether we are cross compiling... no
   checking for suffix of executables...
   checking for suffix of object files... o
   checking whether we are using the GNU C compiler... yes
   checking whether gcc accepts -g... yes
   checking for gcc option to accept ANSI C... none needed
   checking how to run the C preprocessor... gcc -E
   checking for compress in -lz... yes
   checking for getopt_long in -lc... yes
   checking for mysql_init in -lmysqlclient... yes
   checking for egrep... grep -E
   checking for ANSI C header files... yes
   checking for sys/types.h... yes
   checking for sys/stat.h... yes
   checking for stdlib.h... yes
   checking for string.h... yes
   checking for memory.h... yes
   checking for strings.h... yes
   checking for inttypes.h... yes
   checking for stdint.h... yes
   checking for unistd.h... yes
   checking mysql.h usability... no
   checking mysql.h presence... no
   checking for mysql.h... no
   configure: creating ./config.status
   config.status: creating src/Makevars
   is there a way to look at the makefile directly?
   Stephen C. Bond
   Mar 31, 2009 05:37:17 AM, [hidden email] 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
     [hidden email] 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
     > ______________________________________________
     > [hidden email] 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
______________________________________________
[hidden email] 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.