Devart Forums

Hi,
is it possible to use tunnel.php which reside on the https site? I am getting errorr "cannot establish HTTP connection". On http site is working ok. I also tried as protocol mpSSLHttp but without success.

Thanks

Currently, MyDAC supports tunneling via HTTP protocol only. We will consider the possibility to implement support for HTTPS protocol tunneling.
Setting the Protocol property to mpSSLHttp means using SSL protocol for interaction with MySQL server, not with HTTP server.

Hi,

in 9.0.1 is added:
Support for HTTPS protocol is added

How can i use this? If try https url for tunnel i am getting error "" Secure connection i snot available"

Thanks

HTTPS protocol tunneling is only supported when using MyDAC components with SecureBridge components with the help of the TMySSLIOHandler component. To use HTTPS protocol tunneling, please place on the form the TMySSLIOHandler component, assign it to the TMyConnection.IOHandler property and set the Protocol property to mpHttp or mpSSLHttp.
The TMySSLIOHandler component is located in the mydacsbridge package. This package is included in the MyDAC demos. See the package installation instructions in the file "%MyDACDemos%\TechnologySpecific\SecureBridge\Readme.html", where %MyDACDemos% is the MyDAC Demo projects installation path on your computer.

HI,

i have tried and it work but it is extremely slow. About 10x slower than http tunnel version.

How can fix this?

Thanks

It is wrong to compare the speed of work over HTTP and HTTPS protocols, because when using HTTPS protocol comparing to HTTP, some additional operations are performed: encryption (decryption), authentication and additional security data; and the execution time of these additional operations depends on very many environment factors of each specific case.
But the speed fall is in ten times - this is an unusual behavior. In order to investigate the specified behavior our components, please compose and send us a small sample demonstrating the issue with test access to your server and send it to us https://devart.com/company/contactform.html.

Hi,

i have send you sample

Regards

When testing your sample, we got a result about the speed difference of executing the operations using the HTTP protocol and HTTPS by no more than twice, that is a quite acceptable result. Please specify the exact data you get.

I am getting whole different results:

test 1: http=172 https=1969
test 2: http=344 https=1937
test 3: http=94 https=1859
test 4: http=297 https=1969

The speed of operations through the HTTPS protocol depends on very many factors of the environment (network infrastructure, network settings and restrictions, etc.) and, unfortunately, we cannot influence it in any way.
If you can avoid using the HTTP protocol, then you can use a direct connection to MySQL server using SSL, which will still protect your connection, but it will increase the speed of your work.

I have tried on two another pc's (different network)...same result. What kind result i are you getting?
I know that https is slower then http but definitely not factor 7x-20x.
This make your tunnel option through https unusable.

We are getting whole different results:
test 1: http=3193 https=7407
test 2: http=3235 https=8156
test 3: http=3303 https=8125
test 4: http=3219 https=7469

Strange...
Do you have own test server where i can test http/https connection. If so please send me message with credentials.

We used the sent sample and connected to your servers.