[R-sig-DB] DBI problem after R upgrade

[Parlamis Franklin]

Update on this thread:

It turned out that, not only did I need to install RMySQL from  
sources, I also needed to reinstall MySQL from sources, using gcc 3.3  
as the c and c++ compiler.  The binary version of MySQL 5.0.15 was  
compiled using gcc 4.0, which caused some kind of conflict with R  
relating to the C API (R complained as follows):

>> ld: truncated or malformed archive: /usr/local/mysql/lib/
>> libmysqlclient.a (ranlib structures in table of contents extends past
>> the end of the table of contents, can't load from it)

Anyway, it all works now.  I am not sure whether it was the compiler  
version that did the trick, of whether something else in my  
configuration was different than in the MySQL binary (perhaps  
relating to the ld flags) but it works.

FP

On Oct 20, 2005, at 1:22 AM, Prof Brian Ripley wrote:

> On Thu, 20 Oct 2005, Parlamis Franklin wrote:
>
>> I upgraded R to 2.2.0 (Mac Cocoa GUI 1.13) this evening.  I am
>> running MySQL Standard version 4.1.14 locally, which I installed
>> several months ago from binaries on the MySQL web site (mysql-
>> standard-4.1.14-apple-darwin8.2.0-powerpc-64bit.dmg).  Before I
>> upgraded R, everything worked fine with RMySQL and DBI (all I used
>> was DBSendQuery, DBReadTable and DBWriteTable).
>>
>> However, now when I load the DBI package I get the following error:
>>
>>         Warning message:
>>         RS-DBI driver warning: (MySQL mismatch between compiled
>> version 4.0.24 and runtime version 4.1.14)
>>
>> Then, if I attempt to use one of the DBI functions, say DBReadTable,
>> R quits unexpectedly.  I reinstalled MySQL from binaries, and I also
>> reinstalled the DBI and RMySQL packages from binaries.  Nothing has
>> helped.  I have never had MySQL 4.0.24 on my computer (4.1.14 was my
>> first and only install).
>
> It is the (powerpc/2.2) RMySQL MacOS X binary that is compiled  
> against MySQL 4.0.24.  It seems you need to install RMySQL from the  
> sources.
>
> This is not really a R-sig-DB topic but a MacOS one.
>
> -- 
> Brian D. Ripley,                  ripley using stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595