[R] RMysql installation problem.

[Wolski]

Hi!

I am trying to install the RMySQL package.  The installation stops with the following error message.

path to mysql is set.
setenv PKG_CPPFLAGS /home/arabidopsis/software/R1.9.1/linux/mysql/include
setenv PKG_LIBS /home/arabidopsis/software/R1.9.1/linux/mysql/lib

R CMD INSTALL RMySQL_0.5-5.tar.gz 
#....cut cut.
creating src/Makevars
** libs
gcc -I/home/arabidopsis/software/R1.9.1/linux/lib/R/include /home/arabidopsis/software/R1.9.1/linux/mysql/include -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp  -fPIC  -g -O2 -c RS-DBI.c -o RS-DBI.o
gcc: cannot specify -o with -c or -S and multiple compilations
make: *** [RS-DBI.o] Error 1
ERROR: compilation failed for package 'RMySQL'
** Removing '/home/arabidopsis/software/R1.9.1/linux/lib/R/library/RMySQL'


Thought this is because R and Mysql are compiled with different compilers.  Because of this error I just installed the newest R and mysql from source.
Please help.

Eryk