how to connect mysql server with http tunnel

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

how to connect mysql server with http tunnel

Post by kadrisoft2006 » Wed 22 Aug 2012 08:23

hello i found in unidac help how to coonect mysql server with http tunnel
but not worked for me

UniConnection := TUniConnection.Create(self);
UniConnection.ProviderName := 'MySQL';
UniConnection.Server := '192.168.0.10';
UniConnection.Port := 3307;
UniConnection.Username := 'root';
UniConnection.Password := 'root';
UniConnection.SpecificOptions.Values['Protocol'] := 'mpHttp';
UniConnection.SpecificOptions.Values['HttpUrl'] := 'http://server/tunnel.php';
UniConnection.SpecificOptions.Values['ProxyHostname'] := '10.0.0.1';
UniConnection.SpecificOptions.Values['ProxyPort'] := '808';
UniConnection.SpecificOptions.Values['ProxyUsername'] := 'ProxyUser';
UniConnection.SpecificOptions.Values['ProxyPassword'] := 'ProxyPassword';
UniConnection.Connect;

message error is
can't establish http connection

AndreyZ

Re: how to connect mysql server with http tunnel

Post by AndreyZ » Wed 22 Aug 2012 10:28

Hello,

Please check that the tunnel.php script is available through the HTTP protocol. You can verify whether it is accessible using a web browser.

kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

Re: how to connect mysql server with http tunnel

Post by kadrisoft2006 » Fri 24 Aug 2012 21:13

file exsist in the server:

Devart HttpTunnel v1.69
Tunnel script is installed correctly.
You can establish connections through the HTTP tunnel.

but not working

kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

Re: how to connect mysql server with http tunnel

Post by kadrisoft2006 » Sun 26 Aug 2012 11:03

any soulution plz

note: http tunnel with Navicate work greate !!!

AndreyZ

Re: how to connect mysql server with http tunnel

Post by AndreyZ » Mon 27 Aug 2012 11:02

Please try using Devart HttpTunnel v1.66 that is supplied with UniDAC (and not Devart HttpTunnel v1.69 you are using now) and check if the problem persists.

kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

Re: how to connect mysql server with http tunnel

Post by kadrisoft2006 » Mon 27 Aug 2012 12:32

some problem !!

AndreyZ

Re: how to connect mysql server with http tunnel

Post by AndreyZ » Mon 27 Aug 2012 14:20

Please send your connection options (that you use in the example provided in your first post) to andreyz*devart*com .

kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

Re: how to connect mysql server with http tunnel

Post by kadrisoft2006 » Tue 28 Aug 2012 12:17

iam send all my information and project

AndreyZ

Re: how to connect mysql server with http tunnel

Post by AndreyZ » Wed 29 Aug 2012 07:04

I have tried to investigate the problem, but your host is not responding. Please make it running.

kadrisoft2006
Posts: 6
Joined: Wed 22 Aug 2012 08:15

Re: how to connect mysql server with http tunnel

Post by kadrisoft2006 » Wed 29 Aug 2012 09:20

my host it working and this image for connection with navigate


Image

AndreyZ

Re: how to connect mysql server with http tunnel

Post by AndreyZ » Wed 29 Aug 2012 13:11

We have checked this question. Your firewall (that you have on your host) blocks our attempts to connect to it. Your firewall blocks our entire subnet, so we cannot connect to your host from any of our computers. The problem you encountered with tunneling is probably caused by the same reasons. When you connect to the tunnel.php script, it opens a random port to maintain the connection to the server. Please set up your firewall to allow the tunnel.php script to work and not to block the computer that uses it.

Post Reply