Can't connect to MySQL database (on AWS) from ShinyApps.io

Posit Professional & Hosted Products shinyapps.io
,
1

Hi all, my app connects to the MySQL instance on AWS from my computer, but when I deploy to shinyapps.io, the app runs OK, but when it attempts to connect, it hangs or crashes and the Log file reports.

2020-05-26T07:23:01.032414+00:00 shinyapps[2356724]: Warning: Error in : Failed to connect: Can't connect to MySQL server on 'I ... .rds.amazonaws.com' (110)

Could it be similar to these symptoms? https://forum.posit.co/t/after-aws-ddos-attack-shiny-apps-cannot-connect-to-mysql-rds/42933?u=cameronad

2

And getting the same error if trying connect to a MariaDB instance on AWS. Has anyone got any ideas what is happening?

3

Finally worked it out. Did not realise I had to whitelist the IP addresses for shiny apps.io found here

https://docs.rstudio.com/shinyapps.io/applications.html#firewalls

4

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