SSL+Pooling: Application close causes exceptions

[worsoee]

Hi, ...

When using SSL and Pooling=True, I get these exceptions when closing the application:
1) Lost connection to MySQL server during query"
2) Invalid pointer operation

I've tried not using SSL, then it works. I've tried setting Pooling=False, then it works. These exceptions are only created when both SSL and Pooling are on.

Can you help, please?

I'm running my application on Windows 10, it's created using MyDAC 8.7.27; SecureBridge 7.2.3; VirtualDAC 10.0.3; Delphi 10.1 update 2 and the application connects to MySQL 5.7.16 (MySQL server on Ubuntu server 14.04).

Kindly greetings

[ViktorV]

Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.

[worsoee]

Thank you for the quick reply - looking forward to the results, as out application now isn't able to clean up memory properly after close, and thus "pollutes" client computers ...

[ViktorV]

We will continue investigation of the MyDAC behavior and inform you as soon as we get any results, but we can't provide any time frame at the moment.

[worsoee]

Hi,

As we're about to release a new version of our client software, we actually need either a timeframe or a work-round (maybe even a downgrade, if this works in prior version-combinations).

The current situation locks us to either not release software at all, or to release without SSL. None of the options are very appealing - and turning of pooling reduces performance greatly, so that's not an option either...

Best regards

[ViktorV]

We have already fixed this issue. This fix will be included in the next MyDAC build.
To solve your issue you can change in the CRSSLIOHandler.pas file the string

Code: Select all

  SSLClient := TScSSLClient.Create(Self);

into

Code: Select all

  SSLClient := TScSSLClient.Create(nil);

[worsoee]

Hello,

I can see the SecureBridge have been updated to version 7.3.4. Is a fix for this issue included in the new version?

My config is: Delphi 10.1 update 2, MyDAC 8.7.27 and VirtualDAC 10.0.3

Best regards,

Carsten

[ViktorV]

As we wrote earlier, this error cause was not in SecureBridge code, but in the CRSSLIOHandler.pas file code. To solve it, you should make changes specified by us in the previous post to the CRSSLIOHandler.pas file. After that, please rebuild the package mydacsbridgeXX.dpk.