Auto DevOps Postgres Database SSL Error

brandonscott · January 30, 2018, 6:28pm

I enabled Auto DevOps on my repo which contains a Spring Boot app.

Part of the Test stage of the Pipeline spawns up a Postgres database which is nice, but I get the following error:
org.postgresql.util.PSQLException: The server does not support SSL.

I altered both SPRING_DATASOURCE_URL and JDBC_DATABASE_URL as Secret Variables in CI/CD settings to change &sslmode=require to &sslmode=disable on both URLs. SPRING_DATA_SOURCE reflects the secret variable change and this seems to solve the problem, but it’s noteworthy that JDBC_DATABASE_URL is not overridden.

Why does it spawn up an image with Postgres that doesn’t support SSL but enforces it as a URL parameter? Or am I doing something very wrong?

kaikun213 · July 23, 2018, 6:51pm

I got the same problem using Auto DevOps and Spring Boot with an H2 in-memory-database.

I believe this should not happen in the automatic config - Any news on it?

mackstar · February 9, 2019, 12:24pm

I have a feeling this is because the JVM build pack overrides it. On Heroku this should always be an SSL connection hence the build pack enforces it. You could clone the build pack change the line in the following link:

github.com

heroku/heroku-buildpack-jvm-common/blob/7bd3a67940e87447bde0b3836c6ed40bc852f612/opt/jdbc.sh#L11


#!/usr/bin/env bash


set_jdbc_url() {
  local db_url=${1}
  local env_prefix=${2:-"JDBC_DATABASE"}


  if [ -z "$(eval echo \$${env_prefix}_URL)" ]; then
      local db_protocol=$(expr "$db_url" : "\(.\+\)://")
      if [ "$db_protocol" = "postgres" ]; then
        local jdbc_protocol="jdbc:postgresql"
        local db_default_args="&sslmode=require"
      elif [ "$db_protocol" = "mysql" ]; then
        local jdbc_protocol="jdbc:mysql"
      fi


      if [ -n "$jdbc_protocol" ]; then
        local db_user=$(expr "$db_url" : "${db_protocol}://\(.\+\):\(.\+\)@")
        local db_prefix="${db_protocol}://${db_user}:"


        local db_pass=$(expr "$db_url" : "${db_prefix}\(.\+\)@")
        db_prefix="${db_prefix}${db_pass}@"

Then set this as your default build pack.

krlsdu · February 13, 2019, 5:59pm

Hi @brandonscott, using the suggestion from @mackstar, I create this custom buildpack.
https://github.com/krlsdu/heroku-buildpack-java
and
https://github.com/krlsdu/heroku-buildpack-jvm-common

and update on gitlabci the variable

BUILDPACK_URL=GitHub - krlsdu/heroku-buildpack-java: A Heroku buildpack for Java apps.

Obs.: This repository is designed for experimentation and will not be updated.

sigi · February 26, 2019, 3:24pm

Have the same issue. I’m quite surprised that this isn’t fixed.

I’m using Spring Boot and only added a hint for heroku that my java version is 11.

Should be quite the use case for auto devops.

Topic		Replies	Views
Keep getting error "server does not support SSL, but SSL was required" GitLab CI/CD	0	3898	August 14, 2021
What is the best way to go about installing on a system with an existing instance of Postgres? How to Use GitLab	1	851	March 2, 2015
Postgres host error while trying to run build on GitLab CI GitLab CI/CD	1	2833	May 25, 2016
AutoDev Ops:/bin/herokuish build pack test (PHP) not supported Infrastructure as Code & Cloud Native	2	1648	May 2, 2019
Newbie to AutoDevOps and been fighting for 3 straight days GitLab CI/CD	1	293	January 12, 2021

Auto DevOps Postgres Database SSL Error

Related topics