See also my previous post on Debian GNU-Linux installation on a Lenovo T400.
R installI used the Synaptic package manager to add the R repository for Debian from a nearby mirror, under : settings / repositories / other software / add.
Add this APT line:
deb http://cran.univ-paris1.fr/bin/linux/debian/ wheezy-cran3/
There was an error:
W: GPG error: http://cran.univ-paris1.fr wheezy-cran3/ Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 06F90DE5381BA480After looking at several forums, and this stackoverflow question, I installed debian-keyring and added the key with the commands:
gpg --keyserver pgpkeys.mit.edu --recv-key 06F90DE5381BA480I could then install R version 3 from the synaptic package manager.
gpg -a --export 06F90DE5381BA480 |sudo apt-key add -
RstudioI downloaded R-studio and installed it. There was a missing dependency for libjpeg62. I installed that package from Synaptic. Then ran the dpkg command to install rstudio.
dpkg -i rstudio-0.98.507-i386.deb
ToolsThen I installed Git in order to clone my R project from an online repository.
git clone project_repository_url
PackagesWithin Rstudio, I installed a few packages:
install.packages(c("plyr", "reshape2", "ggplot2"))
install.packages(c("xtable", "markdown", "devtools"))
devtoolsThe devtools packages requires a libcurl dev Debian package. You can install it at the shell prompt:
$ sudo apt-get install libcurl4-gnutls-devBack at the R prompt
install.packages("devtools")Other dependencies might be needed, the RStudio page on devtools recommends installing the Debian package r-base-dev.
dplyrThe dplyr package required the latest version of a Rcpp package. Which was not available on my CRAN mirror. I installed it from source, (based on this message):
install.packages("Rcpp", type = "source")
xlsxThe xlsx package installation complained:
configure: error: Cannot compile a simple JNI program. See config.log for details.
Make sure you have Java Development Kit installed and correctly registered in R.
If in doubt, re-run "R CMD javareconf" as root.
Required the latest version of java 7. (inspired by this post). I installed openjdk-7 from the synaptic package manager. Then ran
update-alternatives --config java# Choose java 7 as the default
R CMD javareconf
install.packages("xlsx") # worked
RMySQLMySQL client and server are installed on my system.
While installing RMySQL, I struggled with a configuration error:
could not find the MySQL installation include and/or libraryThis post has an answer (thanks!):
directories. Manually specify the location of the MySQL
libraries and the header files and re-run R CMD INSTALL.
sudo apt-get install libdbd-mysql libmysqlclient-devThat fixes the issue!
I can connect to the database
mychannel <- br="" dbconnect="" host="localhost" user="paul" ysql=""> password="***", dbname="dbname")->