[R-SIG-Mac] RMySQL install failure

[P. B. Pynsent]

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.