Temporarily Open DB Port
-
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.
-
wrote on Feb 24, 2022, 2:25 AM last edited by
wouldn't it be better to wait for the wireguard functionality to allow you to VPN into any app for such a purpose?
-
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.
-
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.
@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 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
@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.