[Zope] Problem in ZOPE-MySQL connectivity..dll mismatch problem
Surajit Sengupta
surajit@ontrackindia.com
Tue, 23 Apr 2002 16:19:43 +0530
This is a multi-part message in MIME format.
------=_NextPart_000_002A_01C1EAE2.AD989110
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I'm using ZOPE Version 2.0, which is using the Python 2.1.2. Now I =
want to make a connectivity of ZOPE with MySQL.
I've =20
I'm using in Windows 2000 platform
1.. Downloaded the Python-MySQL Interface(Version 0.9.0) [MySQLdb]
2.. Downloaded the ZOPE MySQL database Adapter (Version 2.0.8) =
[ZMySQLDA]
3.. Built MySQLdb(0.9.0)
4.. Installed MySQLdb(0.9.0)
5.. Inflated ZMySQLDA in required directory
=20
***Problems found : dll version mismatch
After running the ZOPE server: Following errors are generated
2002-04-23T06:49:32 ERROR(200) Zope Could not import Products.MySQLdb
Traceback (innermost last):
File C:\PROGRA~1\Zope\lib\python\OFS\Application.py, line 531, in =
import_product
File MySQLdb\__init__.py, line 27, in ?
ImportError: Module use of python20.dll conflicts with this version of =
Python.
=20
Anticipations :=20
In C:\Program Files\Zope\bin there is python21.dll which I think the =
latest dll which the python exe of our ZOPE version is using. After =
putting it to the c:\winnt\system32 and registering it, the same error =
is coming. During the run of Zope server __init__ of ZMySQLDA is =
importing _mysql.pyd which is generating the error as it is searching =
for python20.dll(NOT python21.dll). I have a python20.dll also in my =
c:\winnt\system32, its version also does not match with the python exe =
our ZOPE version is using.=20
I don't know what to do
Help required
Regards
Surajit
------=_NextPart_000_002A_01C1EAE2.AD989110
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I'm using ZOPE =
Version 2.0,=20
which is using the Python 2.1.2. Now I want to make a connectivity of =
ZOPE with=20
MySQL.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I've =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> I'm using in Windows =
2000=20
platform</DIV>
<OL style=3D"MARGIN-TOP: 0in" type=3D1>
<LI class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Downloaded the=20
Python-MySQL Interface(Version 0.9.0) [<B><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA">MySQLdb]</SPAN></B></SPAN></B></LI>
<LI class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Downloaded the =
ZOPE MySQL=20
database Adapter (Version 2.0.8) [<B><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: =
AR-SA">ZMySQLDA</SPAN></B>]</SPAN></B></SPAN></B></LI>
<LI class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> <B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Built=20
MySQLdb(0.9.0)</SPAN></B></SPAN></B></SPAN></B></LI>
<LI class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA">Installed=20
MySQLdb(0.9.0)</SPAN></B></SPAN></B></SPAN></B></SPAN></B></LI>
<LI class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><B><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA"><B><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA">Inflated=20
ZMySQLDA in required=20
=
directory</SPAN></B></SPAN></B></SPAN></B></SPAN></B></SPAN></B></LI></OL=
>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><FONT=20
face=3D"Times New Roman"> </DIV>
<H1 class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><U>***Problems =
found :=20
dll version mismatch<?xml:namespace prefix =3D o ns =3D=20
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></U></H1>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in">After running =
the ZOPE=20
server: Following errors are generated</P>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list =
.5in">2002-04-23T06:49:32=20
ERROR(200) Zope Could not import Products.MySQLdb</P>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in">Traceback =
(innermost=20
last):</P>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>File=20
C:\PROGRA~1\Zope\lib\python\OFS\Application.py, line 531, in =
import_product</P>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>File MySQLdb\__init__.py, line =
27, in=20
?</P>
<P class=3DMsoBodyTextIndent=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in">ImportError: =
Module use=20
of python20.dll conflicts with this version of Python.</P>
<P class=3DMsoNormal=20
style=3D"MARGIN-LEFT: 0.5in; mso-list: l0 level1 lfo1; tab-stops: list =
.5in"><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: =
12.0pt"> <o:p></o:p></SPAN></P>
<P class=3DMsoNormal style=3D"mso-list: l0 level1 lfo1; tab-stops: list =
.5in"><SPAN=20
style=3D"FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><SPAN=20
style=3D"mso-tab-count: =
1"> &nbs=
p; =20
</SPAN><B>Anticipations : <o:p></o:p></B></SPAN></P>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA">In=20
C:\Program Files\Zope\bin there is <B>python21.dll </B>which I think the =
latest=20
dll which the python exe of our ZOPE version is using. After putting it =
to the=20
c:\winnt\system32 and registering it, the same error is coming.<SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>During the run of Zope server=20
<B>__init__</B> of <B>ZMySQLDA </B><SPAN=20
style=3D"mso-spacerun: yes"> </SPAN>is importing _mysql.pyd which =
is=20
generating the error as it is searching for python20.dll(NOT =
python21.dll). I=20
have a python20.dll also in my c:\winnt\system32, its version also does =
not=20
match with the python exe our ZOPE version is using. </SPAN></DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA"></SPAN> </DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA">I=20
don't know what to do</SPAN></DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN=20
style=3D"FONT-FAMILY: 'Times New Roman'; FONT-SIZE: 10pt; =
mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; =
mso-ansi-language: EN-US; mso-fareast-language: EN-US; =
mso-bidi-language: AR-SA"></SPAN> </DIV>
<DIV class=3DMsoNormal style=3D"mso-list: l0 level1 lfo1; tab-stops: =
list .5in">Help=20
required</DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in"> </DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list .5in">Regards</DIV>
<DIV class=3DMsoNormal=20
style=3D"mso-list: l0 level1 lfo1; tab-stops: list =
.5in">Surajit</FONT></DIV></FONT></BODY></HTML>
------=_NextPart_000_002A_01C1EAE2.AD989110--