[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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>1) Install Python 1.5.2 but use the bin =
directory=20
in your Zope&nbsp;base directory&nbsp;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&nbsp;(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>&nbsp;.=20
(Launch the Distutils exe rather than extractng 1st.)&nbsp;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>&nbsp; (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&nbsp;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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>So far everything sems to work very =
well. Much=20
faster and secure&nbsp;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>&nbsp;</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>&nbsp;</DIV>
  <DIV><FONT face=3DArial =
size=3D2></FONT>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_002A_01C0A498.7AB4D6F0--


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com