Python: MySQLdb 和 "Library not loaded: libmysqlclient.16.dylib"

11 浏览
0 Comments

Python: MySQLdb 和 "Library not loaded: libmysqlclient.16.dylib"

设置...

试图安装干净的Mac os X 10.6来开发Python/django,我不记得在10.5上遇到过这个问题。

安装了mysql-5.5.8-osx10.6-x86_64.dmg安装程序中的MySQL之后,我运行了

$ sudo pip install MySQL-python

看起来一切都很顺利(下面是输出)

Downloading/unpacking MySQL-python
  Downloading MySQL-python-1.2.3.tar.gz (70Kb): 70Kb downloaded
  Running setup.py egg_info for package MySQL-python
    warning: no files found matching 'MANIFEST'
    warning: no files found matching 'ChangeLog'
    warning: no files found matching 'GPL'
Installing collected packages: MySQL-python
  Running setup.py install for MySQL-python
    building '_mysql' extension
    gcc-4.2 -fno-strict-aliasing -fno-common -dynamic -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -pipe -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3 -I/usr/local/mysql/include -I/System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6 -c _mysql.c -o build/temp.macosx-10.6-universal-2.6/_mysql.o -Os -g -fno-common -fno-strict-aliasing -arch x86_64
    In file included from _mysql.c:36:
    /usr/local/mysql/include/my_config.h:325:1: warning: "SIZEOF_SIZE_T" redefined
    In file included from /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/Python.h:9,
                     from pymemcompat.h:10,
                     from _mysql.c:29:
    /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/pymacconfig.h:33:1: warning: this is the location of the previous definition
    In file included from _mysql.c:36:
    /usr/local/mysql/include/my_config.h:419:1: warning: "HAVE_WCSCOLL" redefined
    In file included from /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/Python.h:8,
                     from pymemcompat.h:10,
                     from _mysql.c:29:
    /System/Library/Frameworks/Python.framework/Versions/2.6/include/python2.6/pyconfig.h:803:1: warning: this is the location of the previous definition
    gcc-4.2 -Wl,-F. -bundle -undefined dynamic_lookup build/temp.macosx-10.6-universal-2.6/_mysql.o -L/usr/local/mysql/lib -lmysqlclient_r -lpthread -o build/lib.macosx-10.6-universal-2.6/_mysql.so -arch x86_64
    warning: no files found matching 'MANIFEST'
    warning: no files found matching 'ChangeLog'
    warning: no files found matching 'GPL'
Successfully installed MySQL-python
Cleaning up...

之后,我尝试了:

$ python -c "import MySQLdb"

它却在我身上出了问题:

Traceback (most recent call last):
  File "", line 1, in 
  File "/Library/Python/2.6/site-packages/MySQLdb/__init__.py", line 19, in 
    import _mysql
ImportError: dlopen(/Library/Python/2.6/site-packages/_mysql.so, 2): Library not loaded: libmysqlclient.16.dylib
  Referenced from: /Library/Python/2.6/site-packages/_mysql.so
  Reason: image not found

那么我的问题是...

我做错了什么?/我还需要做什么?

在这里搜索(和在Google上搜索)会返回很多使用Ruby遇到此错误消息的结果,但并不是很多是使用Python。

admin 更改状态以发布 2023年5月21日
0
0 Comments

_mysql.so 是指 libmysqlclient.16.dylib。也就是说,Python 和 MySQL 客户端库之间的桥梁——共享库 _mysql.so 参考了 MySQL 客户端库的动态库,而由于某些原因,该库无法被加载。

需要回答的问题:

  • 你的系统上是否有 libmysqlclient.16.dylib?如果没有,则需要安装 MySQL 客户端软件。
  • 如果有,则包含该库的目录是否在你的 DYLD_LIBRARY_PATH 设置中?如果没有,则尝试将其添加。
  • 如果有,你需要确保 libmysqlclient.16.dylib 文件没有损坏。我的副本安装在 /opt/local/lib/mysql5/mysql/libmysqlclient.16.dylib ,由 MacPorts 提供,MD5 签名为
    c79ee91af08057dfc269ee212915801a ,大小为 1,462,376 字节。你的副本是什么样子的?
0
0 Comments

在运行pip installeasy_install后,只需设置DYLD_LIBRARY_PATH

export DYLD_LIBRARY_PATH=/usr/local/mysql/lib/

假设您的MySQL安装位于/usr/local/mysql下,这应该可以完成工作。

0