<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 12pt Times New Roman; COLOR: #000000">
<DIV> </DIV>
<DIV> </DIV>
<DIV>--<BR>Ricardo Rodríguez<BR>Your EPEC ICT Team>>> Jeff Ryan<jeff.a.ryan@gmail.com> 2/11/2006 03:39 >>><BR></DIV>
<DIV style="COLOR: #000000">>Ricardo,<BR>><BR>>What does your /users/rrodriguez/Desktop/mysql-5.0.27 directory look<BR>>like? Can you find the libmysqlclient anywhere using<BR>>Spotlight/find/locate...?<BR>><BR>>my lib directory put down by the MySQL binary install (I **think** it<BR>>was a binary install - my only mac at the moment is a weak ibook, that<BR>>takes so long to compile anything on I don't usually bother) looks<BR>>like:<BR>><BR>>[veblen:~] jryan% ls /usr/local/mysql/lib<BR>>libdbug.a libmysqlclient.a libmysys.a<BR>>libmygcc.a libmysqlclient_r.a libz.a<BR>>libmysql.imp libmystrings.a<BR>><BR>>Actually now that I think of it I may have been using the DarwinPorts<BR>>version - though it really shouldn't matter at this stage - that would<BR>>be another error if there was some sort of compat problem.<BR>><BR>>if you can locate it - use the export procedure as you did before -<BR>>only point to the directory that you find it in. You may need to<BR>>build it from scratch. Like I said previously, NOTHING has caused me<BR>>more headaches than getting RMySQL to build.<BR>><BR>>Keep us posted.<BR>>Jeff</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">
<DIV>Hi, Jeff, Paul, Simon, all,</DIV>
<DIV> </DIV>
<DIV>It seems to me that I have gone into trouble waters without the required skills! Well, it is a way to gain knowledge. I do hope colleagues out there don't mind this kind of questions.</DIV>
<DIV> </DIV>
<DIV>I think that I am doing things without a clear idea about what I do and/or what I must.</DIV>
<DIV> </DIV>
<DIV>First of all, concerning MySQL, I have a MySQL running instance installed from an universal binary, mysql-max-5.0.27-osx10.4-i686.dmg. It installs/start/stop without a glitch. Here the content of its /mysql/lib folder...</DIV>
<DIV> </DIV>
<DIV>ricardo-rodriguezs-computer:/usr/local/mysql/lib rrodriguez$ ls<BR>libdbug.a libmysqlclient_r.a libndbclient.la<BR>libmygcc.a libmystrings.a libz.a<BR>libmysql.imp libmysys.a<BR>libmysqlclient.a libndbclient.a</DIV>
<DIV> </DIV>
<DIV>Whithin this directory I can found two libmysqlclient*.* files: libmysqlclient.a and libmysqlclient_r.a. </DIV>
<DIV> </DIV>
<DIV>I have also downloaded and exploded to Desktop a mysql-5.0.27.tar.gz file. I can find libmysqlclient.la in /Desktop/mysql-5.0.27/libmysql folder.</DIV>
<DIV> </DIV>
<DIV>Whatever directory I point to by exporting PKG_CPPFLAGS and PKG_LIBS, I get different errors when I try to build RMySQL.</DIV>
<DIV> </DIV>
<DIV>I can post here each output, but perhaps it could be useful to know what we are looking for and what must we try.</DIV>
<DIV> </DIV>
<DIV>One preliminary question, please, what is the difference between a *.l, a *.la and a *r.a files with the same "name"? What file does content the libraries needed at building time?</DIV>
<DIV> </DIV>
<DIV>As for the compression libraries, Paul is having problems with that, this issue has been solved here by installing the Xcode Tools included with the bundled installation DVD. Just insert the installation DVD, open the Xcode Tools and install then by double-clicking the XcodeTools.mpkg file.</DIV>
<DIV> </DIV>
<DIV>As for last Simon's message in this sam thread, please, does it mean that the problem rely in the RMySQL available release at CRAN?</DIV>
<DIV> </DIV>
<DIV>Sorry if I am messing things!</DIV>
<DIV> </DIV>
<DIV>All the best,</DIV>
<DIV> </DIV>
<DIV>Ricardo</DIV></DIV></BODY></HTML>