mysql and port 3306

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
uKlarmann
Posts: 7
Joined: Tue 22 May 2007 13:52

mysql and port 3306

Post by uKlarmann » Tue 05 Jun 2007 11:03

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
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 05 Jun 2007 14:14

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.
Top
uKlarmann
Posts: 7
Joined: Tue 22 May 2007 13:52

Post by uKlarmann » Wed 06 Jun 2007 09:30

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
Top
uKlarmann
Posts: 7
Joined: Tue 22 May 2007 13:52

Tunneling

Post by uKlarmann » Wed 06 Jun 2007 09:54

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.
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Wed 06 Jun 2007 11:11

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.
Top
uKlarmann
Posts: 7
Joined: Tue 22 May 2007 13:52

worth a try

Post by uKlarmann » Wed 06 Jun 2007 11:22

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?
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 07 Jun 2007 06:30

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.
Top
uKlarmann
Posts: 7
Joined: Tue 22 May 2007 13:52

MyDAC support

Post by uKlarmann » Thu 07 Jun 2007 08:49

what I really wanted to ask ;-)

does crlab/Mysql Data Access plan to support ssh or php tunneling in the near future?
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 07 Jun 2007 09:59

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/
Top
Post Reply

Return to “MySQL Data Access Components”