v10.17 (build: May 28 2024) |
|
SSL-encryption for SQLIt 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 postgresql.conf, and also copy certificate files server.crt, server.key to the same folder (usually, when installing on Linux, a certificate is created automatically and nothing additional needs to be done). More details here: https://www.postgresql.org/docs/current/ssl-tcp.html |
|
© Scopd |