Prisma Studio errors with a Prisma Client error ...It seems there is a problem with your OpenSSL installation!...

[Matheus-S-Costa]

Bug description

Can't use the localhost with prisma studio.

Error starting Prisma Client: {

  "message": "Unable to establish a connection to query-engine-node-api library. It seems there is a problem with your OpenSSL installation!\n\u001b[31m\u001b[1mDetails:\u001b[22m\u001b[39m Unable to require(`/home/matheus/www/nlw/esports/server/node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node`)\n libssl.so.1.1: cannot open shared object file: No such file or directory\n[Context: getConfig]\n\nPrisma CLI Version : 4.3.1",
  "stack": "Unable to establish a connection to query-engine-node-api library. It seems there is a problem with your OpenSSL installation!\n\u001b[31m\u001b[1mDetails:\u001b[22m\u001b[39m Unable to require(`/home/matheus/www/nlw/esports/server/node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node`)\n libssl.so.1.1: cannot open shared object file: No such file or directory\n[Context: getConfig]\n\nPrisma CLI Version : 4.3.1"
}
Error: Error starting Prisma Client: {
  "message": "Unable to establish a connection to query-engine-node-api library. It seems there is a problem with your OpenSSL installation!\n\u001b[31m\u001b[1mDetails:\u001b[22m\u001b[39m Unable to require(`/home/matheus/www/nlw/esports/server/node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node`)\n libssl.so.1.1: cannot open shared object file: No such file or directory\n[Context: getConfig]\n\nPrisma CLI Version : 4.3.1",
  "stack": "Unable to establish a connection to query-engine-node-api library. It seems there is a problem with your OpenSSL installation!\n\u001b[31m\u001b[1mDetails:\u001b[22m\u001b[39m Unable to require(`/home/matheus/www/nlw/esports/server/node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node`)\n libssl.so.1.1: cannot open shared object file: No such file or directory\n[Context: getConfig]\n\nPrisma CLI Version : 4.3.1"
}
    at qs.init (http://localhost:5555/assets/index.js:1:83069)

How to reproduce

I just run the command: npx prisma studio

Expected behavior

Enter in localhost and run my database.

Prisma information

Environment & setup

• OS:
• Browser:
• Database:

Prisma logs

No response

[janpio]

What operating system are you using @Matheus-S-Costa? Does Prisma Client work in a Node app?

[Jolg42]

Our logic detected: It seems there is a problem with your OpenSSL installation!.
Your OpenSSL setup might be the case here.

Could you provide more info?

• about your system? OS, distro
• please run whereis openssl and post the output.

[Matheus-S-Costa]

I use linux distro ubuntu. running whereis openssl: openssl: /usr/bin/openssl /usr/include/openssl /home/matheus/anaconda3/bin/openssl /usr/share/man/man1/openssl.1ssl.gz

[janpio]

"anaconda" rings a bell: #14073

[Matheus-S-Costa]

if the problem is my OpenSSL setup, what steps I need to take? Em qui., 13 de out. de 2022 às 11:17, Matheus Costa < ***@***.***> escreveu:

…

I use linux distro ubuntu. running whereis openssl: openssl: /usr/bin/openssl /usr/include/openssl /home/matheus/anaconda3/bin/openssl /usr/share/man/man1/openssl.1ssl.gz Em qui., 13 de out. de 2022 às 04:59, Joël Galeran < ***@***.***> escreveu: > Our logic detected: It seems there is a problem with your OpenSSL > installation!. > Your OpenSSL setup might be the case here. > > Could you provide more info? > > - about your system? OS, distro > - please run whereis openssl and post the output. > > — > Reply to this email directly, view it on GitHub > <#15771 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/A26EVFMAATURSHGZLVBCICDWC66OFANCNFSM6AAAAAARD7UAHU> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >

[Jolg42]

Indeed.
It looks like something is related to anaconda

• mentions of anaconda interfering with openssl and editing zsh config worked Unable to establish a connection to query-engine-node-api library. It seems there is a problem with your OpenSSL installation! #14073 (comment)
• mention that removing anaconda worked Migration engine error #12570 (comment)

@Matheus-S-Costa You could try what people mentioned, though it doesn't sound like a great solution is you need to use anaconda.
So you could also give us more information, so we could reproduce this.

[Jolg42]

@Matheus-S-Costa Did you solve your issue? What did you do? We're curious to know.

[Matheus-S-Costa]

@Matheus-S-Costa Did you solve your issue? What did you do? We're curious to know.

I uninstalled anaconda from my desktop and tried again. It wasn't the ideal solution for me, but was the easiest way. Thanks for help.

[Jolg42]

We'll keep it open as we want to work on all openssl issues at some point.

[Matheus-S-Costa]

Ok, no problem.

[hubsmoke]

FYI I ran into this issue as well and I renamed the openssl binary under anaconda folder to prevent the issue.

mv /home/user/anaconda3/bin/openssl /home/user/anaconda3/bin/openssl-old

Not sure what the root cause of the conflict is here, but just documenting this in case it's useful

[aqrln]

This issue is reproducible with Prisma up to 4.8.1. Starting with Prisma 4.9.0, OpenSSL installed via Anaconda, Homebrew etc doesn't interfere with system OpenSSL library detection. I'm going to go ahead and close this issue. Please feel free to open a new issue if you still run into any problems!