[R-SIG-Mac] RMySQL problem

[Parlamis Franklin]

Answered my own question:  Installing RMySQL from source did make the  
warning go away and restored all functionality (although dbWriteTable  
worked in my last message, dbReadTable still crashed R).  The Package  
Installer menu item was all I used for the Source install (viewing  
CRAN "source" packages, then Install).  It was not necessary to  
install DBI from source.

On Nov 18, 2005, at 4:21 PM, Parlamis Franklin wrote:

> A while back I posted a question about RMySQL not working because  
> of a corrupted libmysqlclient.a library.  I know at least one other  
> person experienced the same problem.  It was suggested that for  
> compatibility with R 2.2.0 I needed to compile MySQL with gcc 3.3  
> (not gcc 4.0, as is the case with the MySQL binary).  So:
>
> (i) I installed MySQL from sources using gcc 3.3 as the c and c++  
> compiler (this was not as straightforward as I had hoped, and I had  
> to experiment with a few different sets of configuration options --  
> if anyone is having a problem with this send me an email and I will  
> dig up the configure call that worked for me).
>
> (ii) I reinstalled the RMySQL binary using the Package Installer  
> feature in R.App.
>
> I am happy to report that it now works (meaning R doesn't crash  
> when I issue, say, a dbWriteTable command; it successfully writes  
> the table).
>
> However, even though R no longer crashes, I am still receiving the  
> following message when I open the RMySQL package:
>
> "RS-DBI driver warning: (MySQL mismatch between compiled version  
> 4.0.24 and runtime version 4.1.14)"
>
> The message is still confusing to me because I installed MySQL 5.0.15.
>
> Does anyone have a view on whether this warning will go away if I  
> also install RMySQL and DBI from sources?
>
>
> On Oct 28, 2005, at 5:11 PM, Parlamis Franklin wrote:
>
>>
>>>
>>> Did you test the library *after* running ranlib and *before*
>>> reinstalling? That was the crucial point.
>>>
>>
>> Yes, I did.  I should have been more clear.  It still did not work,
>> so then I tried the re-install.
>>
>> I guess the only thing to do now is install MySQL from sources.  I
>> will do so with gcc 3.3 set as default, as another user suggested,
>> let you know if it works.
>>
>> _______________________________________________
>> R-SIG-Mac mailing list
>> R-SIG-Mac at stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-mac
>