[R-SIG-Mac] Connection problem with RMySQL

Andrea Mestriner andrea.mestriner at gmail.com
Thu Dec 14 12:28:59 CET 2006


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



More information about the R-SIG-Mac mailing list