ERROR: An error has occurred. Check your logs or contact the app author for clarification.

shiny
,
1

I wanted to deploy shiny app in shinyapps.io. But I am facing some issues.
I have checked the sample code app by deploying in shinyapp.io. It worked fine.
Then I open the ui.R and server.R, and replaced with other code in place of sample code.
I tried to run it again by "republish" the App.

"ERROR: An error has occurred. Check your logs or contact the app author for clarification."
when I checked the logs, I found:
Warning: Error in .local: Failed to connect to database: Error: Can't connect to MySQL server on '192.168.45.210' (110)
2018-12-21T08:11:07.302084+00:00 shinyapps[621585]:
2018-12-21T08:11:07.306844+00:00 shinyapps[621585]: 61: .local
2018-12-21T08:11:07.306846+00:00 shinyapps[621585]: 60: dbConnect

I don't know how to resolve this issue.
Can anyone help me to resolve this issue, please?

2

Hi,

The db connection IP looks like a local one. Is it your local mysql server?

Regards,

jm

1 Like
3

Yeah, that error indicates your shiny app is struggling to connect to that database.

Here's the documentation on Shiny apps connection to Persistent data storage -- MySQL.

4

These docs on connecting to a database from ShinyappsIO might be helpful too.

1 Like
5

I agree with this, that is a local ip for sure, since shinyappsIO is outside your local network, you need to point your connection string to your public ip, if you don't have a static public ip you could use a ddns service and configure port forwarding in your router/modem to point towards your MySQL server.

1 Like
6

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