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
It works!!!! with: R CMD INSTALL --configure-args='--with-mysql-dir="/home/arabidopsis/software/R1.9.1/linux/mysql/"' RMySQL_0.5-5.tar.gz dunno why. Sorry for the annoyance. Eryk *********** REPLY SEPARATOR *********** On 28.06.2004 at 19:55 Wolski wrote:>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 > >______________________________________________ >R-help at stat.math.ethz.ch mailing list >https://www.stat.math.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html