Thank you very much Uwe for pointing me in the right direction. The solution is to specify the path as: D:\BenSave\Rtools\bin;D:\BenSave\Rtools\gcc-4.6.3\bin;D:\BenSave\Rtools\MinGW\bin;D:\BenSave\R\R-2.15.0\bin;
the reason is in Rtools\MinGW\bin there is a gcc.exe which does not seems to work in this case. It is selected first if D:\BenSave\Rtools\MinGW\bin is in front of D:\BenSave\Rtools\gcc-4.6.3\bin. The folder gcc-4.6.3\bin has the required gcc.exe to compile RMySQL. I just checked again the R-admin page at: http://cran.r-project.org/doc/manuals/R-admin.html#The-Windows-toolset and it is indeed noted in the example of the PATH: "For example for a 32-bit build, all on one line, PATH=c:\Rtools\bin;c:\Rtools\gcc-4.6.3\bin;c:\MiKTeX\miktex\bin; c:\R\R-2.15\bin\i386;c:\windows;c:\windows\system32" My fault. Sorry, I only realised my mistake too late. Best regards, Ben >________________________________ > From: Uwe Ligges <lig...@statistik.tu-dortmund.de> >To: Ben Rhelp <benrh...@yahoo.co.uk> >Cc: "r-help@r-project.org" <r-help@r-project.org> >Sent: Tuesday, 24 April 2012, 19:30 >Subject: Re: [R] Compiling RMySQL on Win7 64bits RS-DBI.c:1:0: sorry, >unimplemented: 64-bit mode not compiled in > > > >On 24.04.2012 20:13, Ben Rhelp wrote: >> Hi Uwe, >> >> I tried removing D:\BenSave\Rtools\MinGW64\bin (and replacing it with >> D:\BenSave\Rtools\MinGW\bin) but the result is the same. >> >> If I try to run "install.packages('RMySQL', type = 'source')" on my R 32bits >> instance I get the following which seems to be due to having a MySQL server >> 64bits as expected. >> >> any other suggestions? > >Yes, do not replace but delete that part, you have gcc-4.6.3 in your >path which should be sufficient. >I do not know if it is possible to compile RMySQL afterwards (untested, >and it depends on the MySQL you are linking against. > >best, >Uwe Ligges > > > >> thanks in advance, >> >> Ben >> >> >> 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 -I"D:/BenSave/R/R-215~1.0/include" -DNDEBUG >> -I"D:/MySQL/forR55"/include    -O3 -Wall -std=gnu99 -mtune=core2 >> -c RS-DBI.c -o RS-DBI.o >> gcc -I"D:/BenSave/R/R-215~1.0/include" -DNDEBUG >> -I"D:/MySQL/forR55"/include    -O3 -Wall -std=gnu99 -mtune=core2 >> -c RS-MySQL.c -o RS-MySQL.o >> gcc -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o RS-MySQL.o >> D:/MySQL/forR55/lib/opt/libmysql.lib -LD:/BenSave/R/R-215~1.0/bin/i386 -lR >> RS-MySQL.o:RS-MySQL.c:(.text+0xba): undefined reference to >> `mysql_more_results@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x352): undefined reference to `mysql_init@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x36f): undefined reference to >> `mysql_options@12' >> RS-MySQL.o:RS-MySQL.c:(.text+0x38d): undefined reference to >> `mysql_options@12' >> RS-MySQL.o:RS-MySQL.c:(.text+0x3ab): undefined reference to >> `mysql_options@12' >> RS-MySQL.o:RS-MySQL.c:(.text+0x3e6): undefined reference to >> `mysql_real_connect@32' >> RS-MySQL.o:RS-MySQL.c:(.text+0x44a): undefined reference to `mysql_close@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x5b8): undefined reference to `mysql_error@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x9c4): undefined reference to `mysql_close@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xa3d): undefined reference to >> `mysql_fetch_fields@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xa55): undefined reference to >> `mysql_field_count@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xd5b): undefined reference to >> `mysql_next_result@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xd85): undefined reference to >> `mysql_use_result@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xd93): undefined reference to >> `mysql_field_count@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xe7b): undefined reference to >> `mysql_affected_rows@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xf56): undefined reference to >> `mysql_fetch_row@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xf73): undefined reference to >> `mysql_free_result@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xfd7): undefined reference to `mysql_query@8' >> RS-MySQL.o:RS-MySQL.c:(.text+0xfea): undefined reference to >> `mysql_use_result@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0xffb): undefined reference to >> `mysql_field_count@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x109d): undefined reference to `mysql_error@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1146): undefined reference to >> `mysql_affected_rows@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x12bd): undefined reference to >> `mysql_fetch_row@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x12d8): undefined reference to >> `mysql_fetch_lengths@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x154f): undefined reference to `mysql_errno@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x16e4): undefined reference to `mysql_errno@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x16f2): undefined reference to `mysql_error@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1766): undefined reference to >> `mysql_fetch_row@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1775): undefined reference to >> `mysql_free_result@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1990): undefined reference to >> `mysql_get_client_info@0' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1b84): undefined reference to >> `mysql_get_host_info@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1bae): undefined reference to >> `mysql_get_server_info@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1bde): undefined reference to >> `mysql_get_proto_info@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x1bf5): undefined reference to >> `mysql_thread_id@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x294a): undefined reference to >> `mysql_fetch_row@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x2977): undefined reference to `mysql_errno@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x2aca): undefined reference to >> `mysql_fetch_lengths@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x315c): undefined reference to >> `mysql_insert_id@4' >> RS-MySQL.o:RS-MySQL.c:(.text+0x324d): undefined reference to >> `mysql_real_escape_string@16' >> RS-MySQL.o:RS-MySQL.c:(.text+0x3317): undefined reference to >> `mysql_get_client_info@0' >> RS-MySQL.o:RS-MySQL.c:(.text+0x335d): undefined reference to >> `mysql_get_client_version@0' >> RS-MySQL.o:RS-MySQL.c:(.text+0x33ae): undefined reference to >> `mysql_server_init@12' >> RS-MySQL.o:RS-MySQL.c:(.text+0x33b6): undefined reference to >> `mysql_get_client_version@0' >> RS-MySQL.o:RS-MySQL.c:(.text+0x33d7): undefined reference to >> `mysql_get_client_info@0' >> RS-MySQL.o:RS-MySQL.c:(.text+0x3408): undefined reference to >> `mysql_server_end@0' >> collect2: ld returned 1 exit status >> ERROR: compilation failed for package 'RMySQL' >> * removing 'D:/BenSave/R/R-2.15.0/library/RMySQL' >> >> The downloaded source packages are in >>     >>âC:\Users\BenSave\TempFolder\RtmpS8df20\downloaded_packagesâ >> Warning messages: >> 1: running command 'D:/BenSave/R/R-2.15.0/bin/i386/R CMD INSTALL -l >> "D:/BenSave/R/R-2.15.0/library" >> C:\Users\BenSave\TempFolder\RtmpS8df20/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 >> >> >> >> >> >>> ________________________________ >>> From: Uwe Ligges<lig...@statistik.tu-dortmund.de> >>> To: Ben Rhelp<benrh...@yahoo.co.uk> >>> Cc: "r-help@r-project.org"<r-help@r-project.org> >>> Sent: Tuesday, 24 April 2012, 18:22 >>> Subject: Re: [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@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. >>> >>> >>> > > > [[alternative HTML version deleted]]
______________________________________________ R-help@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.
