[Zope-dev] MySQL-python-0.3.5 with ZMySQLDA

[Phil Harris]

RE: [Zope-dev] MySQL-python-0.3.5 with ZMySQLDAMike,

You need to put the file _mysql.pyd into your PYTHONPATH.

Try putting it into the same folder as the ZMySQLDA or into
<zopedir>bin/lib.  Either should work OK.

Phil

----- Original Message -----
From: Mike Blake
To: Mike Blake ; 'Zope-Dev (E-mail)'
Cc: 'Phil Harris'
Sent: Wednesday, April 04, 2001 5:53 PM
Subject: RE: [Zope-dev] MySQL-python-0.3.5 with ZMySQLDA


>>> Traceback (innermost last):
>>> File C:\zopes\chikoon\lib\python\OFS\Application.py, line 536 in
import_products
>>>    (Object: string)
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\__init__.py, line 9=
1,
in ?
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\DA.py, line 91, in =
?
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\db.py, line 89, in =
?
sorry, but I forgot to include the last line of the message:
>>> ImportError: No module named _mysql
--
[morcilla@ketden.com chikoon]$ whoami
------------------------------------------------------------
[whoami] >> Mike Blake >> Web Developer / CellNetwork, Spain
[e-mail] >> mike.blake@cellnetwork.com    [icq] >> 103631268
[mobile] >> 678 642 392 [direct office phone] >> 91 761 4913
[office] >> Plaza Alonso Martinez 3, 4=AA Planta, 28004 Madrid
------------------------------------------------------------


-----Original Message-----
From: Mike Blake
Sent: mi=E9rcoles, 04 de abril de 2001 18:50
To: Zope-Dev (E-mail)
Cc: 'Phil Harris'
Subject: RE: [Zope-dev] MySQL-python-0.3.5 with ZMySQLDA


mike wrote:
>> I just tried a build of the MySQL-python-0.3.5 module and
>> I get a file not found error because I don't have a cl.exe,
>> which is apparently something I need to finish the build.
>> Does anyone know what I'm missing?
>> I have Python 2.0 and MySQL 3.23.33 on win2000
phil wrote:
> You need Microsoft Visual C (6.x?) to compile what you want.
Ok, I installed Microsoft Visual C++ from Studio 6, and
after I did a successful build and install of the
setup.py file for the MySQL-python-0.3.5
I installed it in a folder in my python directory:
C:\Python20\win32comext\MySQL-python-0.3.5
But the reason I was compiling this module is because it is
required for the installation of the ZMySQLDA database adaptor.
>>>  Installation
>>>
>>>    The Z MySQL database adapter uses the MySQLdb package.
>>>    This must be installed before you can use the Z MySQL DA.
>>>    Instructions on building the extension modules are given in the
>>>    the README.txt file in the source directory.
Ok, I got this far, but I extract the ZMySQLDA to the
<zope-root>/lib/pyton/products directory, and the product doesn't
install properly. It appears broken in the products list.
Here is the error it gives on startup:
>>> Traceback (innermost last):
>>> File C:\zopes\chikoon\lib\python\OFS\Application.py, line 536 in
import_products
>>>    (Object: string)
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\__init__.py, line 9=
1,
in ?
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\DA.py, line 91, in =
?
>>> File C:\zopes\chikoon\lib\python\Products\ZMySQLA\db.py, line 89, in =
?
Any ideas??? Is there something else besides the MySQLdb that
I must compile for the product to be successfully installed?
Thanks,
mike
--
[morcilla@ketden.com chikoon]$ whoami
------------------------------------------------------------
[whoami] >> Mike Blake >> Web Developer / CellNetwork, Spain
[e-mail] >> mike.blake@cellnetwork.com    [icq] >> 103631268
[mobile] >> 678 642 392 [direct office phone] >> 91 761 4913
[office] >> Plaza Alonso Martinez 3, 4=AA Planta, 28004 Madrid
------------------------------------------------------------