Connecting to a database using a socks proxy?

Skeeve has asked for the wisdom of the Perl Monks concerning the following question:

In my environment I use a socks proxy to connect to my database. This works fine for programs like the Java based DBVisualizer. I simply define the proxy in the connection's properties.

But how could I achieve this with perl? I have no clue which additional modules could help here. Or is there, maybe, no module required and a socks-connection is already possible?

Many thanks in advance for any useful hint.

s$$([},&%#}/&/]+}%&{})*;#$&&s&&$^X.($'^"%]=\&(|?*{%
+.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e

Comment on Connecting to a database using a socks proxy? Select or Download Code

Replies are listed 'Best First'.
Re: Connecting to a database using a socks proxy? by Skeeve (Parson) on Feb 26, 2020 at 19:13 UTC
More than 5 years passed and here I am, having that same question again… I cannot remember what I did 5 years ago as a workaround, but it's sad to see, no one seemed to have an answer :( `s$$([},&%#}/&/]+}%&{});#$&&s&&$^X.($'^"%]=\&(\|?{%` `+`.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e	[reply] [d/l] [select]
Re^2: Connecting to a database using a socks proxy? by haukex (Archbishop) on Feb 26, 2020 at 19:38 UTC
Which database is it? I'm not sure about DBI (I don't think it supports the environment variable `ALL_PROXY=socks5h://host:port`?), but as a general solution, I've had some success with proxychains (and/or proxychains-ng depending on which your Linux distro provides). On newer Debian/Ubuntu releases, there's a package `proxychains4` (alternatively, just `proxychains`), install that, and in `/etc/proxychains.conf` change the `socks4` entry to `socks5` if necessary and adjust the IP and port. Then, for many (but not all) programs, you can just do e.g. `proxychains4 perl ...` and it will try to intercept the networking to send it through the SOCKS proxy.	[reply] [d/l] [select]
Re^3: Connecting to a database using a socks proxy? by Skeeve (Parson) on Feb 26, 2020 at 20:20 UTC
Postgres is what I want to use. I saw that there is a DBD::Proxy but as far as I understood this is only for DBI::ProxyServer. I also wonder whether or not IO::Socket::Socks::Wrapper could be a way to go… Will think about proxychain but I'm not sure it's worth the effort. As it's mainly for testing purposes, I think I will (again?) go for port-forwarding. `s$$([},&%#}/&/]+}%&{});#$&&s&&$^X.($'^"%]=\&(\|?{%` `+`.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e	[reply] [d/l] [select]
Re^2: Connecting to a database using a socks proxy? by marto (Cardinal) on Feb 26, 2020 at 19:37 UTC
Just think, had you posted your solution.workaround in reply to your own question you wouldn't be in this situation ;)	[reply]
Re^3: Connecting to a database using a socks proxy? by Your Mother (Archbishop) on Feb 26, 2020 at 21:58 UTC
I come back for my own stub/test code a couple times a year. :P	[reply]
Re^3: Connecting to a database using a socks proxy? by Skeeve (Parson) on Feb 26, 2020 at 20:14 UTC
You ar right. And usually I do. So since I didn't, I think my workaround was not worth mentioning like: Using port forwarding instead of a socks proxy. `s$$([},&%#}/&/]+}%&{});#$&&s&&$^X.($'^"%]=\&(\|?{%` `+`.+=%;.#_}\&"^"-+%*).}%:##%}={~=~:.")&e&&s""`$''`"e	[reply] [d/l] [select]


Perl Monk, Perl Meditation
	PerlMonks