Connection to a hosted database
Certificates
If we host your database, you will need to get a certificate so that our servers know who is connecting.
Creating a Certificate Signing Request (CSR)
A tool is delivered in the folder "LeSage12", named "MakeCSR".
The CSR (Certificate Signing Request) is a file that you will generate and send us so we can sign it and provide you with a CRT file. The second file created .key is to be put into the folder c:\LeSage12 without sending it to us. Once both files in the folder each time you will want to access your database your password will have to be entered.
How does it works ?
From Windows access c:\LeSage12. Double click on MakeCSR.exe : this will pop up :
1/ Le dossier de destination is the folder where both files will be saved : .csr et .key. If you don't specify anything it will go on your Desktop.
2/ Société : company name
3/ Vos Prénom et nom : Name Surname
4/ Email
5/ Password : this password will be asked each time you connect to Le Sage. You can leave it empty but it won't be GDPR compliant. We won't have any access to this password.
6/ Generated file : name used in the generated file. You won't need to modify this name. It is the one that will be present in your shortcut properties ssl=xxxx
Press Générer : both files (CSR and KEY) are created.
Send the .csr file to cat@improvize.eu (only that file). Keep the .key and place it in c:\LeSage12.
We will send you the .crt file and you will save it in c:\LeSage12.