Mysql Yog Through Proxy

[ruirib]

Does the enterprise version allow you to connect to a MySQL server through a proxy? I don't need to use tunneling, but in my work network all outside traffic goes through a proxy and I need to connect to a MySQL server outside.

I've been using the Community edition and it does noy support proxies. I am more than willing to buy the Enterprise version to be able to use a proxy, as described, as long as the feature is supported.

Thx, in advance, for replying.

[peterlaursen]

Yes .. the ENTERPRISE version supports proxies.

(setting are on Tunnel tab .. HTTP-tunnelling .. advanced button)

Download the TRIAL today and try for yourself.

Please report any problem (but there should not be).

[ruirib]

Yes, but doesn't tunneling need to be enabled to use proxies too?

[peterlaursen]

No there is nothing to 'enable' if I understand your question right.  No configuration on the host/network where the MySQL is, is required.

Technically (from a programmer's perspective) it is almost the same wheter you connect to a HTP server on a remote host/network (and connct to a MySQL server from here) or whether you connect to a Proxy server on your local network and connect to a MySQL server from here.  That is why we have arranged this where it is.

The easiest would be to try!  

[ruirib]

peterlaursen wrote on Dec 20 2006, 02:11 PM:

No there is nothing to 'enable' if I understand your question right. No configuration on the host/network where the MySQL is, is required.

Technically (from a programmer's perspective) it is almost the same wheter you connect to a HTP server on a remote host/network (and connct to a MySQL server from here) or whether you connect to a Proxy server on your local network and connect to a MySQL server from here. That is why we have arranged this where it is.

The easiest would be to try!

I've tried it, but didn't upload SQLYogTunnel.php to the server. My question is, this upload is still needed? Or, putting it differently, the tunnelling option needs to be checked, right?

Speed wise, how does HTTP tunneling behave? Is a slowdown very noticeable?

Thx for your replies.

[peterlaursen]

I must admit that I personally know very little about this.

I have 'called in' assistance to explain in detail.

Please be a litttle patient.

[ruirib]

I'll wait 🙄 .

Thank you.

[Rohit]

There is no built in support for proxies in mysqld. You will have to open up a port by some external means such as creating an SSH tunnel.

Additionally, the MySQL client library does not provide any option to access the underlying socket. This prevents us from developing our own proxy server support for SQLyog.

However, SQLyog HTTP tunnelling module *WORKS* over proxy server. So if you are able to connect to a HTTP server, you should be able to connect to MySQL as well.

[ruirib]

Thank you.

[Author]

Posts