*Hi team,* *My customer is using our ofbiz app hosted on an azure VM and we want now to connect it to an azure postgresql db setup with ssl.* I am trying to find the right connection string to set in the entityengine.xml.
>From different readings, I have found the following: jdbc-uri="jdbc:postgresql:// pql-001.postgres.database.azure.com:5432/hrajiel?sslmode=verify-full&sslfactory=org.postgresql.ssl.SingleCertValidatingFactory&sslfactoryarg=classpath:framework/entity/config/myCyberTrustRoot.crt.pem " when running the gradlew loadDefault command, I face the below error: 2022-06-03 11:33:45,374 |delegator-startup-1 |UtilXml |E| XmlFileLoader: File jar:file:/D:/HRAJIEL/ajsfrc22/ajielsoft/build/libs/ajielsoft.jar!/entityengine.xml process fatal error. Line: 134. Error message: The reference to entity "sslfactory" must end with the ';' delimiter. The below post mentions that this is a tomcat issue and we need to escape the "&" in the connection string. https://marc.info/?l=postgresql-general&m=153342574420527&w=2 Hence I changed the string to: jdbc-uri="jdbc:postgresql:// pql-001.postgres.database.azure.com:5432/hrajiel?sslmode=verify-full&sslfactory=org.postgresql.ssl.SingleCertValidatingFactory&sslfactoryarg=classpath:framework/entity/config/myCyberTrustRoot.crt.pem " But still the same issue: Error message: The reference to entity "sslfactory" must end with the ';' delimiter. Would the ofbiz community know anything about this ssl and postgresql issue? An additional question would be about the format of the certificate. Does it have to be a PKS file mandatory or can we still use the .pem file? Many thanks in advance to all reading this. M. Fadili Ajiel Information Systems Morocco
