[Zope] Zope < - > MySQL -> GOT IT RUNNING!

Carl Robert Blesius crb@uni-hd.de
Wed, 13 Jun 2001 01:16:12 +0200


Just to let the list know (and people that have run into similar problems):

After a long fight to get MySQL and Zope to talk to one another we got it 
going!!!

This little bit of information:

>Date: Thu, 7 Jun 2001 20:14:04 -0400 (EDT)
>From: Andy Dustman <andy@dustman.net>
>
>ZMySQLDA-1.1.3 is not compatible with MySQL-python-0.3.5. Instead, try
>ZMySQLDA-2.0.7 with MySQL-python-0.9.0.
>http://sourceforge.net/projects/mysql-python


along with installing Distutils (and other various requirements mentioned 
in the documentation) on a non Zope Python 1.5.2 Version and copying the 
needed folders and files mentioned in the error messages from standard 
python install to Zope python install did the trick (as well as various 
nitty gritty configuration settings because of our "non standard" system 
and system setup).

I am sorry it is not more detailed, but we were about to give up and as a 
last resort started trying some crazy things (without documenting it): and 
like magic... it started to work (and has been running ever since).

Carl

On Thu, 7 Jun 2001, Carl Blesius wrote:

 > We are having a problem with the MySQL Zope connection...
 >
 > Zope 2.3.0 (binary release, python 1.5.2, solaris-2.6-sparc)
 > Python Version 1.5.2 (#8, Nov 16 1999, 10:05:41) [GCC 2.8.1]
 > sunos5
 >
 > ZMySQLDA-1.1.3-nonbin.tar.gz
 > MySQL-python-0.3.5.tar.gz
 > Distutils-1.0.2.tar.gz
 >
 > Traceback (innermost last):
 >    File "/usr/local/www/zope/lib/python/OFS/Application.py", line 530, 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 "lib/python/Products/ZMySQLDA/DA.py", line 108, in ?
 >      from db import DB
 >    File "lib/python/Products/ZMySQLDA/db.py", line 106, in ?
 >      import MySQL, regex, sys
 > ImportError: dynamic module does not define init function (initMySQL)
 >
 > Anyone have similar problems?
 >


At 08:45 11.06.2001 +0000, horst wrote:
>hi
>
>the same problem happens to me.
>
>is your problem fixt?
>
>please mail me!
>
>mfg horst