[R-sig-DB] error: install the oackage "RMySQL"

[Landscheidt, Ruediger Joachim (AIM SE)]

Hello

I have a problem. I want to install the package "RMySQL".
I was trying to install the package how they describe the installationway in http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL.
During building a binary of the source or installing the package, i get this error-message
:
* installing *source* package 'RMySQL' ...
checking for $MYSQL_HOME... C:/Programme/xampp/mysql
cygwin warning:
  MS-DOS style path detected: C:/Programme/xampp/mysql
  Preferred POSIX equivalent is: /cygdrive/c/Programme/xampp/mysql
  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
cp: cannot stat `src/Makevars.win32': No such file or directory                              <--- especially what is that?!
ERROR: configuration failed for package 'RMySQL'
* removing 'C:/.../RMYSQL~1.RCH/RMySQL'

Also I get this information too:
* installing *source* package 'RMySQL' ...
checking for $MYSQL_HOME... C:/Programme/xampp/mysql
cygwin warning:
  MS-DOS style path detected: C:/Programme/xampp/mysql
  Preferred POSIX equivalent is: /cygdrive/c/Programme/xampp/mysql
  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
Warnung: 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:/Programme/xampp/mysql"/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:/Programme/xampp/mysql"/include        -O3 -Wall  -std=gnu99 -c RS-MySQL.c -o RS-MySQL.o
In file included from RS-MySQL.c:22:0:
RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory
compilation terminated.
make: *** [RS-MySQL.o] Error 1
ERROR: compilation failed for package 'RMySQL'
* removing 'C:/Programme/R/R-2.12.1/library/RMySQL'

I dont know how i can correct the error?!
So I'm lost and please tell me, where is my problem?!
Thanks for your help.

R��diger Landscheidt

Some backgroundinformation:
I am using R.2.12.1, mysql is 5.0.67 and xampp is 1.6.8.
Also i am using Eclipse 3.6. with Rtools 212 in C:/Programme/Rtools.
I set the environmental variable: MYSQL_HOME= C:/Programme/xampp/mysql.


	[[alternative HTML version deleted]]