[R-SIG-Mac] RMySQL problem

[Parlamis Franklin]

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