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
Reference: https://fivetran.com/docs/databases/connection-options#createsshuser
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
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