Prisma after migration to 7.0.1 version database ssl certificate error.

[Zaeem6100]

Question

33 // Login method for users
34 async login(loginDto: LoginDto): Promise {
35 try {
→ 36 const user = await this.prisma.user.findUnique(
Error opening a TLS connection: self-signed certificate in certificate chain

using Digital Ocean managed Database PostgreSQL version 18
DATABASE_URL=postgresql://doadmin:password@dbaas-db-0.f.db.ondigitalocean.com:25060/crm?sslmode=require

How to reproduce (optional)

Expected behavior (optional)

No response

Information about Prisma Schema, Client Queries and Environment (optional)

// Add your schema.prisma

// Add any relevant Prisma Client queries here

• OS:

• Database:

• Node.js version:

• Run prisma -v to see your Prisma version and paste it

[nurul3101]

Hi @Zaeem6100!

Does this error go away if you change use sslmode=no-verify parameter?

Related Discussion:
#28356

[Zaeem6100]

Yep

[nurul3101]

Thanks for confirming. This might be something we need to document because how SSL enforcement is done has changed from Prisma 6 to 7.

[TeyimPila]

But isn't this a security risk? also, where are you setting the sslmode=no-verify?

[github-actions[bot]]

Hi,

As we have not heard back from you, we are closing this discussion to keep our discussions organized.

Feel free to start a new discussion if this remains relevant.

Thank you for being part of the community!