Connecting Through SSH

Hevo can connect to your database via SSH tunnel. Let’s walk through the steps to enable connection through SSH.

Note: You need to whitelist the IP addresses for your respective region on the SSH server. Read Hevo Regions.

Select SSH Option

While configuring the Source connection, select the Connect through SSH check box.

Provide SSH Server Details

Provide the following information about your SSH Server:

  • SSH IP - The IP address or DNS of the SSH server

  • SSH Port - The port of the SSH server as seen from the public internet (default is 22)

  • SSH User - The username on the SSH server (e.g. hevo)

Add Hevo Public Keys to Authorized_Keys

You need to add our public keys file on your SSH Server to .ssh/authorized_keys to enable Hevo to authenticate via public keys.
Following are the steps required for this:

a. Copy our public keys from source configuration screen.

b. Create ssh directory in home directory if it doesn’t exist and give read, write and execute permissions.

#Creates the .ssh directory:
mkdir ~/.ssh

#Set permissions:
chmod 700 ~/.ssh

c. Create authorized_keys file if it doesn’t exist and give read, write permissions.

#Move to the .ssh directory:
cd ~/.ssh

#Create the authorized_keys file:
touch authorized_keys

#Set permissions:
chmod 600 authorized_keys

d. Using your favorite text editor, add or append Hevo public key to authorized_keys file.
Alternatively, you can use the following command for the same:

echo '<public_key>' >> ~/.ssh/authorized_keys


echo 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDyfYljMfLMVD3erbKdslUDzbEUpcxAJgH33HWPtLgVjNAEMeMb2mJe4Zt72gDZnDmO/tMxbPfjIqnR7n2Jkc4XsoS3StvwEeGQ3AuwbWo1NQaDg8P8fHOOgY6z0VglYEZHDIhnZyA/UDLWEUAmQeuZm0tgBZtj/tm+qzdftX6cKzgFNSnimTivBXVmNdHKz+42Wpc/2XRRo6DqHgWnhKR47qcsVfasLd1RdqaJ3Sn4sDDC17KQ/3AMrvF47J0RIwVue/KHdfVi0HmI2Yv4goENokSrVuus7uUPI4bT8pvfb11ugVOGXS61IPyOZYaUQW5dfb00itm9tMBUFdD/nJNL' >> ~/.ssh/authorized_keys

Hevo will be able to connect to your database through SSH after these steps.

Last updated on 18 Nov 2021