RMySQL install failure
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
<webmaster at environmentalchange.net> 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 at 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