this is more of a Docker issue than ShinyProxy one. I have created a shinyapp that collects data from a local SQLite database also running on my pc (which will be similar once deployed on a server).
When I run the app as a package, app functions alright - connection to the database is established.
But once I create a docker image & run it, the app launched but is unable to connect to my local sql database, returning this error:
Warning: Error in connection_create: Failed to connect: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
I have tried multiple solutions including setting up docker compose file, using different docker images, setting up different ports etc. & still hitting the same dead end.
Thanks for any help!