[R-SIG-Mac] installing RMySQL

[Adrian Dușa]

Hi Dan,

Yes indeed, I was able to install the package using your suggestion...
but... I get an error when loading the package in R:

> library(RMySQL)
Loading required package: DBI
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: package or namespace load failed for ‘RMySQL’


I can confirm that RMySQL.so does indeed exists in the specified path,
so I don't quite understand why it could not be loaded...

Still, this is one step further (thanks!)

Best,
Adrian

On Thu, Aug 7, 2014 at 6:46 PM,  <dweeks.pitt at gmail.com> wrote:
> Only after doing this:
>
> export DYLD_LIBRARY_PATH="/usr/local/mysql/lib"
>
> then I was able to successfully install the RMySQL package with this
> command:
>
> R CMD INSTALL --configure-args='--with-mysql-dir=/usr/local/mysql
> --with-mysql-lib=/usr/local/mysql/lib
> --with-mysql-inc=/usr/local/mysql/include' RMySQL_0.9-3.tar.gz
>
> Hope that helps,
> Dan



-- 
Adrian Dusa
University of Bucharest
Romanian Social Data Archive
Soseaua Panduri nr.90
050663 Bucharest sector 5
Romania