
Optimizing SSH Tunnel for Security and Performance Paste the public key (ensure it is pasted on a single line).Open the ~/.ssh/authorized_keys file in your preferred text editor on the bastion server.Using the Copy icon, copy it to your clipboard. You can get the public key once the Key-Pair is formed (starts with ssh-rsa).

(You can create new key pairs, use existing ones, or delete them).Ĭreate your Key Pair by giving it a name and clicking the Create Key Pair button. Select Auto Generated from the SSH Options section.Select the correct SSH tunneled source connection (for example, MySQL).In Rivery console, Go to Connections in the main menu and click New Connection.There is a requirement to generate a new public key that will allow Rivery to connect to the server. Ssh -i /path/to/key_pair.pem Create a group rivery:

Connect to your ssh tunnel server using ssh (we're using the same example of the aws server created above):.Run the following commands on your SSH tunnel host:
#CREATING SSH TUNNEL LINUX INSTALL#
On Windows, you'll need to install an SSH client like OpenSSH to use SSH. This part assumes you're using a Linux or Ubuntu SSH server.

Set up an SSH tunnel on AWS EC2 by following these steps: Configuring an SSH TunnelĬonnect to an AWS EC2 Linux instance via SSH, and then use the same connection to connect to the database instance/Redshift/Azure SQL DWH cluster.
#CREATING SSH TUNNEL LINUX HOW TO#
This tutorial will show you how to configure the server so that Rivery can access it, but it will not show you how to build the server.
