MySQL Forums
Forum List  »  MySQL Workbench

Re: Trouble connecting to database via SSH
Posted by: Lawrence Cooke
Date: November 21, 2020 05:10PM

I did look at the release notes, the issue goes back to the very first release of work bench 8. I have tried various versions to see what would happen.

I looked at the log file and there was something of interest there:


10:03:21 [INF][ SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 6
10:03:21 [INF][ SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
10:03:22 [INF][ SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ecdsa-sha2-nistp256,aes256-ctr,aes256-ctr,hmac-sha2-256,hmac-sha2-256,none,none,,
10:03:22 [INF][ SSHCommon]: libssh: ssh_packet_dh_reply ssh_packet_dh_reply: Received SSH_KEXDH_REPLY
10:03:22 [INF][ SSHCommon]: libssh: ssh_client_curve25519_reply ssh_client_curve25519_reply: SSH_MSG_NEWKEYS sent
10:03:22 [INF][ SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
10:03:22 [INF][ SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
10:03:23 [INF][ SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'none'. Authentication that can continue: publickey,password,keyboard-interactive
10:03:23 [INF][ SSHSession]: Banner:
10:03:23 [INF][ SSHCommon]: libssh: ssh_packet_userauth_failure ssh_packet_userauth_failure: Access denied for 'unknown'. Authentication that can continue: publickey,password,keyboard-interactive
10:03:23 [INF][ SSH tunnel]: SSH tunnel opened on port: 53903
10:03:54 [ERR][SSHTunnelHandler]: Unable to open tunnel. Exception when opening tunnel: Unable to open channel

Whats interesting is the errors "Access denied for 'none'. Authentication that can continue: publickey,password,keyboard-interactive"

and

"Access denied for 'unknown'. Authentication that can continue: publickey,password,keyboard-interactive"

that almost looks like it hasn't sent the password or something to the server, even though it is set.

Not sure if that is what it is or not, but it seems weird.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Trouble connecting to database via SSH
12
November 21, 2020 05:10PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.