SSL Settings and Custom String
SSL Settings and Custom String
Hey guys:
We're using version 6.0.1.0 (dbexpmysql.dll) and we need to setup SSL using parameters, as we use the DLL only. We use the "Custom String" option:
'Custom string=UseSSL=true,"ClientCertificate='+aSSLCert+'","ClientKey='+aSSLKey+'"'
My Question is: what is the custom parameter name for
* ssl ca certificate
* Cypher
Thanks in advance.
--
Jackson Gomes / Flow Software
We're using version 6.0.1.0 (dbexpmysql.dll) and we need to setup SSL using parameters, as we use the DLL only. We use the "Custom String" option:
'Custom string=UseSSL=true,"ClientCertificate='+aSSLCert+'","ClientKey='+aSSLKey+'"'
My Question is: what is the custom parameter name for
* ssl ca certificate
* Cypher
Thanks in advance.
--
Jackson Gomes / Flow Software
Re: SSL Settings and Custom String
dbexpmysql.dll is the standard MySQL driver. You can download our driver from http://www.devart.com/dbx/mysql/download.html
Re: SSL Settings and Custom String
ops... wrong DLL name...
Question is still the same. Can you please answer it regarding your product?
Thanks
--
Jackson
Question is still the same. Can you please answer it regarding your product?
Thanks
--
Jackson
Re: SSL Settings and Custom String
To setup SSL connection to MySQL server, use the following code:
You can find more details in the Readme.html file at %DBXMySQL%\Readme.html ,
where %DBXMySQL% - the path to the installed dbExpress driver for MySQL.
Code: Select all
TSQLConnection.Params.Add('Custom String=Protocol=SSL');
TSQLConnection.Params.Add('SSLCACert=Pathname_to_the_certificate_authority_file');
TSQLConnection.Params.Add('SSLCert=Pathname_to_the_certificate_file');
TSQLConnection.Params.Add('SSLKey=Pathname_to_the_key_file');
TSQLConnection.Params.Add('SSLCipherList=All');
where %DBXMySQL% - the path to the installed dbExpress driver for MySQL.
Last edited by ViktorV on Mon 21 Nov 2016 13:44, edited 3 times in total.
Re: SSL Settings and Custom String
Hi,
i am trying to connect to MySQL server through SSL connection, using your code:
But i get following error:
Can you tell me what does it means and what may be the problem?
thanks
i am trying to connect to MySQL server through SSL connection, using your code:
Code: Select all
TSQLConnection.Params.Add('Custom String=Protocol=SSL');
TSQLConnection.Params.Add['SSLCACert=Pathname_to_the_certificate_authority_file'];
TSQLConnection.Params.Add['SSLCert=Pathname_to_the_certificate_file'];
TSQLConnection.Params.Add['SSLKey=Pathname_to_the_key_file'];
TSQLConnection.Params.Add['SSLCipherList=All'];
Can you tell me what does it means and what may be the problem?
thanks
Re: SSL Settings and Custom String
This error is generated by the OpenSSL library.
For the problem investigation, please send a sample reproducing the problem to viktorv*devart*com, including certificates.
For the problem investigation, please send a sample reproducing the problem to viktorv*devart*com, including certificates.
Re: SSL Settings and Custom String
Hi,
I'm experiencing exactly the same issue.
I can connect with SSL to my server with mysql workbench.
But with the same user / certs I have this error SSL_do_handshake = -1 ....
I'm experiencing exactly the same issue.
I can connect with SSL to my server with mysql workbench.
But with the same user / certs I have this error SSL_do_handshake = -1 ....
Re: SSL Settings and Custom String
This error is generated by OpenSSL library. This error may occur due to various reasons, e.g., usage of OpenSSL version that is not supported by MySQL server.
Please make sure you are using the latest version of dbExpress driver for MySQL (6.8.11). Also make sure that MySQL Workbench and your application use the same versions of OpenSSL libraries. To retrieve the path to the OpenSSL libraries, used by the application, you can use a third-party utility, e.g. Process Explorer.
If versions of OpenSSL libraries are different, please place the libraries used by MySQL Workbench to the directory with the executable file and check whether the error is reproduced. If it is reproduced, for the problem investigation, please send a sample reproducing the problem to viktorv*devart*com, including certificates and the used OpenSSL libraries.
Please make sure you are using the latest version of dbExpress driver for MySQL (6.8.11). Also make sure that MySQL Workbench and your application use the same versions of OpenSSL libraries. To retrieve the path to the OpenSSL libraries, used by the application, you can use a third-party utility, e.g. Process Explorer.
If versions of OpenSSL libraries are different, please place the libraries used by MySQL Workbench to the directory with the executable file and check whether the error is reproduced. If it is reproduced, for the problem investigation, please send a sample reproducing the problem to viktorv*devart*com, including certificates and the used OpenSSL libraries.
Re: SSL Settings and Custom String
As you use MySQL server on Linux, you should specify a value of the SSLCipherList parameter in upper case. For example:
Code: Select all
TSQLConnection.Params.Values['SSLCipherList'] := 'ALL';