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

[Arend P. van der Veen]

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
by:

# 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 

http://stat.bell-labs.com/RS-DBI/download/index.html

with

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