[R] RMySQL & couldn't find function ".valueClassTest"

Arend P. van der Veen apv at capital.net
Wed Nov 12 19:36:32 CET 2003

I compile MySQL from source and do have the client libraries installed
(I can run mysql from a terminal)  However, I was able to compile RMySQL

# export PKG_CPPFLAGS="-I/opt/mysql/include"
# export PKG_LIBS="-L/opt/mysql/lib -lmysqlclient"
# R CMD INSTALL RMySQL_0.5-2.tar.gz

Now I am having the problem that was mentioned at 



> m <- dbDriver("MySQL")
> Error in dbDriver("MySQL") : couldn't find function ".valueClassTest"

One of the solutions was to patch R 1.8.0.  I downloaded R-release.diff.gz but I am not
sure what to do with it.  Does anybody know of any documentation that can
guide me ?

Thanks again,
Arend van der Veen

On Wed, 2003-11-12 at 13:03, Prof Brian Ripley wrote:
> Do you actually have the MySQL client libraries installed?  They are in a
> separate RPM, if you used RPMs, something like
> MySQL-client-4.0.16-0.i386.rpm.
> On 12 Nov 2003, Arend P. van der Veen wrote:
> > I have been having trouble installing RMySQL under Redhat Linux 9.0.  I
> > am using R 1.8.0 and MySQL 4.0.13.  MySQL is install in /opt/mysql.  I
> > try to install RMySQL using configure-args to specify the path of mysql
> > but it does not work.  Does any body have any suggestions.

More information about the R-help mailing list