RMySQL and MySQL 5.0? (was Re: RMySQL and '_fprintf$LDBLStub' symbol not found)
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