mysql - 使用 SSL (.pem + .key) 连接到 MySQL

Question

我正在尝试使用带有 SSL 证书 (.pem) 和私钥的 MySQL 数据库连接到 KNIME。

不幸的是，我找不到在节点或属性中包含这两个文件 (.pem + .key) 的方法。

任何人都可以帮助我或有这种联系的经验吗？

谢谢。

Answer 1

这里的 KNIME 论坛给出了全面的答案:https://forum.knime.com/t/connection-to-mysql-with-ssl-pem-key/17755

first you need to import the certificate and the private key into the Java keystore so that they can be used by the Java SSL library. For more details on this see the Setting up Client Authentication section of the MySQL documentation.

Once this is done you need to tell KNIME to use the truststore. You can do this either by appending the following two lines to the end of your knime.ini file which is located in the KNIME installation folder:

-Djavax.net.ssl.keyStore= path_to_keystore_file
-Djavax.net.ssl.keyStorePassword= mypassword

or you can specify them as JDBC Parameters in the connector node. In KNIME 4.0 you open the node dialog of the MySQL Connector node and go to the JDBC Parameters tab. In the tab add the following two parameters with the appropriate file path:

clientCertificateKeyStoreUrl=file:path_to_truststore_file
clientCertificateKeyStorePassword= mypassword

Instead of writing the password in plain text into the node dialog you can also use the Credentials Configuration node and connect it to the MySQL Connector node.

Once they are connected you can select the Credentials - password Type in the Type column of the table and then selecting the name of the credential in the Value column.