Issue

While connecting a Database connector via SSH Tunnel, the following error appears:

com.fivetran.port.TunnelableConnectionException: Auth fail

Environment

Database connectors

Resolution

There are a few potential issues that may cause this error. Please follow the checklist below:

• Make sure that the public key from your connector's setup form matches exactly in your authorized_keys file.
• Set the the authorized_keys file to read and write only.
  

  • chmod 600 authorized_keys
    

• Edit the /etc/ssh/sshd_config file with the following parameters

  • PubkeyAcceptedAlgorithms=+ssh-rsa,ssh-rsa-cert-v01@openssh.com
    HostKeyAlgorithms=+ssh-rsa,ssh-rsa-cert-v01@openssh.com

• Redhat v9+ may also need this command

  • sudo update-crypto-policies --set LEGACY

For more information, please visit our Documentation.

Set permissions

chmod 600 authorized_keys

Using your favorite text editor, add the public SSH key from the database setup page in your Fivetran dashboard to the authorized_keys file. The key must be all on one line. Make sure that you don’t introduce any line breaks when cutting and pasting. The public SSH key is generated uniquely for each Fivetran destination.

Cause

• The authorized_keys file is in the wrong location.
• The public key does not match what you've inputted in the authorized_keys file.
• The permissions have not been set correctly for the authorized_keys file.
• The sshd is not accepting ssh-rsa key types.