Tom, I'm not a pro at building and compiling things either, so I'm not sure what those errors mean. All I can tell you is the combination that worked for me. Again, I have OS X 10.4.5, Xcode 2.2.1, R2.2.1, RMySQL 0.5-7, and mySQL 5.0.18 (from mysql.com). Then I used the exact commands I gave you below - you only have to change the location of the RMySQL tar file (mine was sitting on my desktop).
Otherwise, you might try to contact Simon Urbanek on the R-sig-Mac list ([email protected]). He's the one who put me up to the solution of using the gcc 3.3 compiler, which worked for me. Best of luck, - Jason Jason Horn Boston University Department of Biology 5 Cumington Street Boston, MA 02215 [EMAIL PROTECTED] office: 617 353 6987 cell: 401 588 2766 On Feb 22, 2006, at 7:59 AM, Tom Love wrote: > Thanks for the suggestion. The compile fails with the error: > > ld: truncated or malformed archive: /usr/local/mysql/lib/ > libmysqlclient.a (ranlib structures in table of contents extends > past the end of the table of contents, can't load from it) > ld: warning multiple definitions of symbol _signgam > /Library/Frameworks/R.framework/../R.framework/R(lgamma.lo) > definition of _signgam > /usr/lib/libSystem.dylib(gamma9.o) definition of _signgam > > Can you suggest anything? Sorry to bug you, but I'm working > essentially on my own on this, at the moment, and it's new to me! > > Tom > > -----Original Message----- > From: Jason Horn [mailto:[EMAIL PROTECTED] > Sent: Tue 2/21/2006 1:57 PM > To: Tom Love > Subject: Re: RMySQL > > Tom, > > Don't bother with compiling mySQL from source. you shouldn't need > to. I have everything working with OS X 10.4.5, R 2.2.1, and mySQL > 5.0.18. The solution is to recompile the latest version of RMySQL > from source using the gcc 3.3 compiler (and not gcc4). > > 1) Download the RMySQL source from CRAN > 2) sudo gcc_select 3.3 > 3) PKG_CPPFLAGS=-I/usr/local/mysql/include PKG_LIBS='-L/usr/local/ > mysql/lib -lmysqlclient -lSystemStubs' R CMD INSTALL /Users/jason/ > Desktop/RMySQL_0.5-7.tar.gz.tar > > That worked for me. > > - Jason > > On Feb 21, 2006, at 5:59 AM, Tom Love wrote: > > > Hi Jason, > > > > > > > > I have RmySQL working on a mac - sort of. I did a post a couple of > > days ago because I can make it go, but it crashes if I try to > > extract more than one field at a time. I have the same error > > message as you, which is probably related to the problem, and I > > have tried installing different versions of MySQL to see if that > > fixes it, which it doesn't. I am about to try installing from > > source, although this is not something that I'm massively familiar > > with. I didn't see any post following up your query. Did you get > > any response to your problem off the list? > > > > > > > > Tom > > > > > > > > -------------------------------------------- > > > > Tom Love > > > > CSO Research Training Fellow > > > > Tayside Centre for General Practice > > > > Kirsty Semple Way > > > > Dundee, DD2 1BF > > > > ph 01382 420022 > > > > > > > > > > > [[alternative HTML version deleted]] _______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
