Accessing Vertica using socks proxy
Answered
Vertica is accessible via a socks (jump) server. What do I need to do on the machine running Idea.sh (IntelliJ) to access Vertica via the socks server?
Please sign in to leave a comment.
SSH proxy is available for any database connection in "SSH" tab. See
I am still having problems.
Let me explain what I have.
I have a jumper-server (the socks proxy server) at bastion1.r1.03.laxa.gaikai.net (I can ssh into it).
I configured my ~/.ssh/config to listen on 1080 and send requests to proxy server:
IdentityFile ~/.ssh/id_crt
CACertificateFile /etc/ssl/gk.certs/cacert.pem
CARevocationFile /etc/ssl/gk.crl/cacrl.pem
ForwardAgent yes
CanonicalizeHostname always
PubkeyAuthentication yes
User ucarrasquilla
DynamicForward 1080
Host bastion
HostName bastion1.r1.03.laxa.gaikai.net
#===================== end of file ===========================
Let me show you what I have in IntelliJ for the "Data Sources and Drivers"
1) the Vertica server is at 10.11.192.135 port = 5433 and the database = gaikai for user=microstrategy
2) I go to advanced and under the VM Options I tell it to use a proxy host = localhost and proxy port = 1080
I expect that between this information and the setup in my ~/.ssh/config would be sufficient.
With this new information, is there anything I need to put in the SSH/SSL tab (the one you posted)?
One more comment, when I do a "Test Connection" I get success:
It is only when I try to run a SQL that it complains.