[R] RMySQL Install Problem

[David James]

Fred Gerson wrote:
> Hey David,
> 
> Sorry about that, the server runs MySQL 3.2.39.

Probably you mean 3.23.39?

You need to change line 197 in the file RMySQL/src/RS-MySQL.c from

#if defined(MYSQL_VERSION_ID) && MYSQL_VERSION_ID > 32339

to

#if defined(MYSQL_VERSION_ID) && MYSQL_VERSION_ID > 32348

--
David

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

-- 
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636