To connect to a database in a private network, create an SSH tunnel using the following steps:
Download our public key and whitelist
220.127.116.11 through your firewall.
Create a user account for Periscope:
[email protected]:~$ sudo useradd periscope
Note there's no password, as Periscope authenticates via public key. Authorize that key by opening up periscope_id_rsa.pub and pasting its contents into a new line in
In most cases the SSH Port will be default 22. Check the Port variable in
/etc/ssh/sshd_config to see which port is used for SSH.
[email protected]:~$ cat /etc/ssh/sshd_config | grep Port Port 22 [email protected]:~$
For more details, including how to set up a Windows bastion host, check out this section of our redshift guide.
Finally, return to the Connect Form with your SSH host, port and username, and click
Connect to a Private Network.