Connect via SSH using socket on remote machine

[alexkuc]

This is rather a question than a request specifically. I would like to connect via socket on remote SSH machine. Is this supported? When choosing SSH tab for connection type, I can see user/password fields but I believe it is not possible to specify socket?

[Jason-Morcos]

This isn't supported by Sequel Ace for sure. I'm not sure if it's possible at all but I think probably not?

[alexkuc]

Why it wouldn't be supported in general? That's my home server is set up currently. I ssh into server as a user, say, xyz, type mysql and immediately logged into MySQL w/o prompting for a password. It's auth_socket plugin which is generally preferred over password due to better security.

[Jason-Morcos]

Ace currently doesn't support it. I'd be happy to review a PR that adds support for it if someone writes it, but I think it's too niche a use-case to be a helpful feature for many users.

[alexkuc]

In that case maybe change tag from wontfix to pr-welcome?

[Jason-Morcos]

That's fine. Generally the Wontfix tag is used to indicate issues the core team won't fix/do, but I'm okay removing it in this case.

[alexkuc]

Ah! I thought wontfix meant that if even PR is provided, it won't be considered.

[Jason-Morcos]

No worries!
We review all PRs that are submitted, regardless of if there's an issue or not :)

[e-gaulue]

👍

Google shows more and more requests on it and it is supported by more and more clients (sequel pro).

As far as I've seen, doesn't look hard to do: create a kind of port forwarding but working with sockets instead of ports (so you need to provide the path to the remote sock):

ssh -L /tmp/local-mysql.sock:/var/run/mysqld/remote-mysqld.sock sshuser@remotehost
mysql -h localhost --protocol=SOCKET -S /tmp/local-mysql.sock -u'username' -p'mypassword'

Should be even easier than connect to a local server socket (due to sandbox limitation).

Sorry, I've have strictly no time to spend on it, I already work on too much projects.

Regards,

[e-gaulue]

Just tried from the command line, with the brew mariadb client and it works:

$ mariadb -h localhost --protocol=SOCKET -S /tmp/mysql.sock -u'pipo'
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 97
Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> exit
Bye

If I try through sequel while ssh unix socket tunnel is still active and giving the path of the socket: it doesn't work.

Shame...

[Jason-Morcos]

Just tried from the command line, with the brew mariadb client and it works:

$ mariadb -h localhost --protocol=SOCKET -S /tmp/mysql.sock -u'pipo'

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 97

Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11



Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.



Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.



MariaDB [(none)]> exit

Bye

If I try through sequel while ssh unix socket tunnel is still active and giving the path of the socket: it doesn't work.

Shame...

This comment isn't related to connecting via SSH and hence is not relevant to this issue. Please see the more general socket issue instead #113. This issue is a feature request for remote socket support.

[e-gaulue]

Yes it may. I read #113 too fast and thought it was a file access trouble when trying to access a local mysql server instance socket. As I though I was in another context, I gave it a try. Indeed, it looks to be a larger access trouble.

As I said, I'm really not specialised in Xcode devs, but it would look strange to me a process can't access a socket it creates itself. As far as I understand in #113, people tries to access an existant socket. But maybe, in this context: "Sequel create itself the socket as a remote ssh socket and then consume it", it would work. I don't know exactly what sandboxes imply.

Regards,

[stale]

This issue has been marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[stale]

This issue has been auto-closed because there hasn't been any activity for at least 35 days. However, we really appreciate your contribution, so thank you for that! 🙏 Also, feel free to open a new issue if you still experience this problem 👍.