Unable to get prisma 5 with nixpacks openssl #1030

Maxim-Filimonov · 2023-12-14T11:10:53Z

Is there an existing issue for this?

I have searched the existing issues

Describe the bug

Following up on the issue Prisma does support open ssl 3.0.x now.
However, for some reason I'm still not able to use nixpack with Prisma.
I tried installing libssl-dev in setup stage and got the same error.

To reproduce

After building i get the following error on trying to instantiate PrismaClient():
index.ts

import { PrismaClient} from '@prisma/client'
const prisma = new PrismaClient();

Error:

PrismaClientInitializationError: Unable to require(`/app/node_modules/.prisma/client/libquery_engine-debian-openssl-3.0.x.so.node`).

Prisma cannot find the required `libssl` system library in your system. Please install openssl-3.0.x and try again.

Details: libssl.so.3: cannot open shared object file: No such file or directory

at new e (/app/node_modules/@prisma/client/runtime/library.js:26:1871)

Noticed that it's using libquery_engine-debian-openssl-3.0.x.so.node - shouldn't be using ubuntu version not debian ?

Expected behavior

Able to build and deploy application using Prisma.

Environment

nixpacks.toml

[phases.setup]
aptPkgs = ["..."]
[phases.build]
cmds = ["...", "bunx prisma generate", "bunx prisma migrate deploy"]

package.json

 "dependencies": {
    "@prisma/client": "5.7.0",
  },

Bun: 1.0.17

I have no problems running locally.

The text was updated successfully, but these errors were encountered:

github-actions · 2023-12-14T11:11:09Z

Hello, @Maxim-Filimonov! Thanks for your submission.

Our team will respond soon. If you need more immediate help, try our Forum or our Discord. Thanks!

coffee-cup · 2023-12-14T16:43:10Z

We have an example that builds and runs no problem using Prisma 5 and bun https://github.com/railwayapp/nixpacks/tree/main/examples/node-bun-prisma.

I can check this out further, but there is evidence of both working so I am not sure what is going on with your specific repo. Do you have a sample repo that doesn't work with Bun?

Maxim-Filimonov · 2023-12-15T03:44:21Z

@coffee-cup I tried using linked example and it fails with different error for some reason.



$ bunx prisma migrate deploy

Prisma schema loaded from prisma/schema.prisma

Datasource "db": PostgreSQL database "railway", schema "public" at "roundhouse.proxy.rlwy.net:17360"

Error: P1001: Can't reach database server at `roundhouse.proxy.rlwy.net`:`17360`

Please make sure your database server is running at `roundhouse.proxy.rlwy.net`:`17360`.

error: script "start" exited with code 1 (SIGHUP)

$ bunx prisma migrate deploy

I did add shared variable DATABASE_URL.
Project on railway -> https://railway.app/project/f43b6f45-bce0-4138-bb1f-4dedca53ed97
Tried recreating postgres service - no luck.

Also tried using PRIVATE_DATABASE_URL from pg got this instead:

Error: P1001: Can't reach database server at `postgres.railway.internal`:`5432`

Please make sure your database server is running at `postgres.railway.internal`:`5432`.

thomas779 · 2023-12-25T03:19:57Z

Bumping this as I'm getting the exact issue to @Maxim-Filimonov. Everything works locally, but deploying to railway is a journey of painful debugging.

@coffee-cup if you need some hard evidence, I would suggest running through these steps:

fork this repo: https://github.com/amorriscode/elysia-starter
"prisma": "5.7.1" and "@prisma/client": "5.7.1" (versions shouldn't matter, but some devs reported having it fixed downgrading or upgrading... error was replicated with v5.3.x and v5.7.x on my side).
cp this schema.prisma:

What's your Prisma schema set-up Maxim ?
This is mine:

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

generator client {
    provider      = "prisma-client-js"
    output        = "./generated/client"
    binaryTargets = ["native", "linux-musl", "debian-openssl-3.0.x"]
}

nixpacks.toml:

[phases.setup]
nixPkgs = ['bun']

[phases.install]
cmds = ['bun install']

[phases.build]
cmds = ['bunx prisma generate', 
        'bunx prisma migrate deploy', 
        'bun build --target=bun ./src/index.ts --outdir ./build']

[start]
cmd = 'bun run src/index.ts'

Error:

PrismaClientInitializationError: Unable to require(`/app/prisma/generated/client/libquery_engine-debian-openssl-3.0.x.so.node`).
Prisma cannot find the required `libssl` system library in your system. Please install openssl-3.0.x and try again.
Details: libssl.so.3: cannot open shared object file: No such file or directory

Tried to add 'openssl_3_0_x to my nixPkgs = ['bun', 'openssl_3_0_x'] but that didn't work.

Also, changing start cmd from bun run src/index.ts to bun run build/indexjs will produce error:

Server is running at localhost:5000
1 | __dirname
^
ReferenceError: Can't find variable: __dirname
at /app/build/index.js:1604:69
at processTicksAndRejections (:61:76)

imadbz · 2024-01-23T04:21:22Z

+1 couldn't get it to work either

baptisteArno · 2024-02-05T15:27:21Z

I have the exact same error when trying to deploy an Elysia app. Has anyone found a fix?

Maxim-Filimonov · 2024-02-06T22:02:21Z

My fix was to migrate to fly.io :|

iloveitaly · 2024-02-07T17:29:54Z

--libs openssl will fix the issue, or we can get this PR merged :)

#1054

Maxim-Filimonov · 2024-02-07T23:09:43Z

@iloveitaly where to add --libs openssl ?

baptisteArno · 2024-02-08T10:38:26Z

@iloveitaly Nah, I that's not it... I think nixpacks even detected that it needs openssl by default for my project.

Still, I tried to specifically tell it to add the openssl lib with the env NIXPACKS_PKGS=openssl

╔═══════════════ Nixpacks v1.20.0 ══════════════╗
║ setup │ openssl, nodejs_18, bun, openssl ║
║───────────────────────────────────────────────║
║ install │ bun install ║
║───────────────────────────────────────────────║
║ build │ bun build:chat-api ║
║───────────────────────────────────────────────║
║ start │ bun start:chat-api ║
╚═══════════════════════════════════════════════╝

The problem happens at runtime, on the docker when the app is running, on Prisma init, it says:

PrismaClientInitializationError: Unable to require(`/app/node_modules/.prisma/client/libquery_engine-debian-openssl-3.0.x.so.node`).

Prisma cannot find the required `libssl` system library in your system. Please install openssl-3.0.x and try again.

Details: libssl.so.3: cannot open shared object file: No such file or directory

at new e (/app/node_modules/@prisma/client/runtime/library.js:26:1871)

iloveitaly · 2024-02-09T00:20:59Z

You need it as a lib, not as a package. Without this the ENV config is not changed. Take a look at the linked PR: #1054

GautierT · 2024-03-13T14:44:41Z

Hey !
I did not quite understand the latest message. What is the solution to avoid this error : Unable to require(/app/node_modules/.prisma/client/libquery_engine-debian-openssl-3.0.x.so.node). 2024-03-13T14:39:50.020131817Z Prisma cannot find the required libssl system library in your system. Please install openssl-3.0.x and try again.

Thanks !

ksaitor · 2024-03-26T03:32:38Z

Even on the latest prisma@^5.11.0 still getting this error on Nixpacks (running inside Coolify)

╔═════════════ Nixpacks v1.21.2 ═════════════╗
║ setup │ nodejs_21, bun, openssl ║
║────────────────────────────────────────────║
║ install │ bun i --no-save ║
║────────────────────────────────────────────║
║ build │ echo Skip build process ║
║────────────────────────────────────────────║
║ start │ bun run worker/main.worker.ts ║
╚════════════════════════════════════════════╝

PrismaClientInitializationError: Unable to require(`/app/node_modules/.prisma/client/libquery_engine-debian-openssl-3.0.x.so.node`).
Prisma cannot find the required `libssl` system library in your system. Please install openssl-3.0.x and try again.

ksaitor · 2024-03-26T03:40:12Z

--libs openssl

where do you add --libs openssl ? @iloveitaly

@Maxim-Filimonov were you able to resolve this?

Maxim-Filimonov · 2024-03-26T04:24:46Z

@ksaitor I haven't tried since it wasn't working when I needed it for initial launch. It works pretty well on fly I don't really see a reason why try to move it back to railway TBH.

JakeCooper · 2024-03-26T05:44:44Z

Fixable by simply specifying binaryTargets

amorriscode/elysia-starter#2 (comment)

ksaitor · 2024-03-26T09:57:50Z

added NIXPACKS_LIBS=openssl and it worked!
notice: not NIXPACKS_PKGS

cc @baptisteArno check it out

JakeCooper · 2024-03-26T19:16:36Z

@ksaitor Could you link the Railway project where it works or a repo with it working so that we can fix it at the nixpacks level?

ksaitor · 2024-03-27T02:34:11Z

@ksaitor Could you link the Railway project where it works or a repo with it working so that we can fix it at the nixpacks level?

@JakeCooper I'm not on Railway. I'm on Coolify, that's using Nixpacks under the hood. Nixpacks v1.21.2.

Maxim-Filimonov added the bug Something isn't working label Dec 14, 2023

github-actions bot added the community label Dec 14, 2023

thomas779 mentioned this issue Dec 25, 2023

deployment issues on railway amorriscode/elysia-starter#2

Open

baptisteArno mentioned this issue Feb 5, 2024

fix: openssl should be set to lib #1054

Open

baptisteArno mentioned this issue Feb 6, 2024

Nix: When generating the client, prisma:get-platform step infers incorrect libssl version in github action under ubuntu-latest prisma/prisma#20905

Open

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Unable to get prisma 5 with nixpacks openssl #1030

Unable to get prisma 5 with nixpacks openssl #1030

Maxim-Filimonov commented Dec 14, 2023 •

edited

github-actions bot commented Dec 14, 2023

coffee-cup commented Dec 14, 2023

Maxim-Filimonov commented Dec 15, 2023 •

edited

thomas779 commented Dec 25, 2023 •

edited

imadbz commented Jan 23, 2024

baptisteArno commented Feb 5, 2024

Maxim-Filimonov commented Feb 6, 2024 •

edited

iloveitaly commented Feb 7, 2024

Maxim-Filimonov commented Feb 7, 2024

baptisteArno commented Feb 8, 2024

iloveitaly commented Feb 9, 2024

GautierT commented Mar 13, 2024

ksaitor commented Mar 26, 2024 •

edited

ksaitor commented Mar 26, 2024 •

edited

Maxim-Filimonov commented Mar 26, 2024

JakeCooper commented Mar 26, 2024

ksaitor commented Mar 26, 2024

JakeCooper commented Mar 26, 2024

ksaitor commented Mar 27, 2024

Unable to get prisma 5 with nixpacks openssl #1030

Unable to get prisma 5 with nixpacks openssl #1030

Comments

Maxim-Filimonov commented Dec 14, 2023 • edited

Is there an existing issue for this?

Describe the bug

To reproduce

Expected behavior

Environment

github-actions bot commented Dec 14, 2023

coffee-cup commented Dec 14, 2023

Maxim-Filimonov commented Dec 15, 2023 • edited

thomas779 commented Dec 25, 2023 • edited

imadbz commented Jan 23, 2024

baptisteArno commented Feb 5, 2024

Maxim-Filimonov commented Feb 6, 2024 • edited

iloveitaly commented Feb 7, 2024

Maxim-Filimonov commented Feb 7, 2024

baptisteArno commented Feb 8, 2024

iloveitaly commented Feb 9, 2024

GautierT commented Mar 13, 2024

ksaitor commented Mar 26, 2024 • edited

ksaitor commented Mar 26, 2024 • edited

Maxim-Filimonov commented Mar 26, 2024

JakeCooper commented Mar 26, 2024

ksaitor commented Mar 26, 2024

JakeCooper commented Mar 26, 2024

ksaitor commented Mar 27, 2024

Maxim-Filimonov commented Dec 14, 2023 •

edited

Maxim-Filimonov commented Dec 15, 2023 •

edited

thomas779 commented Dec 25, 2023 •

edited

Maxim-Filimonov commented Feb 6, 2024 •

edited

ksaitor commented Mar 26, 2024 •

edited

ksaitor commented Mar 26, 2024 •

edited