SSL-encryption for SQL

It is possible to encrypt traffic from the complex server and/or the global settings program to the SQL-server.

MS SQL Server
1. In the SQL server connection windows you have to specify a prefix ssl:// before the server name.
For example: ssl://server-sql
2. It is necessary to make settings at the SQL server itself to install certificates (see here)
Note: if the certificate is self-signed and not added to trusted, then a connection error will be received.

PostgreSQL
The connection to the SQL server uses a secure, encrypted SSL connection (if enabled on the server), or plain without encryption (if not enabled on the server). To enable SSL on the server, just set the parameter ssl=on in data\postgresql.conf, and also copy certificate files server.crt, server.key to the same folder.
More details here:
https://www.postgresql.org/docs/current/ssl-tcp.html

MySQL
SSL traffic encryption is not supported in the current version of the complex.

v9.80 (build: Jul 4 2023)
Introduction +Software suite structure +Software suite installation +Software suite uninstall +Software suite update +Global settings -Other Remote employees Server behind the DMZ Remote monitoring via internet https-access configuration Server transfer Client service Key activation LDAP for PostgreSQL SSL-encryption for SQL +FAQ +Technical support	SSL-encryption for SQL It is possible to encrypt traffic from the complex server and/or the global settings program to the SQL-server. MS SQL Server 1. In the SQL server connection windows you have to specify a prefix ssl:// before the server name. For example: ssl://server-sql 2. It is necessary to make settings at the SQL server itself to install certificates (see here) Note: if the certificate is self-signed and not added to trusted, then a connection error will be received. PostgreSQL The connection to the SQL server uses a secure, encrypted SSL connection (if enabled on the server), or plain without encryption (if not enabled on the server). To enable SSL on the server, just set the parameter ssl=on in data\postgresql.conf, and also copy certificate files server.crt, server.key to the same folder. More details here: https://www.postgresql.org/docs/current/ssl-tcp.html MySQL SSL traffic encryption is not supported in the current version of the complex.
© Mirobase