Prisma 7 - Error opening TLS connection (cockroachdb)
I migrated from Prisma 6 to Prisma 7. And i am facing client connection related error.
Database: cockroachdb
docker compose file
.env file at root
prisma client configuration
Error opening a TLS connection: unable to verify the first certificateError opening a TLS connection: unable to verify the first certificateDatabase: cockroachdb
docker compose file
cockroachdb:
image: cockroachdb/cockroach:v25.3.3
command: >
start-single-node
--certs-dir=/cockroach/certs
ports:
- "26257:26257"
volumes:
- roach-single:/cockroach/cockroach-data
- roach-certs:/cockroach/certs
environment:
# if prior volumes already exist, these will have no effect
- COCKROACH_DATABASE=ufc
- COCKROACH_USER=john
- COCKROACH_PASSWORD=pork
volumns:
roach-single:
roach-certs:cockroachdb:
image: cockroachdb/cockroach:v25.3.3
command: >
start-single-node
--certs-dir=/cockroach/certs
ports:
- "26257:26257"
volumes:
- roach-single:/cockroach/cockroach-data
- roach-certs:/cockroach/certs
environment:
# if prior volumes already exist, these will have no effect
- COCKROACH_DATABASE=ufc
- COCKROACH_USER=john
- COCKROACH_PASSWORD=pork
volumns:
roach-single:
roach-certs:.env file at root
DATABASE_URL=postgresql://aseer:password@localhost:26257/althire?sslmode=verify-fullDATABASE_URL=postgresql://aseer:password@localhost:26257/althire?sslmode=verify-fullprisma client configuration
import { PrismaPg } from '@prisma/adapter-pg'
import { env } from '@/data/env'
import { PrismaClient } from '@/generated/prisma/client'
const globalForPrisma = globalThis as unknown as { prisma: PrismaClient }
export const prisma =
globalForPrisma.prisma ||
new PrismaClient({
log: ['query', 'info', 'error', 'warn'],
adapter: new PrismaPg({ connectionString: env.DATABASE_URL }),
})
if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prismaimport { PrismaPg } from '@prisma/adapter-pg'
import { env } from '@/data/env'
import { PrismaClient } from '@/generated/prisma/client'
const globalForPrisma = globalThis as unknown as { prisma: PrismaClient }
export const prisma =
globalForPrisma.prisma ||
new PrismaClient({
log: ['query', 'info', 'error', 'warn'],
adapter: new PrismaPg({ connectionString: env.DATABASE_URL }),
})
if (process.env.NODE_ENV !== 'production') globalForPrisma.prisma = prisma
ORM