similar to: Accessing MySQL Database in R

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)

Full_Name: Apfel Schmied Version: 2.8.1 (2008-12-22) OS: WinXP SP2 Submission from: (NULL) (134.106.122.139) RMySQL Version: 0.7-2 DBI Version: 0.2-4 MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set) Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when requesting data from a mysql database. Example Code:

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 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''m new Ruby as well as the Rails Framework. I want to install Passenger so that I can develop in MAMP (Leopard), but I can''t find any instructions specific to installing Passenger on MAMP. Can anyone provide with me instructions on how to do so? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups

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",

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

Is there something like MAMP, but uses PostgreSQL instead? I found a couple PostgreSQL dmg''s, but one was < 8.x. For those who use PostgreSQL on Mac, how''d you install it (fink, package, please don''t say compile!)? Thanks, Joe -- Posted via http://www.ruby-forum.com/.

Sorry mistake from me. This was another problem in my mind , but with RMySQL. Christian > library(RMySQL) > library(sqldf) > sqldf("Select * from mtcars") Fehler in mysqlNewConnection(drv, ...) : RS-DBI driver: (Failed to connect to database: Error: Access denied for user 'user'@'localhost' (using password: NO) ) Fehler in if (dbname ==

Quick question about the configuration files relative to RMySQL (I've tried to get feedback directly from the author David James, but his email address was non-responsive): Documentation at http://cran.r-project.org/doc/packages/RMySQL.pdf on page 3 indicates that for windows machines the only place that the my.cnf file will be looked for is the root (C:\) directory. Is this read correct?

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:

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

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

Hi, I am newbie and i am using MAMP with rails for trying out few things in web development. I just upgraded to rails 1.1 and created a new rails depot project and when i just gone to change my database.yml, I get this ------------------------------------------------------------------------------- development: adapter: mysql database: depot_development username: root password: root

Dear all, I have a very simple question. I am trying to find where islocated the rscript in mac os x. The r is installed in the applications folderbut I can not find the rscript. Thank you.Dimitris [[alternative HTML version deleted]]

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 |

I''m using Locomotive on MacOSX 10.4, and I have installed mysql 5.0.45. To my surprise, the Ruby version included in Locomotive does not come with the mysql gem installed, so I tried to install it manually. According to the instructions in database.yml, this should be done using the --include switch, like this: gem install mysql -- --include=/usr/local/lib I selected the mysql 2.7

Hello, I have been trying to deploy my Rails application using Passenger on my local machine that runs Mac OS X Tiger. I saw the screencast by Ryan Bates and also referred to benr75[http://benr75.com/articles/ 2008/04/12/setup-mod_rails-phusion-mac-os-x-leopard] for specific instructions for Mac (but they are for leopard). Right now if I go to http://localhost all I get is "It Works!".

Does anyone know a good authentication tutorial they can suggest? I''ve tried several restful authentication ones and an authlogic one on RailsCast. But with each one I try, something seems to be missing in the tutorial and I can''t get it to work. I''m new to Rails so it''s possible user error on my part. I''m on Mac OS X 10.5 and I generate all my apps in