Hi Scott,
I get (for the first suggestion):
Error : .onLoad failed in loadNamespace() for 'RMySQL', details:
call: dyn.load(file, DLLpath = DLLpath, ...)
error: unable to load shared object
'/Users/dusadrian/Library/R/3.1/library/RMySQL/libs/RMySQL.so':
dlopen(/Users/dusadrian/Library/R/3.1/library/RMySQL/libs/RMySQL.so, 6):
Library not loaded: libmysqlclient.18.dylib
Referenced from:
/Users/dusadrian/Library/R/3.1/library/RMySQL/libs/RMySQL.so
Reason: image not found
Error: loading failed
Execution halted
ERROR: loading failed
* removing â/Users/dusadrian/Library/R/3.1/library/RMySQLâ
And for the second (within R):
> install.packages("RMySQL",
configure.args="--with-mysql-dir=/usr/local//mysql-5.6.17-osx10.7x86_64
--with-mysql-inc=/usr/local/mysql-5.6.17-osx10.7-x86_64/include
--with-mysql-lib=/usr/local/mysql-5.6.17-osx10.7-x86_64/lib")
Installing package into â/Users/dusadrian/Library/R/3.1/libraryâ
(as âlibâ is unspecified)
package âRMySQLâ is available as a source package but not as a binary
Warning message:
package âRMySQLâ is not available (for R version 3.1.0)
It seems that I'll have to wait for the next version of the RMySQL package,
for the time being I managed to find a temporary solution by reverting to R
3.0.3 for which RMySQL works as expected.
Best, and thanks again,
Adrian
On Thu, May 29, 2014 at 4:09 PM, Scott Robert Schreckengaust <
[email protected]> wrote:
> Try adding the other two configure.args "--with-mysql-inc" and
> "--with-mysql-lib":
>
> $ R CMD INSTALL
> --configure-args='--with-mysql-dir=/usr/local/mysql-5.6.17-osx10.7-x86_64
> --with-mysql-inc=/usr/local/mysql-5.6.17-osx10.7-x86_64/include
> --with-mysql-lib=/usr/local/mysql-5.6.17-osx10.7-x86_64/lib'
> RMySQL_0.9-3.tar.gz.tar.gz
>
> or
>
> install.packages("RMySQL",
> configure.args="--with-mysql-dir=/usr/local//mysql-5.6.17-osx10.7x86_64
> --with-mysql-inc=/usr/local/mysql-5.6.17-osx10.7-x86_64/include
> --with-mysql-lib=/usr/local/mysql-5.6.17-osx10.7-x86_64/lib")
>
> Cheers,
> Scott
>
> On May 28, 2014, at 8:11 AM, Adrian DuÈa <[email protected]> wrote:
>
> > Hello everyone,
> >
> > I am having some difficulties installing the RMySQL package from sources
> > (not available via the R Package Installer GUI, probably for the same
> > reasons). Just installed a fresh instance of MySQL, which I could find
> in:
> > /usr/local/mysql-5.6.17-osx10.7-x86_64
> >
> >
> > This is what I get:
> >
> > $ R CMD INSTALL RMySQL_0.9-3.tar.gz.tar.gz
> > ...
> > 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.
> >
> >
> > I tried:
> >
> > $ export PKG_CPPFLAGS="/usr/local/mysql-5.6.17-osx10.7-x86_64/include/"
> > $ export PKG_LIBS="/usr/local/mysql-5.6.17-osx10.7-x86_64/lib/"
> > $ R CMD INSTALL RMySQL_0.9-3.tar.gz.tar.gz
> > ...
> > In file included from RS-MySQL.c:22:
> > ./RS-MySQL.h:32:10: fatal error: 'mysql.h' file not found
> > #include <mysql.h>
> > ^
> > 1 error generated.
> >
> >
> > Also tried:
> >
> > $ R CMD INSTALL
> >
> --configure-args='--with-mysql-dir=/usr/local/mysql-5.6.17-osx10.7-x86_64'
> > RMySQL_0.9-3.tar.gz.tar.gz
> >
> > (with the same result)
> >
> > I'd be grateful for any hint, thanks in advance,
> > Adrian
> >
> >
> > --
> > Adrian Dusa
> > University of Bucharest
> > Romanian Social Data Archive
> > 1, Schitu Magureanu Bd.
> > 050025 Bucharest sector 5
> > Romania
> > Tel.:+40 21 3126618 \
> > +40 21 3120210 / int.101
> > Fax: +40 21 3158391
> >
> > [[alternative HTML version deleted]]
> >
> > _______________________________________________
> > R-SIG-Mac mailing list
> > [email protected]
> > https://stat.ethz.ch/mailman/listinfo/r-sig-mac
> >
>
>
--
Adrian Dusa
University of Bucharest
Romanian Social Data Archive
1, Schitu Magureanu Bd.
050025 Bucharest sector 5
Romania
Tel.:+40 21 3126618 \
+40 21 3120210 / int.101
Fax: +40 21 3158391
[[alternative HTML version deleted]]
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
