1. Problem phenomenon
The workbench that is normally used on weekdays finds that it cannot connect to the corresponding database after restarting the computer, and the workbench log displays
SSH tunnel]: Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
Check the complete log and find the following:
$ tail -f ~/.mysql/workbench/log/wb.log
File "/usr/share/mysql-workbench/sshtunnel.py", line 303, in _connect_ssh
look_for_keys=has_key, allow_agent=has_key, timeout=SSH_CONNECTION_TIMEOUT)
File "/usr/lib/python2.7/dist-packages/paramiko/client.py", line 325, in connect
t.start_client()
File "/usr/lib/python2.7/dist-packages/paramiko/transport.py", line 492, in start_client
raise e
NotImplementedError: Use module Crypto.Signature.pkcs1_15 instead
14:17:14 [INF][ SSH tunnel]: TunnelManager.wait_connection authentication error: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
14:17:14 [ERR][ SSH tunnel]: Authentication error opening SSH tunnel: Authentication error, unhandled exception caught in tunnel manager, please refer to logs for details
14:18:24 [INF][ WBContext]: Connection to XinJangCityWolMart cancelled by user: Tunnel connection cancelled
The point is
NotImplementedError: Use module Crypto.Signature.pkcs1_15 instead
Found after querying with PIP list
$ pip2 list | grep crypto
asn1crypto (1.4.0)
cryptography (2.7)
pycrypto (2.6.1)
pycryptodome (3.11.0)
There is a pycryptodome
, which may be installed when installing other tools later
2. Solutions
Uninstall pycryptodome
sudo pip2 uninstall pycryptodome
Then reopen the workbench
to connect to the database and return to normal.
Read More:
- ansible Q&A: Failed to connect to the host via ssh: ssh_exchange_identification and Authentication or per
- ssh can connect but sftp can not connect
- Solve the problem of keyboard interactive authentication with the SSH2 server failed
- Cloning failed using an SSH key for authentication
- MySQL Workbench Failed to Connect to MySQL at 127.0.0.1:3306 with user root Bad handshake
- [Error resolution] paramiko.ssh_exception.SSHException: Error reading SSH protocol banner setting
- The solution to the problem that the virtual machine and the host SSH can’t connect on vmvare
- Gt Report Error ssh:connect to host github.com port 22
- SSH Remote ulimit does not work
- [How to Fix] MySQL Workbench for Mac Flashback
- CDH HDFS webui browser authentication (after Kerberos authentication is enabled)
- [MySQL] the solution of MySQL workbench “error code: 1175”
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- Authentication error occurred on remote connection, the required function is not supported
- Failed to restart ssh.service: Unit not found.
- MySQL workbench insert data prompt error: 1046 (errorcode: 1046. No database select…)
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- Solution to MySQL workbench error 1148 unable to load local data
- Python module learning-Paramiko-Use python to throw an exception: Authentication failed.