RMySQL crashes R - R-help | R Mailing Lists

Thu, May 15, 2003 12:37 AM #

I received three responses to my previous question, all of them were off
list. So I am posting the dialogue for the benefit of other users.

Subsequent to this dialogue, I have installed MySQL4 and have tried to
compile the RMySQL package from source for both versions of MySQL. 

I have not been sucessful and have had to revert to using RMySQL version
0.4-6 for the time being - which works fine with R v1.7.0 despite being
built under R v1.5.1 and it works with MySQL versions 3.x and 4.x.

I would respectfully like to keep this question open - refiled as a question
regarding either the source code, the instructions or my inability to follow
them.

Regards, 

John Marsland

-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: 14 May 2003 10:51
To: Marsland, John
Subject: RE: [R] RMySQL crashes R


On Wed, 14 May 2003, Marsland, John wrote:

Thanks for the pointer, I am indeed using MySQL version 3.23.40. 

My mysql server is on a solaris server. So I have installed

the windows

version 3.23.56 which is described as "recent" by mysql.com.

I have tried to compile RMySQL from source but I have a

problem. In the

README.windows (in which you are credited), I am following

the instructions

to re-import the libmysql.dll library with reimp. But reimp

seems only to

produce libmysql.def and liblibmysql.a - no dll file. Reimp

is now part of

mingw-utils now - I don't know if this make a difference? I

am no expert on

these utilities...

You only need the .a

When I try to compile the package, I get a number of

undefined references to

'mysql_init' and 'mysql_options' - I presume it's trying to

find this

reimported dll for version 3.23.x.

They should be in the .a.

I'd be grateful if you could give me a clue as to where I

am going wrong.

Regards,

John Marsland

PS I have received a number of off-list emails in response

to my posting

from users with similar problems.

-----Original Message-----
From: Prof Brian Ripley [mailto:ripley at stats.ox.ac.uk]
Sent: 13 May 2003 18:56
To: Marsland, John
Subject: Re: [R] RMySQL crashes R

You did compile this from the sources, didn't you, because

1) You are asked *not* to send messages to R-help about the 
pre-compiled 
Windows packages and

2) The pre-compiled package on CRAN requires RMySQL 4.0.x, as it 
documentation states.

Your symptoms are consistent with negligence of these points.
I hope not!

On Tue, 13 May 2003, Marsland, John wrote:

I have justed upgraded R v1.7.0 on Windows NT 4 and have

installed the

latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages.

When I issue the following commands (tactfully adjusted) R

just crashes and

disappears, any ideas?

require(RMySQL)
m <- dbDriver("MySQL")
con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",
host="myserver.com")

I get the same result with mysqlNewConnection().

I've sucessfully used both previous versions of R and the

MySQL package

together with no problems.


-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,

http://www.stats.ox.ac.uk/~ripley/

University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

-----Original Message-----
From: David Tudor [mailto:dtudor at evhr.net]
Sent: 13 May 2003 19:50
To: Marsland, John
Subject: Re: [R] RMySQL crashes R



I've got the same problem...

Best regards,
David Tudor

-----Original Message-----
From: Adelchi Azzalini [mailto:azzalini at stat.unipd.it]
Sent: 14 May 2003 09:22
To: Marsland, John
Subject: Re: [R] RMySQL crashes R


On Tuesday 13 May 2003 19:16, you wrote:

I have justed upgraded R v1.7.0 on Windows NT 4 and have

installed the

latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages.

When I issue the following commands (tactfully adjusted) R

just crashes and

disappears, any ideas?

require(RMySQL)
m <- dbDriver("MySQL")
con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",
host="myserver.com")

Unfortunately,  I cannot help ...in fact I have  the same 
problem myself!
only on a different environment (R 1.6.1 on Linux).  I wrote 
to the R-help list 
some time ago  about this, but only got an anwser from the 
author of RMySQL 
stating that the case is unusual, check the libaries, etc...

If you sort out how to habdle the problem, I would be 
interested in knowing
about it

good luck

Adelchi Azzalini

-- 
Adelchi Azzalini  <azzalini at stat.unipd.it>
Dipart.Scienze Statistiche, Universit? di Padova, Italia
http://azzalini.stat.unipd.it/

********************************************************************** 
This is a commercial communication from Commerzbank AG.\ \ This ... {{dropped}}