RMySQL and MySQL 5.0

On Jan 13, 2006, at 12:22 PM, Simon Urbanek wrote:

I didn't test MySQL, but AFAIR this problem is caused by compiler  
mismatch (it started with Xcode 2.2 I believe). Did you run sudo  
gcc_select 3.3 before compiling? The real reason for the above is  
that you're missing -lSystemStubs (which is static) when compiling  
RMySQL. Adding that to the LIBS for the package should work.

I can confirm now that I was using gcc 3.3, but there were some  
warnings. Here is the build log:

I'm sorry that I probably didn't make myself clear - as I was trying  
to say the problem is (and your build log confirms it) that you have  
Xcode 2.2 and you didn't add -lSystemStubs. You need to do so,  
because R was configured with a different compiler. I just checked  
and the following worked for me with the latest MySQL (5.0.18) and  
latest Xcode (2.2.1):

PKG_CPPFLAGS=-I/usr/local/mysql/include PKG_LIBS='-L/usr/local/mysql/ 
lib -lmysqlclient -lSystemStubs' R CMD INSTALL RMySQL

Cheers,
Simon