error installing psycopg2, library not found for -lssl

by

For anyone looking for a solution for this on macOS Sierra 10.12 (or later, most likely): I fixed this by installing the command line tools:

xcode-select --install

After that, pip install psycopg2 should work.

If it doesn’t, you could also try to link against brew’s openssl:

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip install psycopg2

with openssl installed via brew. Note that the brew link openssl --force does not work anymore:

$ brew link openssl --force                                                                                 17.5s
Warning: Refusing to link: openssl
Linking keg-only openssl means you may end up linking against the insecure,
deprecated system OpenSSL while using the headers from Homebrew's openssl.
Instead, pass the full include/library paths to your compiler e.g.:
  -I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib

As @macho points out below if this still does not work, you might need to use the --no-cache option of pip, e.g.

env LDFLAGS="-I/usr/local/opt/openssl/include -L/usr/local/opt/openssl/lib" pip --no-cache install psycopg2

Remember to adjust these paths accordingly should you for instance build on ARM/Apple M1 Macs (as homebrew is installed at /opt/homebrew/); command as follows:

env LDFLAGS="-I/opt/homebrew/opt/openssl/include -L/opt/homebrew/opt/openssl/lib" pip --no-cache install psycopg2

More Related Contents:

  1. psycopg2: insert multiple rows with one query
  2. Parameterized queries with psycopg2 / Python DB-API and PostgreSQL
  3. Passing table name as a parameter in psycopg2
  4. DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
  5. Error: pg_config executable not found when installing psycopg2 on Alpine in Docker
  6. How to set up a PostgreSQL database in Django
  7. psycopg2.OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
  8. Psycopg2 image not found
  9. Error Installing Psycopg2 on MacOS 10.9.5
  10. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  11. Create a Postgres database using python
  12. Python/postgres/psycopg2: getting ID of row just inserted
  13. Escape SQL “LIKE” value for Postgres with psycopg2
  14. How to set connection timeout in SQLAlchemy
  15. Mac + virtualenv + pip + postgresql = Error: pg_config executable not found
  16. “Failed building wheel for psycopg2” – MacOSX using virtualenv and pip
  17. Psycopg2, Postgresql, Python: Fastest way to bulk-insert
  18. Insert Python Dictionary using Psycopg2
  19. Use binary COPY table FROM with psycopg2
  20. How Postgresql COPY TO STDIN With CSV do on conflic do update?
  21. pg_config executable not found
  22. How to create an SQL View with SQLAlchemy?
  23. Import psycopg2 Library not loaded: libssl.1.0.0.dylib
  24. psycopg2 TypeError: not all arguments converted during string formatting
  25. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  26. Creating partial unique index with sqlalchemy on Postgres
  27. Filling Many2many field (odoo 8)
  28. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  29. Deploying Django to Heroku (Psycopg2 Error)
  30. How to perform filtering with a Django JSONField?

Leave a Comment