[Zope] Disappointment with mysql DA under win

f.stefanelli filippo@oltrelinux.com
Tue, 18 Sep 2001 01:06:27 +0200 (CEST)


Hi all! My nme is Filippo,
I'm  a very big newbie of zope and python. Also my english is some kind
of newbie stuff. But please listen to me.

The box is a win nt 2000

I have installed: Zope 2.4.1; MySQL server 2.23.39; Python 2.11; after I
tryed two ways:
a)
mysql-python-0.9.0.win32-py2.1.exe; egenix-mx-extension; zmysqlda 2.0.8
the installation dir for the first two is c:\python21

with this I get this error after zope restart (there is the image of a
brokenproduct: zmysqlda):

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

I think that this kind of problems are for the incorrect use of
c:\python211 instead of c:\zope\bin    but how can I tell to the installer
of the two products (mysql-python and egenix) to use the zope bin dir? The
only choice possible where c:\python211

So I tried another way:
b)
I download the source of mysql-python (mysql-python-0.9.0) and distutils
1.0.2. I set the path to c:\zope\bin and  i do:
python setup.py install (for distutils) and
python setup.py build (for mysql-python) at this point after some lines
there is an error it says that cannot find cl.exe (I also try to search 
on hard disk for cl.exe, but nothing)and exit...


I'm really hopeless... what steps should I take? Where I'm wrong ?

All this stuff goes great at my linux box at home but on windows I get all
this errors.
Please help me, I don't know where to look :-(

I promise to write an howto in italian when all is ok :-)

Thanks in advance!
Filippo