This post originated from an RSS feed registered with Python Buzz by Victor Ng. Original Post: MySQLdb, OSX and -lmysqlclient_r Feed Title: Victor Ng's Weblog Feed URL: https://blog.crankycoder.com/feed/atom/ Feed Description: Python Feed Latest Python Buzz Posts Latest Python Buzz Posts by Victor Ng Latest Posts From Victor Ng's Weblog

The Python MySQLdb driver (0.9.2) doesn't build out of the box for OSX 10.2.8 and MacPython 2.3.

The last couple errors you'll get are:

gcc -Wl,-x -Wl,-F. -bundle -framework Python build/temp.darwin-6.6-Power_Macintosh-2.3/_mysql.o -L/usr/lib/mysql -L/usr/local/lib/mysql -L/usr/local/mysql/lib/mysql -L/sw/lib -lmysqlclient_r -lz -o build/lib.darwin-6.6-Power_Macintosh-2.3/_mysql.so -flat_namespace
ld: warning -L: directory name (/usr/lib/mysql) does not exist
ld: warning -L: directory name (/usr/local/lib/mysql) does not exist
ld: can't locate file for: -lmysqlclient_r
error: command 'gcc' failed with exit status 1

Changes you'll have to make to setup.py in MySQLdb:

     23 mysqlclient = thread_safe_library and "mysqlclient"
...
     25 # include files and library locations should cover most platforms
     26 include_dirs = [
     27     '/usr/local/mysql/include/mysql',
     28     ]
     29 library_dirs = [
     30     '/usr/local/mysql/lib/mysql',
     31     ]