and then I installed RMySQL from R itself using install.packages Cheers
2011/4/6 Radhouane Aniba <arad...@gmail.com> > Alon, I remember having the same problem than you, but I am using Ubuntu > > I solved that by installing libmysqlclient16-dev using "sudo apt-get > install libdbd-mysql libmysqlclient16-dev" > > I don't know what command equivalet you have in Suse > > Radhouane > > 2011/4/6 alon.benari <alon.ben...@gmail.com> > > Hello All, >> >> I have a technical difficulty installing RMySQL. I am running openSUSE11.1 >> and R 2.12 >> I have installed MySQL from the website. >> and following installation , as root >> This is the part where trouble begin, >> ...... >> checking mysql.h usability... no >> checking mysql.h presence... no >> checking for mysql.h... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking for mysql_init in -lmysqlclient... no >> checking /usr/local/include/mysql/mysql.h usability... no >> checking /usr/local/include/mysql/mysql.h presence... no >> checking for /usr/local/include/mysql/mysql.h... no >> checking /usr/include/mysql/mysql.h usability... no >> checking /usr/include/mysql/mysql.h presence... no >> checking for /usr/include/mysql/mysql.h... no >> checking /usr/local/mysql/include/mysql/mysql.h usability... no >> checking /usr/local/mysql/include/mysql/mysql.h presence... no >> checking for /usr/local/mysql/include/mysql/mysql.h... no >> checking /opt/include/mysql/mysql.h usability... no >> checking /opt/include/mysql/mysql.h presence... no >> checking for /opt/include/mysql/mysql.h... no >> checking /include/mysql/mysql.h usability... no >> checking /include/mysql/mysql.h presence... no >> checking for /include/mysql/mysql.h... no >> >> Configuration error: >> could not find the MySQL installation include and/or library >> directories. Manually specify the location of the MySQL >> libraries and the header files and re-run R CMD INSTALL. >> >> INSTRUCTIONS: >> >> 1. Define and export the 2 shell variables PKG_CPPFLAGS and >> PKG_LIBS to include the directory for header files (*.h) >> and libraries, for example (using Bourne shell syntax): >> >> export PKG_CPPFLAGS="-I" >> export PKG_LIBS="-L -lmysqlclient" >> >> Re-run the R INSTALL command: >> >> R CMD INSTALL RMySQL_.tar.gz >> >> 2. Alternatively, you may pass the configure arguments >> --with-mysql-dir= (distribution directory) >> or >> --with-mysql-inc= (where MySQL header files reside) >> --with-mysql-lib= (where MySQL libraries reside) >> in the call to R INSTALL --configure-args='...' >> >> R CMD INSTALL --configure-args='--with-mysql-dir=DIR' RMySQL_.tar.gz >> >> ERROR: configuration failed for package RMySQL >> * removing /root/R/i686-pc-linux-gnu-library/2.12/RMySQL >> >> Any ideas how to proceed from here? I am quite a newbie in LINUX >> How do I find the mysql.h ? >> using find / -name mysql.h but nothing there? >> Did I use it right? >> Any other ideas? How do I set this right? >> >> Thank you >> >> >> -- >> View this message in context: >> http://r.789695.n4.nabble.com/Cannot-install-pakcage-RMySQL-tp3431025p3431025.html >> Sent from the R help mailing list archive at Nabble.com. >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > > > -- > ** > > -- *Radhouane Aniba* *Bioinformatics Research Associate* *Institute for Advanced Computer Studies Center for Bioinformatics and Computational Biology* *(CBCB)* *University of Maryland, College Park MD 20742* [[alternative HTML version deleted]]
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
