[R-SIG-Mac] RMySQL and MySQL 5.0

[Simon Urbanek]

On Jan 13, 2006, at 12:30 PM, Christopher Fonnesbeck wrote:

> 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