[R-SIG-Mac] RMySQL with R 2.1.1 and Tiger 10.4

[Richard Piper]

Has anyone managed to compile RMySQL for 2.11. I had it working for  
the previous version of R.

It compiles with errors, and then when I load the library, it  
complains about shared libraries

Any suggestions would be much appreciated.

Thanks

Richard Piper


** libs
gcc-3.3 -no-cpp-precomp -I/Library/Frameworks/R.framework/Resources/ 
include -I/usr/local/mysql/include -I/usr/local/include   -fno- 
common  -g -O2 -c RS-DBI.c -o RS-DBI.o
gcc-3.3 -no-cpp-precomp -I/Library/Frameworks/R.framework/Resources/ 
include -I/usr/local/mysql/include -I/usr/local/include   -fno- 
common  -g -O2 -c RS-MySQL.c -o RS-MySQL.o
gcc-3.3 -bundle -flat_namespace -undefined suppress -L/usr/local/lib - 
o RMySQL.so RS-DBI.o RS-MySQL.o -L/usr/local/mysql/lib -lmysqlclient - 
lz  -framework R
ld: warning multiple definitions of symbol _compress2
/usr/lib/libz.dylib(compress.o) definition of _compress2
/Library/Frameworks/R.framework/R(compress.lo) definition of _compress2
ld: warning multiple definitions of symbol _compress
/usr/lib/libz.dylib(compress.o) definition of _compress
/Library/Frameworks/R.framework/R(compress.lo) definition of _compress
ld: warning multiple definitions of symbol _compressBound

and then when I load the library, it complains about shared libraries

 > library(RMySQL)
Loading required package: DBI
Error in dyn.load(x, as.logical(local), as.logical(now)) :
     unable to load shared library '/Library/Frameworks/R.framework/ 
Resources/library/RMySQL/libs/RMySQL.so':
   dlopen(/Library/Frameworks/R.framework/Resources/library/RMySQL/ 
libs/RMySQL.so, 6): Symbol not found: _printf$LDBLStub
   Referenced from: /Library/Frameworks/R.framework/Resources/library/ 
RMySQL/libs/RMySQL.so
   Expected in: flat namespace
Error in library(RMySQL) : .First.lib failed for 'RMySQL'