Connecting Through SSH

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

1. Select SSH option

While configuring Source connection, select Connect through SSH checkbox.

2. Provide SSH Server Details

Provide following information about your SSH Server:

  • SSH IP - The IP address / 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)

3. Add Hevo Public keys to authorized_keys

You will have 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/append Hevo public key to authorized_keys file.
Alternatively, you can use the following command for the same:

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

Usage:

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

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

Last updated on 24 Aug 2020