python - psycopg2 installation error - Library not loaded: libssl.dylib

40
votes

I try to install psycopg2 in a virtualenv using pip, the compilation looks ok, it says "Successfully installed psycopg2", but when I try to import it in python interpreter (in virtualenv), it indicates error:

  File "<stdin>", line 1, in <module>
  File "/Users/me/sites/env/trackmap/lib/python2.7/site-packages/psycopg2/__init__.py", line 67, in <module>
    from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: dlopen(/Users/me/sites/env/trackmap/lib/python2.7/site-packages/psycopg2/_psycopg.so, 2): Library not loaded: libssl.dylib
  Referenced from: /Users/me/sites/env/trackmap/lib/python2.7/site-packages/psycopg2/_psycopg.so
  Reason: Incompatible library version: _psycopg.so requires version 1.0.0 or later, but libssl.0.9.8.dylib provides version 0.9.8

The thing is I install it successfully using pip in my other virtual env before, like, several weeks ago, and get it working with the postgresql on my mac. I am wondering if this is a problem of compiler? I saw some warnings like shortens from 64-bit to 32-bit during the installation of psycopg2. My compiler is i686-apple-darwin11-llvm-gcc-4.2, default one on mac os x lion.

I see several posts related to psycopg2 install but most of them are solved by installing in a virtual env. So...could anyone give me a suggestion? Thank you! Really appreciated.

p.s. If you need the compilation log of installing psycopg2 please let me know, I didn't paste it here because it is too long.

9
pythonvirtualenvpsycopg2

9 Answers

99
votes

Does the error say libssl.dylib version is too old?

On my mac, the error is that libssl.dylib and libcrypto.dylib is too old for pyscopg to use. The openssl package used by mac is 0.98, while pyscopg needs 1.0.0 or later version.

My solution is this:

  1. install openssl from brew

    $ brew install openssl

  2. copy libssl.1.0.0.dylib and libcrypto.1.0.0.dylib from /usr/local/Cellar/openssl/1.0.1c to /usr/lib/

    $ cd /usr/local/Cellar/openssl/1.0.1c/lib
$ sudo cp libssl.1.0.0.dylib libcrypto.1.0.0.dylib /usr/lib/

  3. in /usr/lib directory, make a softlink libssl.dylib and libcrypto.dylib. You may have to remove the existing links.

    $ sudo rm libssl.dylib libcrypto.dylib
$ sudo ln -s libssl.1.0.0.dylib libssl.dylib
$ sudo ln -s libcrypto.1.0.0.dylib libcrypto.dylib
34
votes

I think in Mac we need:

export LDFLAGS="-L/usr/local/opt/openssl/lib"
24
votes

On OSX 10.11+ (El Capitan or later) solution with replacing symlinks (see above - https://stackoverflow.com/a/11911870/565525) sudo rm libssl.dylib libcrypto.dylib reports Operation not permitted. Solution that worked for me was:

brew install openssl

Find where openssl brew libs are located, start searching from directory /usr/local/Cellar/openssl. In my case it is in /usr/local/Cellar/openssl/1.0.2d_1/lib

Finally set up DYLD_LIBRARY_PATH, i.e. add a line like this into .bash_profile :

# replace location of lib files with folder name you found in previous step
export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:/usr/local/Cellar/openssl/1.0.2d_1/lib

restart shell, or just source ~/.bash_profile and test if it works:

$ python -c"import psycopg2  ;   print('psycopg2 is now ok')"
23
votes

I had a similar issue. I had used Anaconda to install python and a number of packages and then later used pip to install psycopg2. I was able to fix the error by uninstalling psycopg2 and reinstalled it with the conda package manager instead of pip.

pip uninstall psycopg2
conda install psycopg2
13
votes

Thanks @khrf for your answer.

If you are using the postgres system installer (instead of Postgres.app), use: 

export DYLD_LIBRARY_PATH=/Library/PostgreSQL/9.3/lib

which can be placed in your ~/.bash_profile if you want to avoid typing it every time.

1
votes

If you are using PostgresApp, set DYLD_LIBRARY_PATH environment variable accrordingly, e.g.:

DYLD_LIBRARY_PATH=/Applications/Postgres.app/Contents/MacOS/lib/ ../venv/bin/python manage.py syncdb
1
votes

Add below line in ~/.bash_profile

export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/

Then

source ~/.bash_profile
0
votes

After a few hours troubleshooting, the following line added to my .zshrc file helped me out

export DYLD_LIBRARY_PATH=/Library/PostgreSQL/11/lib
0
votes

Find where your libssl and libcrypto files are and set the LIBRARY_PATH in your zshrc file would work.

References: Add library search path to clang https://mithun.co/hacks/library-not-loaded-libcrypto-1-0-0-dylib-issue-in-mac/