[R-sig-DB] R MYSQL INSTALLATION

[sayan dasgupta]

Hi useRs,

So I am trying to install RMySQL on my windows vista machine from source as
mentioned in http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL.
I am running R version 2.12.1 (2010-12-16) and a MySQL installation Server
version: 5.5.8 MySQL Community Version (A complete installation).
I also have latest version of Rtools installed and its is added to PATH
variable

I have copied the total log file. Towards the end it says
gcc.exe: C:/Program Files/MySQL/MySQL Server 5.5/lib/opt/libmysql.lib: No
such file or directory
ERROR: compilation failed for package 'RMySQL'

While checking manually I find that libmysql.lib is in directory C:\Program
Files\MySQL\MySQL Server 5.5\lib and not in C:/Program Files/MySQL/MySQL
Server 5.5/lib/opt/
Please help,


Thanks and Regards
Sayan Dasgupta






> install.packages('RMySQL',type='source')
Installing package(s) into �C:\Users\sayan\Documents/R/win-library/2.9�
(as �lib� is unspecified)
--- Please select a CRAN mirror for use in this session ---
trying URL 'http://cran.cnr.Berkeley.edu/src/contrib/RMySQL_0.7-5.tar.gz'
Content type 'application/x-gzip' length 160769 bytes (157 Kb)
opened URL
downloaded 157 Kb

* installing *source* package 'RMySQL' ...
checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.5
cygwin warning:
  MS-DOS style path detected: C:/Program
  Preferred POSIX equivalent is: /cygdrive/c/Program
  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
test: Files/MySQL/MySQL: unknown operand
** 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:/PROGRA~1/R/R-212~1.1/etc/i386/Makeconf
  Preferred POSIX equivalent is:
/cygdrive/c/PROGRA~1/R/R-212~1.1/etc/i386/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
gcc -I"C:/PROGRA~1/R/R-212~1.1/include" -I"C:/Program Files/MySQL/MySQL
Server 5.5"/include        -O3 -Wall  -std=gnu99 -c RS-DBI.c -o RS-DBI.o
gcc -I"C:/PROGRA~1/R/R-212~1.1/include" -I"C:/Program Files/MySQL/MySQL
Server 5.5"/include        -O3 -Wall  -std=gnu99 -c RS-MySQL.c -o RS-MySQL.o
gcc -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o RS-MySQL.o
C:/Program Files/MySQL/MySQL Server 5.5/lib/opt/libmysql.lib
-LC:/PROGRA~1/R/R-212~1.1/bin/i386 -lR
gcc.exe: C:/Program Files/MySQL/MySQL Server 5.5/lib/opt/libmysql.lib: No
such file or directory
ERROR: compilation failed for package 'RMySQL'
* removing 'C:/Users/sayan/Documents/R/win-library/2.9/RMySQL'

The downloaded packages are in
        �C:\Users\sayan\AppData\Local\Temp\RtmpUaOXvZ\downloaded_packages�
Warning messages:
1: running command 'C:\PROGRA~1\R\R-212~1.1/bin/i386/R CMD INSTALL -l
"C:\Users\sayan\Documents/R/win-library/2.9"
C:\Users\sayan\AppData\Local\Temp\RtmpUaOXvZ/downloaded_packages/RMySQL_0.7-5.tar.gz'
had status 1
2: In install.packages("RMySQL", type = "source") :
  installation of package 'RMySQL' had non-zero exit status

	[[alternative HTML version deleted]]