[Zope] ZMySQLDA broken with Redhat 9?

[hpinson at indepthl.com]

This is really baffling:

I cannot seem to get ZMySQLDA to work on Redhat 9.

Here's what is installed:

(Zope 2.6.1 (binary release, python 2.1, linux2-x86), python 2.1.3, 
linux2) 
MySQL-shared-compat-4.0.13-0
MySQL-server-4.0.13-0
MySQL-devel-4.0.13-0
MySQL-client-4.0.13-0
MySQL-python-0.9.2-1

/var/zope/lib/python/Products/ZMySQLDA version 2.0.8

Here is the traceback:

Traceback (most recent call last):
  File "/var/zope/lib/python/OFS/Application.py", line 541, in 
import_product
    product=__import__(pname, global_dict, global_dict, silly)
  File "/var/zope/lib/python/Products/ZMySQLDA/__init__.py", line 91, 
in ?
    import DA
  File "/var/zope/lib/python/Products/ZMySQLDA/DA.py", line 92, in ?
    from db import DB
  File "/var/zope/lib/python/Products/ZMySQLDA/db.py", line 89, in ?
    import _mysql
ImportError: No module named _mysql

Is it a path problem? Adding: 

PYTHONPATH=/usr/lib/python2.2/site-packages
EXPORT PYTHONPATH

to /var/zope/start does not seem to fix it.  Nor does:

PYTHONPATH=/usr/lib/python1.5/site-packages
EXPORT PYTHONPATH

...which is where I can find _mysql.so as well as the MySQLdb 
directory.

Zope appears not to run at all if I change Zope' python to 2.2, which 
came with RH9, so I am using the default python that came with the 
Zope binary.

Getting MySQL and Zope to talk on Linux used to be so easy.  What am 
I doing wrong?  

Any help would be greatly appreciated.

Harlow Pinson
Indepth Learning
Email: hpinson at indepthl.com 
Web: http://www.indepthl.com
Voice: 505-994-2135
FAX: 208-475-7678