prisma migrate dev (prisma+postgres://accelerate.prisma-data) P1011: Error opening a TLS connection
Hi team, I have setup a prisma-data db and recently I'm getting error when prisma migrate, don't know if it's something of my computer setup or it's happening to others.
pnpm prisma migrate dev
Environment variables loaded from .env
Prisma schema loaded from prisma/schema.prisma
Datasource "db": PostgreSQL database "postgres", schema "public" at "accelerate.prisma-data.net"
Error: P1011: Error opening a TLS connection: The certificate was not trusted.
10 Replies
You decided to hold for human wisdom. We'll chime in soon! Meanwhile,
#ask-ai is there if you need a quick second opinion.Hey @Juan Raya
Can you share with me your GitHub handle or the email id with which you signed up?
I would like to take a look at the logs to debug this
I signed with [email protected] to prisma postgres
more context: prisma and prisma/client 6.6.0
using prisma-data:
DATABASE_URL="prisma+postgres://accelerate.prisma-data.net/?api_key=ey...
the db is working, i can connect through tunnel, but i can not update schema through migrate
i tried a few things with my computer certificates but none of that worked (mac)Thanks for sharing the email.
This is happening on production environment of project "petricor"?
I am sharing this with our Prisma Postgres team to check
yess
both development and production environments can not prisma migrate
Thank you for confirming. I have raised this with team internally.
The team would like to know if you were getting this same error before you made changes with certificates, or was it a different error?
i tried a few things with my computer certificatesCan you elaborate on what you tried? Based on our logs, everything is looking normal so any additional information you can provide will be very helpful
yeah I tried different things but I still have the same error. I think I updated openssl and few more things, if all looks normal on your end i will try with other computer and see what happen, thanks for the help!
Do let us know in case the same error occurs in other computer as well
it worked in my linux machine! so something I messed up with certificates/openssl in my mac, I will try to figure out, thanks!!
do you know by chance which certificates ssl tsl prisma+postgres are required?
nvm it's working now, I think I didn't change anything but it works now 🙂
Glad to hear that! 🙏