mysql-workbench-community 无法通过 ssh 连接

mysql-workbench-community 无法通过 ssh 连接

我在通过 ssh tunel 连接到 mysql 服务器时遇到问题,应用程序崩溃了。

我已经在 snap 权限对话框中启用了 ssh-keys,但这似乎没有帮助。

每次我尝试使用 ssh 连接时,都会出现“无法连接到 SSH 隧道,主机的真实性......”弹出窗口,在我确认(例如确定)后,再次尝试连接并崩溃。

工作台是否可能无法将 ssh 指纹添加到某处(因为它总是再次询问)?

我设置了另一个连接,为此我需要手动打开似乎可以正常工作的 ssh tunel。(但如果没有 ssh tunel,工作台仍然会崩溃)。

刚刚安装了全新的 22.04 Ubuntu

MySQL Workbench 8.0.25 内部版本 788958。

MySQL 服务器:8.0.28(在 AWS 上,服务器似乎没有参与?)

snap 的 Strace 看起来很有趣,也证实了我的理论。在打开 known_hosts 进行读取,然后写入(都失败了?)后,它立即崩溃了:

[pid 102272] close(16)                  = 0
[pid 102272] openat(AT_FDCWD, "/home/letynsoft/.ssh/known_hosts", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 102272] openat(AT_FDCWD, "/etc/ssh/ssh_known_hosts", O_RDONLY) = -1 ENOENT (No such file or directory)
[pid 102272] openat(AT_FDCWD, "/home/letynsoft/.ssh/known_hosts", O_WRONLY|O_CREAT|O_APPEND, 0666) = -1 EACCES (Permission denied)
[pid 102272] futex(0x7fc3fec9d1e0, FUTEX_WAKE_PRIVATE, 2147483647) = 0
[pid 102272] close(15)                  = 0
[pid 102272] ioctl(2, TCGETS, 0x7fffa0688010) = -1 ENOTTY (Inappropriate ioctl for device)
[pid 102272] getpid()                   = 102272
[pid 102272] stat("/etc/localtime", {st_mode=S_IFREG|0644, st_size=2329, ...}) = 0
[pid 102272] write(2, "\n(mysql-workbench-bin:102272): g"..., 117
(mysql-workbench-bin:102272): glibmm-ERROR **: 22:52:21.904: 
unhandled exception (type unknown) in signal handler

) = 117

以下是最后一部分/home/<user>/snap/mysql-workbench-community/9/.mysql/workbench/log/wb.x.log

22:24:41 [INF][SSHTunnelManager]: Wakeup socket port created: 35105
22:24:41 [INF][     SSH tunnel]: Starting tunnel
22:24:41 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
22:24:41 [INF][     SSH tunnel]: Opening SSH tunnel to wa4:22
22:24:41 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.5 (c) 2003-2019 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
22:24:41 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 16
22:24:41 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
22:24:41 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.6p1 Ubuntu-4ubuntu0.5
22:24:41 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.6p1 Ubuntu-4ubuntu0.5
22:24:41 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.6 (70600)
22:24:41 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,[email protected],[email protected],[email protected],[email protected],none,none,,
22:24:41 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
22:24:41 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
22:24:41 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
22:24:41 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
22:24:41 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid
22:26:42 [INF][     SSH tunnel]: Opening SSH tunnel to wa4:22
22:26:42 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: libssh 0.9.5 (c) 2003-2019 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_stdthread
22:26:42 [INF][      SSHCommon]: libssh: ssh_socket_connect ssh_socket_connect: Nonblocking connection socket: 16
22:26:42 [INF][      SSHCommon]: libssh: ssh_connect ssh_connect: Socket connecting, now waiting for the callbacks to work
22:26:42 [INF][      SSHCommon]: libssh: ssh_client_connection_callback ssh_client_connection_callback: SSH server banner: SSH-2.0-OpenSSH_7.6p1 Ubuntu-4ubuntu0.5
22:26:42 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: Analyzing banner: SSH-2.0-OpenSSH_7.6p1 Ubuntu-4ubuntu0.5
22:26:42 [INF][      SSHCommon]: libssh: ssh_analyze_banner ssh_analyze_banner: We are talking to an OpenSSH client version: 7.6 (70600)
22:26:42 [INF][      SSHCommon]: libssh: ssh_kex_select_methods ssh_kex_select_methods: Negotiated curve25519-sha256,ssh-ed25519,[email protected],[email protected],[email protected],[email protected],none,none,,
22:26:42 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
22:26:42 [INF][      SSHCommon]: libssh: ssh_init_rekey_state ssh_init_rekey_state: Set rekey after 4294967296 blocks
22:26:42 [INF][      SSHCommon]: libssh: ssh_packet_client_curve25519_reply ssh_packet_client_curve25519_reply: SSH_MSG_NEWKEYS sent
22:26:42 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Received SSH_MSG_NEWKEYS
22:26:42 [INF][      SSHCommon]: libssh: ssh_packet_newkeys ssh_packet_newkeys: Signature verified and valid

我如何启用此快照来访问.ssh/known_hosts

任何帮助都值得感激!

答案1

该问题的解决方案如下:https://askubuntu.com/a/1403713/132783

基本上。

snap connect mysql-workbench-community:password-manager-service
snap connect mysql-workbench-community:ssh-keys

相关内容