Ricardo, What does your /users/rrodriguez/Desktop/mysql-5.0.27 directory look like? Can you find the libmysqlclient anywhere using Spotlight/find/locate...?
my lib directory put down by the MySQL binary install (I **think** it was a binary install - my only mac at the moment is a weak ibook, that takes so long to compile anything on I don't usually bother) looks like: [veblen:~] jryan% ls /usr/local/mysql/lib libdbug.a libmysqlclient.a libmysys.a libmygcc.a libmysqlclient_r.a libz.a libmysql.imp libmystrings.a Actually now that I think of it I may have been using the DarwinPorts version - though it really shouldn't matter at this stage - that would be another error if there was some sort of compat problem. if you can locate it - use the export procedure as you did before - only point to the directory that you find it in. You may need to build it from scratch. Like I said previously, NOTHING has caused me more headaches than getting RMySQL to build. Keep us posted. Jeff On 11/1/06, Ricardo Rodríguez - Your EPEC ICT Team <[EMAIL PROTECTED]> wrote: > > > On Nov 1, 2006, at 3:04 PM, P. B. Pynsent wrote: > > I wonder if anybody has successfully got the RMySQL installation > working? > > I have followed the instructions (both approaches) given on the build > failure CRAN site but still get a configuration error. > > WARNING: ignoring environment value of R_HOME > * Installing *source* package 'RMySQL' ... > creating cache ./config.cache > checking how to run the C preprocessor... > The downloaded packages are in > /private/tmp/RtmpNiFrHt/downloaded_packages > /lib/cpp > checking for compress in -lz... no > checking for getopt_long in -lc... no > checking for mysql_init in -lmysqlclient... no > checking for mysql.h... no > checking for mysql_init in -lmysqlclient... no > checking for mysql_init in -lmysqlclient... no > checking for mysql_init in -lmysqlclient... no > checking for mysql_init in -lmysqlclient... no > checking for mysql_init in -lmysqlclient... no > > Configuration error: > Could not locate the library "libz" required by MySQL. > > INSTRUCTIONS: > > The "libz" library is required by the MySQL client library > in order to compress/uncompress connections between clients > and the MySQL engine. > > Make sure you have "libz" installed properly and/or included > in your $LD_LIBRARY_PATH. Perhaps it is not in any of the > standard directories (e.g., /usr/lib/, /usr/local/lib)? > > Aborting the installation of RMySQL. > > ** Removing '/Users/paul/Library/R/library/RMySQL' > ** Restoring previous > '/Users/paul/Library/R/library/RMySQL' > ERROR: configuration failed for package 'RMySQL' > > > R.version > _ > platform powerpc-apple-darwin8.7.0 > arch powerpc > os darwin8.7.0 > system powerpc, darwin8.7.0 > status > major 2 > minor 4.0 > year 2006 > month 10 > day 03 > svn rev 39566 > language R > version.string R version 2.4.0 (2006-10-03) > > Mac OS 10.4.8 4 x 2.5GHz G5 > > A similar error message is produced on my MacBook Pro running R 2.4.0. > > zlib is in /usr/lib. I should be grateful for any suggestions. > > Many thanks, > > Paul > > > P. B. Pynsent, > Research & Teaching Centre, > Royal Orthopaedic Hospital, > Northfield, > Birmingham, B31 2AP, > U. K. > > _______________________________________________ > R-SIG-Mac mailing list > R-SIG-Mac@stat.math.ethz.ch > https://stat.ethz.ch/mailman/listinfo/r-sig-mac > > > Hi, Paul, > > I'm also struggling to get RMySQL up and running over here. My installation: > > > R.version > _ > platform i386-apple-darwin8.6.1 > arch i386 > os darwin8.6.1 > system i386, darwin8.6.1 > status > major 2 > minor 3.1 > year 2006 > month 06 > day 01 > svn rev 38247 > language R > version.string Version 2.3.1 (2006-06-01) > > I have luckily receive a message from Jeff Ryan pointing to the key of the > problem: to get a MySQL distribution including headers and the client > library. He speaks about a "developer distribution", but I am not able to > find such a thing for Mac/Intel (neither for Mac/PPC!) I am currently trying > the source distribution trying to build it here, but I'm facing a number of > problems so far. > > As for the compression libraries, I've installed the XTools package included > with the installation DVD bundled with our last MacBooks. > > By downloading mysql-5.0.27.tar.gz, exploding it and exporting the concerned > variables as following, I get the messages included below... > > export > PKG_CPPFLAGS="-I/users/rrodriguez/Desktop/mysql-5.0.27/include" > export > PKG_LIBS="-L/users/rrodriguez/Desktop/mysql-5.0.27/lib > -lmysqlclient" > R CMD INSTALL RMySQL_0.5-9.tar.gz > > ricardo-rodriguezs-computer:/Users/rrodriguez/Desktop root# > R CMD INSTALL RMySQL_0.5-9.tar.gz > * Installing *source* package 'RMySQL' ... > creating cache ./config.cache > checking how to run the C preprocessor... cc -E > checking for compress in -lz... yes > checking for getopt_long in -lc... yes > checking for mysql_init in -lmysqlclient... no > checking for mysql.h... no > updating cache ./config.cache > creating ./config.status > creating src/Makevars > ** libs > ** arch - i386 > gcc-4.0 -arch i386 > -I/Library/Frameworks/R.framework/Resources/include > -I/Library/Frameworks/R.framework/Resources/include/i386 > -I/users/rrodriguez/Desktop/mysql-5.0.27/include -msse3 > -D__NO_MATH_INLINES -fPIC -fno-common -g -O2 -std=gnu99 -march=pentium-m > -mtune=prescott -c RS-DBI.c -o RS-DBI.o > gcc-4.0 -arch i386 > -I/Library/Frameworks/R.framework/Resources/include > -I/Library/Frameworks/R.framework/Resources/include/i386 > -I/users/rrodriguez/Desktop/mysql-5.0.27/include -msse3 > -D__NO_MATH_INLINES -fPIC -fno-common -g -O2 -std=gnu99 -march=pentium-m > -mtune=prescott -c RS-MySQL.c -o RS-MySQL.o > gcc-4.0 -arch i386 -flat_namespace -bundle -undefined suppress > -L/usr/local/lib -o RMySQL.so RS-DBI.o RS-MySQL.o > -L/users/rrodriguez/Desktop/mysql-5.0.27/lib -lmysqlclient > -lz -L/Library/Frameworks/R.framework/Resources/lib/i386 > -lR > /usr/bin/ld: warning -L: directory name > (/users/rrodriguez/Desktop/mysql-5.0.27/lib) does not exist > /usr/bin/ld: can't locate file for: -lmysqlclient > collect2: ld returned 1 exit status > make: *** [RMySQL.so] Error 1 > chmod: > /Library/Frameworks/R.framework/Versions/2.3/Resources/library/RMySQL/libs/i386/*: > No such file or directory > ERROR: compilation failed for package 'RMySQL' > ** Removing > '/Library/Frameworks/R.framework/Versions/2.3/Resources/library/RMySQL' > ricardo-rodriguezs-computer:/Users/rrodriguez/Desktop root# > > In fact there is no /iib folder where the compilation process is calling for > it. I am guessing I must first build MySQL, then install it, then build > RMySQL, but I am afraid that my programer skills are too poor to solve this > issue! > > Currently I'm running MySQL max 5.0.27 for Mac/Intel in this box. By > pointing PKG_CPPFLAGS and PKG_LIBS to this directory I get a much, much > longer error log! > > Any input will be welcome! Thanks, > > -- > Ricardo Rodríguez > Your EPEC ICT Team > > > > _______________________________________________ R-SIG-Mac mailing list R-SIG-Mac@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac