[R] Database newbee problem...

[Fredrik Karlsson]

Hi and thank you all for your quick response,

Indeed, the version of R I am working on is 1.6.0 on a Debian Woody
 (stable) system. All the client and server MySQL packages report version 
 3.23.49-8. According to the MySQL web page, the current stable version of 
MySQL is 3.23.53. Development release is 4.0.4.

Could anyone please advice me on a version of MySQL that does work. 
For me, the important thing is to get a working MySQL <-> R connection
going.

Thanks!

/Fredrik


On Wed, Oct 16, 2002 at 08:55:08AM -0400, David James wrote:
> Hi Fredrik,
> 
> I've heard people running Debian having this problem, but
> I have only access to solaris, red-hat, and Irix systems.
> Could you tell me the exact versions of R (1.6.0, I presume),
> MySQL client and server?
> 
> thanks,
> 
> --
> David
> 
> Fredrik Karlsson wrote:
> > Hi all,
> > 
> > 
> > This is a potentially very stupid question about MySQL <-> R
> > interaction, but I have not been able to solve it.
> > I'm just trying to connect R to my MySQL databse, and gets this:
> > 
> > > library(RMySQL)
> > Loading required package: methods 
> > > m <- dbDriver("MySQL")
> > > con <- dbConnect(m,group="testdb")
> > 
> > Process R segmentation fault at Wed Oct 16 07:04:30 2002
> > 
> > My .my.conf contains this:
> > 
> > [client]
> > user = zak
> > host = localhost
> > password=<something>
> > 
> > [rs-dbi]
> > database = sdata
> > 
> > [testdb]
> > host = localhost
> > database = testDB
> > 
> > and connecting through the mysql client is no problem using those
> > settings:
> > 
> > $ mysql 
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 34 to server version: 3.23.49-log
> > 
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > 
> > mysql> use testDB
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> > 
> > Database changed
> > mysql> show tables;
> > 
> > +------------------+
> > | Tables_in_testDB |
> > +------------------+
> > | pet              |
> > +------------------+
> > 1 row in set (0.00 sec)
> > 
> > mysql>
> > 
> > 
> > What's wrong with my setup that's causing R to segfault (but not mysql
> > client)?
> > Any ideas?
> > 
> > /Fredrik
> > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> > r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> > Send "info", "help", or "[un]subscribe"
> > (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> > _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 
> -- 
> David A. James
> Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
> Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
> Murray Hill, NJ 09794-0636
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._