Sylvain Zimmer - blog

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!

Share This

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 ? ;-)

Share This

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!

Share This

jscrypt: the best (well… at least the geekiest) way to chat with your buddies about your top-secret projects you don’t want Gmail or Facebook to know about ;-)

Share This