1. Securing SQL communications

When full security is enabled, SQL communications are secured using HTTPS over TLS. Therefore, SQL driver connections must be configured to use the correspondent HTTPS certificate. In this section you will learn how to download the TLS certificate for your LeanXcale instance.

1.1. Download TLS certificate

1.1.1. Cloud Console

TLS certificate can be downloaded in the Security tab under the Operations section in the web console, in the SQL Interface Security.

sslcert

1.1.2. On Premise instance

When managing an On Premise LeanXcale Deployment, you must access to the main node and get the certificate from the following path (being $BASEDIR your installation path):

$BASEDIR/conf/LeanXcaleSSLConnect.crt

1.2. Installing certificates

1.2.1. Windows

If using Windows, to install LeanXcale TLS certificate you have to open the .crt file and add the certificate to the trusted ca certificates store.

sslwindows1
sslwindows2
sslwindows3
sslwindows4
sslwindows5
sslwindows6

1.2.2. Linux

In case Linux is your operative system, you need to add the TLS certificate to your trusted ca certificates for your machine.

sudo mkdir /usr/local/share/ca-certificates/extra
sudo cp LeanXcaleSSLConnect.crt /usr/local/share/ca-certificates/extra/LeanXcaleSSLConnect.crt
sudo update-ca-certificates