Using Python with MySQL on Mac OSX 10.5 Leopard at paulcarvill.com, the home of Paul Carvill on the web

link: paulcarvill at flickr

paulcarvill.com

Hi, I'm Paul Carvill and I'm a web developer. I am Head of Interface Development at LBi, Europe's largest digital agency.

I also like walking, cooking, Bollywood and rock 'n' roll.

Using Python with MySQL on Mac OSX 10.5 Leopard

posted: Wednesday, March 18th, 2009 at 1:00 pm

If you try to build the MySQL Python library on Mac OS X 10.5 (Leopard) you’ll get an error similar to this:

/usr/include/sys/types.h:92: error: duplicate ‘unsigned’
/usr/include/sys/types.h:92: error: two or more data types in declaration specifiers
error: command 'gcc' failed with exit status 1

I found the fix for this error here: http://www.keningle.com/?p=11, via a comment on this site: http://dotnet.org.za/ncode/archive/2007/01/31/setting-up-mysql-for-python-mysqldb-on-mac-os-x-2.aspx. It’s just a couple of lines in Terminal, adding a symlink so the library knows where to look to find the files.

Some background: Unless you’re using SQLite, you need to install a Python library to interface with your chosen database (PostgreSQL, MySQL or Oracle).

The MySQL library can be downloaded here: http://www.djangoproject.com/r/python-mysql/

But it seems there are a few problems running this library on Mac OS X 10.5 (Leopard), hence the above fix.

Tags:

«
»

This entry was posted on Wednesday, March 18th, 2009 at 1:00 pm and is filed under Development, Python. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.