Hey all,
I'm trying to deploy my first shiny app to shinyapps.io. The app runs fine locally but I encounter the following error in the logs when I try to deploy: "Error: SSL connection error: error:1425F102:SSL". Full error log below.
I've looked on the other forums solutions but without any luck. Any help would be really appreciated!
Database details:
MySQL v5.7 (can't run a newer version due to provider)
InnoDB
Relevant R Code extract
#Connect to sql
conn <- dbConnect(
drv = RMySQL::MySQL(),
dbname = "",
host = "",
username = "",
password = "")
on.exit(dbDisconnect(conn), add = TRUE)
df = dbGetQuery(conn,
"SELECT * FROM table LIMIT 1000;")
Full error log:
2022-12-20T11:25:55.453846+00:00 shinyapps[7919361]: Container event from container-7557637: start
2022-12-20T11:25:55.864829+00:00 shinyapps[7919361]: Running on host: ade787cd28dd
2022-12-20T11:25:55.864839+00:00 shinyapps[7919361]: Server version: 2022.11.0
2022-12-20T11:25:55.864843+00:00 shinyapps[7919361]: LANG: C.UTF-8
2022-12-20T11:25:55.864854+00:00 shinyapps[7919361]: Working directory: /srv/connect/apps/tilmeldte
2022-12-20T11:25:55.865131+00:00 shinyapps[7919361]: Running content using the current R environment
2022-12-20T11:25:55.869775+00:00 shinyapps[7919361]: R version: 4.2.0
2022-12-20T11:25:55.869786+00:00 shinyapps[7919361]: shiny version: 1.7.2
2022-12-20T11:25:55.869789+00:00 shinyapps[7919361]: httpuv version: 1.6.5
2022-12-20T11:25:55.869795+00:00 shinyapps[7919361]: rmarkdown version: (none)
2022-12-20T11:25:55.869822+00:00 shinyapps[7919361]: knitr version: (none)
2022-12-20T11:25:55.869834+00:00 shinyapps[7919361]: jsonlite version: 1.8.3
2022-12-20T11:25:55.869837+00:00 shinyapps[7919361]: RJSONIO version: (none)
2022-12-20T11:25:55.869842+00:00 shinyapps[7919361]: htmltools version: 0.5.3
2022-12-20T11:25:55.869845+00:00 shinyapps[7919361]: reticulate version: (none)
2022-12-20T11:25:55.870123+00:00 shinyapps[7919361]: Using pandoc: /opt/connect/ext/pandoc/2.16
2022-12-20T11:25:56.224477+00:00 shinyapps[7919361]: Starting R with process ID: '25'
2022-12-20T11:25:56.224860+00:00 shinyapps[7919361]: Shiny application starting ...
2022-12-20T11:25:56.261377+00:00 shinyapps[7919361]: Attaching package: ‘rsconnect’
2022-12-20T11:25:56.261939+00:00 shinyapps[7919361]: The following object is masked from ‘package:shiny’:
2022-12-20T11:25:56.261955+00:00 shinyapps[7919361]: serverInfo
2022-12-20T11:25:56.753195+00:00 shinyapps[7919361]: Attaching package: ‘dplyr’
2022-12-20T11:25:56.753363+00:00 shinyapps[7919361]: The following objects are masked from ‘package:stats’:
2022-12-20T11:25:56.753385+00:00 shinyapps[7919361]: filter, lag
2022-12-20T11:25:56.753571+00:00 shinyapps[7919361]: The following objects are masked from ‘package:base’:
2022-12-20T11:25:56.753589+00:00 shinyapps[7919361]: intersect, setdiff, setequal, union
2022-12-20T11:25:56.935801+00:00 shinyapps[7919361]: Attaching package: ‘dbplyr’
2022-12-20T11:25:56.935970+00:00 shinyapps[7919361]: The following objects are masked from ‘package:dplyr’:
2022-12-20T11:25:56.936000+00:00 shinyapps[7919361]: ident, sql
2022-12-20T11:25:56.986726+00:00 shinyapps[7919361]: Listening on http://127.0.0.1:38875
2022-12-20T11:26:03.090687+00:00 shinyapps[7919361]: Warning: Error in .local: Failed to connect to database: Error: SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol
2022-12-20T11:26:03.106926+00:00 shinyapps[7919361]: 185: .local
2022-12-20T11:26:03.106958+00:00 shinyapps[7919361]: 184: dbConnect
2022-12-20T11:26:03.106965+00:00 shinyapps[7919361]: 182: renderPlot [/srv/connect/apps/tilmeldte/app.R#114]
2022-12-20T11:26:03.106970+00:00 shinyapps[7919361]: 180: func
2022-12-20T11:26:03.106974+00:00 shinyapps[7919361]: 140: drawPlot
2022-12-20T11:26:03.106977+00:00 shinyapps[7919361]: 126: <reactive:plotObj>
2022-12-20T11:26:03.106980+00:00 shinyapps[7919361]: 110: drawReactive
2022-12-20T11:26:03.106996+00:00 shinyapps[7919361]: 97: renderFunc
2022-12-20T11:26:03.107000+00:00 shinyapps[7919361]: 96: output$distPlot
2022-12-20T11:26:03.107003+00:00 shinyapps[7919361]: 15: <Anonymous>
2022-12-20T11:26:03.107006+00:00 shinyapps[7919361]: 13: fn
2022-12-20T11:26:03.107009+00:00 shinyapps[7919361]: 8: retry
2022-12-20T11:26:03.107012+00:00 shinyapps[7919361]: 7: connect$retryingStartServer
2022-12-20T11:26:03.107015+00:00 shinyapps[7919361]: 6: eval
2022-12-20T11:26:03.107018+00:00 shinyapps[7919361]: 5: eval
2022-12-20T11:26:03.107024+00:00 shinyapps[7919361]: 4: eval
2022-12-20T11:26:03.107028+00:00 shinyapps[7919361]: 3: eval
2022-12-20T11:26:03.107031+00:00 shinyapps[7919361]: 2: eval.parent
2022-12-20T11:26:03.107035+00:00 shinyapps[7919361]: 1: local
Thanks in advance!