[R] RMySQL : Mac : bus error at dbConnect time

Geoff Grimwood geoff.grimwood at paradise.net.nz
Sun Jan 18 22:00:47 CET 2004

Any help on this will be greatly appreciated.



Version 1.8.1 Patched (2004-01-15), ISBN 3-900051-00-3

 >   library(RMySQL)
 >   library(DBI)
 >   drv<-dbDriver("MySQL")
 > drv
 > dbConnect(drv,dbname="mysql",user="root",password="******")
Bus error

RMySQL 0.5-3
MySQL is working fine and is 4.0.17
R is fine apart from this
Mac OS 10.2.8, fink, et al (a big et al)

R built using

  ./configure --enable-R-shlib --with-blas=-framework vecLib 

(It fails to build using ./configure with no options)

RMySQL installed using

setenv PKG_CPPFLAGS '-I/usr/local/mysql/include -I/sw/include/gnugetopt'
setenv PKG_LIBS '-L/usr/local/mysql/lib -lmysqlclient -lgnugetopt'
R CMD INSTALL --configure-args='--with-mysql-dir=/usr/local/mysql' 

[SIDLAW02:~geoff/heaven/src] root# mysql_config
Usage: /usr/local/mysql/bin/mysql_config [OPTIONS]
         --cflags         [-I/usr/local/mysql/include -O3 
         --include        [-I/usr/local/mysql/include]
         --libs           [-L/usr/local/mysql/lib -lmysqlclient -lz -lm]
         --libs_r         [-L/usr/local/mysql/lib -lmysqlclient_r -lz 
         --socket         [/tmp/mysql.sock]
         --port           [3306]
         --version        [4.0.17]
         --libmysqld-libs [-L/usr/local/mysql/lib -lmysqld -lz -lm]

More information about the R-help mailing list