<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>Done, Simon!</DIV>
<DIV> </DIV>
<DIV>--<BR>Ricardo Rodríguez<BR>Your EPEC ICT Team<BR><BR>>>> Simon Urbanek<simon.urbanek@r-project.org> 4/11/2006 22:09 >>><BR></DIV>
<DIV style="COLOR: #000000">>Ricardo,<BR><BR>On Nov 4, 2006, at 2:50 PM, Ricardo Rodríguez - Your EPEC ICT Team <BR>wrote:<BR></DIV>
<DIV style="COLOR: #000000">>HFS+ is case insensitive by default so it shouldn't matter. However, <BR>>you're passing the wrong directories anyway - mysql sources won't <BR>>work for this.<BR></DIV>
<DIV style="COLOR: #000000">So, it is Bourne's shell what is making the HFS+ looks like case sensitive?<BR></DIV>
<DIV style="COLOR: #000000">>I don't think you really want to do this, especially if you're not <BR>>sure what you're doing. You can get mysql binary from the MySQL pages <BR>>(and apparently you have it already). Compiling MySQL may be a nice <BR>>exercise, but I would recommend you to get RMySQL compiled first as <BR>>it is much easier.<BR></DIV>
<DIV style="COLOR: #000000">Agreed! Yes, I've already downloaded and installed MySQL binary. It runs without a glitch.</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">>Those are the static libraries that you can use if you compile RMySQL <BR>>from sources - the -L flag tells the compile where to look for them <BR>>(that's why it says PKG_LIBS='-L/usr/local/mysql/lib -l <BR>>libmysqlclient').<BR></DIV>
<DIV style="COLOR: #000000">This is now clearer for me. Thus, .la files must be source files binary libraries are compiled from. Am I right?</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">Another issue there: -<STRONG>l</STRONG>mysqlclient at PKS_LIBS works here. -<STRONG>lib</STRONG>mysqlclient doesn't. Does it work for you? Why this -libmysqlclient doesn't work here then? </DIV>
<DIV style="COLOR: #000000"><BR>>A quick look at config.log would tell you - that is the first step <BR>>you should take when something goes wrong. I don't remember if the <BR>>first post was from you, but if it fails at -lz already, then the <BR>>problem is more likely your tools and not the way you set the flags. <BR>>Please use the PKG_xx settings I posted and send me your config.log <BR>>if in doubt.</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">From the whole log file there are a couple of things are calling my attention:</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">1. Why these two NO at checking for mysql_init in -lmysqlclient and checking for mysql.h?</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">* Installing *source* package 'RMySQL' ...<BR>creating cache ./config.cache<BR>checking how to run the C preprocessor... cc -E<BR>checking for compress in -lz... yes<BR>checking for getopt_long in -lc... yes<BR>checking for mysql_init in -lmysqlclient... no<BR>checking for mysql.h... no<BR>updating cache ./config.cache<BR>creating ./config.status<BR>creating src/Makevars</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">2. There are a number of warning multiple definitions of symbol _xxxxx. Do they matter?</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">In spite of these, at the end a clear * DONE (RMySQL) appears!</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">I've tried the same syntax before, but I'd not installed DBI before trying to build RMySQL. That was another error on my side.<BR><BR>Once more, thanks for your help,</DIV>
<DIV style="COLOR: #000000"> </DIV>
<DIV style="COLOR: #000000">Ricardo<BR></DIV></BODY></HTML>