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 export(.valueClassTest) 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:[EMAIL PROTECTED] Sent: Wed 11/12/2003 7:36 PM To: [EMAIL PROTECTED] Cc: 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 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. > ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help
