[R] install RMySQL

[Xander Meadow]

Hi,

Thank you so much for the help.  After setting the environment variables
I was able to install RMySQL.  Thanks again.


>Xander

On Thu, 2005-02-10 at 10:09, Don MacQueen wrote:
> 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
>