[R] RMySQL Suse 10.0 installing problems

[Prof Brian Ripley]

On Thu, 6 Jul 2006, H. Paul Benton wrote:

> Thanks again everyone,
> 	I have a problem trying to install RMySQL on Suse 10.0. I have used
> both the install.packages() and the 'R CMD INSTALL RMySQL..." neither
> worked. I get the error message telling me that it cannot find mysql. So I
> have set the flags using
>
> export PKG_CPPFLAGS="-I</usr/bin/>"
> export PKG_LIBS="-L</usr/lib/mysql>"

Those cannot be right: you don't want <> and -I/usr/bin is not a plausible 
include path.  RPM-based systems normally need

export PKG_CPPFLAGS=-I/usr/include/mysql
export PKG_LIBS=-I/usr/lib/mysql

and if you have /usr/lib/mysql, try

/usr/lib/mysql/mysql_config -cflags

to be sure about the first.

>
> After that I run R CMD INSTALL RMySQL... it starts to check and it cannot
> find mysql_init, mysql.h then it exits after gcc(ing) with an error code of
> make:*** [RS-DBI.o] Error 1
>
> I also tried the other way that the help suggested of putting the dir in the
> R CMD INSTALL command but that didn't work either giving me the same help
> menu.
>
> I am on opensuse 10.0 x86, and yes I su(ed).
>
> Cheers,
>
> Research Technician
> Mass Spectrometry
>  o The
> /
> o Scripps
> \
>  o Research
> /
> o Institute
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595