Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

getting error related to ssl for postgresql

I'm getting the error in docker logs as "level=fatal msg="x509: cannot validate certificate for <PostgreSQL host ip> because it doesn't contain any IP SANs"

and the docker compose file is given below

services:
test:
restart: unless-stopped
ports:
- '127.0.0.1:8080:8080'
image: gcr.io/test/test.2.0.7
environment:
- ENV_TYPE=dev
- AUTH0_AUD=abcdfgrthwjsjxsjxsx
- AUTH0_ISS=https://testus.auth0.com/
- PG_HOSTNAME=<ip address of Postgresql>
- PG_PORT=5432
- PG_USER=Test
- PG_PASSWORD=test123
- PG_DB_NAME=test_db
- VAULT_ID=hello
- APP_BUFFER_SIZE_DB_READ=25000
- APP_BUFFER_SIZE_DB_WRITE=25000
- APP_SSL_MODE=True
- NODE_ADDR=wss://test.example.net/rpc
- SECRET_SEED=0x9089009fcb34b31da88c69aca70836d4c17c4d0e827fa1864
- ACTIVATION_DEST_BUCKET=test-bucket



 

and the postgressql configuration using terraform is 


resource "google_sql_database_instance" "pg_instance" {
  name = "test-pg-${random_id.postfix.hex}"
  database_version = "POSTGRES_13"
  region = var.gcp_region
  project = var.gcp_project
  deletion_protection = false
  settings {
    tier = var.db_tier
    availability_type = var.db_avialability_type  
    disk_autoresize = true
    disk_autoresize_limit = var.db_autoresize_limit
    disk_type = "PD_SSD"
    disk_size = var.db_disk_size
    maintenance_window {
      day  = "7"  # sunday
      hour = "3" # 3am
    }

    backup_configuration {
      backup_retention_settings {
        retained_backups = var.retained_backups
        retention_unit = "COUNT"
      }
    }

    ip_configuration {
      ipv4_enabled = true
      require_ssl = false
      #allocated_ip_range = "10.0.0.0/24"
      authorized_networks {
        value = "0.0.0.0/0"
    }
 
and manually tried with client ssl keys but not worked and same error came 
0 0 189
0 REPLIES 0
Top Labels in this Space
Top Solution Authors