Devart Forums

i have a lot of apps running at my customers that connect remotely to a mysql database using port 3306 (Delphi 7/mydac 5/mysql 5.1). It happens more and more that those customers have problems establising a connection because they have to configure their firewall, proxy so that they open 3306.
Imagine an standard software that is used by 1000 customers and they all have to configure their firewalls - lot of work -> lot of support.

Is there a possibility to use port 80 instead? a port that is mostly open. I know its for http but why not sending data per http?

that would be great!

Thank you in advance!

Ulf

You can try, but I do not think that this is a good idea, because the traffic transferred through this port can be affected by a firewall, or any other tools. This may lead to data loss. Anyway you should consult your system administrator.

To setup working with MySQL through a non-default port, firstly you should setup your MySQL server. Just change the following line in the [mysqld] section of the My.ini file correspondingly, and restart your server:
port = 3306

To specify the new port number for MyDAC, you should use the Port property of TMyConnection.

I just found the following at http://www.webyog.com/en/sqlyog_tunneling.php that could solve the problem.
They use a php-tunneling script, i.e. web-services. Would it be possible to combine that with myDac?

Ulf

the more I think about tunneling the more I think this is a excellent idea.

Nobody would need to configure their systems in order to make the delphi/MySQL app to work anymore. The app would simply behave as a Web-App but with much better user interface. Just think of emule where only experienced users can configure their firewall in order to make emule work (opening ports) that is really a big disadvantage that hinders the spread of such apps.

uKlarmann wrote:They use a php-tunneling script, i.e. web-services. Would it be possible to combine that with myDac?

Yes, it is possible. But you should know that this may decrease performance of your system.

yes i can imagine that tunneling could decrease performance, but I think its worth a try, isn't it? Does perhaps interbase direct have such a tunneling functionality already?

You can setup port forwarding using any available tool, but we would recommend you to assign a separate port for MySQL server if it is possible.

what I really wanted to ask

does crlab/Mysql Data Access plan to support ssh or php tunneling in the near future?

We added support for SSH tunneling via SecureBridge components in MyDAC 5. You can read more about SecureBridge at this page: http://www.crlab.com/sbridge/