search

ellie-commons / sequeler

SQL Client built in Vala
GNU General Public License v3.0
804 stars 66 forks source link

Connecting through SSH Tunnel #325

Open rattlion opened 4 years ago

rattlion commented 4 years ago

Hey there. I'd love to help trouble shoot this issue if you like but I wasn't immediately sure where to start. Haven't developed for Gnome or in Vala yet but willing to pick it up.

I'm trying to connect to a database through an SSH tunnel but I seem to get a DNS error at first, could not translate host name. In this case the host name is not publically available and would make sense if I were trying to directly connect. But it is in fact available via the server I ssh to. To confirm I manually connected through the command line, and also with DBeaver and DataGrip.

If I dismiss the error and try again I get a different error, failed to bind.

I couldn't find where the app logs to so please let me know if there is more info I can pull to share.

Built from AUR.

Unable to Connect to dbname could not translate host name "hostname" to address: Name or service not known

Unable to Connect to dbname Failed to bind. Your Database Port may be wrong!

FranciscoDA commented 4 years ago

Passing G_MESSAGES_DEBUG=all as an env var enables logging to stdout. Maybe showing non-sensitive db connection params can help too

Alecaddd commented 4 years ago

This might be an issue of LibGDA which can't handle some specific setting of your remote server, or could be an issue of the AUR package, which I don't maintain directly. Hard to troubleshoot without having access to your SSH server and Database to look at your configuration.