[R] RMySQL crashes R

[Marsland, John]

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}}