Psql: server does not support SSL, but SSL was required

Build Environment Databases
, ,
1

When I run .circle/config.yml, it throw error as below,
#!/bin/bash -eo pipefail
database/scripts/load_app_data_client.sh minimal
08:01 Alter reference data tables
psql: server does not support SSL, but SSL was required
08:01 Set LDS table contraints
psql: server does not support SSL, but SSL was required
08:01 Dropping Clarify Application tables
psql: server does not support SSL, but SSL was required
08:01 Dropping Clarify Application database types
psql: server does not support SSL, but SSL was required
here is my config.yml

    version: 2.0
    jobs:
      build-and-test:
        docker:
          - image: circleci/node:8.9.4-stretch-browsers
            environment:
            - PG_HOST: localhost
            - PG_USER: ubuntu
            - DATABASE_URL: "postgres://@localhost:5432/circle_test?ssl=true"
            - DATABASE_ADMIN_URL: postgres://@localhost:5432/circle_test?ssl=true
          - image: circleci/postgres:9.6-alpine-postgis-ram
            environment:
            - POSTGRES_USER: ubuntu
        working_directory: ~/hospital
        environment:
          - REDISCLOUD_URL: redis://@redis-17242.c10.us.com:17242
        steps:
          - checkout
          # database
          - run:
              name: install dockerize
              command: wget https://github.com/jwilder/dockerize/releases/download/$DOCKERIZE_VERSION/dockerize-linux-amd64-$DOCKERIZE_VERSION.tar.gz && sudo tar -C /usr/local/bin -xzvf dockerize-linux-amd64-$DOCKERIZE_VERSION.tar.gz && rm dockerize-linux-amd64-$DOCKERIZE_VERSION.tar.gz
              environment:
                DOCKERIZE_VERSION: v0.3.0
          - run: sudo apt-get install -y postgresql-client
          # - run: dockerize -wait tcp://localhost:5432 -timeout 1m
              # Add the Postgres 10.3 binaries to the path.
          # - run: echo '/usr/lib/postgresql/10.3/bin/:$PATH' >> $BASH_ENV
          # - run: sleep 5 && nc -vz localhost 5432
          # - run: cat data/database/create_roles.sql | psql -U ubuntu -d $DB --set db="$DB" --set role="$ROLE"
          - run: cat data/database/create_roles.sql | psql -h localhost -p 5432 -U ubuntu -d $DB --set db="$DB" --set role="$ROLE"
          # - run: cat data/database/create_roles.sql | psql $DATABASE_URL -U ubuntu -d $DB --set db="$DB" --set role="$ROLE"
          - run: gzip -cd data/database/minimal2.backup.gz | psql -h localhost -p 5432 -U ubuntu -d $DB
          - run: database/scripts/load_app_data_client.sh minimal

image
image.png1764×378 36.6 KB

Can anyone help me? Many thanks!

2

Finally, I use a pg image which support ssl to solve this problem.
here is my config.yml

version: 2
jobs:
  build-and-test:
    working_directory: ~/hospital
    environment:
      CIRCLE_ARTIFACTS: /tmp/circleci-artifacts
      CIRCLE_TEST_REPORTS: /tmp/circleci-test-results
    docker:
    - image: circleci/node:8.10-stretch-browsers
      environment:
        PGHOST: 0.0.0.0
        DATABASE_URL: "postgres://clarify:Ia@localhost:5432/circle_test?ssl=true"
    - image: nimbustech/postgres-ssl:9.5
      environment:
        POSTGRES_USER: ubuntu
        POSTGRES_DB: circle_test
    steps:
    - checkout
    - run: sudo apt-get install -y postgresql-client

    - run: cat data/database/create_roles.sql | psql -U ubuntu -d $DB --set db="$DB" --set role="$ROLE"
    - run: gzip -cd data/database/minimal2.backup.gz | psql -U ubuntu -d $DB
    # Test
    - run: npm run pretest
    - run: npm run prod
    - run: node_modules/.bin/webdriver-manager update
    - run: database/scripts/load_app_data_client.sh minimal
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.