undefined symbol: SSL_get1_peer_certificate

[0xReagan8]

Memgraph version Which version did you use?
2.13.0

Environment Some information about the environment you are using Memgraph
on: operating system, how do you connect, with or without docker, which driver
etc.
docker w/ conda pytohn =3.10.0

Describe the bug A clear and concise description of what the bug is.
trying to install

undefined symbol: SSL_get1_peer_certificate

To Reproduce Steps to reproduce the behavior:
from gqlalchemy import Memgraph

1. Run the following query '...'
2. Click on '....'

Expected behavior A clear and concise description of what you expected to
happen.

Logs If applicable, add logs of Memgraph, CLI output or screenshots to help
explain your problem.

Additional context Add any other context about the problem here.

[katarinasupe]

Hi @0xReagan8, can you try installing all of the prerequisites, including the build prerequisites for pymgclient? OpenSSL might be missing.

[0xReagan8]

The following packages will be UPDATED:

ca-certificates anaconda::ca-certificates-2023.08.22-~ --> conda-forge::ca-certificates-2023.11.17-hbcca054_0
openssl anaconda::openssl-3.0.12-h7f8727e_0 --> conda-forge::openssl-3.2.0-hd590300_1

python-devtools 0.12.2 pyhd8ed1ab_0 conda-forge
cmake 3.22.1 h1fce559_0 anaconda
make 4.2.1 h1bed415_1 anaconda
gcc 13.2.0 h574f8da_2 conda-forge
gcc_impl_linux-64 13.2.0 h338b0a0_3 conda-forge
libgcc-devel_linux-64 13.2.0 ha9c7c90_103 conda-forge
libgcc-ng 13.2.0 h807b86a_3 conda-forge
gxx 13.2.0 h574f8da_2 conda-forge
gxx_impl_linux-64 13.2.0 h338b0a0_3 conda-forge
openssl 3.2.0 hd590300_1 conda-forge

I am still getting -> undefined symbol: SSL_get1_peer_certificate

[katarinasupe]

Can you write down the OS you're running this on?
I see you're using Docker w/ Conda and Python 3.10.
Please also list the commands you run and at which step you get stuck. This will help me debug more quickly. I think this has something to do with the fact that Conda comes with its version of SSL.

[katarinasupe]

I see we had this issue a couple of times reported now, and it is mostly related to Conda env. Can you try installing gqlalchemy without Conda? Here is related discussion: #285 (comment)

[as51340]

Investigated the issue, you are probably having locally old version of pymgclient. Clean pymgclient from global path (pip uninstall pymgclient gqlalchemy), activate your conda environmen and install ONLY gqlalchemy (pip install gqlalchemy). You should see that pymgclient 1.3.1 is being built while installing gqlalchemy. No need to install pymgclient before gqlalchemy, we will correct docs.

[katarinasupe]

@0xReagan8 can you try what @as51340 suggested and let us know whether that works for you 🙏 😄