Menu

#3 ssh tunnel vs my.cnf "skip-networking"

open
nobody
None
5
2006-09-03
2006-09-03
Nisvara
No

I have a concern regarding CocoaMySQL and ssh tunnel. For the record I
have been able to connect to a mysql server via a remote ssh tunnel using
CocoaMySQL. However this case presents an obstacle for which I am at a
loss in negotiating.

I have deduced the remote mysqld connect failure to be attributed by the
fact that the remote mysql server is utilizing the "skip-networking" option
in "my.cnf". It is stated in the mysql documentation that this option
restricts mysqld from using the network stack--no tcp port for network
connections. As such, I am forced to talk to the mysqld via a unix socket
file.

- I have tried creating the ssh tunnel leaving the remote port designation
blank--to no avail.
- I also tried entering the location of the remote mysql.socket file into the
"socket *" field within the CocoaMySQL connection window--to no avail.
CocoaMySQL seemed to be trying to look in my filesystem for the location
of mysql.socket. I suspect some limitation within ssh local port
forwarding.

That being said, I am not sure if a CocoaMySQL connection via ssh tunnel
is possible at all under this particular scenario. Omitting "skip-
networking" is currently not an option.

I am using CocoaMySQL 0.7b4 on OS X 10.4.7 (8J135). The remote mysql
server is running MySQL 3.23.58.

Best Regards

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.