I created a PostgreSQL instance on Google Cloud
I followed https://github.com/prisma/prisma2/blob/master/docs/core/connectors/postgresql.md#configuring-an-ssl-connection created the .p12 with a password from the certificates downloaded from the Google project
openssl pkcs12 -export -out client-identity.p12 -inkey client-key.pem -in client-cert.pem
my prisma/.env
DATABASE_URL="postgresql://postgres:[email protected]:5432/mydb?schema=public&sslmode=require&sslidentity=client-identity.p12&sslpassword=mysecurepass3728508&sslcert=server-ca.pem"
When doing prisma2 introspect
Error: P1011
Error opening a TLS connection: One or more parameters passed to a function were not valid.
When removing &sslcert=server-ca.pem it works without sslcert even with sslmode=require
I created a PostgreSQL instance on Google Cloud
I followed https://github.com/prisma/prisma2/blob/master/docs/core/connectors/postgresql.md#configuring-an-ssl-connection created the .p12 with a password from the certificates downloaded from the Google project
openssl pkcs12 -export -out client-identity.p12 -inkey client-key.pem -in client-cert.pemmy
prisma/.envWhen doing
prisma2 introspectWhen removing
&sslcert=server-ca.pemit works without sslcert even with sslmode=require