@damiencoraboeuf 👋

I believe you may need to enable the use of SSL on the DB connection you’re creating from the Spring Boot application; note the , SSL off suffix at the end of the error. This could just be a matter of appending ?sslmode=require to your connection string URL, but may involve other steps depending on the PG client you’re using. We expose a bindable variable called ${JDBC_DATABASE_URL} that may simplify your use-case, since it would contain the entire connection string, including the ?sslmode=require suffix.

Hi,

Thanks for the answer.

I’m now using:

SPRING_DATASOURCE_URL = ${ontrack-db.JDBC_DATABASE_URL}
SPRING_DATASOURCE_USERNAME = ${ontrack-db.USERNAME}
SPRING_DATASOURCE_PASSWORD = ${ontrack-db.PASSWORD}

and I now get:

java.net.UnknownHostException: ontrack-db:xxxxxxx@app-380c5616-0dff-4d2b-8ae7-5cf1accc4651-do-user-269664-0.b.db.ondigitalocean.com

I think it’s because the JDBC_DATABASE_URL JDBC URL contains still the username & password and it should probably not?

jdbc:postgresql://ontrack-db:xxxxxx@app-380c5616-0dff-4d2b-8ae7-5cf1accc4651-do-user-269664-0.b.db.ondigitalocean.com:25060/ontrack-db?sslmode=require

I’d rather expect:

jdbc:postgresql://app-380c5616-0dff-4d2b-8ae7-5cf1accc4651-do-user-269664-0.b.db.ondigitalocean.com:25060/ontrack-db?sslmode=require

I think my workaround is to build the URL myself in the meantime, using ?sslmode=require as you’ve mentioned in your answer:

jdbc:postgresql://${ontrack-db.HOSTNAME}:${ontrack-db.PORT}/${ontrack-db.DATABASE}?sslmode=require

Thanks a lot,
Damien