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

Trond Rafoss trond.rafoss at planteforsk.no
Wed Nov 12 20:53:34 CET 2003

Hi Arend, I had the same problem on RH 9 as you, but the tip on http://stat.bell-labs.com/RS-DBI/download/index.html at the bottom telling:

The following are some workarounds: 

append the line 

to the file $R_HOME/src/library/methods/NAMESPACE where $R_HOME refers to the directory where you have R 1.8.0 installed. 

fixed the problem for me, and I can use RMySQL successfully on RedHat 9 !

Regards, Trond Rafoss

-----Original Message-----
From:	Arend P. van der Veen [mailto:apv at capital.net]
Sent:	Wed 11/12/2003 7:36 PM
To:	r-help at stat.math.ethz.ch
Subject:	Re: [R] RMySQL & couldn't find function ".valueClassTest"
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.

R-help at stat.math.ethz.ch mailing list

More information about the R-help mailing list