[Zope] _mysql.so causes problem

[Peter Bengtsson]

Infinite problems with MySQL and Zope and MySQL-python (which used to be
called MySQLdb before right)

 - I downloaded the latest MySQL-python 0.3.3
 - Followed the instructions carefully. Had to install the python-devel kit
for Distutils.
 - # python setup.py build and install gave me a C parse error at line 1678
in _mysqlmodule.c which I fixed.

Anyhow I now have a file called _mysql.so in
/usr/lib/python1.5/site-packages/
<zopedir> ./start
Complains the usual (common problem according to endless searches on the
mailing list archive)

Traceback (innermost last):
ImportError: No module named _mysql

So I copy /usr/lib/python1.5/site-packages/_mysql.so to
<zopedir>/lib/python/Products/ZMySQLDA/

Now this is the error I get:

2001-02-15T13:00:06 ERROR(200) Zope Couldn't import Products.ZMySQLDA
Traceback (innermost last):
  File /home/zope/Zope-2.3.0-linux2-x86/lib/python/OFS/Application.py, line
530, in import_products
    (Object: string)
  File
/home/zope/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/__init__.py,
line 91, in ?
  File /home/zope/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/DA.py,
line 91, in ?
  File /home/zope/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/db.py,
line 89, in ?
ImportError:
/home/zope/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/_mysql.so:
undefined symbol: Py_InitModule3


In the mailing list archives I've seen this error before, but no concrete
solution other than "check your paths to mysql" etc.


Zope 2.3.0
RedHat 6.2
Mysql 2.23.32
Python 1.5.2 (with python-devel)


Can somebody suggest a good _combination of versions_ to be used because the
box hasn't been hooked up yet and we can reinstall a lot from scratch if
necessary.


Really really grateful for advice, Peter