[Zope] ZMySQLDA problem after following HOW TO...

[Ragnar Beer]

1. You may have forgotten the "python build.py" step during MySQLDB 
installation. It's not mentioned in the howto but in the README the 
howto refers to.

2. Your MySQL libraries and includes may not be where they are beeing 
looked for. Here is what I did (I posted this earlier):

The solution that FINALLY WORKED for Suse 6.3, Zope 2.1.3, ZMySQLDA 
1.1.3, MySQLDB 0.1.1 and MySQL 2.2.30 (installed in /usr/local/mysql):

Added two links:
ln -s /usr/local/mysql/include/mysql /usr/include/mysql
ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql

Added the following line to /etc/ld.so.conf:
/usr/local/mysql/lib/mysql

And then ran "ldconfig"

HTH, Ragnar

>I followed the directions in the How-To by alanpog.  Everything seemed to go
>along well.  I restarted and checked the control panel only to find a
>'broken' installation...
>
>Here is the Traceback...
>
>Product at /Control_Panel / Products / ZMySQLDA
>
>ZMySQLDA Import Traceback
>
>Traceback (innermost last):
>   File "/pub/Zope/lib/python/OFS/Application.py", line 387, in
>import_products
>     product=__import__(pname, global_dict, global_dict, silly)
>   File "lib/python/Products/ZMySQLDA/__init__.py", line 106, in ?
>     import sys, os, Globals, DA
>   File "/pub/Zope/lib/python/Products/ZMySQLDA/DA.py", line 108, in ?
>     from db import DB
>   File "/pub/Zope/lib/python/Products/ZMySQLDA/db.py", line 106, in ?
>     import _mysql, regex, sys
>ImportError: No module named _mysql