[R] install RMySQL

[Don MacQueen]

I have a working installation of RMySQL in Mac OS X (10.3.7). I have 
libz in /usr/lib, as you do.
None of my personal installation notes mention doing anything special 
for /usr/lib/libz*.
My R was built from a source distribution; it is not a binary 
distribution. (version info below)

The only extra step I do is to define environment variables 
PKG_CPPFLAGS and PKG_LIBS,
like this:

mysql.home <- '/usr/local/mysql'
Sys.putenv('PKG_CPPFLAGS'=paste('-I',file.path(mysql.home,'include'),sep=''))
Sys.putenv('PKG_LIBS'=paste('-L',file.path(mysql.home,'lib'),' 
-lmysqlclient',sep=''))
install.packages('RMySQL')

You could try adding /usr/lib to PKG_LIBS.

-Don


>  version
          _                       
platform powerpc-apple-darwin6.8.5
arch     powerpc                 
os       darwin6.8.5             
system   powerpc, darwin6.8.5    
status                           
major    2                       
minor    0.1                     
year     2004                    
month    11                      
day      15                      
language R                       


RMySQL is 0.5-5


At 9:10 AM -0600 2/9/05, Xander  Meadow wrote:
>Hi,
>
>I'm still trying to get RMySQL installed on my Mac.  When I try and
>install from R (version 2.0.1) I'm told that the library "libz" can't be
>located.  It suggests checking in /usr/lib to see if I have the
>necessary libraries.  However, if I check /usr/lib I find I have the
>following:
>
>libz.1.1.3.dylib*
>libz.1.dylib*
>libz.dylib@
>
>Since I have the libraries that RMySQL needs to install I can't figure
>out why the installation is failing.  Does anyone have any thoughts on
>how to get RMySQL installed on my Mac?  Thanks so much.
>
>>Xander
>
>On Mon, 2005-02-07 at 13:52, Xander Meadow wrote:
>>  Hi,
>>
>>  Thank you for responding.  One thing I forgot to mention (although I'm
>>  guessing you figured it out anyway) is that I'm running Mac OS X.
>>
>>  I checked and I've got the file /usr/include/zlib.h installed on my
>>  machine.  Is this enough for R or does it need a more robust
>>  installation of zlib?  If this is enough, how do I let R know about the
>>  zlib.h file. If it's not, where should I get the correct zlib from?
>>  Thank you for any and all responses.
>>
>>  -Xander
>>
>>  On Mon, 2005-02-07 at 13:43, Roger D. Peng wrote:
>>  > R comes with it's own copy of zlib so even if it is compiled into R,
>>  > there isn't necessarily a system-wide installation of the library.
>>  > You may still need to install it.
>>  >
>>  > -roger
>>  >
>>  > Xander Meadow wrote:
>>  > > Hi,
>>  > >
>>  > > I've got a Dual G5 running 10.3.7 and I'm trying to install RMySQL.
>>  > > I've already got R up and running.  When I try the command
>>  > >
>>  > >
>>  > >>install.packages("RMySQL")
>>  > >
>>  > >
>>  > > It downloads a few things and then produces the following error:
>>  > > ---------------------------
>>  > > 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'
>>  > > ----------------------------
>>  > >
>>  > > However, if I check for libz I get:
>>  > >
>>  > >
>>  > >>capabilities("libz")
>>  > >
>>  > > libz
>>  > > TRUE
>>  > >
>>  > > I'm not sure what the problem is because R is telling me that it doesn't
>>  > > know where libz is, but then it's also telling me it does know where
>>  > > libz is.
>>  > >
>>  > > Has anyone else seen this problem or know how I can get RMySQL installed
>>  > > on my machine?
>>  > >
>>  > > Just as an added note I know that install.packages works because
>  > > >
>>  > >
>>  > >>install.packages("DBI")
>>  > >
>>  > >
>>  > > worked without a problem.
>>  > >
>>  > > Thanks again.
>>  > >
>>  > > -Xander
>>  > >
>>  > > ______________________________________________
>>  > > R-help at stat.math.ethz.ch mailing list
>>  > > https://stat.ethz.ch/mailman/listinfo/r-help
>>  > > PLEASE do read the posting guide! 
>>http://www.R-project.org/posting-guide.html
>>  > >
>>
>>  ______________________________________________
>>  R-help at stat.math.ethz.ch mailing list
>>  https://stat.ethz.ch/mailman/listinfo/r-help
>>  PLEASE do read the posting guide! 
>>http://www.R-project.org/posting-guide.html
>
>______________________________________________
>R-help at stat.math.ethz.ch mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html


-- 
--------------------------------------
Don MacQueen
Environmental Protection Department
Lawrence Livermore National Laboratory
Livermore, CA, USA