Temporarily Open DB Port

[doodlemania2]

Thinking like a support person, I wonder if it would be a good thing (or even possible) to have a button or something that could temporarily open up the DB port through the reverse proxy of an app so one could connect to it remotely from a tool?

This feels like it could be relatively simple as a "here's a 30 minute window" from inside the app control panel.

[robi]

wouldn't it be better to wait for the wireguard functionality to allow you to VPN into any app for such a purpose?

[nebulon]

At least for mysql this should be possible with mysql over SSH tunnel. For Postgres, I am not sure if that exists, but also the postgres addon is setup to do auth also based on connection source IP, so that likely wont work, but have never tried.

[girish]

@doodlemania2 If giving the user ssh access is an option, then a possible idea is https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis/2

[doodlemania2]

@girish yeah, that's one option, as is the SSH tunnel, but thinking about a more user friendly approach so DBAs can simply do DBA things with a few clicks from the admin instead of setting up tunnels, etc.