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 correct permissions for the
authorized_keys
file. - Make sure that the entry
PubkeyAcceptedKeyTypes
in thesshd_config
file is including thessh-rsa
key type.
Note: This can be accomplished with the line:PubkeyAcceptedKeyTypes=+ssh-rsa
For more information, please visit our Documentation.
Set permissions
chmod 600 authorized_keysUsing 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.