[R] How to build the RMySQL package on Windows?

[Witold Eryk Wolski]

Hi!
I am gone a bit further. Now its looking much nicer because I started the
compilation from the cygwin shell. Thanks.

bash-2.02$ make pkg-RMySQL
make DLLNM=  EXTRADOCS= \
  -C d:/prog/rw1011/src/library/RMySQL PKG=RMySQL RHOME=d:/prog/rw1011
RLIB=d:/prog/rw1011/library \
  -f d:/prog/rw1011/src/gnuwin32/MakePkg
---------- Making package RMySQL ------------
mkdir -p d:/prog/rw1011/library/RMySQL
cp -r   ./DESCRIPTION  ./INDEX  ./TITLE ./Copyrights ./LGPL ./README
./S-DBI.notes.txt d:/prog/rw1011/library/RMySQL/
mkdir -p d:/prog/rw1011/library/RMySQL/R
cat ./R/DBI.R ./R/MySQL.R ./R/MySQLsupport.R ./R/S4R.R ./R/zzz.R     >
d:/prog/rw1011/library/RMySQL/R/RMySQL
make -C ./src RHOME=d:/prog/rw1011 \
  -f d:/prog/rw1011/src/gnuwin32/MakeDll DLLNAME=RMySQL
gcc -mno-cygwin -DWIN32   -Id:/prog/rw1011/src/include -include
d:/prog/rw1011/src/include/globalvar.h  -Wall -O2   -c R
MySQL.c -o RMySQL.o
In file included from RMySQL.c:1:
RMySQL.h:24: mysql.h: No such file or directory
RMySQL.h:25: mysql_com.h: No such file or directory
make[2]: *** [RMySQL.o] Error 1
make[1]: *** [src/RMySQL.dll] Error 2
make: *** [pkg-RMySQL] Error 2

If I guess right the problem remains that the compiler couldnt find the mysql.h
and so on, which are in my mysql client directory.
How and where to pass the path information?

Eryk

Eryk Witold Wolski
Max Plank Institut fuer Molekulare Genetik
Ihnestr 73 14195 Berlin
Germany



Prof Brian D Ripley wrote:

> On Sun, 22 Oct 2000, Witold Eryk Wolski wrote:
>
> > Hello!
> >
> > I tried to build the RMySQL package by myself on an NT machine. I have a
> > NT machine with cygwin compiler and activestate Perl installed on it.
> >
> > Perl details:
> > D:\prog\rw1011\src\gnuwin32>perl -v
> > This is perl, version 5.005_03 built for MSWin32-x86-object
> > (with 1 registered patch, see perl -V for more detail)
> > Copyright 1987-1999, Larry Wall
> > Binary build 522 provided by ActiveState Tool Corp.
> > http://www.ActiveState.com
> > Built 09:52:28 Nov  2 1999
> >
> > I followod the steps described in RHOME/readme.packages. and perished
> > at.
> >
> > D:\prog\rw1011\src\gnuwin32>make pkg-RMySQL
> > make DLLNM=  EXTRADOCS= \
> >           -C D:/prog/rw1011/src/library/RMySQL PKG=RMySQL
> > RHOME=D:/prog/rw1011 RLIB=D:/prog/rw1011/library \
> >           -f D:/prog/rw1011/src/gnuwin32/MakePkg
> > ""---------- Making package RMySQL ------------""
> > mkdir -p D:/prog/rw1011/library/RMySQL
> > The syntax of the command is incorrect.
> > make[1]: *** [D:/prog/rw1011/library/RMySQL/zzzz] Error 1
> > make: *** [pkg-RMySQL] Error 2
> >
> > Some hints? Some tips? A precompiled package?
>
> I am pretty sure you don't have the tools described in
> RHOME/readme.packages in your PATH correctly.  You can probably use the
> cygwin ones, but only if somehow you managed to collect a set on one of the
> days when they all work. You appear to be getting the NT mkdir. Try mkdir
> --help to find out.
>
> I believe that to build RMySQL (which is from Devel) you will have to do
> quite a bit of work, for it is configure-based and does not seem (as
> `Writing R Extensions' requests) to describe how to configure it manually.
> Also its README says
>
>     For installation see "README.install"
>
> and there is no such file.  At the very least you will need a
> src/Makevars with PKG_CPPFLAGS and PKG_LIBS set correctly.
>
> --
> Brian D. Ripley,                  ripley at stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272860 (secr)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._