Connect with an SSH tunnel

You can set up an SSH tunnel to connect to OpenText™ Analytics Database through a proxy server. This can be useful in cases where the client or database server is on a private network.

Server on private network

If the database server is on a private network, run ssh -R to configure remote port forwarding on the database server host. For example, to let the client connect to the database through a proxy hosted on proxy.example.com:9595:

1. On the proxy server, add GatewayPorts yes to /etc/ssh/sshd_config.

2. On the proxy server, restart the SSH service:

   $ sudo systemctl restart ssh
   

3. On the database server host, run:

   $ ssh -N -R 9595:localhost:5433 user@proxy.example.com
   

4. On the client host, run the following to connect to the database through the proxy server:

   $ vsql -h proxy.example.com -p 9595
   

Client on private network

If the client machine is on a private network, run ssh -L on the client to configure local port forwarding. For example, to let the client use localhost:9595 to connect to the database hosted on vertica.example.com:5433 through a proxy on proxy.example.com:

$ ssh -N -L 9595:vertica.example.com:5433 user@proxy.example.com

You can then connect to the database from the client:

$ vsql -p 9595