Certificate verification (SSL connection)

Certificate verification (SSL connection)

Postby Thomas Huppertz » Thu 13 Oct 2016 06:37

We are using the lastest mySQL dotConnect for MySQK (Standard Edition) to connect to a MaraiDB via SSL. Everything works fine.

My question is:
How can we verify the Certificate issued by the MariaDB.
We use a self generated certificate and therefore this certificate is not 100% safe (it is not signed).

Atm we can connect to the database (although the certificate is not signed), but how do we force the certificate to be signed by a trusted source?

Is there any chance of a callback function or a paramater used in the connection string?
Thomas Huppertz
 
Posts: 4
Joined: Fri 30 Sep 2016 11:30

Re: Certificate verification (SSL connection)

Postby Pinturiccio » Mon 17 Oct 2016 14:59

You can assign your CACert certificate to the SslOptions.CACert property of a MySqlConnection object. A CACert certificate is used to verify, that the server, which sends a request, is the same server that you expect. For more information, please refer to
https://www.devart.com/dotconnect/mysql/docs/SecureConnections.html#usessl
https://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.SslOptions~CACert.html
https://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlConnection~ConnectionString.html
Pinturiccio
Devart Team
 
Posts: 1849
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL