[Zope] ZMySQLDA error

[Slaets, Maarten]

hi,

i keep getting this error no mather what i try:

<traceback>
ZMySQLDA Import Traceback

Traceback (innermost last):
  File "/usr/local/Zope-2.0.1-src/lib/python/OFS/Application.py", line 393,
in import_products
    product=__import__(pname, global_dict, global_dict, silly)
  File "lib/python/Products/ZMySQLDA/__init__.py", line 106, in ?
  File "/usr/local/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/DA.py", line
108, in ?
    from db import DB
  File "/usr/local/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py", line
106, in ?
    import _mysql, regex, sys
ImportError: ld.so.1: python: fatal: libmysqlclient.so.6: open failed: No
such file or directory
</traceback>

the file 'libmysqlclient.so.6' does exist, in /usr/local/lib/mysql.
do I need to put it in an environment variable? and how do I do this if I
run Zope with PCGI?

Maarten Slaets
KPNQwest Belgium
Contact info:
http://www.fonky.com/vcard/MaartenSlaets/