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 <
scott@schrecktech.com> 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 <dusa.adrian@unibuc.ro> 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
> > R-SIG-Mac@r-project.org
> > 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]]

