Re: [R] RMySQL Suse 10.0 installing problems

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Fri 07 Jul 2006 - 16:48:04 EST

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

______________________________________________
R-help@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
Received on Fri Jul 07 16:52:24 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Fri 07 Jul 2006 - 18:17:30 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.