Skip to content

Connection problem with RMySQL

2 messages · Andrea Mestriner, David James

Original
Andrea Mestriner
# 
Hi,

I hope eveyone can help me. I use DBI and RMySQL library to connect R
2.4 from my iBook G4 to a MySQL db. The problem is that if I connect R
to my remote Linux Server thwe connect is ok, but when i try to
connect to offline db (RMySQL of my iBook) R get a crash.

The connection command is:

MySQL(max.con=16, fetch.default.rec=500, force.reload=F)
m<-dbDriver("MySQL")
connessione<-dbConnect(m,user="reteinterna",password="reikem",host="127.0.0.1",dbname="data")

The error message is:

*** caught bus error ***
address 0x54, cause 'invalid alignment'

Traceback:
1: .Call("RS_MySQL_newConnection", drvID, con.params, groups,
default.file, PACKAGE= . MySQLPKgName)
2: mysqlNewConnection(drv, ...)
3: .class1(object)
4: .class1(object)
5: is(object, Cl)
6: .valueClassTest(standardGeneric("dbConnect"),"DBIConnection","dbConnect")
7: dbConnect(m,user="reteinterna",password="reikem",host="127.0.0.1",dbname="data")

Possible actions:
1: abort (with core dump)
2: normal R exit
3: exit R without saving workspace
4: exit R saving workspace


What's the problem?

Thanks,

Andrea
David James
# 
Hi,

This is a bug in RMySQL that I'll be fixing in the next couple of days.  If
you need to fix it right now, contact me offline for details.

Regards,

--
David
On 12/14/06, Andrea Mestriner <andrea.mestriner at gmail.com> wrote: