It is recommended to use PEM certificates. To ensure that the connection to the data source is successful, click Test Connection. The SSL connection fails if the server certificate cannot be verified. Verify CA: verifies the server by checking the certificate chain up to the root certificate that is stored on the client.įull Verification: verifies the server host to ensure that it matches the name stored in the server certificate. Require: verifies that the server accepts SSL connections for this IP address and recognizes the client certificate.
In the Client key file field, navigate to the client key file (for example, client-key.pem).įrom the Mode list, select the verification mode: In the Client certificate file field, navigate to the client certificate file (for example, client-cert.pem). In the CA file field, navigate to the CA certificate file (for example, mssql.pem). On the Data Sources tab, select a data source that you want to modify.Ĭlick the SSH/SSL tab and select the Use SSL checkbox. In the Database tool window ( View | Tool Windows | Database), click the Data Source Properties icon.
You can see configuration examples for Cassandra and Heroku Postgres in the DataGrip documentation. For some databases, you need to use another approach for a successful connection.
The following procedure describes the SSL configuration that suits most databases. To make a connection to a database more secure, some services require SSH or SSL usage.