Hi everyone I am facing some problem with Postgresqlsetup over ssl Tried with below conf but it was not successful , Valuse.yml - sql section

sql:
    datasource:
      host: "<http://xxx.privatelink.azure.com:5432|xxx.privatelink.azure.com:5432>"
      hostForpostgresqlClient: "<http://xxx.privatelink.azure.com|xxx.privatelink.azure.com>"
      port: "5432"
      url: "jdbc:<postgresql://xxx.privatelink>..<http://azure.com:5432/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8|azure.com:5432/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8>"
      driver: "org.postgresql.Driver"
      username: "pgadmin"
      password:
        secretRef: mysql-secrets
        secretKey: password

Error that i am getting

2022/07/28 10:48:26 Waiting for: <tcp://xxx.privatelink.postgres.database.azure.com:5432>
2022/07/28 10:48:26 Connected to <tcp://xxx.privatelink.postgres.database.azure.com:5432>
psql: error: connection to server at "<http://xxx.privatelink.postgres.database.azure.com|xxx.privatelink.postgres.database.azure.com>" , port 5432 failed: FATAL:  password authentication failed for user "datahub"
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
connection to server at "<http://xxx.privatelink.postgres.database.azure.com|xxx.privatelink.postgres.database.azure.com>" , port 5432 failed: FATAL:  SSL connection is required. Please specify SSL options and retry.

I verified pgadmin password is correct and able to login with the same password in PGADMIN4 app Please help here

Hi @silly-room-64336 Could you please provide steps to reproduce this issue

Hi Vinoth , could you try changing

url: "jdbc:<postgresql://xxx.privatelink>..<http://azure.com:5432/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8|azure.com:5432/datahub?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8>"

to

url: "jdbc:<postgresql://xxx.privatelink>..<http://azure.com:5432/pgadmin?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8|azure.com:5432/pgadmin?verifyServerCertificate=false&useSSL=true&useUnicode=yes&characterEncoding=UTF-8>"

you can follow this thread for same issue https://datahubspace.slack.com/archives/CV2UVAPPG/p1658173279061999