P
Prisma•2mo ago
D3levV

Prisma and Google cloud run

Hello guys have you ever run on this issue before: I get this error in the logs when trying to access prisma client "Prisma cannot find the required libssl system library in your system. Please install openssl and try again." This is my prisma config 
generator client {
  provider = "prisma-client-js"
  previewFeatures = ["fullTextSearchPostgres"]
  binaryTargets = ["native", "debian-openssl-1.1.x"]
}

datasource db {
  provider = "postgresql"
  url=env(DATABASE_URL)
}
generator client {
  provider = "prisma-client-js"
  previewFeatures = ["fullTextSearchPostgres"]
  binaryTargets = ["native", "debian-openssl-1.1.x"]
}

datasource db {
  provider = "postgresql"
  url=env(DATABASE_URL)
}
3 Replies
Prisma AI Help
Prisma AI Help•2mo ago
You selected the carefully hand-crafted route. A dev artisan will respond soon. Meanwhile, the #ask-ai channel awaits if you're curious!
RaphaelEtim
RaphaelEtim•2mo ago
Hi @D3levV Can you please take a look at this closed issue? There are some solutions mentioned there.
GitHub
Prisma cannot find the required libssl` system library in your sy...
Bug description [ERROR] (PRISMA) $queryRaw Invalid prisma.$queryRaw() invocation: Unable to require(/home/runner/bot/node_modules/.prisma/client/libquery_engine-debian-openssl-1.1.x.so.node). P...
D3levV
D3levVOP•2mo ago
I will give it a try with the docker RUN and let you guys know how it went I've ended up changing docker node version 
//Dockerfile
FROM node:alpine

//prisma.config
  generator client {
  provider = "prisma-client-js"
  previewFeatures = ["fullTextSearchPostgres"]
  binaryTargets = ["native", "debian-openssl-1.1.x", "linux-musl-openssl-3.0.x"]
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}
//Dockerfile
FROM node:alpine

//prisma.config
  generator client {
  provider = "prisma-client-js"
  previewFeatures = ["fullTextSearchPostgres"]
  binaryTargets = ["native", "debian-openssl-1.1.x", "linux-musl-openssl-3.0.x"]
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

Did you find this page helpful?