Cannot install MySQL-Python

Question

for some reason I'm unable to install the MySQL-Python package in neither my virtualenv nor in my main Python install on OS X. I'm getting the following output:

 Downloading/unpacking MySQL-Python
 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 -arch i386 -arch ppc -arch x86_64 -pipe -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3 -I/usr/local/Cellar/mysql/5.5.10/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 -g
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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:39:1: warning: this is the location of the previous definition
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/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
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:619:1: warning: "SIZEOF_TIME_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:40:1: warning: this is the location of the previous definition
 /usr/libexec/gcc/powerpc-apple-darwin10/4.2.1/as: assembler (/usr/bin/../libexec/gcc/darwin/ppc/as or /usr/bin/../local/libexec/gcc/darwin/ppc/as) for architecture ppc not installed
 Installed assemblers are:
 /usr/bin/../libexec/gcc/darwin/x86_64/as for architecture x86_64
 /usr/bin/../libexec/gcc/darwin/i386/as for architecture i386
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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:39:1: warning: this is the location of the previous definition
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/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
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:619:1: warning: "SIZEOF_TIME_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:40:1: warning: this is the location of the previous definition
 _mysql.c:2888: fatal error: error writing to -: Broken pipe
 compilation terminated.
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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/Cellar/mysql/5.5.10/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
 lipo: can't open input file: /var/folders/8O/8OOqsN1GEkSD0wcAjZFbMk+++TI/-Tmp-//cc0nabTS.out (No such file or directory)
 error: command 'gcc-4.2' failed with exit status 1
 Complete output from command /Users/jmalina/Sites/virtualenvs/muckrack/bin/python -c "import setuptools;__file__='/Users/jmalina/Sites/virtualenvs/muckrack/build/MySQL-Python/setup.py';exec(compile(open(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --single-version-externally-managed --record /var/folders/8O/8OOqsN1GEkSD0wcAjZFbMk+++TI/-Tmp-/pip-92IOBF-record/install-record.txt --install-headers /Users/jmalina/Sites/virtualenvs/muckrack/bin/../include/site/python2.6:
 running install
 running build
 running build_py
 copying MySQLdb/release.py -> build/lib.macosx-10.6-universal-2.6/MySQLdb
 running build_ext
 building '_mysql' extension
 gcc-4.2 -fno-strict-aliasing -fno-common -dynamic -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch ppc -arch x86_64 -pipe -Dversion_info=(1,2,3,'final',0) -D__version__=1.2.3 -I/usr/local/Cellar/mysql/5.5.10/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 -g
 In file included from _mysql.c:36:
 /usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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:39:1: warning: this is the location of the previous definition
 In file included from _mysql.c:36:
/usr/local/Cellar/mysql/5.5.10/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
 In file included from _mysql.c:36:
/usr/local/Cellar/mysql/5.5.10/include/my_config.h:619:1: warning: "SIZEOF_TIME_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:40:1: warning: this is the location of the previous definition
 /usr/libexec/gcc/powerpc-apple-darwin10/4.2.1/as: assembler (/usr/bin/../libexec/gcc/darwin/ppc/as or /usr/bin/../local/libexec/gcc/darwin/ppc/as) for architecture ppc not installed
 Installed assemblers are:
 /usr/bin/../libexec/gcc/darwin/x86_64/as for architecture x86_64
 /usr/bin/../libexec/gcc/darwin/i386/as for architecture i386
 In file included from _mysql.c:36:
/usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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:39:1: warning: this is the location of the previous definition
 In file included from _mysql.c:36: /usr/local/Cellar/mysql/5.5.10/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
 In file included from _mysql.c:36:
/usr/local/Cellar/mysql/5.5.10/include/my_config.h:619:1: warning: "SIZEOF_TIME_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:40:1: warning: this is the location of the previous definition
 _mysql.c:2888: fatal error: error writing to -: Broken pipe
compilation terminated.
 In file included from _mysql.c:36:
/usr/local/Cellar/mysql/5.5.10/include/my_config.h:326: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/Cellar/mysql/5.5.10/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
 lipo: can't open input file: /var/folders/8O/8OOqsN1GEkSD0wcAjZFbMk+++TI/-Tmp-//cc0nabTS.out (No such file or directory)
 error: command 'gcc-4.2' failed with exit status 1
 ----------------------------------------
 Command /Users/jmalina/Sites/virtualenvs/muckrack/bin/python -c "import setuptools;__file__='/Users/jmalina/Sites/virtualenvs/muckrack/build/MySQL-Python/setup.py';exec(compile(open(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --single-version-externally-managed --record /var/folders/8O/8OOqsN1GEkSD0wcAjZFbMk+++TI/-Tmp-/pip-92IOBF-record/install-record.txt --install-headers /Users/jmalina/Sites/virtualenvs/muckrack/bin/../include/site/python2.6 failed with error code 1

• Jim Garrison: Belongs on superuser.com
• JJMalina: thanks for helping me format the output

Answer 1

It seems you have installed MySQL 5.5.10 and Python 2.6. Current version of MySQL-python (version 1.2.3) is supported from MySQL-3.23 through 5.0. However you can try installing it via ActivePython.

If you install ActivePython to the default path, open terminal and run:

/opt/ActivePython-2.6/bin/pypm install mysql-python

I had the similar case with MySQL 5.5 and Python 2.7 on my Fedora 15 platform and it worked well for me.

• frankV: after 3 hours of pure frustration, this saved my day! Thanks!
• Akif: @frankV I am happy to hear that this answer helps to solve your issue.

Answer 2

Try redownloading the entire package and also be sure to be executing the commands in the same directory as the package. Right now MySQL cannot find the necessary files.