Mendix 10.19.0.57669 - SQL Server deployment without SSL

0
Hello,   I deployed my app for testing on a VM. I linked the app to a postgres DB with success. Now I try to deploy this same app on an other server with a SQL Server instance.   When starting the app, I have this error : Opening JDBC connection to localhost/dpa failed with SQLState: 08S01 Error code: 0 Message: "La propriété « chiffrer » a la valeur « true » et la propriété « CertificatServeurApprouvé » a la valeur « false » mais le pilote n’a pas pu établir de connexion sécurisée à SQL Server à l’aide du chiffrement SSL (Secure Sockets Layer) : Erreur : PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. ClientConnectionId:...", giving up...(4/4)   With Mendix 9, it worked well. So I noticed that Mendix 10 changed the SQL Server driver implementation. I found this link but nothing work.   Is DatabaseUseSsl working ? How to correctly implement it ?   I tried to add it in Project/Settings/Configuration/Custom but when updating the app on the server, the error is still there.   Have someone find a solution to disable SSL on SQL Server DB link ?   Thanks, Kevin  
asked
1 answers
0

Found the solution:

 

I am using Mendix Service Console to host the app on a server.

 

The custom app settings can be configured in:

Project tab > Configuration > Advanced > Custom settings table

I added the DatabaseUseSsl: False and it worked.

 

In Settings.yaml file, this key-value parameter is added under the Runtime section

Runtime:
  ...
  DatabaseUseSsl: false

 

answered