similar to: Re: [RMySQL] unable to establish connection since R-1.8.0 upgrade

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

I am a newbie in R and want to use MySQL database. Here is what I have and done. R 1.8.0 mysql 4.0.16 Both running in Windows XP. I download the RMySQL.zip from the internet and used the Packages installer in the RGui to install RMySQL. I also installed DBI packages. I ran the following and got the error. > mgr<-dbDriver("MySQL") Error in dbDriver("MySQL") :

Hello, I have trouble installing and loading the RMySQL package on OS X 2.8. The package seems to install from source fine (using R package manager from within the R environment). I have the following error when I try to load the package: loading package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Jeff, the tip on http://stat.bell-labs.com/RS-DBI/download/index.html (at the bottom of the page) may help. Trond Rafoss -----Opprinnelig melding----- Fra: Jeff Lee [mailto:JLee at acamllc.com] Sendt: 10. desember 2003 23:34 Til: 'r-help at stat.math.ethz.ch' Emne: [R] How to start RMySQL I am a newbie in R and want to use MySQL database. Here is what I have and done. R 1.8.0 mysql

I don't use MySQL but I have seen messages like this before. They often have replies which indicate that you need to follow the instructions more closely. I suggest you search the list for these previous posts as I'm sure there is help there, somewhere! Tom > -----Original Message----- > From: Adriano von Sydow [mailto:pdasilva at xtra.co.nz] > Sent: Thursday, 10 March 2005 5:13

Since there doesn't appear to be an RMySQL rpm for SuSE 8.*, does anyone know if the 7.3 version will work with the SuSE 8.2 rpms of R and DBI? The package installs without complaint, but when I try to run con <- dbConnect(dbDriver("MySQL"),dbname="test") I get the error Error in dbConnect(dbDriver("MySQL")) : couldn't find function

Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MYSQL driver: ------------------------------------------------------------------------------------ > library("RMySQL") Loading required package: DBI >

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no such file" error, but all the files do exist, RMySQL.so and

Hello, I have a problem.. I'm trying to make R communicate with MySQL, but I always receive an error.. My code is: library(DBI) library(RMySQL) drv <- dbDriver("MySQL") conn<-dbConnect(drv,username="####",password="####",dbname="prova",host="localhost") and I receive this message: Errore in function (classes, fdef, mtable) :

Hi there. I see in a post from 2002 that you got the following problem with RMySQL: > con <- dbConnect(m) Process R segmentation fault at Wed Aug 28 08:21:11 2002 I have the same problem today: drv=dbDriver("MySQL") dbConnect(drv) # or with pretty much any other failing options Program received signal SIGSEGV, Segmentation fault. 0x00002b28d60c9fa0 in strlen () from

Hi, I am having trouble getting RMySQL running on a solaris machine. [43] bedrock:/home/jayoung/source_codes/R/other_packages> uname -a SunOS bedrock 5.10 Generic_118833-36 sun4v sparc SUNW,Sun-Fire-T200 I thought I had finally managed to get it installed, albeit with some warnings that I didn't understand (it took me a while to find where our mysql libraries were), but when I tried

According David Jame's response to my earlier question, there is a problem with setGeneric.setMethod in R 1.8.0 that affects DBI and RMySQL. Is there a fix for this? David Jame's refers to an 'R-patched version' but I haven't seen anything like this on CRAN. Would going back to an older version of R solve the problem? Thanks, Barnet Wagman "David James wrote:

Hi all, I'm using the latest RMySQL to send requests to a MySQL database (which is quite small for the time - let's say 20 tables with a total of 1000 rows), and this should be part of a whole decisionnal system. It produces results which are displayed on a website, and therefore I need fast results (the database being quite small, I think this must be possible !). Unfortunately, a

I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the following error message when trying to run a script with RMySQL: Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? Any ideas? Thanks, Frank

Hi All, Sorry to bother everyone again.Ofcourse Prof Ripley ,Yihui and Uwe had replied to my email.But this segmentation fault error was not solved.I agree with Prof Ripley,as he said my R and all other configurations,are very old.But what i don't understand is ,i was able to run analysis till few days before,and why suddenly this error. *The configuartions i use:---* *R-version * *>

Hi all, I have to call R from PHP code. I manage to run R and to make it parse my script (see below) but I have an error which I cannot cope with yet while running the PHP page: Error in file("/home/faisnel/Rscripts/testphp2.Rout", open = "wt") : unable to open connection In addition: Warning message: cannot open file `/home/faisnel/Rscripts/testphp2.Rout' Execution

Hello, I'm tearing my hair out over this. Any help will be very much appreciated. It's been two long nights battling with RMySQL. > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/usr/local/lib/R/library/RMySQL/libs/RMySQL.so": dlcompat: dyld: /usr/local/lib/R/bin/R.bin Undefined symbols: _getopt_long

HI, 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. Thanks, Arend van der Veen The command that I am using is: # R CMD INSTALL

List, Last week with the help of Uwe and some other folks I was able to get RMySQL 0.5-7 compiled against R 2.4.1 and MySQL 5.0.27. It was working fine--I was able to send select queries to the db, put the results in a data frame, and so forth. Today, dbDriver() threw an error: > dbDriver(MySQL) Error in function (classes, fdef, mtable) : unable to find an inherited method for

I am trying something I haven't attempted before and the available documentation doesn't quite answer my questions (at least in a way I can understand). My usual course of action would be to extract my data from my DB, do whatever manipulation is necessary, either manually or using a C++ program, and then import the data into R. Now I need to try to do it all within R+RMySQL+MySQL. I