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

[matthiasdg]

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]

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]

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