...
Facing this error since 2 days while deploying my app on shinyapps.io
Not sure whether it helps but it looks as if you try to access a MySQL data base via localhost (127.0.0.1). This will work on your local machine but the instance on shinyapps.io won't have this MySQL server running locally.
1 Like
Can you please suggest the possible solution steps?
I apologize but without additional information and a reproducible example it is very hard to help. I suggest that you figure out how to make sure that your code can access the mysql data base when running on a remote system (like on shinyapps.io). Good luck!
If your MySQL server accepts remote connections and you have a static public ip you can simply replace localhost (127.0.0.1) by your public ip in the connection string. If you don't have a static public ip you can use a Dinamic DNS service (e.g. noip.com) to point towards your sql server.
Another option, if you dont need to update the data frequently is to export your data to a file and deploy it along with your app instead of making an odbc connection.
What additional information you need?
This topic was automatically closed 54 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.