RMySQL release candidate 0-7.0
I am pretty sure that distributing libmysql.dll (without the sources) is a license violation on MySQL, and in fact the binary releases made available on CRANextras did not distribute it. The Windows material in the RMySQL sources is years old, and not what has been used recently. My version of MySQL came with .a and not .lib, but neither are needed as you can link against libmysql.dll directly. I'll take a closer look when I have a machine booted into Windows that has MySQL installed, probably over the weekend.
On Thu, 13 Nov 2008, Jeffrey Horner wrote:
Hi, I'm the new maintainer for RMySQL and I have a new release candidate for everyone to test. Please download the source or the binary here: http://biostat.mc.vanderbilt.edu/twiki/pub/Main/JeffreyHorner/RMySQL_0.7-0.tar.gz http://biostat.mc.vanderbilt.edu/twiki/pub/Main/JeffreyHorner/RMySQL_0.7-0.zip Issues related to memory leaks in dbConnect() and friends have been addressed, and the long-standing \r issue for dbWriteTable() has been addressed. Please provide feedback on these if you can. Also, I'd like the windows/R developer community to provide some feedback on the points below regarding how I've changed the build process: 1.a For previous RMySQL releases, there had been some incantations with reimp (utility in mingw NOT distributed in the latest Rtools.exe [not that it needs to be either]) and dlltool to create an appropriate libmysql.a library to link against. For 0.6-1 and 0.7-0 I could not get this to work. Instead, I chose to place the path to libmysql.lib right into the PKG_LIBS variable. For instance, this is my Makevars.win after an R CMD INSTALL: PKG_CPPFLAGS = -Ic:/PROGRA~1/MYSQL/MYSQLS~1.1/include PKG_LIBS = c:/PROGRA~1/MYSQL/MYSQLS~1.1/lib/opt/libmysql.lib 1.b In addition, binary releases up to and including 0.6-1 installed libmysql.lib and libmysq.dll into the package lib directory, while only the dll is installed for 0.7-0; the lib simply was not needed. 2. Previous RMySQL releases had the installer edit both configure.win and Makevars.win with appropriate paths. I've changed this so that the install only needs to set the env var MYSQL_HOME to an appropriate value, and if one is not provided, a default is chosen. Should a default be chosen or should configure.win fail? TIA, Jeff -- http://biostat.mc.vanderbilt.edu/JeffreyHorner
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
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