Python安装Mysqldb报#error “LONG_BIT.“问题及解

在Mac Snow Leopard系统中，使用Python + Django + MySQL + MySQLdb进行开发时，在构建MySQLdb时遇到如下错误：

Amit-Vermas-MacBook:mysql-python-1.2.2 amitverma$ python setup.py build
running build
running build_py
copying MySQLdb/release.py -> build/lib.macosx-10.3-i386-2.5/MySQLdb
running build_ext
building '_mysql' extension
creating build/temp.macosx-10.3-i386-2.5
gcc-4.0 -isysroot /Developer/SDKs/MacOSX10.4u.sdk -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -fno-common -dynamic -DNDEBUG -g -O3 -Dversion_info=(1,2,2,'final',0) -D__version__=1.2.2 -I/usr/local/mysql/include -I/Library/Frameworks/Python.framework/Versions/2.5/include/python2.5 -c _mysql.c -o build/temp.macosx-10.3-i386-2.5/_mysql.o -g -Os -arch x86_64 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL
In file included from /Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/Python.h:57,
                 from pymemcompat.h:10,
                 from _mysql.c:29:
/Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/pyport.h:761:2: error: #error "LONG_BIT definition appears wrong for platform (bad gcc/glibc config?)."
In file included from _mysql.c:35:
/usr/local/mysql/include/my_config.h:1050:1: warning: "HAVE_WCSCOLL" redefined
In file included from /Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/Python.h:8,
                 from pymemcompat.h:10,
                 from _mysql.c:29:
/Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/pyconfig.h:721:1: warning: this is the location of the previous definition
In file included from _mysql.c:35:
/usr/local/mysql/include/my_config.h:1168:1: warning: "SIZEOF_LONG" redefined
In file included from /Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/Python.h:8,
                 from pymemcompat.h:10,
                 from _mysql.c:29:
/Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/pyconfig.h:811:1: warning: this is the location of the previous definition
In file included from _mysql.c:35:
/usr/local/mysql/include/my_config.h:1177:1: warning: "SIZEOF_PTHREAD_T" redefined
In file included from /Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/Python.h:8,
                 from pymemcompat.h:10,
                 from _mysql.c:29:
/Library/Frameworks/Python.framework/Versions/2.5/include/python2.5/pyconfig.h:820:1: warning: this is the location of the previous definition
error: command 'gcc-4.0' failed with exit status 1
Amit-Vermas-MacBook:mysql-python-1.2.2 amitverma$ 

2、解决方案

根据网友提供的解决方案，可以尝试以下方法解决问题：

方法一：

1. 使用Apple-supplied python2.6 on Snow Leopard 这是64-bit。
2. 安装32-bit版本的MySQL库。
3. 使用MacPorts安装完整的解决方案
   • 安装MacPorts基础设施。
   • 安装python 2.6或2.5的MySQLdb适配器，这将安装所有必需的依赖项，包括新的python和MySQL客户端库。

方法二：

1. 使用MacPorts安装基础设施：sudo port install py26-mysql或py25-mysql。
2. 修改.bash_profile，将/opt/local/bin添加到$PATH
3. 重新打开终端，应该能找到MacPorts版本python2.6。
4. 如果想让python指向MacPorts版本，可以使用sudo port install python_select并选择使用python26。

方法三：

1. 从官方下载MySQL-python-1.2.3c1.tar.gz放到要安装的目录
2. 在Linux中执行tar -zxvf MySQL-python-1.2.3c1.tar.gz
3. 在MySQL-python-1.2.3c1目录下执行python setup.py install

注：建议使用MacPorts安装，可以避免很多麻烦。