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
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@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.
