search

TablePlus / TablePlus-Linux

TablePlus Linux issue tracker
https://tableplus.com
293 stars 30 forks source link

TablePlus with ssh tunnel: "ssh error could not authenticate with private key" #70

Open matthiasdg opened 4 years ago

matthiasdg commented 4 years ago

  1. Database version (Ex: PostgreSQL 10.0): Postgres 10

  2. TablePlus version (the number on the welcome or about screen, Ex: build 81): (Alpha) build 60

  3. Linux distro (Ex: Ubuntu 18.04): Ubuntu 20.04

  4. The steps to reproduce this issue: I have a few remote databases, where I use ssh tunneling to connect. This normally works fine, but today I had one failing with the error mentioned above (unfortunately not very meaningful).
    After examining the private key, it turned out it started with -----BEGIN OPENSSH PRIVATE KEY----- instead of -----BEGIN RSA PRIVATE KEY-----. Turns out this is a different format (https://coolaj86.com/articles/openssh-vs-openssl-key-formats/) and this is not supported by the library(?) used by TablePlus, but of course works with the regular OpenSSH client I use to login for cli tasks. After converting the key to the right format, using ssh-keygen -p -N "" -m pem -f /path/to/key (https://stackoverflow.com/a/55817907/1382108) TablePlus was working fine with this connection. Maybe this format could be supported too? (or more specific error messages could help as well). Could also be related to the more general https://github.com/TablePlus/TablePlus/issues/412

ZayRTun commented 3 years ago

Hi, I am on Build 64 and I am trying to connect to db on server but I keep getting the same message.

James-h143 commented 3 years ago

I can confirm this issue on my end too TablePlus (Alpha) Build 64 on Debian 10

JaldeaR commented 1 year ago

Issue still resides Pop_OS! 22.04 TablePlus 0.1 (192) Alpha