Protocol "sftp" not supported or disabled in libcurl when deploying to shinyapps.io

Hello Community,

I have been desperately searching for days but still can't solve this error

Loading required package: bitops 
Error in value[[3L]](cond) : Protocol "sftp" not supported or disabled in libcurl
Calls: local ... tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous>
Execution halted

I received when I tried to deploy the app to shinyapps.io. I am using one script app.R rather than ui + server. This app works locally without any problem. Based on my research, this reason of this error may be that I am using the package RCurl to call the .csv files (as the data sources) in a sFTP server directory directly from app.R, and shinyapps.io is based on Ubuntu Linux distribution system, and one of its default system packages called libcurl doesn't currently support 'sftp' protocol. I apologize if the info doesn't make sense at all as I have little knowledge about operating systems.

Here is the output of my rsconnect::appDependencies()

                 package    version source
1                     BH   1.69.0-1   CRAN
2                    C50      0.1.2   CRAN
3                 Cubist      0.2.2   CRAN
4                    DBI      1.0.0   CRAN
5                Formula      1.2-3   CRAN
6             KernSmooth    2.23-15   CRAN
7                   MASS   7.3-51.1   CRAN
8                 Matrix     1.2-15   CRAN
9           ModelMetrics      1.2.2   CRAN
10                   NLP      0.2-0   CRAN
11  PerformanceAnalytics      1.5.2   CRAN
12                    R6      2.4.0   CRAN
13          RColorBrewer      1.1-2   CRAN
14                 RCurl  1.95-4.11   CRAN
15               RSQLite      2.1.1   CRAN
16         RSiteCatalyst     1.4.15   CRAN
17                  Rcpp      1.0.0   CRAN
18             RcppEigen  0.3.3.5.0   CRAN
19              RcppRoll      0.3.0   CRAN
20           RgoogleMaps      1.4.3   CRAN
21                Rserve      1.7-3   CRAN
22               SQUAREM  2017.10-1   CRAN
23               TH.data     1.0-10   CRAN
24                  VGAM      1.1-1   CRAN
25                 abind      1.4-5   CRAN
26                adabag        4.2   CRAN
27                   arm     1.10-1   CRAN
28               askpass        1.1   CRAN
29            assertthat      0.2.0   CRAN
30             backports      1.1.3   CRAN
31             base64enc      0.1-3   CRAN
32                   bit     1.1-14   CRAN
33                 bit64      0.9-7   CRAN
34                bitops      1.0-6   CRAN
35                  blob      1.1.1   CRAN
36                 broom      0.5.1   CRAN
37                 callr      3.1.1   CRAN
38               carData      3.0-2   CRAN
39                 caret     6.0-81   CRAN
40            cellranger      1.1.0   CRAN
41                 chron     2.3-53   CRAN
42                 class     7.3-15   CRAN
43                   cli      1.0.1   CRAN
44                 clipr      0.5.0   CRAN
45            clisymbols      1.2.0   CRAN
46                  coda     0.19-2   CRAN
47             codetools     0.2-16   CRAN
48                  coin      1.2-2   CRAN
49            colorspace      1.4-0   CRAN
50              corrplot       0.84   CRAN
51                crayon      1.3.4   CRAN
52             crosstalk      1.0.0   CRAN
53                  curl        3.3   CRAN
54            data.table     1.12.0   CRAN
55                dbplyr      1.3.0   CRAN
56                  desc      1.2.0   CRAN
57              devtools      2.0.1   CRAN
58                digest     0.6.18   CRAN
59            doParallel     1.0.14   CRAN
60                 dplyr    0.8.0.1   CRAN
61               dummies      1.5.6   CRAN
62                 dummy      0.1.3   CRAN
63                 e1071    1.7-0.1   CRAN
64               effects      4.1-0   CRAN
65              ellipsis      0.1.0   CRAN
66          estimability        1.3   CRAN
67              evaluate       0.13   CRAN
68                 fansi      0.4.0   CRAN
69               forcats      0.4.0   CRAN
70               foreach      1.4.4   CRAN
71                    fs      1.2.6   CRAN
72              generics      0.0.2   CRAN
73                 ggmap      3.0.0   CRAN
74               ggplot2      3.1.0   CRAN
75                    gh      1.0.1   CRAN
76                 git2r     0.24.0   CRAN
77                glmnet     2.0-16   CRAN
78                  glue      1.3.0   CRAN
79                 gower      0.1.2   CRAN
80             gridExtra        2.3   CRAN
81                gsubfn        0.7   CRAN
82                gtable      0.2.0   CRAN
83                 haven      2.1.0   CRAN
84                 highr        0.7   CRAN
85                   hms      0.4.2   CRAN
86             htmltools      0.3.6   CRAN
87           htmlwidgets        1.3   CRAN
88                httpuv    1.4.5.1   CRAN
89                  httr      1.4.0   CRAN
90                igraph      1.2.4   CRAN
91                   ini      0.3.1   CRAN
92                  inum      1.0-0   CRAN
93                 ipred      0.9-8   CRAN
94             iterators     1.0.10   CRAN
95                  jpeg      0.1-8   CRAN
96              jsonlite        1.6   CRAN
97               kernlab     0.9-27   CRAN
98                  kknn      1.3.1   CRAN
99                 knitr       1.21   CRAN
100             labeling        0.3   CRAN
101                later      0.8.0   CRAN
102              lattice    0.20-38   CRAN
103                 lava      1.6.5   CRAN
104             lazyeval      0.2.1   CRAN
105              leaflet      2.0.2   CRAN
106              libcoin      1.0-4   CRAN
107                 lme4     1.1-20   CRAN
108            lubridate      1.7.4   CRAN
109             magrittr        1.5   CRAN
110             markdown        0.9   CRAN
111                  mda     0.4-10   CRAN
112              memoise      1.1.0   CRAN
113                 mgcv     1.8-27   CRAN
114                 mime        0.6   CRAN
115                minqa      1.2.4   CRAN
116               modelr      0.1.4   CRAN
117           modeltools     0.2-22   CRAN
118             multcomp     1.4-10   CRAN
119              munsell      0.5.0   CRAN
120              mvtnorm     1.0-10   CRAN
121                 nlme    3.1-137   CRAN
122               nloptr      1.2.1   CRAN
123                 nnet     7.3-12   CRAN
124             numDeriv   2016.8-1   CRAN
125              openssl      1.2.1   CRAN
126             outliers       0.14   CRAN
127                 pROC     1.13.0   CRAN
128              packrat      0.5.0   CRAN
129                party      1.3-2   CRAN
130             partykit      1.2-3   CRAN
131               pillar      1.3.1   CRAN
132             pkgbuild      1.0.2   CRAN
133            pkgconfig      2.0.2   CRAN
134              pkgload      1.0.2   CRAN
135                plogr      0.2.0   CRAN
136              plotrix      3.7-4   CRAN
137                  pls      2.7-0   CRAN
138                 plyr      1.8.4   CRAN
139                  png      0.1-7   CRAN
140          prettyunits      1.0.2   CRAN
141             processx      3.2.1   CRAN
142              prodlim 2018.04.18   CRAN
143             progress      1.2.0   CRAN
144             promises      1.0.1   CRAN
145                proto      1.0.0   CRAN
146                   ps      1.3.0   CRAN
147                purrr      0.3.0   CRAN
148             quadprog      1.5-5   CRAN
149         randomForest     4.6-14   CRAN
150               raster     2.8-19   CRAN
151            rcmdcheck      1.3.2   CRAN
152                readr      1.3.1   CRAN
153               readxl      1.3.0   CRAN
154              recipes      0.1.4   CRAN
155              rematch      1.0.1   CRAN
156              remotes      2.0.2   CRAN
157               reprex      0.2.1   CRAN
158             reshape2      1.4.3   CRAN
159                rjson     0.2.20   CRAN
160                rlang      0.3.1   CRAN
161            rmarkdown       1.11   CRAN
162               rminer      1.4.2   CRAN
163                rpart     4.1-13   CRAN
164            rprojroot      1.3-2   CRAN
165            rsconnect     0.8.13   CRAN
166           rstudioapi      0.9.0   CRAN
167                rvest      0.3.2   CRAN
168             sandwich      2.5-0   CRAN
169               scales      1.0.0   CRAN
170              selectr      0.4-1   CRAN
171          sessioninfo      1.1.1   CRAN
172                shiny      1.2.0   CRAN
173                 slam     0.1-45   CRAN
174          sourcetools      0.1.7   CRAN
175                   sp      1.3-1   CRAN
176                sqldf     0.4-11   CRAN
177              stringi      1.3.1   CRAN
178              stringr      1.4.0   CRAN
179          strucchange      1.5-1   CRAN
180               survey     3.35-1   CRAN
181             survival     2.43-3   CRAN
182                  sys        3.0   CRAN
183        taskscheduleR        1.4   CRAN
184               tibble      2.0.1   CRAN
185                tidyr      0.8.2   CRAN
186           tidyselect      0.2.5   CRAN
187            tidyverse      1.2.1   CRAN
188             timeDate   3043.102   CRAN
189              tinytex       0.10   CRAN
190                   tm      0.7-6   CRAN
191              usethis      1.4.0   CRAN
192                 utf8      1.1.4   CRAN
193              viridis      0.5.1   CRAN
194          viridisLite      0.3.0   CRAN
195              whisker      0.3-2   CRAN
196                withr      2.1.2   CRAN
197            wordcloud        2.6   CRAN
198                 xfun        0.5   CRAN
199              xgboost   0.81.0.1   CRAN
200                 xml2      1.2.0   CRAN
201                xopen      1.0.0   CRAN
202               xtable      1.8-3   CRAN
203                  xts     0.11-2   CRAN
204                 yaml      2.2.0   CRAN
205                  zoo      1.8-4   CRAN

And here is the log.txt:

masked from ‘package:ggplot2’:
2019-03-04T22:14:49.641864+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.641865+00:00 shinyapps[746194]:     annotate
2019-03-04T22:14:49.641866+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.687110+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.687113+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.687112+00:00 shinyapps[746194]: Attaching package: ‘wordcloud’
2019-03-04T22:14:49.687453+00:00 shinyapps[746194]: The following object is masked from ‘package:PerformanceAnalytics’:
2019-03-04T22:14:49.687454+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.687455+00:00 shinyapps[746194]: 
2019-03-04T22:14:49.692053+00:00 shinyapps[746194]: Loading required package: bitops
2019-03-04T22:14:49.687454+00:00 shinyapps[746194]:     textplot
2019-03-04T22:14:53.062898+00:00 shinyapps[746194]:   Protocol "sftp" not supported or disabled in libcurl
2019-03-04T22:14:53.062908+00:00 shinyapps[746194]: Execution halted
2019-03-04T22:14:53.062907+00:00 shinyapps[746194]: Calls: local ... tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous>
2019-03-04T22:14:53.062894+00:00 shinyapps[746194]: Error in value[[3L]](cond) : 
2019-03-04T22:14:55.294948+00:00 shinyapps[746194]: Server version: 1.7.0-11
2019-03-04T22:14:55.294980+00:00 shinyapps[746194]: LANG: en_US.UTF-8
2019-03-04T22:14:55.294981+00:00 shinyapps[746194]: R version: 3.5.1
2019-03-04T22:14:55.295032+00:00 shinyapps[746194]: knitr version: NA
2019-03-04T22:14:55.295034+00:00 shinyapps[746194]: RJSONIO version: NA
2019-03-04T22:14:55.294986+00:00 shinyapps[746194]: shiny version: 1.2.0
2019-03-04T22:14:55.294987+00:00 shinyapps[746194]: httpuv version: 1.4.5.1
2019-03-04T22:14:55.294999+00:00 shinyapps[746194]: rmarkdown version: NA
2019-03-04T22:14:55.295033+00:00 shinyapps[746194]: jsonlite version: 1.6
2019-03-04T22:14:55.295057+00:00 shinyapps[746194]: htmltools version: 0.3.6
2019-03-04T22:14:55.295143+00:00 shinyapps[746194]: Using pandoc at /opt/connect/ext/pandoc2
2019-03-04T22:14:55.438409+00:00 shinyapps[746194]: Using jsonlite for JSON processing
2019-03-04T22:14:55.443312+00:00 shinyapps[746194]: Starting R with process ID: '41'
2019-03-04T22:14:55.503677+00:00 shinyapps[746194]: Attaching package: ‘rsconnect’
2019-03-04T22:14:55.503675+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.443310+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.504414+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.504415+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.503678+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.504413+00:00 shinyapps[746194]: The following object is masked from ‘package:shiny’:
2019-03-04T22:14:55.504414+00:00 shinyapps[746194]:     serverInfo
2019-03-04T22:14:55.783416+00:00 shinyapps[746194]: Type 'citation("pROC")' for a citation.
2019-03-04T22:14:55.784274+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.784275+00:00 shinyapps[746194]: Attaching package: ‘pROC’
2019-03-04T22:14:55.784276+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.784683+00:00 shinyapps[746194]: The following objects are masked from ‘package:stats’:
2019-03-04T22:14:55.784686+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.784685+00:00 shinyapps[746194]:     cov, smooth, var
2019-03-04T22:14:55.789429+00:00 shinyapps[746194]: Loading required package: lattice
2019-03-04T22:14:55.784684+00:00 shinyapps[746194]: 
2019-03-04T22:14:55.807456+00:00 shinyapps[746194]: Loading required package: ggplot2
2019-03-04T22:14:57.209236+00:00 shinyapps[746194]: Loading required package: xts
2019-03-04T22:14:57.236386+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.212230+00:00 shinyapps[746194]: Loading required package: zoo
2019-03-04T22:14:57.236389+00:00 shinyapps[746194]: Attaching package: ‘zoo’
2019-03-04T22:14:57.236390+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.236773+00:00 shinyapps[746194]: The following objects are masked from ‘package:base’:
2019-03-04T22:14:57.291515+00:00 shinyapps[746194]: Attaching package: ‘PerformanceAnalytics’
2019-03-04T22:14:57.291516+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.291847+00:00 shinyapps[746194]: The following object is masked from ‘package:graphics’:
2019-03-04T22:14:57.291848+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.291849+00:00 shinyapps[746194]:     legend
2019-03-04T22:14:57.291849+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.311786+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.311789+00:00 shinyapps[746194]: Attaching package: ‘e1071’
2019-03-04T22:14:57.311790+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.312161+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.312160+00:00 shinyapps[746194]: The following objects are masked from ‘package:PerformanceAnalytics’:
2019-03-04T22:14:57.236774+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.343298+00:00 shinyapps[746194]: Attaching package: ‘leaflet’
2019-03-04T22:14:57.236776+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.236775+00:00 shinyapps[746194]:     as.Date, as.Date.numeric
2019-03-04T22:14:57.343299+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.291513+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.343646+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.312162+00:00 shinyapps[746194]:     kurtosis, skewness
2019-03-04T22:14:57.312162+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.343295+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.343645+00:00 shinyapps[746194]: The following object is masked from ‘package:xts’:
2019-03-04T22:14:57.343647+00:00 shinyapps[746194]:     addLegend
2019-03-04T22:14:57.343647+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.356741+00:00 shinyapps[746194]: Loading required package: NLP
2019-03-04T22:14:57.370679+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.370681+00:00 shinyapps[746194]: Attaching package: ‘NLP’
2019-03-04T22:14:57.370682+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.371037+00:00 shinyapps[746194]: The following object is masked from ‘package:ggplot2’:
2019-03-04T22:14:57.371038+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.371039+00:00 shinyapps[746194]:     annotate
2019-03-04T22:14:57.371040+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.426171+00:00 shinyapps[746194]: Loading required package: bitops
2019-03-04T22:14:57.421252+00:00 shinyapps[746194]: Attaching package: ‘wordcloud’
2019-03-04T22:14:57.421250+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.421253+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.421589+00:00 shinyapps[746194]: The following object is masked from ‘package:PerformanceAnalytics’:
2019-03-04T22:14:57.421590+00:00 shinyapps[746194]: 
2019-03-04T22:14:57.421591+00:00 shinyapps[746194]:     textplot
2019-03-04T22:14:57.421592+00:00 shinyapps[746194]: 
2019-03-04T22:15:03.675479+00:00 shinyapps[746194]: Error in value[[3L]](cond) : 
2019-03-04T22:15:03.675481+00:00 shinyapps[746194]:   Protocol "sftp" not supported or disabled in libcurl
2019-03-04T22:15:03.675483+00:00 shinyapps[746194]: Execution halted
2019-03-04T22:15:03.675483+00:00 shinyapps[746194]: Calls: local ... tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous>

Many thanks!!

Sadly this is due to a long standing circumstance of curl and Ubuntu. But there appears to be hope for the future...

Hi Josh,

Thanks so much for your reply. Do you see any workaround by chance? I searched but failed to find any other R packages that support sFTP file transfer. I apologize for my limited knowledge in this area.

My intention here is to have scheduled CSV files written to shared data directories (happened to be a sFTP server in the first place) so that my app hosted on shinyapps.io can retrieve the auto-update data without having to re-deploy it. Other than the sFTP server, I may be able to use an internal shared network drive, but I need to confirm if the file path can be called remotely. Do you by chance see any types of remote data source that may be available?

Much Appreciated,

This topic was automatically closed 54 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.