Shiny App querying a remote database, deployment error

13 views
Skip to first unread message

Rich Pauloo

unread,
Feb 27, 2018, 3:06:14 PM2/27/18
to shiny-...@googlegroups.com
I have a working Shiny App that queries a remote MySQL database via pool that I can run on my local machine.  


When I deploy it to shinyapps.io, I get this error:  

Inline image 1

.global  

    library(shiny)
    library(DBI)
    library(pool)
    library(DT)

    pool <- dbPool(
      drv = RMySQL::MySQL(),
      dbname = "gw_observatory",
      host = "sage.metro.ucdavis.edu",
      username = "gw_observatory", 
      password = "password"
    )
    onStop(function() {
      poolClose(pool)
    })

.server  

    shinyServer(function(input, output, session) {
      
      output$data_table <- renderDataTable({
        
        DT::datatable(pool %>% tbl("small_data") %>% collect())
        
      })

.ui  

    shinyUI(
      fluidPage(
          mainPanel(DT::dataTableOutput("data_table"))
      )
    )




-- 
Rich Pauloo


--
Rich Pauloo
logs (1).txt
Reply all
Reply to author
Forward
0 new messages