Post AwcvqKwvPCfPXMonia by evan@fedi.evrys.me
 (DIR) More posts by evan@fedi.evrys.me
 (DIR) Post #Awcs1wrsMkI0VZjp5M by evan@fedi.evrys.me
       2025-07-29T12:43:04Z
       
       3 likes, 2 repeats
       
       Boyfriend had a fun IT problem today I was able to solve with some 2010-style ssh tunnel trickery!He wants to develop web app on his macbook. But app backend needs to read from a postgres db server, which is only accessible via VPN on a Windows laptop controlled by his employer (they don't issue macbooks)Solution: reverse ssh tunnel from Ubuntu VM on the Windows laptop opening a local port on the macbook which routes back through the tunnel to the db`ssh -R 5432:dbhost:5432 macbook`
       
 (DIR) Post #Awcs1xf9PXhkyOnAtE by yura@udongein.xyz
       2025-07-29T12:48:42.056874Z
       
       0 likes, 0 repeats
       
       @evan haha, I thought of this method before reading the "solution" part :)Same trick works also if you have an unexposed postgres in a docker container on a server. You can forward ports with ssh and connect to a remote db with something like pgadmin.
       
 (DIR) Post #AwcsZNSMX0caWkkDce by evan@fedi.evrys.me
       2025-07-29T12:53:38Z
       
       1 likes, 0 repeats
       
       @yura yuhh so many fiddly configuration problems you can work around with ssh tunnels :D
       
 (DIR) Post #Awcuz9YT2V5Eql1DMG by yura@udongein.xyz
       2025-07-29T13:21:47.496073Z
       
       0 likes, 0 repeats
       
       @evan by the way, do you know any good autpssh alternatives for windows? I want something that will reconnect ssh tunnels in case of interruptions.
       
 (DIR) Post #AwcvqKwvPCfPXMonia by evan@fedi.evrys.me
       2025-07-29T13:25:07Z
       
       0 likes, 0 repeats
       
       @yura I don't really know much windows IT stuff sadly, I'd just do everything in WSL if I had to work with a windows machine xD
       
 (DIR) Post #AwcvqLrzz0JwONWNg8 by yura@udongein.xyz
       2025-07-29T13:31:29.162428Z
       
       0 likes, 0 repeats
       
       @evan >wslI should finally test it lol
       
 (DIR) Post #AwfAQXhJC1MLotgcHg by scathach@stereophonic.space
       2025-07-29T13:19:23.622681Z
       
       2 likes, 0 repeats
       
       @evan This is how I access all the private services I have hosted on my serverProbably going to replace it with a headscale net soon though
       
 (DIR) Post #AwfATTXL7RWhmgQE0u by evan@fedi.evrys.me
       2025-07-29T13:20:46Z
       
       0 likes, 0 repeats
       
       @scathach hadn't heard of headscale before, sounds neat!
       
 (DIR) Post #AwfATUk8dLMHWfPxbM by scathach@stereophonic.space
       2025-07-29T13:21:13.860105Z
       
       1 likes, 0 repeats
       
       @evan It's a self-hostable reimplementation of the Wireguard network