[R] RMySQL Install Problem

[Fred Gerson]

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()