[R-sig-DB] [R] RMySQL crashes R / incompatible MySQL 5.1 client libraries / vista solution

[Krzysztof Sakrejda]

Further searching on R-help and R-sig-db shows that the problem is the MySQL
client libraries in the 5.1 series which cause R/RMySQL to crash.  I wanted
to keep the 5.1 server on my machine, but the 5.0 client libraries will
happily coexist with it:

- Download the current 5.0 series "essentials" package client/C libraries
for _32-bit_. (Still 5.0.67)
- Do custom install, install only client/C libraries, don't install the
server unless you know you want it.
- Set MySQL_HOME, note that the path has to be to the 32-bit version of the
MySQL client libraries under Vista, thus the extra (x86):
Sys.setenv(MYSQL_HOME="C:/Program Files (x86)/MySQL/MySQL Server 5.0")

Apologies for the earlier email, I did not realize it was the same old
problem.

Best,

Krzysztof

On Fri, Jan 23, 2009 at 5:31 AM, Krzysztof Sakrejda <
krzysztof.sakrejda using gmail.com> wrote:

> Hi,
>
> I've had great experiences with the RMySQL library and MySQL from windows
> XP and Gentoo/Linux environments with R-2.7.2 so I'm happy to test solutions
> or to try to find out more about the problem.  I've (unfortunately) had the
> same (previous report appended) experience with a new install of Vista on a
> Vaio/VGN-NS255J laptop, running R (I checked 2.7.2 and 2.8 both exhibit the
> same behavior).  My MySQL binaries are from a fresh install of MySQL server
> (32bit) 5.1. The MySQL server is separate and plays well with other
> Windows/Linux R installations.
>
> The download/install is clean, I can connect and run dbGetQuery(conn, "SHOW
> TABLES;") at least a few times, but when I run a query against any table,
> even one which returns limited data (conn, "SELECT * FROM blah LIMIT 6;")
> Vista says "there has been a problem with R and it needs to close"
> (paraphrased).  The message is completely uninformative.  It then proceeds
> to close R with no further comment.  I will let you know if I find any more
> information but I don't know if there are better error logs somewhere on
> Vista.... any suggestions would be appreciated in dealing with this.
>
> Best regards,
>
> Krzysztof Sakrejda-Leavitt
>
> -----------------------------------------------
> Krzysztof Sakrejda-Leavitt
>
> Organismic and Evolutionary Biology
> University of Massachusetts, Amherst
> 319 Morrill Science Center South
> 611 N. Pleasant Street
> Amherst, MA 01003
>
> work #: 413-325-6555
> email: sakrejda using nsm.umass.edu
> -----------------------------------------------
>
>
> On Mon, Jan 12, 2009 at 1:02 PM, auburneconomics <nathan_forczyk using yahoo.com
> > wrote:
>
>>
>> This is similar to another current post about RMySQL crashing R, except on
>> the other post it crashed on connection to the database.  I can
>> successfully
>> connect, and even can do dbListTables().  But, if I send a query or
>> anything
>> to actually see the data, R crashes to desktop.
>>
>> I have tried this on two computers, one Vista, one XP.  Both crashed.  I
>> am
>> running 2.8.1, and am using the correct version of DBI and RMySQL.  They
>> are
>> both loaded with the library() function beforehand.  Versions of MySQL
>> that
>> it was tried are 5.1 and 6.0a.
>>
>> I have searched on the internet and haven't found any answers, and would
>> be
>> grateful for any help,
>>
>> Nathan Forczyk
>> Auburn University
>> --
>> View this message in context:
>> http://www.nabble.com/RMySQL-crashes-R-tp21419908p21419908.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> R-help using r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>
>
> --
>
>


-- 
-----------------------------------------------
Krzysztof Sakrejda-Leavitt

Organismic and Evolutionary Biology
University of Massachusetts, Amherst
319 Morrill Science Center South
611 N. Pleasant Street
Amherst, MA 01003

work #: 413-325-6555
email: sakrejda using nsm.umass.edu
-----------------------------------------------

	[[alternative HTML version deleted]]