[Zope] Disappointment with mysql DA under win

[Capesius, Alan]

You might also consider using the MySQL ODBC driver and the Zope ZmxODBC DA.
See http://www.mysql.org and 
http://www.zope.org/Members/djay/ZmxODBC

Zope Tips and tricks for Windows NT and SQL
===========================================
http://twsite.bizland.com/zopetips.htm

 

>>>-----Original Message-----
>>>From: f.stefanelli [mailto:filippo@oltrelinux.com]
>>>Sent: Monday, September 17, 2001 6:06 PM 
>>>To: zope@zope.org
>>>Subject: [Zope] Disappointment with mysql DA under win
>>>
>>>
>>>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
>>>
>>>
>>>
>>>
>>>_______________________________________________
>>>Zope maillist  -  Zope@zope.org
>>>http://lists.zope.org/mailman/listinfo/zope
>>>**   No cross posts or HTML encoding!  **
>>>(Related lists - 
>>> http://lists.zope.org/mailman/listinfo/zope-announce
>>> http://lists.zope.org/mailman/listinfo/zope-dev )
>>>