Message-ID: <16BA782E-A490-4266-9E14-59007945FB1A@r-project.org>
Date: 2006-01-15T07:28:44Z
From: Simon Urbanek
Subject: RMySQL and MySQL 5.0
In-Reply-To: <AF457C21-0FD8-4EEC-A04C-A3C8F0C27884@trichech.us>
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