If you configured SSL settings for one data source, you can copy them for another data source.Ĭlick the Copy from … link and select the configuration that you want to copy.
Create ssh tunnel bsd client driver#
As a temporary solution, try to downgrade the JDBC driver (for example, for the MySQL connector, you need to switch to the 5.1.40 version.) Disable SSL connection to a databaseĬlick the SSH/SSL tab and clear the Use SSL checkbox.Ĭopy SSL settings from other data sources
The SSL connection might fail if your Java keystore does not accept the certificate chains. With self-signed certificates and in some cases with certificates issued by the trusted root entity, you might experience errors when you use the latest JDBC driver version. 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 either one of the certificates cannot be verified. Verifies the server host to ensure that it matches the name stored in the server certificate. Verifies the server by checking the certificate chain up to the root certificate that is stored on the client. Verifies that the server recognizes the client certificate, if the certificate is provided.
Create ssh tunnel bsd client verification#
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). System: Use System truststore certificates. You can add new accepted certificates in Tools | Server Certificates. IDE: Use the certificates that are accepted by the IDE. To do that, tick the Use truststore checkbox and select the truststore that you want to use. You can leave the certificate file fields empty and use a truststore to obtain a required certificate from the certificates that it contains. 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 open data source properties by using one of the following options: 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.
0 kommentar(er)
