[Zope-DB] Plone2, MySQL-python-0.9.3b2, fink mySQL 4.0.15, Mac OS X install problems

[AdvertisingDept]

ld: can't locate file for: -lmysqlclient
error: command 'gcc' failed with exit status 1

setup.py fails when trying to install mysql-python.

-----

I'm trying to use mySQL 4.0.15 with Plone 2. 

But having trouble getting the mySQL-python to install correctly.


Mac OSX version 10.2.8

Plone 2.0 RC3 Mac OS X 
  =  python 2.3.2
     Zope 2.7 (control panel doesn't say, so I'm guessing)

Fink installed mySQL          v 4.0.15-11
Fink installed mySQL-client   v 4.0.15-11
Fink installed mySQL12-shlibs v 4.0.15-11

-----

Problem #1) Solved
    
    Creating a database connection in Zope gives
    ErrorValue: server_capabilities

    MySQL-python-0.92 & zMySQLda 
    do not work with python 2.3
    
    Supposedly fixed in the 0.93beta releases

-----

Problem #2) Solved

   http://sourceforge.net/projects/mysql-python

   the latest featured version is hosed.
   
   0.9.3b3  December 28, 2003

   Bad .tgz file. Copied onto all Mirrors as a bad tgz file.

   Using CVS to check out the latest version,
   gets you the usable 0.9.3b3
   Go to the CVS section (not the browse CVS section)
   and read the instructions at the bottom of the page.

   Hint, the change log only mentions 0.9.3a2
   but the changes to the setup.py have the same date
   as 0.9.3b3 release date. So I assume cvs is giving
   us the latest version.

-----

Problem #3)

   Can't get the setup.py to run completely.
   Everything is working swimmingly until the end.

   note: fink installs everything in a sub-directory  /sw

running build_ext
building '_mysql' extension
creating build/temp.darwin-6.8-Power_Macintosh-2.3
gcc -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd 
-DNDEBUG -g -O3 -Wall -Wstrict-prototypes -I/sw/include -I/sw/include 
-I/usr/include/mysql -I/usr/local/include/mysql 
-I/usr/local/mysql/include/mysql -I/sw/include 
-I/Applications/Plone2/Library/Software/Zope270/Python/include/python2.3 
-c _mysql.c -o build/temp.darwin-6.8-Power_Macintosh-2.3/_mysql.o
_mysql.c: In function `_mysql_server_init':
_mysql.c:193: warning: unused variable `s'
_mysql.c:194: warning: unused variable `cmd_argc'
_mysql.c:194: warning: unused variable `i'
_mysql.c:194: warning: unused variable `groupc'
_mysql.c:195: warning: unused variable `item'
_mysql.c:269: warning: label `finish' defined but not used
_mysql.c: At top level:
_mysql.c:180: warning: `_mysql_server_init__doc__' defined but not used
_mysql.c:191: warning: `_mysql_server_init' defined but not used
_mysql.c:275: warning: `_mysql_server_end__doc__' defined but not used
_mysql.c:281: warning: `_mysql_server_end' defined but not used
gcc -bundle -bundle_loader 
/Applications/Plone2/Library/Software/Zope270/Python/bin/python2.3 
-L/sw/lib -I/sw/include -I/sw/include 
build/temp.darwin-6.8-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 -lz -o build/lib.darwin-6.8-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: warning -L: directory name (/usr/local/mysql/lib/mysql) does not exist
ld: can't locate file for: -lmysqlclient
error: command 'gcc' failed with exit status 1



Can anyone help me with problem #3?

Many Thanks in Advance!