RMySQL Error Messages, crashing R
Jason, please consult the R FAQ for Mac OS X, this has been discussed many times - run sudo gcc_select 3.3 Just in case you are using Xcode 2.2.1, you may also want to read this: https://stat.ethz.ch/pipermail/r-sig-mac/2006-January/002593.html As it says, last time I checked, I had no problem using the stock MySQL libraries (i.e. simply the binary from www.mysql.com), no need to re-compile it. Cheers, Simon
On Feb 20, 2006, at 8:35 AM, Jason Horn wrote:
Phil, Thanks for the tip. I have tried rebuilding the RMySQL library, but it always fails. When I run: R CMD INSTALL --configure-args='--with-mysql-inc=/usr/local/mysql/ include --with-mysql-lib=/usr/local/mysql/lib' /Users/jason/Desktop/ RMySQL_0.5-7.tar.gz.tar I get ... gcc-3.3 -bundle -flat_namespace -undefined suppress -L/usr/local/lib - o RMySQL.so RS-DBI.o RS-MySQL.o -L/usr/local/mysql/lib -lmysqlclient - lz -lcc_dynamic -F/Library/Frameworks/R.framework/.. -framework R ld: can't locate file for: -lcc_dynamic make: *** [RMySQL.so] Error 1 ERROR: compilation failed for package 'RMySQL' The MySQL that I have is 5.0.18 that I downloaded as a binary directly from mysql.com. Is your mySQL installation from elsewhere? What do you mean "...that I installed through port." It sounds like you have everything working. What commands did you use to get mySQL 5 installed? To get RMySQL compiled? Any help here is appreciated. I am heavily dependent on R working with mySQL for my project.