[R-SIG-Mac] RMySQL and MySQL 5.0? (was Re: RMySQL and '_fprintf$LDBLStub' symbol not found)
fparlamis at mac.com
Tue Dec 6 00:13:29 CET 2005
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?
> - Paul
> R-SIG-Mac mailing list
> R-SIG-Mac at stat.math.ethz.ch
More information about the R-SIG-Mac