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