[R-SIG-Mac] RMySQL and MySQL 5.0? (was Re: RMySQL and '_fprintf$LDBLStub' symbol not found)

[Parlamis Franklin]

yes.  i am running MySQL 5.0.15 and R 2.2.0.  everything appears to  
work fine now, although I've found that MySQL "goes away" (I believe  
that is close to the syntax from the R error message--can't replicate  
right now) if I don't call to it for a long period of time. not sure  
whether that is a bug or security measure.


On Dec 5, 2005, at 12:53 PM, Paul Shannon wrote:

> Simon asks:
>
>> can you, please, supply us with some critical details such as how you
>> installed and/or compiled RMySQL and whether you have a custom or
>> CRAN version of R?
>
> Gene offered:
>
>> I just had (and posted about) the exact same error message.  I found
>> it went away after updating Xcode to 2.2.  I also made a change to
>> SHLIB (though I don't know if that made a difference), which I can
>> look up when I am at my other computer.
>
> and Franklin said:
>
>> hi.  you may have found my postings on this topic in the archives
>> from about a month back.  i had somewhat different problems with
>> RMySQL, but all my problems were resolved after I re-installed
>> MySQL from source and RMySQL from source (both with default
>> compiler 3.3).
>
> I used R 2.1.1, installed from the CRAN binary.  RMySQL I built  
> from source, version 0.5-5,
> on top of XML (0.97-8)  and DBI (0.1-9).
>
> I did all this at home, on OSX 10.4.3, but only after installing  
> the latest
> MySQL binary -- version 5.0.16-standard.
>
> Repeating the installation at work, using MySQSL 4.1.10-max,  
> everything worked fine.
> I'm afraid to upgrade MySQL from 4.1. to 5.0.
>
> Has anyone else had any luck with MySQL 5.0 and RMySQL?
>
> Thanks!
>
>  - Paul
>
> _______________________________________________
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-mac