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

[AdvertisingDept]

Ok, I feel pretty stupid.

the solution to problem #3) is
fink install mySQL12-dev
which installs the missing includes to coordinate 
with the rest of mysql v 4.0.15-11


I had been successfully using 
mysql 3.23 with ZmySQLda and zope 2.5

When I decided to try Plone2,
I stepped into the whole nest of bugs.

So I foolishly moved to MySQL 4 
thinking it might solve the problems. 

Ouch!




>-----
>
>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

you must also have
Fink installed mySQL12-dev     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) Solved
>
>   Can't get the setup.py to run completely.

If you are fink upgrading from mysql 3.x note that the libraries have 
changed names

  mySQL12-shlibs v 4.0.15-11
  mySQL12-dev    v 4.0.15-11

You need to install them both.
And probably fink remove the mysql 3.x libraries.