[R-SIG-Mac] RMySQL install failure

[Jeff Ryan]

Hello,

Sort of confused who I was talking to - plus I'm not registered on R-SIG-Mac so I don't think these replies are making it through.

One part (of many) to the RMySQL problems I was having was no zlib detected.  Looking through the Makefile inside the tar.gz RMySQL I noticed some comments relating to the error - they sort of dismissed them as not the package's problem, and said "oh well" if people couldn't figure it out.

Definetely check that the most recent XCode is installed, and your PATH variable is set to include all the related includes from the developer's tools.

Another thing you may try in uncompressing the RMySQL package like so:

$ tar -xvzf RMySQL....tar.gz (fill in your version)

And cd to the new directory. Read all the documentation there - e.g. README...

Try running the standard (unix not R standard) configure/make and look at the errors.  It may be a linker issue, or a permissions one, or something else.

You'll probably just have to discard the configure/build(make) process, but it may give you some hints as to what is causing the problems.

I haven't had a moment to try to rebuild my install, but as soon as I do I'll tell you how it went.

Jeff
------Original Message------
From: P. B. Pynsent
To: Jeff Ryan
Cc: r-sig-mac at stat.math.ethz.ch
Sent: Nov 2, 2006 11:49 AM
Subject: Re: [R-SIG-Mac] RMySQL install failure

Jeff,

Thank you for this information, unfortunately this made no difference:

$ ls /usr/local/mysql/lib
libdbug.a               libmysql.imp             
libmysqlclient_r.a      libmysys.a
libmygcc.a              libmysqlclient.a         
libmystrings.a          libz.a

$ export PKG_CPPFLAGS="-I/usr/local/mysql/include"

$ export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient"

$ sudo R CMD INSTALL RMySQL_0.5-10.tar.gz
* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... /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

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.

ERROR: configuration failed for package 'RMySQL'
** Removing '/Library/Frameworks/R.framework/Versions/2.4/Resources/ 
library/RMySQL'

Thanks,
Paul

On 2 Nov 2006, at 02:39, Jeff Ryan wrote:

> 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
>> sta