Hello All, I tried to install RMySQL package, but the error messages says there is no such package, even though I did see RMySQL is there in the contributed package list in all mirror sites of CRAN I tried. Not sure what is the problem.> 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', repos "http://www.biometrics.mtu.edu/CRAN/",dependencies =T)dependency ''RMySQL'' is not available> install.packages('RMySQL', repos "http://www.biometrics.mtu.edu/CRAN/")Warning in download.packages(pkgs, destdir = tmpd, available = available, : no package 'RMySQL' at the repositories I tried download the package manually under unix, and install it from within R, and no luck too. cd ~/download/R curl -O http://www.biometrics.mtu.edu/CRAN/src/contrib/RMySQL_0.5-7.tar.gz> install.packages( 'RMySQL_0.5-7.tar.gz', repos NULL)Error in gzfile(file, "r") : unable to open connection In addition: Warning message: cannot open compressed file 'RMySQL_0.5-7.tar.gz/DESCRIPTION'>> sessionInfo()Version 2.3.0 (2006-04-24) powerpc-apple-darwin8.6.0 attached base packages: [1] "methods" "stats" "graphics" "grDevices" "utils" "datasets" [7] "base" could anybody tell me what happens here, and how to fix the problem? Thank you so much! Weijun
If this is R as installed from CRAN, it is by default looking for a binary and not a source package. Please study the `R Installation and Administration' manual. On Wed, 5 Jul 2006, Luo Weijun wrote:> Hello All, > > I tried to install RMySQL package, but the error > messages says there is no such package, even though I > did see RMySQL is there in the contributed package > list in all mirror sites of CRAN I tried. Not sure > what is the problem. > > > 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', repos > "http://www.biometrics.mtu.edu/CRAN/",dependencies =T) > dependency ''RMySQL'' is not available > > install.packages('RMySQL', repos > "http://www.biometrics.mtu.edu/CRAN/") > Warning in download.packages(pkgs, destdir = tmpd, > available = available, : > no package 'RMySQL' at the repositories > > I tried download the package manually under unix, and > install it from within R, and no luck too. > > cd ~/download/R > curl -O > http://www.biometrics.mtu.edu/CRAN/src/contrib/RMySQL_0.5-7.tar.gzAnd where did you run R from? I think you needed to give a full path here ....> > install.packages( 'RMySQL_0.5-7.tar.gz', repos > NULL) > Error in gzfile(file, "r") : unable to open connection > In addition: Warning message: > cannot open compressed file > 'RMySQL_0.5-7.tar.gz/DESCRIPTION' > > > > > sessionInfo() > Version 2.3.0 (2006-04-24) > powerpc-apple-darwin8.6.0 > > attached base packages: > [1] "methods" "stats" "graphics" "grDevices" > "utils" "datasets" > [7] "base" > > > could anybody tell me what happens here, and how to > fix the problem? Thank you so much! > Weijun > > ______________________________________________ > 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 >-- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Try
install.packages('RMySQL', repos
="http://www.biometrics.mtu.edu/CRAN/", dependencies=TRUE ,
type='source')
Check the help for install.packages() for an explanation of the
'type' argument, and some Mac-specific information about it.
-Don
At 10:00 AM -0700 7/5/06, Luo Weijun wrote:>Hello All,
>
>I tried to install RMySQL package, but the error
>messages says there is no such package, even though I
>did see RMySQL is there in the contributed package
>list in all mirror sites of CRAN I tried. Not sure
>what is the problem.
>
>> 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', repos
>"http://www.biometrics.mtu.edu/CRAN/",dependencies =T)
>dependency ''RMySQL'' is not available
> > install.packages('RMySQL', repos
>"http://www.biometrics.mtu.edu/CRAN/")
>Warning in download.packages(pkgs, destdir = tmpd,
>available = available, :
> no package 'RMySQL' at the repositories
>
>I tried download the package manually under unix, and
>install it from within R, and no luck too.
>
>cd ~/download/R
>curl -O
>http://www.biometrics.mtu.edu/CRAN/src/contrib/RMySQL_0.5-7.tar.gz
>
>> install.packages( 'RMySQL_0.5-7.tar.gz', repos >NULL)
>Error in gzfile(file, "r") : unable to open connection
>In addition: Warning message:
>cannot open compressed file
>'RMySQL_0.5-7.tar.gz/DESCRIPTION'
>>
>
>> sessionInfo()
>Version 2.3.0 (2006-04-24)
>powerpc-apple-darwin8.6.0
>
>attached base packages:
>[1] "methods" "stats" "graphics"
"grDevices"
>"utils" "datasets"
>[7] "base"
>
>
>could anybody tell me what happens here, and how to
>fix the problem? Thank you so much!
>Weijun
>
>______________________________________________
>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