HI,
I tried to install ODBC package on the connect server, but it failed everytime. Do i have to anything different to install it on connect server. It founds the package, unpacks it and throws error.
[Connect] 2020/05/01 17:39:23.875032166 [1] "Command failed (1)\n\nFailed to run system command:\n\n\t'/opt/R/3.6.2/lib/R/bin/R' --vanilla CMD INSTALL --preclean '/opt/rstudio-connect/mnt/tmp/RtmpBO4k9e/odbc' --library='/opt/rstudio-connect/mnt/app/packrat/lib/x86_64-pc-linux-gnu/3.6.2' --install-tests --no-docs --no-multiarch --no-demo \n\nThe command failed with output:\n* installing source package ‘odbc’ ...\n** package ‘odbc’ successfully unpacked and MD5 sums checked\n** using staged installation\nmake: Makevars: No such file or directory\nmake: *** No rule to make target 'Makevars'. Stop.\nFound pkg-config cflags and libs!\nPKG_CFLAGS=\nPKG_LIBS=-lodbc\n:1:10: fatal error: sql.h: No such file or directory\ncompilation terminated.\n------------------------- ANTICONF ERROR ---------------------------\nConfiguration failed because odbc was not found. Try installing:\n * deb: unixodbc-dev (Debian, Ubuntu, etc)\n * rpm: unixODBC-devel (Fedora, CentOS, RHEL)\n * csw: unixodbc_dev (Solaris)\n * brew: u
[Connect] nixodbc (Mac OSX)\nTo use a custom odbc set INCLUDE_DIR and LIB_DIR and PKG_LIBS manually via:\nR CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=... PKG_LIBS=...'\n--------------------------------------------------------------------\nERROR: configuration failed for package ‘odbc’\n* removing ‘/opt/rstudio-connect/mnt/app/packrat/lib/x86_64-pc-linux-gnu/3.6.2/odbc’"
[Connect] 2020/05/01 17:39:23.875818428 Error: Command failed (1)
[Connect] 2020/05/01 17:39:23.875827489
[Connect] 2020/05/01 17:39:23.875898292 Failed to run system command:
[Connect] 2020/05/01 17:39:23.875901048
[Connect] 2020/05/01 17:39:23.875913890 '/opt/R/3.6.2/lib/R/bin/R' --vanilla CMD INSTALL --preclean '/opt/rstudio-connect/mnt/tmp/RtmpBO4k9e/odbc' --library='/opt/rstudio-connect/mnt/app/packrat/lib/x86_64-pc-linux-gnu/3.6.2' --install-tests --no-docs --no-multiarch --no-demo
[Connect] 2020/05/01 17:39:23.875917656
[Connect] 2020/05/01 17:39:23.875926326 The command failed with output:
[Connect] 2020/05/01 17:39:23.875926976 * installing source package ‘odbc’ ...
[Connect] 2020/05/01 17:39:23.875937936 ** package ‘odbc’ successfully unpacked and MD5 sums checked
[Connect] 2020/05/01 17:39:23.875941558 ** using staged installation
[Connect] 2020/05/01 17:39:23.875949885 make: Makevars: No such file or directory
[Connect] 2020/05/01 17:39:23.875950585 make: *** No rule to make target 'Makevars'. Stop.
[Connect] 2020/05/01 17:39:23.875958785 Found pkg-config cflags and libs!
[Connect] 2020/05/01 17:39:23.875959510 PKG_CFLAGS=
[Connect] 2020/05/01 17:39:23.875978292 PKG_LIBS=-lodbc
[Connect] 2020/05/01 17:39:23.875981848 :1:10: fatal error: sql.h: No such file or directory
[Connect] 2020/05/01 17:39:23.875990550 compilation terminated.
[Connect] 2020/05/01 17:39:23.875991190 ------------------------- ANTICONF ERROR ---------------------------
[Connect] 2020/05/01 17:39:23.876002306 Configuration failed because odbc was not found. Try installing:
[Connect] 2020/05/01 17:39:23.876002992 * deb: unixodbc-dev (Debian, Ubuntu, etc)
[Connect] 2020/05/01 17:39:23.876011006 * rpm: unixODBC-devel (Fedora, CentOS, RHEL)
[Connect] 2020/05/01 17:39:23.876011641 * csw: unixodbc_dev (Solaris)
[Connect] 2020/05/01 17:39:23.876019582 * brew: unixodbc (Mac OSX)
[Connect] 2020/05/01 17:39:23.876020235 To use a custom odbc set INCLUDE_DIR and LIB_DIR and PKG_LIBS manually via:
[Connect] 2020/05/01 17:39:23.876028227 R CMD INSTALL --configure-vars='INCLUDE_DIR=... LIB_DIR=... PKG_LIBS=...'
[Connect] 2020/05/01 17:39:23.876028879 --------------------------------------------------------------------
[Connect] 2020/05/01 17:39:23.876036792 ERROR: configuration failed for package ‘odbc’
[Connect] 2020/05/01 17:39:23.876037532 * removing ‘/opt/rstudio-connect/mnt/app/packrat/lib/x86_64-pc-linux-gnu/3.6.2/odbc’
[Connect] 2020/05/01 17:39:23.876056114
[Connect] 2020/05/01 17:39:23.876057374 Unable to fully restore the R packages associated with this deployment.
[Connect] 2020/05/01 17:39:23.876066674 Please review the preceding messages to determine which package
[Connect] 2020/05/01 17:39:23.876067325 encountered installation difficulty and the cause of the failure.
[Connect] 2020/05/01 17:39:23.886631864 Warning message:
[Connect] 2020/05/01 17:39:23.886712762 In packrat::restore(overwrite.dirty = TRUE, prompt = FALSE, restart = FALSE) :
[Connect] 2020/05/01 17:39:23.886724729 The most recent snapshot was generated using R version 3.6.1
[Connect] 2020/05/01 17:39:23.875149270 Error code: r-missing-system-library
[Connect] An R package cannot be installed because a required system-level dependency is missing.