[R] RMySQL on win32

[Uwe Ligges]

If you have gcc installed, yes, still a path issue:
You have tp put MinGW's ./bin directory into your PATH.

Best,
uwe


Pete Cap wrote:
> */Uwe Ligges <ligges at statistik.uni-dortmund.de>/* wrote:
> 
>     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.
> 
> 
> Uwe,
> 
> It seems you are correct!
> I neglected to alter my PATH statement.
> 
> My only remaining issue, it seems, is what to add to %PATH%.
> 
> The R documentation instructs the reader to download various tools in 
> the MinGW set ("An alternative is to download the components 
> individually...and unpack these into the same directory"),  All of the 
> recommended files were unzipped and untarred to C:\MinGW, which is in 
> the path, but obviously this is insufficient as there are binaries in 
> most of of the subdirectories.  The result is now:
> 
> C:\>Rcmd build --binary RMySQL
> * checking for file 'RMySQL/DESCRIPTION' ... OK
> * preparing 'RMySQL':
> * checking DESCRIPTION meta-information ... OK
> * cleaning src
> * checking whether 'INDEX' is up-to-date ... NO
> * use '--force' to overwrite the existing 'INDEX'
> * removing junk files
> * checking for LF line-endings in source files
> * checking for empty or unneeded directories
> * building binary distribution
>  WARNING
> * some HTML links may not be found
> installing R.css in c:/TEMP/Rinst19605847
> 
> Using auto-selected zip options ' RMySQL-HELP=ziponly'
> 
> ---------- Making package RMySQL ------------
> ======================================================================
> RMySQL configure.win:
> * Using mysql libraries from c:/PROGRA~1/MySQL/MYSQLS~1.0/lib/opt
> * Using mysql dll from c:/PROGRA~1/MySQL/MYSQLS~1.0/bin
> * Copying runtime libMySQL.dll and libmysql.lib to inst/libs
> * Using an existing libmysql.a in c:/PROGRA~1/MySQL/MYSQLS~1.0/lib/opt
> ======================================================================
>   adding build stamp to DESCRIPTION
>   making DLL ...
> making RS-DBI.d from RS-DBI.c
> make[3]: gcc: Command not found
> make[3]: *** [RS-DBI.d] Error 127
> make[2]: *** [srcDynlib] Error 2
> make[1]: *** [all] Error 2
> make: *** [pkg-RMySQL] Error 2
> *** Installation of RMySQL failed ***
> 
> Removing 'c:/TEMP/Rinst19605847/RMySQL'
>  ERROR
> * installation failed
> 
> Is this still a path issue?  Just wondering before I go messing with it 
> even more.
> 
> Thanks,
> 
> Pete
> 
> ------------------------------------------------------------------------
> Get your own web address. 
> <http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL>
> Have a HUGE year through Yahoo! Small Business. < 
> http://us.rd.yahoo.com/evt=49678/*http://smallbusiness.yahoo.com/domains/?p=BESTDEAL> 
>