Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: FDConnection BAd Handshake error MySQL


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Nov 5, 2017 12:24 PM Last Post By: Mark Williams
Mark Williams

Posts: 120
Registered: 5/8/10
FDConnection BAd Handshake error MySQL  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 5, 2017 9:51 AM
I am trying to connect to a remote database using FireDac. I keep getting a bad handshake response on connection and cannot figure out why.

I am trying to set the parameters at run time without success.

As a result I tried to establish the connection via the FDConnection's Connection Editor at design time using the same params. This worked fine and I was able to successfully run a query via the connection editor. Having set the params this way I removed the code which attempted to set the params at run time (ie relying on the params set vi the connection editor) and ran the app again. It still failed to connect with a bad handshake error.

Can anyone please explain why I can connect via the IDE, but not at run time even though using the same params?

Below are the connection definition params, less any sensitive info.

================================
Connection definition parameters
================================
Server=62.30.???.???
UseSSL=True
Password=*****
User_Name=[?????????]
SSL_key=C:\ProgramData\MWC\Viewer\Certs\client-key.pem
SSL_cert=C:\ProgramData\MWC\Viewer\Certs\client-cert.pem
SSL_ca=C:\ProgramData\MWC\Viewer\Certs\markwilliamsconsultancy.pem
Database=[??????]
DriverID=MySQL
================================
FireDAC info
================================
Tool = RAD Studio 10.2
FireDAC = 16.0.0 (Build 88974)
Platform = Windows 32 bit
Defines = FireDAC_NOLOCALE_META;FireDAC_MONITOR
================================
Client info
================================
Loading driver MySQL ...
DLL = C:\Delphi\Projects\Viewer\libmysql.dll
Client version = 506250000
================================
Session info
================================
Current catalog =
Current schema =
Server info = 5.6.26
Client info = 5.6.25
Characterset name = latin1
Host info = 62.30.221.167 via TCP/IP
Name modes = CILCTD
SSL Cipher = DHE-RSA-AES256-SHA
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: FDConnection BAd Handshake error MySQL  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 5, 2017 11:01 AM   in response to: Mark Williams in response to: Mark Williams
The secure MySQL API that FireDAC uses may be outdated.
If you will send me (privately at dmitrya dog embarcadero dot come) your / test credentials, I can try to fix that.

--
With best regards,
Dmitry
Mark Williams

Posts: 120
Registered: 5/8/10
Re: FDConnection BAd Handshake error MySQL  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 5, 2017 12:24 PM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
If you will send me (privately at dmitrya dog embarcadero dot come) your / test credentials, I can try to fix that.

Hi Dimitry,

I assume "dog" should have said "dot"?

I am actually working with live data at the moment. I will set up a small test db in the morning and email the credentials for that.

However, I don't understand how I can connect to the database with the same credentials via the Connection Editor if the API is outdated. Surely it would prevent connection via the IDE also?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02