Question

You are trying to connect your Database Connector via SSH Tunnel and receive the following  error:

com.fivetran.port.TunnelableConnectionException: Auth fail

Environment

Connector: Database Connectors

Answer

• The public key from your Connector's setup form must match exactly in your authorized_keys file.
• Set the correct permissions for the authorized_keys file
• Ensure the entry PubkeyAcceptedKeyTypes in the sshd_config file is including the ssh-rsa key type.  This can be accomplished with the line PubkeyAcceptedKeyTypes=+ssh-rsa

Reference: https://fivetran.com/docs/databases/connection-options#createsshuser

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

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