I have a user defined with REQUIRE SSL on a MariaDb Server.
When I connect with a SQLYog client using client CERT/KEYS and I run
SHOW SESSION STATUS LIKE "Ssl_cipher" I get
Code: Select all
DHE-RSA-AES256-SHA
Using MyDAC: (with libeay32.dll, ssleay32.dll from 2018, works in Indy)
Code: Select all
aCon := TMyConnection.Create(nil);
aCon.Username := 'xxx';
aCon.Password := 'xxx';
aCon.Options.Protocol := mpSSL;
aCon.SSLOptions.CipherList := 'DHE-RSA-AES256-SHA....';
aCon.SSLOptions.CACert := 'ca-cert.pem';
aCon.SSLOptions.Key := 'client-key.pem';
aCon.SSLOptions.Cert := 'client-cert.pem';
SHOW SESSION STATUS LIKE "Ssl_cipher" just rerturns a generic value: "Ssl_cipher".
In other words, Protocol := mpSSL creates a working SSL connection but it does not use the client certificates.
I am using the latest MyDac version (10.3.2 14) with Delphi 10.4
Any help/suggestions would be appreciated.