[R-SIG-Mac] RMySQL won't install

[Chris Bunch]

Thanks Simon -

Unfortunately I have installed the 32 bit (ie non-64 bit) version of MySQL
5.0.22 and get the same error when I try to install RMySQL;

Error in dyn.load(x, as.logical(local), as.logical(now)) : 
	unable to load shared library
'/Library/Frameworks/R.framework/Versions/2.3/Resources/library/RMySQL/libs/ppc/RMySQL.so':

dlopen(/Library/Frameworks/R.framework/Versions/2.3/Resources/library/RMySQL/libs/ppc/RMySQL.so,
6): Symbol not found: _load_defaults
  Referenced from:
/Library/Frameworks/R.framework/Versions/2.3/Resources/library/RMySQL/libs/ppc/RMySQL.so
  Expected in: flat namespace
Error in library(RMySQL) : .First.lib failed for 'RMySQL'


C
__________________________
Dis aliter visum
http://jambalaya.bayswaterfarm.com

--On Tuesday, August 1, 2006 00:27 -0400 Simon Urbanek
<simon.urbanek at r-project.org> wrote:

> 
> On Jul 31, 2006, at 2:26 PM, Chris Bunch wrote:
> 
>> I am having problems installing the RMySQL binary package [Mac OS X  
>> 10.4.7;
>> R 2.3.1; R-GUI 1.16 (3198);
>> mysql-max-5.0.22-osx10.4-powerpc-64bit (binary)]
> 
>   ^^^ --- this is not a good idea - it won't work, because the 64-bit
> MySQL package doesn't contain 32-bit client libraries. You will have  to
> get the 32-bit version instead (or use 64-bit version of R  instead, but
> then you lose the GUI, Quartz etc.).
> 
> In theory 32-bit library could potentially work with 64-bit server as
> they communicate over sockets, but I didn't test it myself, so I  don't
> know if that's true in practice.
> 
> Cheers,
> Simon
>