How to set up SSL in the Navicat Report Viewer

Secure Sockets Layer (SSL) is the contract for transferring private files over the Internet, the first thing to do in order to secure a connection is to install the OpenSSL library and download the database source. This tutorial will explain how to set up SSL for the Navicat report Viewer.

Navicat report Viewer setting up SSL

Please note: The Navicat report Viewer is limited to MySQL, PostgreSQL, and Mariadb,postgresql 8.4 or later support.

MySQL and MariaDB connections

To provide verification information, enable the Use authentication feature and fill in the required information:

Client Secret: A PEM-format SSL key file used to create a secure connection.

Client Certificate: A PEM-format SSL certificate used to create a secure connection.

CA Certificate: Contains a PEM format file path that is trusted by an SSL certification authority.

Verify the CA certificate name: Check the certificate that the server sends to the client, the general name value of the server.

Specified Cipher: The list of Cipher used to allow SSL encryption.

PostgreSQL Connection

Select SSL Mode:

Require: only try SSL connection.

Verify-ca: Try an SSL connection and verify that the server certificate is issued by a trusted CA.

Verify-full: Try an SSL connection, verify that the server certificate is issued by a trusted CA, and that the server hostname meets the certificate requirements.

To provide verification information, enable the Use authentication feature and fill in the required information:

Client key: The path to the client key.

Client Certificate: The path to the client certificate.

CA Certificate: Trusted by the certification authority path.

Certificate Revocation list: The file path of the certificate revocation list (CRL).

A tutorial on how to set up SSL for the Navicat Report Viewer is simple, click on the "Navicat tutorial " For more tutorials.

The above is reproduced content, the original is: http://www.formysql.com/jiqiao/viewer-ssl.html

How to set up SSL in the Navicat Report Viewer