Error: Com.Fivetran.Port.TunnelableConnectionException: Auth Fail

Issue

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

com.fivetran.port.TunnelableConnectionException: Auth fail

Environment

Database connectors

Resolution

To resolve this issue, do the following:

1. Ensure that the public key from your connector's setup form matches your authorized_keys file exactly.
2. Set the authorized_keys file to read and write only by entering the following command: chmod 600 authorized_keys.
3. 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
4. If you're using Redhat v9+, enter the following command: sudo update-crypto-policies --set LEGACY
5. Restart the SSHD service or restart the SSH server.
   • Enter the following service command:# service sshd restart
   • If you are using RHEL, CentOS, or Fedora Linux with systemd, such as RHEL v7 or above, enter the following command: $ sudo systemctl restart sshd
   • If you are using RHEL v6 or below, enter the following command: # /etc/init.d/sshd restart

NOTE: If Fivetran provides your SSH tunnel, contact our support team.

Cause

This issue is caused by one of the below potential causes:

• The authorized_keys file is in the wrong location.
• The public key doesn't match the authorized_keys file.
• The permissions are not set correctly for the authorized_keys file.
• The SSHD is not accepting ssh-rsa key types.