Sylvain Zimmer

“Open Business is still Business” – Jon Phillips

Speech about innovation, openness and creative commons

Joining us via skype, wikipedia founder Jimmy Wales talks about open source search engines

After a full day of work, most of the team around some drinks in Place de France, Luxembourg. Nice!

I’m testing the new wordpress iPhone app, and it rocks! The UI is neat while still exposing a lot of features so congrats to the wp devs!

Seems like no week passes without a new concert appearing on my google calendar

• Maceo Parker with the WDR Big Band, in Dudelange (July 14th) : A really different performance from Maceo, with a tribute to Ray Charles. As always, it was a blast. Bassist Rodney ‘Skeet’ Curtis lays down basslines like nobody else and the Big Band was one of the best I’ve seen.
• Goldfrapp tonight at the Neumunster Abbey : We bought our tickets yesterday even if we don’t know Goldfrapp very well, mostly because the venue is nothing short of amazing! Check it out…
• The Mars Volta, 3 hours of show at the Atelier, next Sunday : will we survive more than one ?

Like many others, I struggled for a good hour to install the recommended MySQL module for Python, which is MySQLdb. So I’m sharing here the solution I found

The latest MAMP (1.7.1) uses MySQL 5.0.41, and MacOS X Leopard (10.5) uses Python 2.5.1 . As I couldn’t find a prebuilt MySQLdb binary for those versions, well, I had to compile my own.

So let’s go for it :

• Download an old copy of mysql 5.0.41
• Download the latest MySQLdb


$ tar zxvf mysql-5.0.41.tar.gz
$ cd mysql-5.0.41
$ ./configure && make
$ sudo make install
$ cd ..

(now MySQL is installed in /usr/local/)

$ tar zxvf MySQLdb...
$ cd MySQLdb...

• In the MySQLdb folder, edit the file _mysql.c
  • Delete the following lines :
    

    #ifndef uint
    #define uint unsigned int
    #endif

  • Replace 2 occurences of “uint” by “unsigned int”
• Then edit the site.cfg file, and set the mysql_config variable to “/usr/local/bin/mysql_config”


(Still in the MySQLdb folder)

$ python setup.py clean
$ python setup.py build
$ sudo python setup.py install
$ sudo rm /tmp/mysql.sock
$ sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock


And that’s it! You should now be able to “import MySQLdb” in python. Good luck!