[R] RMySQL on win32

[Uwe Ligges]

Pete Cap wrote:
> List,
> 
> I am still unable to compile RMySQL on XP and would appreciate any assistance anyone could provide.
> 
> I know that setting up RMySQL on win32 is not easy.  The installation instructions are supposedly contained in ../src/README.win.  They give instructions on creating a file, libmysql.a, which I was able to do successfully.
> 
> Here is where the instructions basically break down.  The creation of this file all occurs in \MySQL\..\lib\opt, after which the reader is instructed to copy libmysql.a to ..\lib\opt (huh?  You mean, where it already is?).  Then the reader is instructed to build the binaries with Rcmd build --binary RMySQL.
> 
>>From the windows command shell, the result is:
> 
> C:\>Rcmd build --binary RMySQL
> * checking for file 'RMySQL/DESCRIPTION' ... OK
> * preparing 'RMySQL':
> * checking DESCRIPTION meta-information ...'sh' is not recognized as an internal  or external command, operable program or batch file.
>  OK
> * cleaning src
> 'sh' is not recognized as an internal or external command, operable program or batch file.
> Error: cannot open file 'c:/TEMP/Rout381268676' for reading


Please follow the Instructions to set up your build environment as 
mentioned in the R Installation and Administration manual. That includes 
installing the tools from Duncan Murdochs Webpage and putting it into 
your path. You either forgot to install those tools or you forgot to add 
it to your PATH environment variable.

Uwe Ligges



> Apparently R is trying to call some shell script (from the windows prompt??) so I attempted this in cygwin.  Results:
> 
> Can't locate R/Dcf.pm in @INC (@INC contains: c \PROGRA~1\R\R-24~1.1\share\perl; /usr/lib/perl5/5.8/cygwin /usr/lib/perl5/5.8 /usr/lib/perl5/site_perl/5.8/cygwin /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/site_perl/5.8/cygwin /usr/lib/perl5/site_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin /usr/lib/perl5/vendor_perl/5.8 /usr/lib/perl5/vendor_perl/5.8/cygwin /usr/lib/perl5/vendor_perl/5.8 .) at c:\PROGRA~1\R\R-24~1.1/bin/build line 29.
> BEGIN failed--compilation aborted at c:\PROGRA~1\R\R-24~1.1/bin/build line 29.
> 
> Dcf.pm is actually located in C:\Program Files\R\R-2.4.1\share\perl\R.  I wonder if the variable @INC is simply incorrect (it's looking under R-24~1.1, not sure if the truncated value is actually correct) but I have no idea in which file it may be located.
> 
> Anyone have any ideas?
> I have installed mingw-utils while attempting to get this up and running, if it matters.
> 
> If there is a simply better solution that I should try, I would appreciate hearing about it as well.  All I really need to do at this point is send select and join queries to the local server--perhaps I should just install RSQLite from CRAN?
> 
> Thanks in advance,
> 
> Pete
> 
>  
> ---------------------------------
> Be a PS3 game guru.
> 
> 	[[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at stat.math.ethz.ch 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.