SSL+Pooling: Application close causes exceptions
SSL+Pooling: Application close causes exceptions
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
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
Re: SSL+Pooling: Application close causes exceptions
Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.
Re: SSL+Pooling: Application close causes exceptions
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 ...
Re: SSL+Pooling: Application close causes exceptions
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.
Re: SSL+Pooling: Application close causes exceptions
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
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
Re: SSL+Pooling: Application close causes exceptions
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
into
To solve your issue you can change in the CRSSLIOHandler.pas file the string
Code: Select all
SSLClient := TScSSLClient.Create(Self);
Code: Select all
SSLClient := TScSSLClient.Create(nil);
Re: SSL+Pooling: Application close causes exceptions
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
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
Re: SSL+Pooling: Application close causes exceptions
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.