Re: [R] Cannot install pakcage RMySQL

From: Radhouane Aniba <aradwen_at_gmail.com>
Date: Wed, 06 Apr 2011 16:33:33 -0400

and then I installed RMySQL from R itself using install.packages

Cheers

2011/4/6 Radhouane Aniba <aradwen_at_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.benari_at_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_at_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_at_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.

Received on Wed 06 Apr 2011 - 20:50:55 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 06 Apr 2011 - 21:00:27 GMT.

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

list of date sections of archive