search

Azure / meta-azure-service-broker

A service broker to manage multiple Azure services in Cloud Foundry
Apache License 2.0
39 stars 44 forks source link

JDBC connection string hard codes SSL to true #219

Open gavinvandermerwe opened 4 years ago

gavinvandermerwe commented 4 years ago

Hi

We have the following settings configured for the azure service broker tile in opsman: 

{
  "postgresqlServerParameters": {
      "allowPostgresqlServerFirewallRules": [
          {
            "ruleName": "all",
            "startIpAddress": "Y.Y.Y.Y",
            "endIpAddress": "X.X.X.X"
          }
      ],
      "properties": {
          "version": "9.6",
          "sslEnforcement": "Disabled",
          "storageMB": 51200
      }
  }
}

Notably is the sslEnforcement is disabled, this breaks postgresql connections for apps running in the foundation that use jdbc connection string because the ssl parameter is hard coded to true.

https://github.com/Azure/meta-azure-service-broker/blob/64a7d1c74ef1fc39042f969d5615f8b1f26a8302/lib/services/azurepostgresqldb/index.js#L141-L145

Can this connection url generation be changed to honour the settings above?