Ben Rhelp
2012-Apr-24 14:40 UTC
[R] Compiling RMySQL on Win7 64bits RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in
Hi,
On a Win7 64 bit, I have installed:
*R-15.0 and I am running it in 64bits
*Rtools215.exe*MySQL 5.5.23 64bits
My PATH start with
D:\BenSave\Rtools\bin;D:\BenSave\Rtools\MinGW64\bin;D:\BenSave\R\R-2.15.0\bin;D:\BenSave\Rtools\MinGW\bin;D:\BenSave\Rtools\gcc-4.6.3\bin;
Note that I place MinGW64\bin has I want the package in 64 bits, so just in case
it helps...
To install RMySQL 64 bits, I then followed the steps described in
http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails,
namely:
1. Install latest RTools from http://cran.r-project.org/bin/windows/Rtools/
2. install MySQL or header and library files of mysql
3. create or edit file C:\Program Files\R\R-2.15\etc\Renviron.site and add line
like MYSQL_HOME=C:/mysql (path to your mysql files)
4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
5. copy libmysql.dll to C:\Program Files\R\R-2.15\bin directory.
6. run install.packages('RMySQL',type='source') and wait while
compilation will end.
> install.packages('RMySQL', type = 'source')
--- Please select a CRAN mirror for use in this session ---
trying URL
'http://cran.ma.imperial.ac.uk/src/contrib/RMySQL_0.9-3.tar.gz'
Content type 'application/x-gzip' length 165363 bytes (161 Kb)
opened URL
downloaded 161 Kb
* installing *source* package 'RMySQL' ...
** package 'RMySQL' successfully unpacked and MD5 sums checked
checking for $MYSQL_HOME... D:/MySQL/forR55
** libs
Warning: this package has a non-empty 'configure.win' file,
so building only the main architecture
gcc -m64 -I"D:/BenSave/R/R-215~1.0/include" -DNDEBUG
-I"D:/MySQL/forR55"/include
-I"d:/RCompile/CRANpkg/extralibs64/local/include" -O2 -Wall
-std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o
RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in
make: *** [RS-DBI.o] Error 1
ERROR: compilation failed for package 'RMySQL'
* removing 'D:/BenSave/R/R-2.15.0/library/RMySQL'
The downloaded source packages are in
‘C:\Users\Bvinsonneau\TempFolder\RtmpwPJoVe\downloaded_packages’
Warning messages:
1: running command 'D:/BenSave/R/R-2.15.0/bin/x64/R CMD INSTALL -l
"D:/BenSave/R/R-2.15.0/library"
C:\Users\BenSave\TempFolder\RtmpwPJoVe/downloaded_packages/RMySQL_0.9-3.tar.gz'
had status 1
2: In install.packages("RMySQL", type = "source") :
installation of package ‘RMySQL’ had non-zero exit
status>
I seems to have the same error than the reporter on
http://r.789695.n4.nabble.com/Installing-RMySQL-64-bit-Windows-7-td4466352.html
and Prof Brian Ripley suggests that the reporter should re-read the the
instructions in 'R Installation and
Administration'. I did so but no luck. I am not sure what I am missing.
Does anyone have a suggestion?
Regards,
Ben
[[alternative HTML version deleted]]
Uwe Ligges
2012-Apr-24 17:22 UTC
[R] Compiling RMySQL on Win7 64bits RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in
On 24.04.2012 16:40, Ben Rhelp wrote:> Hi, > > On a Win7 64 bit, I have installed: > *R-15.0 and I am running it in 64bits > *Rtools215.exe*MySQL 5.5.23 64bits > > My PATH start with D:\BenSave\Rtools\bin;D:\BenSave\Rtools\MinGW64\bin;D:\BenSave\R\R-2.15.0\bin;D:\BenSave\Rtools\MinGW\bin;D:\BenSave\Rtools\gcc-4.6.3\bin;What is D:\BenSave\Rtools\MinGW64\bin? Probably it needs to go out of the way. Uwe Ligges> > Note that I place MinGW64\bin has I want the package in 64 bits, so just in case it helps... > > > To install RMySQL 64 bits, I then followed the steps described in http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails, namely: > > 1. Install latest RTools from http://cran.r-project.org/bin/windows/Rtools/ > 2. install MySQL or header and library files of mysql > 3. create or edit file C:\Program Files\R\R-2.15\etc\Renviron.site and add line like MYSQL_HOME=C:/mysql (path to your mysql files) > 4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies. > 5. copy libmysql.dll to C:\Program Files\R\R-2.15\bin directory. > 6. run install.packages('RMySQL',type='source') and wait while compilation will end. > >> install.packages('RMySQL', type = 'source') > --- Please select a CRAN mirror for use in this session --- > trying URL 'http://cran.ma.imperial.ac.uk/src/contrib/RMySQL_0.9-3.tar.gz' > Content type 'application/x-gzip' length 165363 bytes (161 Kb) > opened URL > downloaded 161 Kb > > * installing *source* package 'RMySQL' ... > ** package 'RMySQL' successfully unpacked and MD5 sums checked > checking for $MYSQL_HOME... D:/MySQL/forR55 > ** libs > Warning: this package has a non-empty 'configure.win' file, > so building only the main architecture > > gcc -m64 -I"D:/BenSave/R/R-215~1.0/include" -DNDEBUG -I"D:/MySQL/forR55"/include? ? ? -I"d:/RCompile/CRANpkg/extralibs64/local/include"? ? ? ? -O2 -Wall? -std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o > RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in > make: *** [RS-DBI.o] Error 1 > ERROR: compilation failed for package 'RMySQL' > * removing 'D:/BenSave/R/R-2.15.0/library/RMySQL' > > The downloaded source packages are in > ? ? ? ? ? ? ? ???C:\Users\Bvinsonneau\TempFolder\RtmpwPJoVe\downloaded_packages??? > Warning messages: > 1: running command 'D:/BenSave/R/R-2.15.0/bin/x64/R CMD INSTALL -l "D:/BenSave/R/R-2.15.0/library"? ? C:\Users\BenSave\TempFolder\RtmpwPJoVe/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1 > 2: In install.packages("RMySQL", type = "source") : > ? installation of package ???RMySQL??? had non-zero exit status >> > > > > I seems to have the same error than the reporter on > > http://r.789695.n4.nabble.com/Installing-RMySQL-64-bit-Windows-7-td4466352.html > and Prof Brian Ripley suggests that the reporter should re-read the the instructions in 'R Installation and > Administration'. I did so but no luck. I am not sure what I am missing.? > > Does anyone have a suggestion? > > Regards, > > Ben > [[alternative HTML version deleted]] > > > > > ______________________________________________ > R-help at r-project.org 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.