SSL Connection Setup for MariaDB in Helical Insight

Technical queries
, , , ,
#1

Hello,

We are using Helical Insight version 6.1.0.852 GA (Docker). We need to enable SSL while connecting to MariaDB and pass the certificate file through the JDBC connection URL. How can we configure SSL correctly in Helical Insight for MariaDB connection?

Thanks,
Netta.

#2

Hello,

In the MariaDB connection screen, provide the basic details such as host, port, database name, username, and password.

To enable SSL, go to the Advanced section and add the following parameters in the JDBC URL:

?useSSL=true&requireSSL=true&verifyServerCertificate=true&serverSslCert=/usr/local/Helical Insight/hi/db/mariadb_ssl.pem

Note :

Place the SSL certificate file inside the Docker-mounted path, for example: /opt/Helical610_852GA/hi/db.

This path will be mapped inside the container as /usr/local/Helical Insight/hi/db/mariadb_ssl.pem, which is then used in the JDBC URL.

image

image

Thanks,
Helical Insight.