To set up a reverse SSH tunnel to your integration, contact Alooma support and provide the public key you will use to connect to our network (usually, the contents of
Once we set up a user for SSH, support will contact you and provide you with the username, tunnel server, and port.
Then, set up a reverse SSH tunnel using the command:
autossh -M 0 -f -N -R <port>:<redshift-host>:5439 <USERNAME>@<tunnel-server>o -g -i ~/.ssh/id_rsa -o ServerAliveInterval=10 -o ServerAliveCountMax=1 -o ExitOnForwardFailure=yes
We recommend you run the command using
runsv or a similar service monitor.
When setting up the connection to your integration, set
<tunnel-server> as the host and
<port> as the port.