R help - Jul 2006 - RMySQL Suse 10.0 installing problems

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

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

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