[Rd] R Tools & Vista_x64: Problem compiling RMySQL?

[Spencer Graves]

Hello:


	  What do I need to do to compile R packages (especially RMySQL) for 
the 64-bit version of R 2.12.0 under Vista_x64?


	  I upgraded to "Rtools212.exe" yesterday but immediately got errors 
from "R CMD check RMySQL_0.7-5.tar.gz".  After the first error, I 
installed it a second time, then got "undefined reference to" roughly 50 
different names beginning "mysql_";  copied below.  I see two possible 
sources for this problem:


		    (1) RTools212 may not be installed properly.


		    (2) RMySQL may be incompatible with R x64 2.12.0, especially with 
a 32-bit version of MySQL.


	  NOTE:  RMySQL worked with R2.11.1 (and MySQL 5.1.50-community server) 
before I installed R2.12.0.  I'm reasonably sure that my local 
installation of MySQL is only 32-bit.


	  What do you suggest?  I use the 32-bit version of R2.12.0?


	  Thanks,
	  Spencer
#####################################
* installing *source* package 'RMySQL' ...
checking for $MYSQL_HOME... C:/PROGRA~2/MySQL/MYSQLS~1.1/
cygwin warning:
   MS-DOS style path detected: C:/PROGRA~2/MySQL/MYSQLS~1.1/
   Preferred POSIX equivalent is: /cygdrive/c/PROGRA~2/MySQL/MYSQLS~1.1/
   CYGWIN environment variable option "nodosfilewarning" turns off this 
warning.
   Consult the user's guide for more details about POSIX paths:
     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
** libs
Warning: this package has a non-empty 'configure.win' file,
so building only the main architecture

cygwin warning:
   MS-DOS style path detected: C:/Users/sgraves/R/R-212~1.0/etc/x64/Makeconf
   Preferred POSIX equivalent is: 
/cygdrive/c/Users/sgraves/R/R-212~1.0/etc/x64/Makeconf
   CYGWIN environment variable option "nodosfilewarning" turns off this 
warning.
   Consult the user's guide for more details about POSIX paths:
     http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
x86_64-w64-mingw32-gcc -I"C:/Users/sgraves/R/R-212~1.0/include" 
-I"C:/PROGRA~2/MySQL/MYSQLS~1.1/"/include        -O2 -Wall  -std=gnu99 
-c RS-DBI.c -o RS-DBI.o
x86_64-w64-mingw32-gcc -I"C:/Users/sgraves/R/R-212~1.0/include" 
-I"C:/PROGRA~2/MySQL/MYSQLS~1.1/"/include        -O2 -Wall  -std=gnu99 
-c RS-MySQL.c -o RS-MySQL.o
x86_64-w64-mingw32-gcc -shared -s -static-libgcc -o RMySQL.dll tmp.def 
RS-DBI.o RS-MySQL.o C:/PROGRA~2/MySQL/MYSQLS~1.1//bin/libmySQL.dll 
-LC:/Users/sgraves/R/R-212~1.0/bin/x64 -lR
RS-MySQL.o:RS-MySQL.c:(.text+0xb0): undefined reference to 
`mysql_more_results'
RS-MySQL.o:RS-MySQL.c:(.text+0x2c6): undefined reference to `mysql_init'
RS-MySQL.o:RS-MySQL.c:(.text+0x2d9): undefined reference to `mysql_options'
RS-MySQL.o:RS-MySQL.c:(.text+0x2ef): undefined reference to `mysql_options'
RS-MySQL.o:RS-MySQL.c:(.text+0x305): undefined reference to `mysql_options'
RS-MySQL.o:RS-MySQL.c:(.text+0x338): undefined reference to 
`mysql_real_connect'
RS-MySQL.o:RS-MySQL.c:(.text+0x399): undefined reference to `mysql_close'
RS-MySQL.o:RS-MySQL.c:(.text+0x3d1): undefined reference to `mysql_error'
RS-MySQL.o:RS-MySQL.c:(.text+0x7a2): undefined reference to `mysql_close'
RS-MySQL.o:RS-MySQL.c:(.text+0x80f): undefined reference to 
`mysql_fetch_fields'
RS-MySQL.o:RS-MySQL.c:(.text+0x823): undefined reference to 
`mysql_field_count'
RS-MySQL.o:RS-MySQL.c:(.text+0xae7): undefined reference to 
`mysql_next_result'
RS-MySQL.o:RS-MySQL.c:(.text+0xb0b): undefined reference to 
`mysql_use_result'
RS-MySQL.o:RS-MySQL.c:(.text+0xb16): undefined reference to 
`mysql_field_count'
RS-MySQL.o:RS-MySQL.c:(.text+0xbff): undefined reference to 
`mysql_affected_rows'
RS-MySQL.o:RS-MySQL.c:(.text+0xd27): undefined reference to 
`mysql_fetch_row'
RS-MySQL.o:RS-MySQL.c:(.text+0xd3d): undefined reference to 
`mysql_fetch_lengths'
RS-MySQL.o:RS-MySQL.c:(.text+0xf2e): undefined reference to `mysql_errno'
RS-MySQL.o:RS-MySQL.c:(.text+0x1093): undefined reference to `mysql_errno'
RS-MySQL.o:RS-MySQL.c:(.text+0x109e): undefined reference to `mysql_error'
RS-MySQL.o:RS-MySQL.c:(.text+0x1114): undefined reference to 
`mysql_fetch_row'
RS-MySQL.o:RS-MySQL.c:(.text+0x1121): undefined reference to 
`mysql_free_result'
RS-MySQL.o:RS-MySQL.c:(.text+0x11f0): undefined reference to `mysql_query'
RS-MySQL.o:RS-MySQL.c:(.text+0x1200): undefined reference to 
`mysql_use_result'
RS-MySQL.o:RS-MySQL.c:(.text+0x120b): undefined reference to 
`mysql_field_count'
RS-MySQL.o:RS-MySQL.c:(.text+0x128f): undefined reference to `mysql_query'
RS-MySQL.o:RS-MySQL.c:(.text+0x12ac): undefined reference to `mysql_error'
RS-MySQL.o:RS-MySQL.c:(.text+0x133c): undefined reference to 
`mysql_affected_rows'
RS-MySQL.o:RS-MySQL.c:(.text+0x1539): undefined reference to 
`mysql_get_client_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x172d): undefined reference to 
`mysql_get_host_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x174b): undefined reference to 
`mysql_get_server_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x176d): undefined reference to 
`mysql_get_proto_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x177c): undefined reference to 
`mysql_thread_id'
RS-MySQL.o:RS-MySQL.c:(.text+0x23db): undefined reference to 
`mysql_fetch_row'
RS-MySQL.o:RS-MySQL.c:(.text+0x23fd): undefined reference to `mysql_errno'
RS-MySQL.o:RS-MySQL.c:(.text+0x252a): undefined reference to 
`mysql_fetch_lengths'
RS-MySQL.o:RS-MySQL.c:(.text+0x28fd): undefined reference to 
`mysql_insert_id'
RS-MySQL.o:RS-MySQL.c:(.text+0x29cd): undefined reference to 
`mysql_real_escape_string'
RS-MySQL.o:RS-MySQL.c:(.text+0x2a7a): undefined reference to 
`mysql_get_client_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x2ab8): undefined reference to 
`mysql_get_client_version'
RS-MySQL.o:RS-MySQL.c:(.text+0x2afc): undefined reference to 
`mysql_server_init'
RS-MySQL.o:RS-MySQL.c:(.text+0x2b01): undefined reference to 
`mysql_get_client_version'
RS-MySQL.o:RS-MySQL.c:(.text+0x2b29): undefined reference to 
`mysql_get_client_info'
RS-MySQL.o:RS-MySQL.c:(.text+0x2b69): undefined reference to 
`mysql_server_end'
collect2: ld returned 1 exit status
ERROR: compilation failed for package 'RMySQL'
* removing 'C:/Users/sgraves/Rpkgs/RMySQL/RMySQL.Rcheck/RMySQL'