TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Published 20 hours ago • verified publisher icon TablePlus

Input values in Host/Socket not being correctly trimmed from spaces, will cause connection to get stuck and fail

Open christianceb opened this issue 2 years ago • 3 comments

Originally posted in the wrong repo.

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): PostgreSQL, connecting to PostgreSQL 14

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 5.0.4 (214) x64

  3. The steps to reproduce this issue:

  • Open a new connection to a database with the correct details as long as you can successfully connect. You might want to use an IP address (e.g.: 127.0.0.1)
  • Close the connection
  • Edit the connection and go to the Host/Socket field
  • Add a space at the end of the hostname
  • Connect
  • Observe your connection get stuck until you terminate it.

Noted: If the bug is related to data, please attach an example SQL data.

This bug was discovered by accident based on the actual scenario I had to go through:

  1. From my macbook running Tableplus Build 468, I exported a PostgreSQL connection with Over SSH set. Unknown to me, there was a stray space at the end of the IP address that I put in the host (e.g.: "127.0.0.1 " instead of "127.0.0.1"). From this build and machine, I was able to connect just fine with this typo.
  2. Gave the connection file to a friend running on a Windows 11 Pro machine, with TablePlus 5.0.4 (214) x64
  3. Tried to connect with it and stuck for hours wondering why I can connect with that connection file but my friend could not
  4. Instructed him to recreate the connection from scratch, surprisingly was able to connect.
  5. A quick digging around revealed that the stray space from the exported file I sent was enough to cause the connection to fail.

christianceb avatar Dec 22 '22 14:12 christianceb

@christianceb does your Windows Client actually show the field as Host/Socket?

I'm on 5.3.1 (224) and it only shows the field as Host. Trying to put in a socket results in a hanging connection similar to what you described.

Below are the settings that I exported from my iPad where it works just fine. I even tried adding the rest of the /.s.PGSQL.5432 to the path, but nothing changed.

Any ideas?

image

Yukigamine avatar Feb 17 '23 04:02 Yukigamine

Hi @colwellkr the TablePlus on Windows does not support create a tunnel with socket. We will support in the future release.

huyphams avatar Feb 17 '23 04:02 huyphams

I'd assume this is related to this issue: https://github.com/TablePlus/TablePlus/issues/3113 ?

guplem avatar Oct 16 '23 16:10 guplem