MySQL Adapter SSL

Posts   
 
    
OSSistemes
User
Posts: 19
Joined: 20-Nov-2019
# Posted on: 14-Jun-2023 20:05:03   

Hi,

For security reason we need to connect to MySQL database (8.X) using SSL, we are using pay version devart mysql dotnet.

here the string connect passing to DataAccessAdapter

"UserId = test; Server = 192.168.0.10 ; Port = 3306; Database = test ; Password = test; Protocol=SSL"

But receive this error

'Authentication failed because the remote party sent a TLS alert: 'HandshakeFailure'.'

Dataprovider config

RuntimeConfiguration.ConfigureDQE<MySqlDQEConfiguration>(c => c.AddDbProviderFactory(typeof(Devart.Data.MySql.MySqlProviderFactory)));

What is the parameter that we have to activate to use SSL?

Test with mysql workbench and can connect using SSL, so server is correctly configurated

Thanks

OSSistemes
User
Posts: 19
Joined: 20-Nov-2019
# Posted on: 14-Jun-2023 22:48:33   

solved,

Error on cipher list, reconfigure mysql cipher list and now its ok with tls 1.2