~/.ssh/config not loading

[MaximeLaurenty]

I have a ssh config which I want to use with TablePlus on Windows (10). As soon as I try to use the ssh config (by selecting Use SSH Key and leaving SSH private key blank), connection fails (after 2min) with message SSH Error / Can't connect to host.. It looks to me as if ~/.ssh/config is not loaded.

More infos:

• The ssh config is not faulty given it is working with Powershell.
• The TablePlus connection setup is the same as I have for MacOS (where it is working fine).
• If I define all parameters within TablePlus (and not rely on ssh config), connection works. However I can't do this for all connections because most use ProxyCommand and there's no TablePlus option to use ProxyCommand.
• SSH debug Logs are too light to give any direction:

  [15:01:27.369826] ssh_connect: libssh 0.9.2 (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_winlock[15:01:29.642124] ssh_socket_connect: Nonblocking connection socket: 3616
  [15:01:29.642124] ssh_connect: Socket connecting, now waiting for the callbacks to work
  [15:01:29.642124] ssh_connect: Actual timeout : 120000
  

• Using an older build, the SSH debug log was indicating "failed to resolve hostname".
• If I try a server which is not defined in ~/.ssh/config I have the exact same logs.

Moreover that's slightly different but related: once I've tried to connect and it timed out, trying to connect again to another functional SSH connection (set in TablePlus) writes no additional debug log (like it would before) and connection takes ~1min to be tested (instead of 1sec before).

Please answer the questions below, it helps us to track the issue.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 8.0

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 218

3. The steps to reproduce this issue:

• Create/Get a server which you can connect to with SSH
• Create a ~/.ssh/config file with

Host master_ssh
  Hostname your.server.url.com
  IdentityFile id_your_key
  User ubuntu
  Port 22

• set up a MySQL connection in TablePlus:

[MaximeLaurenty]

I can use port redirection to connect, but having one terminal open per db I need to connect to + having to map all local ports so none overlap is pretty painful.

[huyphams]

Hi @MaximeLaurenty TablePlus windows does not support ssh config. You have to enter host port and import private key manually

[huyphams]

I don't understand wht you need to do the port forwarding manually as you can just put the host/port into the TablePlus ssh entries?

[MaximeLaurenty]

@huyphams I put the simplest example to highlight that ssh config wasn't working. The real reason why I want to use ssh config is that to connect to my servers, I need to use a ProxyCommand: see AWS doc

ProxyCommand C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe "aws ssm start-session --target %h --document-name AWS-StartSSHSession --parameters portNumber=%p"

If there was a way to indicate a ProxyCommand in TablePlus directly, I would use it directly. But it doesn't exist yet, does it?

[MaximeLaurenty]

If ProxyCommand is not available for now, is it a feature on the roadmap? Or otherwise having ssh config supported on TablePlus Windows ?

We have roughly ~15 TablePlus users (with licences) on Windows for which I have to find a solution, and the only clean alternative I see so far is to setup a VPN for them to access the instances without using ProxyCommand / AWS SSM, which will cost us an extra few hundreds $/month ...

[cdomigan]

We have a similar issue. We are using ephemeral IPs on our dev VMs, and update the .ssh/config file automatically to point the Host to the latest IP. Without windows support for ssh config files we have no way of reliably connecting to our instances from TablePlus :(

[MaximeLaurenty]

@huyphams is there any chance to see an improvement on this? Having ssh config supported on TablePlus Windows would really be great for us, and bring it a bit more on par with Macos !

[pomegranited]

Hi @MaximeLaurenty TablePlus windows does not support ssh config. You have to enter host port and import private key manually

Is this still true? Docs say otherwise: https://docs.tableplus.com/gui-tools/manage-connections#ssh-tunneling