Problems in installing packages RODBC and rCharts on a shiny server (Ubuntu 13.04)

[Alain Vanlanduyt]

Hi

I want to install  RODBC and rCharts (with devtools) on a shiny server, the error messages are as follows.

Can someone help me?

Thanks

My sessionInfo() :

sessionInfo()
R version 3.0.1 (2013-05-16)
Platform: i686-pc-linux-gnu (32-bit)

locale:
 [1] LC_CTYPE=fr_BE.UTF-8       LC_NUMERIC=C             
 [3] LC_TIME=fr_BE.UTF-8        LC_COLLATE=fr_BE.UTF-8   
 [5] LC_MONETARY=fr_BE.UTF-8    LC_MESSAGES=fr_BE.UTF-8  
 [7] LC_PAPER=C                 LC_NAME=C                
 [9] LC_ADDRESS=C               LC_TELEPHONE=C           
[11] LC_MEASUREMENT=fr_BE.UTF-8 LC_IDENTIFICATION=C      

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base    

loaded via a namespace (and not attached):
[1] tools_3.0.1



install.packages('RODBC', repos='http://cran.r-project.org//')
Installing package into ‘/usr/local/lib/R/site-library’
(as ‘lib’ is unspecified)
essai de l'URL 'http://cran.r-project.org//src/contrib/RODBC_1.3-8.tar.gz'
Content type 'application/x-gzip' length 1087673 bytes (1.0 Mb)
URL ouverte
==================================================
downloaded 1.0 Mb
* installing *source* package ‘RODBC’ ...
** package ‘RODBC’ correctement décompressé et sommes MD5 vérifiées
checking for gcc... gcc -std=gnu99
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc -std=gnu99 accepts -g... yes
checking for gcc -std=gnu99 option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -std=gnu99 -E
checking for egrep... grep -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking sql.h usability... no
checking sql.h presence... no
checking for sql.h... no
checking sqlext.h usability... no
checking sqlext.h presence... no
checking for sqlext.h... no
configure: error: "ODBC headers sql.h and sqlext.h not found"
ERROR: configuration failed for package ‘RODBC’
* removing ‘/usr/local/lib/R/site-library/RODBC’



install.packages('devtools')
Installing package into ‘/usr/local/lib/R/site-library’
(as ‘lib’ is unspecified)
also installing the dependencies ‘stringr’, ‘httr’, ‘RCurl’, ‘memoise’, ‘whisker’, ‘evaluate’

...


ERROR: dependency ‘RCurl’ is not available for package ‘httr’
* removing ‘/usr/local/lib/R/site-library/httr’
* installing *source* package ‘evaluate’ ...
** package ‘evaluate’ correctement décompressé et sommes MD5 vérifiées
** R
** inst
** preparing package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded
* DONE (evaluate)
ERROR: dependencies ‘httr’, ‘RCurl’ are not available for package ‘devtools’
* removing ‘/usr/local/lib/R/site-library/devtools’

[Justin Freels]

I installed the dependencies one by one (and installed their dependencies as needed).

For example to install devtools, start by installing ‘stringr’, ‘httr’, ‘RCurl’, ‘memoise’, ‘whisker’, ‘evaluate’ first. If those have dependencies, install those dependencies first.