[R] RMySQL Install Problem

[Fred Gerson]

Hey David,

Sorry about that, the server runs MySQL 3.2.39.

Thanks a lot,
Fred

On Mon, 17 Mar 2003, David James wrote:

> 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
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>