[Zope-DB] Very basic MySQL/Windows installation question

[working4aliving]

Geoff,
there's a Mysql-python-0.9.1.win32-py2.1.exe binary available that should
take care and "find" your installations.

Bob.


----- Original Message -----
From: "Geoff Gardiner" <ggardiner@accelrys.com>
To: <zope-db@zope.org>
Sent: Tuesday, September 17, 2002 7:08 AM
Subject: [Zope-DB] Very basic MySQL/Windows installation question


> I have spent some hours trying to work out how to install MySQL and hook
it
> to Zope in a Windows environment. Most of those hours have been spent
> trawling the newsgroups and following those links that aren't broken - but
> without reaching any true enlightment.
>
> It seems so simple in overview, but I'm stuck with the MySQLdb bit. Where
> does Win32_Py21_mysql-python091.pyd actually go? I have put it in
> Website\lib\python but the MySQLDA product fails to install, giving the
> message "ImportError: No module named _mysql".
>
> I've been trying to understand MySQLdb, but all I can see is that it has
> changed character between versions 2.0.7 (which seems to need compilation)
> and 2.0.8 (which is a .pyd).
>
> Can anyone point me in the right direction here?
>
> Details so far:
>
> 1) Zope: Downloaded and installed Zope 2.5.1 to C:\Program Files\Website.
> Check it starts Ok.
>
> 2) MySQL: Downloaded and installed MySQL 3.23.52 to C:\mysql. Check it
> tests out Ok.
>
> 3) MySQL-Python: Downloaded Win32_Py21_mysql-python091.zip, which contains
> Win32_Py21_mysql-python091.pyd. Assume it goes into Website\lib\python as
> other .pyd files.
>
> 4) MySQLDA: Downloaded ZMySQLDA-2.0.8.tar.gz and dropped into Zope
Products
> to create a ZMySQLDA folder and contents.
>
> 5) Restart Zope and view the ZMySQLDA product. Results:
> Import Traceback
> Traceback (most recent call last):
>   File "C:\PROGRA~1\WebSite\lib\python\OFS\Application.py", line 531, in
> import_product
>     product=__import__(pname, global_dict, global_dict, silly)
>   File "C:\PROGRA~1\WebSite\lib\python\Products\ZMySQLDA\__init__.py",
line
> 91, in ?
>     import DA
>   File "C:\PROGRA~1\WebSite\lib\python\Products\ZMySQLDA\DA.py", line 92,
> in ?
>     from db import DB
>   File "C:\PROGRA~1\WebSite\lib\python\Products\ZMySQLDA\db.py", line 89,
> in ?
>     import _mysql
> ImportError: No module named _mysql
>
> Thank you,
> Geoff
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>