similar to: Connection problem to MySQL

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, Can anyone help me please?I don't know much about segmentation faults.I understand what it is,but why my script's throwing the error i don't know. This is my main function:---- *main<-function()* *{* * dbName<-"xyz_database"* * hostName<-"xyz.com"* * con<-myDbconnect(dbName,hostName) * *

Hi, I had my R to MySQL 5.0 connection working fine under 2.5.1 on Windows XP. My MySQL installation is local, not on a server and I could connect with: con <- dbConnect(MySQL(), dbname = "mydatabase", user="root", password="XX") I have updated to R 2.8.1 (RMySQL 0.7-2) but that same line of code yields: Error in mysqlNewConnection(drv, ...) : RS-DBI driver:

Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...). My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI)

Hello, A newbie to R. I am trying to use the exonmap package in R. According to the docs, the xmapDatabase() command should read the config file with all the connection parameters and connect to the DB. But i get the error shown below.... > xmapDatabase("Human") Error in mysqlNewConnection(dbDriver(drv), ...) : RS-DBI driver: (could not connect cagadmin at mysql2.cag.chop.edu on

Hi everybody, I'm having a problem with connecting to my MySQL database. Each time I try to connect library(RMySQL) m <- dbDriver("MySQL") con <- dbConnect (m, host="my_host",username="my_username", password="my_password", dbname="name_of_db") it says Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect

I get the following error trying to connect to a MySQL database: > library(RMySQL) Loading required package: DBI > drv<-dbDriver("MySQL") > con<-dbConnect(drv, user="hothand", password=xxx, host="localhost", dbname="hh03"); Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect hothand at localhost on dbname

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

Hello, I have access to my database via command line and through workbench, and have access on the grant tables: mysql> SELECT host,user,password,select_priv,insert_priv FROM user; +------+-------+-------------------------------------------+-------------+-------------+ | host | user | password | select_priv | insert_priv |

Hi, I was able to connect to a MySQL database (called "zooscan" and with a table "serie" under Win XP with R 1.6.2 using: > library(DBI) > library(RMySQL) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > drv <- dbDriver("MySQL") > con <- dbConnect(drv, dbname="zooscan") > dbExistsTable(con,

I have a local installation of MySQL on my computer. I enter the following to access MySQL from the command line: /Applications/MAMP/Library/bin/mysql -h localhost -u root -p I am then prompted for a password, and I use: root This connects me to MySQL in the command line. I now want to access MySQL databases in R. I enter the following: mysql <- dbDriver("MySQL") conn <-

---------- Forwarded message ---------- From: Moumita Das <das.moumita.online@gmail.com> Date: Sat, May 16, 2009 at 2:26 PM Subject: Cannot allocate a new database connection error To: r-help-request@r-project.org Hi friends, why do i keep getting this error?The program runs, twice and every third time i get this error.I have to quit.Again get teh R-prompt and then run the script. *Error

Dear All, I haven't seen any further comments about the problem that John Marsland first noted and that I also have: > library(DBI) > library(RMySQL) Warning message: DLL attempted to change FPU control word from 8001f to 9001f > mgr <- dbDriver("MySQL") > con <- dbConnect(mgr, host="localhost", dbname="marketing") upon which R dies...

Hi All, If you have already finished reading my previous emails regarding segmentation fault , please have a look at this .I think this may help you to diagnose the reason for the segmentation fault and help me,because i don't understand much. Rather than running the script using the command " source("new_regression.R") ", what I did was ,simply typed in the commands in

Hello r-help! My name is Dan McGoldrick, I am a statistical geneticist and I work with ontologies, AI and general genetic data analysis. I was wondering aabout the tryCatch function -- don't really understand the implimentation... What I would like to do is within an R API, test a mysql connection object for an error (server has gone away) and if the connection is functional leave it alone;

I have justed upgraded R v1.7.0 on Windows NT 4 and have installed the latest RMySQL (version 0.5-1)and DBI (version 0.1-5) packages. When I issue the following commands (tactfully adjusted) R just crashes and disappears, any ideas? require(RMySQL) m <- dbDriver("MySQL") con <- dbConnect(m, dbname="xxx", user="xxx", password="xxx",

Hi, I would to get the first letter of a word like: > title_cat TitleCat 1 Training I would like T from Training! Thnaks a lot for your help Sabine --------------------------------- T侀l侀chargez le ici ! [[alternative HTML version deleted]]

hello, to use the function plot3d, i should use the package R.basic! plot3d {R.basic} If people know exactly a site to load this package, please give me the URL! Thanks Sabine --------------------------------- [[alternative HTML version deleted]]

hi, My code: data<-matrix(data=c(0.425,0.5,0.75,0.125,0.25,0.475,0.375,0.25,0.625,0.5,0.1,0.125,0,0.25,0.25),nrow=3,ncol=5,byrow=TRUE, dimnames=list(c("Good","Medium","Bad"),c("Content","Logistic","Trainer","Supply","User contribution"))) plot(corresp(data,nf=2),xlim=c(-1,1),ylim=c(-1,1)); The plot is

Hi, I would like to do a polar graph (=star graph) ! is that graph existing on R? Because more softwares can do that but I don't found it on R! Thanks Sabine --------------------------------- ils, photos et vidéos ! [[alternative HTML version deleted]]