Tunnel trough https

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Tunnel trough https

Post by pedja2 » Fri 01 Apr 2016 11:58

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Thu 07 Apr 2016 13:10

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.

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Tue 17 Apr 2018 11:55

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Wed 18 Apr 2018 09:19

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.

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Thu 24 May 2018 11:55

HI,

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

How can fix this?

Thanks

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Fri 25 May 2018 08:04

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.

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Fri 25 May 2018 09:28

Hi,

i have send you sample

Regards

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Fri 25 May 2018 12:02

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.

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Fri 25 May 2018 12:48

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Fri 25 May 2018 13:59

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.

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Fri 25 May 2018 14:29

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.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Fri 25 May 2018 14:43

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

pedja2
Posts: 29
Joined: Thu 04 Jun 2009 11:11

Re: Tunnel trough https

Post by pedja2 » Fri 25 May 2018 15:25

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

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Tunnel trough https

Post by ViktorV » Tue 29 May 2018 08:17

We used the sent sample and connected to your servers.

Post Reply