[Zope] ZMySQLDa and Win32
David Parker
daevidparker@yahoo.com
Sun, 4 Mar 2001 10:47:16 -0600
This is a multi-part message in MIME format.
------=_NextPart_000_002A_01C0A498.7AB4D6F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hey Robert,
I managed to get it all going yesterday evening. It turns out it is not =
too difficult doing it this way (figuring it out was the hard part) =
(assumes Zope 2.3 and MySQL 3.23.33 are currently installed on Windows =
2000):
1) Install Python 1.5.2 but use the bin directory in your Zope base =
directory as the destination path. (Where python.exe resides). This =
essentially adds the python components that are needed by Distutils that =
are not distributed as part of Zope 2.3.
2) Install ZMySQLDA-2.0.4 using standard Zope product install procedure.
3) Install Python Distutils (Distutils-1.0.1.win32.exe) =
http://www.python.org/sigs/distutils-sig/download.html . (Launch the =
Distutils exe rather than extractng 1st.) This is required for step 4. =
This is also why I did step 1, to allow Distutils to install properly.
4) Install MySQLdb 0.3.3 using the Windows Installer package at =
http://highqualdev.com/ (link from page =
http://dustman.net/andy/python/MySQLdb).
5) From a Python cmdline type "import _mysql".
6) Restart Zope.=20
So far everything sems to work very well. Much faster and secure than =
using Access as a backend database. (MS SQL Server not an option due to =
price constraints).
Thanks,
David
----- Original Message -----=20
From: Robert Rottermann=20
To: David Parker=20
Sent: Sunday, March 04, 2001 12:02 AM
Subject: Re: [Zope] ZMySQLDa and Win32
Hi David,
I did install mysql for zope on an nt 2000 box.
It's a coupple of weeks ago and I did not keep any notes so what I =
tell you is wat my stak overflow riddlel brain remembers.
------=_NextPart_000_002A_01C0A498.7AB4D6F0
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 http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4611.1300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hey Robert,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I managed to get it all going yesterday =
evening. It=20
turns out it is not too difficult doing it this way (figuring it out was =
the=20
hard part) </FONT><FONT face=3DArial size=3D2>(assumes Zope 2.3 and =
MySQL 3.23.33=20
are currently installed on Windows 2000):</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>1) Install Python 1.5.2 but use the bin =
directory=20
in your Zope base directory as the destination path. (Where =
python.exe=20
resides). This essentially adds the python components that are needed by =
Distutils that are not distributed as part of Zope 2.3.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) Install ZMySQLDA-2.0.4 using =
standard Zope=20
product install procedure.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3) Install Python=20
Distutils (Distutils-1.0.1.win32.exe) <A=20
href=3D"http://www.python.org/sigs/distutils-sig/download.html">http://ww=
w.python.org/sigs/distutils-sig/download.html</A> .=20
(Launch the Distutils exe rather than extractng 1st.) This is =
required for=20
step 4. This is also why I did step 1, to allow Distutils to install=20
properly.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>4) Install MySQLdb 0.3.3 using the =
Windows=20
Installer package at <A=20
href=3D"http://highqualdev.com/">http://highqualdev.com/</A> (link =
from page=20
<A=20
href=3D"http://dustman.net/andy/python/MySQLdb">http://dustman.net/andy/p=
ython/MySQLdb</A>).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>5) From a Python cmdline type =
"import=20
_mysql".</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>6) Restart Zope. </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>So far everything sems to work very =
well. Much=20
faster and secure than using Access as a backend database. (MS SQL =
Server=20
not an option due to price constraints).</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>David</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A title=3Drobert@redcor.ch href=3D"mailto:robert@redcor.ch">Robert =
Rottermann</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3Ddaevidparker@yahoo.com=20
href=3D"mailto:daevidparker@yahoo.com">David Parker</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Sunday, March 04, 2001 =
12:02=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: [Zope] ZMySQLDa =
and=20
Win32</DIV>
<DIV><FONT face=3DArial size=3D2></FONT><BR></DIV>
<DIV><FONT face=3DArial size=3D2>Hi David,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I did install mysql for zope on an nt =
2000=20
box.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>It's a coupple of weeks ago and I did =
not keep=20
any notes so what I tell you is wat my stak overflow riddlel brain=20
remembers.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_002A_01C0A498.7AB4D6F0--
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com