psycopg2 installation error - Library not loaded: libssl.dylib

Question

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 "", line 1, in File "/Users/me/sites/env/trackmap/lib/python2.7/site-packages/psycopg2/__init__.py", line 67, in 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 compil…

Accepted Answer

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:

install openssl from brew

```
$ brew install openssl
```

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/
```

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
```

psycopg2 installation error - Library not loaded: libssl.dylib

Solution

Problem

Related problems