错误库未加载:运行python应用程序时的/usr/local/opt/mysql-client/lib/libssl.1.1.dylib

Question

我正在运行我的应用程序，并得到了这个错误--似乎它与某个mysql客户机包有关。

Uncaught exception!
Traceback (most recent call last):
  File "/Users/myname/my-app/some/path/sqlalchemy_db_profiling.py", line 10, in <module>
    from MySQLdb.converters import conversions, escape
  File "/Users/myname/my-app/venv/lib/python3.7/site-packages/MySQLdb/__init__.py", line 18, in <module>
    from . import _mysql
ImportError: dlopen(/Users/myname/my-app/venv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so, 2): 
  Library not loaded: /usr/local/opt/mysql-client/lib/libssl.1.1.dylib
      Referenced from: /Users/myname/my-app/venv/lib/python3.7/site-packages/MySQLdb/_mysql.cpython-37m-darwin.so
      Reason: image not found

这些是我对requirements.txt的依赖

Flask==1.1.2
Flask-Login==0.5.0
Flask-Security==3.0.0
Flask-SQLAlchemy==2.4.4
gevent==1.5.0
SQLAlchemy==1.3.20
mysqlclient==1.4.6
PyMySQL==0.10.1
Flask-Compress==1.8.0
Flask-HTTPAuth==3.3.0

环境：

• OS: macOS 11.4 (大Sur)

• Python : pyenvPython3.7.10

• Connector/C:国产mysql-client 8.0.29

• Openssl:自制openssl@1.1

注意到：直到今天，我的应用程序运行良好。今天早上我运行了brew update && brew upgrade，从那时起我就克服了错误。

当我检查/usr/local/opt/mysql-client/lib下面的内容时，我得到的是：

> ls /usr/local/opt/mysql-client/lib
libmysqlclient.21.dylib libmysqlclient.a        libmysqlclient.dylib    pkgconfig

Answer 1

解决方案：https://github.com/PyMySQL/mysqlclient/issues/546

• 创建干净的venv
• 清晰的pip缓存。(车轮缓存可能包含旧的二进制链接，旧客户端library).
• Follow，brew信息，mysql-client说。再次输出PKG_CONFIG_PATH="/usr/local/opt/mysql-client/lib/pkgconfig"
• Install .