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:
- Ensure that the public key from your connector's setup form matches your
authorized_keys
file exactly. - Set the
authorized_keys
file to read and write only by entering the following command: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
- If you're using Redhat v9+, enter the following command:
sudo update-crypto-policies --set LEGACY
- 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
- Enter the following service command:
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.