Open guillaumealgis opened 5 years ago
Hi we have a blog with debug build here, where you can see SSH detail on your terminal: https://tableplus.com/blog/2018/10/failed-to-connect-via-ssh-tableplus.html
@huyphams Thanks. I doesn't help me understand the problem better, but maybe it'll help you :
[2019/01/22 18:32:39.254935, 3] ssh_config_parse_file: Reading configuration data from /Users/guillaume/.ssh/config
[2019/01/22 18:32:39.261238, 1] ssh_config_parse_line: Unsupported option: AddKeysToAgent, line: 3
[2019/01/22 18:32:39.261265, 1] ssh_config_parse_line: Unknown option: UseKeychain, line: 4
[2019/01/22 18:32:39.261276, 1] ssh_config_parse_line: Unsupported option: AddKeysToAgent, line: 7
[2019/01/22 18:32:39.261286, 1] ssh_config_parse_line: Unknown option: UseKeychain, line: 8
[2019/01/22 18:32:39.262151, 3] ssh_config_parse_file: Reading configuration data from /etc/ssh/ssh_config
[2019/01/22 18:32:39.262269, 2] ssh_config_parse_line: Unapplicable option: SendEnv, line: 49
[2019/01/22 18:32:39.262370, 2] ssh_connect: libssh 0.8.5 (c) 2003-2018 Aris Adamantiadis, Andreas Schneider and libssh contributors. Distributed under the LGPL, please refer to COPYING file for information about your rights, using threading threads_pthread
[2019/01/22 18:32:42.081344, 2] ssh_socket_connect: Nonblocking connection socket: 22
[2019/01/22 18:32:42.082273, 2] ssh_connect: Socket connecting, now waiting for the callbacks to work
[2019/01/22 18:32:42.082317, 3] ssh_connect: Actual timeout : 35000
[2019/01/22 18:32:42.091762, 4] ssh_socket_pollcallback: Poll callback on socket 22 (POLLIN ), out buffer 0
[2019/01/22 18:32:42.092041, 1] socket_callback_connected: Socket connection callback: 2 (61)
[2019/01/22 18:32:42.092228, 1] socket_callback_connected: Connection refused
[2019/01/22 18:32:42.092246, 3] ssh_connect: current state : 9
Ok super weird : I swear I didn't change anything, and suddently the connection started working.
Connected a few times, then I stopped the VPN connection and started it again (without restarting TablePlus) and now I can't connect again. I'm puzzled.
Hmm, are you using the debug build or the normal build?
Debug.
Here the full log of one of the run I just did in the debug build.
At first the connection fails a few times, and (without changing the settings) it suddently starts connecting.
Connecting to the server using ssh
in another terminal seems to "help" TablePlus to open the connection, but it could be a coincidence.
Thanks @guillaumealgis for the super details log. It’s midnight at my timezone so i will be back tomorrow. Please use native open-ssh as a temporary solution for now.
Don't worry about it, it's no emergency. I was using Postico until then and was just giving TablePlus a try 👍
Is there any plan on the roadmap to support connection to databases using VPN? It's the same case as the original issue. I need to connect to a MSSQL database using a VPN and I'm not able to do it in Table Plus. I got the following error and the VPN and database are working properly because I'm doing a couple of queries in another client on the same machine
Thank you
I have the same problem with connecting to remote server ( not local ) while using VPN connection. If I disconnect VPN, it works fine as expected, so clearly the issue is with configuration somewhere. Is there a way to connect via VPN already?
@cruzo333 same issue here, I wasted a lot of time today thinking something was wrong with my VPN and MSSQL server, but it turns out its a TablePlus issue.
I can connect to any server with VPN (Cloudflare Warp) and many users out there can. There are a lot of edge cases and we simply could not cover all that cases. If you have any issues please try with other clients (to confirm the credentials are correct) or create a tunnel using ssh command line. I'm trying to reproduce the issue but it's not that simple and I think I need lots of luck to fix this issue.
@huyphams This is with MSSQL server, without SSH, so its just a normal username/password combination. Other clients work, such as Beekeeper and Azure Data Studio, but I prefer the native feel of TablePlus and those tools are barely usable
SQL Server is very complicated. There are many drivers that support it with various input syntax, TablePlus uses freetds (as it's a native), can you can give me your error message?
Beekeeper didn't use Freetds so the input syntax in Freetds could be a bit different
This is what I am getting:
Error: Read from the server failed (prod.database.example.com)
Adaptive Server connection failed (prod.database.example.com)
Message:
(no message is present)
The error is caused by the use of the wrong version of TDS.
To resolve just specify the TDS version
Could you please try to change this input?
Awesome, thank you! This works!
Hi, we added support ed25519
in this patch, if you have a chance, please try it (also don't leave the ssh user empty): https://www.dropbox.com/s/3rkgc4yylrr9buj/TablePlus.dmg?dl=0
Hi, I'm having the same type of problem as reported here - unable to connect to PostgreSql DB over SSH (SSH username is filled, no password, using private key) when Warp (Cloudflare) VPN is active. Verified on the latest version of TablePlus (build 469). The connection to the SSH server works well.
PostgreSQL 10.6
182
Hi,
I'm trying to connect to a server which is only available through a VPN connection. Unfortunatelly it seems TablePlus is enable to find the server.
I tried to connect to a server with a similar setup but accessible without VPN and it worked fine. I also confirmed that I could connect to the server behind a VPN using the
ssh
command and Postico.I tried several different settings, none of which is working (I'm always getting
Can't connect to host
) :I'm also unable to get any more connection information / logs from TablePlus so it's complicated to debug the issue further.
Thank you for your help.