Error: SSH_MSG_DISCONNECT: 2 Too Many Authentication Failures
Issue
While connecting a database to Fivetran using an SSH tunnel, the following error appears:
SSH_MSG_DISCONNECT: 2 Too many authentication failures
Environment
Database connectors using the SSH tunnel connection method.
Resolution
To resolve this issue, do the following:
- Go to the Setup tab of your connector details page.
- Under Connection Details, locate and copy the Public Key.
- Add the public key to your SSH server's
authorized_keys
file.
NOTE: For more information on adding the public key to your SSH server's
authorized_keys
file, see step 9 of our create SSH user documentation.
Cause
This issue occurs when you don't add the public SSH key from the database setup page to your SSH server's authorized_keys
file.