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 (r-sig-mac@stat.math.ethz.ch).  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

jhorn@bu.edu
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:jhorn@bu.edu]
> 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]]

