curved-easter-24577
05/26/2023, 12:52 PM/go/pkg/mod/gorm.io/gorm@v1.24.1-0.20221019064659-5dd2bb482755/gorm.go:206
[error] failed to initialize database, got error failed to connect to `host=***** user=flyteadmin database=flyteadmin`: server error (FATAL: no pg_hba.conf entry for host "172.32.101.12", user "flyteadmin", database "flyteadmin", no encryption (SQLSTATE 28000))
We have run this command to test the database connection:
kubectl run pgsql-postgresql-client --rm --tty -i --restart='Never' --namespace testdb --image <http://docker.io/bitnami/postgresql:11.7.0-debian-10-r9|docker.io/bitnami/postgresql:11.7.0-debian-10-r9> --env='PGPASSWORD=<Password>' --command -- psql testdb --host <RDS-ENDPOINT-NAME> -U flyteadmin -d flyteadmin -p 5432
And works. The only difference is that when we run it asks for the password. Anyone knows whatβs happening here?damp-potato-83989
05/26/2023, 1:32 PMaverage-finland-92144
05/26/2023, 3:30 PMaverage-finland-92144
05/26/2023, 3:32 PMdamp-potato-83989
05/26/2023, 3:32 PMaverage-finland-92144
05/26/2023, 3:36 PMdamp-potato-83989
05/26/2023, 3:37 PMdamp-potato-83989
05/26/2023, 3:37 PMaverage-finland-92144
05/26/2023, 3:40 PMdamp-potato-83989
05/26/2023, 3:42 PMcurved-easter-24577
05/29/2023, 3:14 PMsslmode=require
worked for me. We are using a RDS postgres 15.2 (no aurora)calm-zoo-68637
08/07/2023, 5:27 PMdatacatalog-config
configmap looks like:
apiVersion: v1
data:
db.yaml: |
database:
dbname: datacatalog
host: <Postgres host>
options: sslmode=require
port: 5432
username: postgres
...
? Even when I set this, I still see the following in logs:
{
"json": {},
"level": "fatal",
"msg": "failed to connect to `host=<host> user=postgres database=flyteadmin`: server error (FATAL: no pg_hba.conf entry for host \"10.48.3.24\", user \"postgres\", database \"flyteadmin\", SSL off (SQLSTATE 28000))",
"ts": "2023-08-07T17:22:38Z"
}
which makes me think the SSL key is not being readaverage-finland-92144
08/07/2023, 5:37 PMcalm-zoo-68637
08/07/2023, 5:58 PM