Hi,
Could you tell us what version of MySQL you're running?
--
David
Fred Gerson wrote:> Hey all,
>
> I asked my server administrator to install the RMySQL package for me
> however he was unable to and received the below errors. I searched the
> archives for some of the words in the error mesage but found no answers.
> Does anyone have any ideas what might be going wrong? This is R 1.6.2 on a
> linux box.
>
> Thanks,
> Fred
>
>
>
>
> > install.packages("RMySQL")
> trying URL `http://cran.r-project.org/src/contrib/PACKAGES'
> Content type `text/plain; charset=iso-8859-1' length 100850 bytes
> opened URL
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ........
> downloaded 98Kb
>
> trying URL `http://cran.r-project.org/src/contrib/RMySQL_0.5-0.tar.gz'
> Content type `application/x-tar' length 390241 bytes
> opened URL
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .......... ..........
> .......... .......... .......... .
> downloaded 381Kb
>
> * Installing *source* package 'RMySQL' ...
> creating cache ./config.cache
> checking how to run the C preprocessor... cc -E
> checking for mysql_init in -lmysqlclient... yes
> checking for mysql.h... no
> checking for /usr/local/include/mysql/mysql.h... no
> checking for /usr/include/mysql/mysql.h... yes
> updating cache ./config.cache
> creating ./config.status
> creating src/Makevars
> ** libs
> gcc -I/usr/local/lib/R/include -I/usr/include/mysql -I/usr/local/include
> -D__NO_MATH_INLINES -mieee-fp -fPIC -g -O2 -c RS-DBI.c -o RS-DBI.o
> gcc -I/usr/local/lib/R/include -I/usr/include/mysql -I/usr/local/include
> -D__NO_MATH_INLINES -mieee-fp -fPIC -g -O2 -c RS-MySQL.c -o RS-MySQL.o
> RS-MySQL.c: In function `RS_MySQL_newConnection':
> RS-MySQL.c:203: `MYSQL_OPT_LOCAL_INFILE' undeclared (first use in this
> function)
> RS-MySQL.c:203: (Each undeclared identifier is reported only once
> RS-MySQL.c:203: for each function it appears in.)
> make: *** [RS-MySQL.o] Error 1
> ERROR: compilation failed for package 'RMySQL'
>
> Delete downloaded files (y/N)? y
>
> Warning message:
> Installation of package RMySQL had non-zero exit status in:
> install.packages("RMySQL")
> > q()
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
--
David A. James
Statistics Research, Room 2C-253
Bell Labs, Lucent Technologies
Murray Hill, NJ 09794-0636