I am having a hard time deploying my application to shinyappsio.
It deploys fine locally, but once I push it to my shinyapps.io account, it errors out and just tells me to refer to the logs. This is what it tells me (sorry it's long):
2021-03-31T18:46:06.900110+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.900788+00:00 shinyapps[3888130]: The following objects are masked from ‘package:methods’:
2021-03-31T18:46:06.900789+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.900110+00:00 shinyapps[3888130]: runExample
2021-03-31T18:46:06.900789+00:00 shinyapps[3888130]: removeClass, show
2021-03-31T18:46:06.900790+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.915120+00:00 shinyapps[3888130]: Welcome to clipr. See ?write_clip for advisories on writing to the clipboard in R.
2021-03-31T18:46:06.990046+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.990048+00:00 shinyapps[3888130]: Attaching package: ‘readr’
2021-03-31T18:46:06.990049+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.990499+00:00 shinyapps[3888130]: The following object is masked from ‘package:rvest’:
2021-03-31T18:46:06.990501+00:00 shinyapps[3888130]: guess_encoding
2021-03-31T18:46:06.990500+00:00 shinyapps[3888130]:
2021-03-31T18:46:06.990501+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.032711+00:00 shinyapps[3888130]: Loading required package: RMySQL
2021-03-31T18:46:07.108150+00:00 shinyapps[3888130]: Loading required package: gWidgets
2021-03-31T18:46:07.363167+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.363169+00:00 shinyapps[3888130]: Attaching package: ‘gWidgets’
2021-03-31T18:46:07.363170+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]: id
2021-03-31T18:46:07.490839+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.491253+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.364666+00:00 shinyapps[3888130]: The following object is masked from ‘package:shiny’:
2021-03-31T18:46:07.364667+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.491251+00:00 shinyapps[3888130]: The following object is masked from ‘package:shinyjs’:
2021-03-31T18:46:07.364667+00:00 shinyapps[3888130]: tag
2021-03-31T18:46:07.363719+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.363718+00:00 shinyapps[3888130]: The following object is masked from ‘package:dplyr’:
2021-03-31T18:46:07.364668+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.490841+00:00 shinyapps[3888130]: Attaching package: ‘shinyWidgets’
2021-03-31T18:46:07.491252+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.490842+00:00 shinyapps[3888130]:
2021-03-31T18:46:07.491252+00:00 shinyapps[3888130]: alert
2021-03-31T18:46:07.863014+00:00 shinyapps[3888130]: ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.0 ──
2021-03-31T18:46:07.866675+00:00 shinyapps[3888130]: ✔ tibble 3.1.0 ✔ forcats 0.5.1
2021-03-31T18:46:08.021543+00:00 shinyapps[3888130]: ✖ dplyr::collapse() masks nlme::collapse()
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ tibble::data_frame() masks dplyr::data_frame(), vctrs::data_frame()
2021-03-31T18:46:08.021541+00:00 shinyapps[3888130]: ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
2021-03-31T18:46:08.021542+00:00 shinyapps[3888130]: ✖ data.table::between() masks dplyr::between()
2021-03-31T18:46:08.041638+00:00 shinyapps[3888130]: 93: <Anonymous>
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ dplyr::filter() masks plotly::filter(), stats::filter()
2021-03-31T18:46:08.021544+00:00 shinyapps[3888130]: ✖ data.table::first() masks dplyr::first()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ data.table::last() masks dplyr::last()
2021-03-31T18:46:08.021545+00:00 shinyapps[3888130]: ✖ dplyr::group_rows() masks kableExtra::group_rows()
2021-03-31T18:46:08.037558+00:00 shinyapps[3888130]: Warning: Error in : nanodbc/nanodbc.cpp:1021: 00000: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
2021-03-31T18:46:08.021547+00:00 shinyapps[3888130]: ✖ data.table::transpose() masks purrr::transpose()
2021-03-31T18:46:08.021545+00:00 shinyapps[3888130]: ✖ readr::guess_encoding() masks rvest::guess_encoding()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ gWidgets::id() masks dplyr::id()
2021-03-31T18:46:08.021546+00:00 shinyapps[3888130]: ✖ dplyr::lag() masks stats::lag()
2021-03-31T18:46:08.021547+00:00 shinyapps[3888130]: ✖ purrr::modify() masks renv::modify()
Also printed in my RStudio Console are these warnings:
Warning in FUN(X[[i]], ...) : Unable to find repository URL for package Matrix Warning in FUN(X[[i]], ...) : Unable to find repository URL for package dbConnect Warning in FUN(X[[i]], ...) : Unable to find repository URL for package gWidgets Warning in FUN(X[[i]], ...) : Unable to find repository URL for package mgcv
Some additional context:
- I am deploying this by publishing a ui.R/server.R set up
- The version of R I am using is 3.4.4 (and sorry, I cannot update this to the latest version because I have some other software that relies upon 3.4.4 version, so I do have some package dependencies that need to be compatible with this older version or have reverse compatibility)
- One of the scripts used by the application does connect to a local postgresql database on a Windows 10 64bit system. I am using the
dbConnectlibrary to establish the connection to the database and then I usedbDisconnect()to close the connection after the data object has been created and saved.
Given the above and my specific situation, is there any way to get this to deploy on shinyapps.io?