[Zope] win32 - best DBMS with Zope?
Mon, 17 Jun 2002 15:21:01 +0200
>Having read a bit, I concluded the open source
>DBMS to use with Zope was mySQL. Easier
>said than done under win32, I've discovered.
You're right, installing ZMySQLDA under windows is really difficult. I
got it thanks to a doc I found I don't know where (maybe Derek sent it
to me), but here you are.
Here's a document that says how I got it working. It would be
nice if this could be turned into a "Howto" on the Zope.org website, but
don't have an account there.
Ever try to get a MySQL server and Zope running under
Here's what I had to do. And no, I didn't find this documented
anywhere. This was a bit challenging as I haven't really used
for anything other than gaming in about 5 years.
1. Install and start Zope
2. Install and start MySQL server (I'm using mysqld-opt.exe)
3. Install ZMySQLDA
(*) You need a Windows program that can handle tarballs, as=20
ZMySQLDA, like most Zope "Products", is not distributed as a .zip file
4. Restart Zope
5. Notice that the ZMySQLDA Product is showing as "broken" in the Zope
Control Panel, because you are missing the MySQL-python interface
6. Try to install MySQL-python (filename
(*) This will fail, because the Windows installer program will
only unpack the files if it can find a "Python Installation" directory
unpack it into. There is no way to specify your Zope Python install as
will only let you choose a Python install that is finds in the registry
*think*). I.e., you fscking NEED Python to get access to the files. A=20
.zip file was not available for download.
7. Download and install the win32 Python 2.1.2 (to match your Zope
8. Now install MySQL-python (it should work this time)
9. Restart Zope, and notice that the ZMySQLDA Product is broken, because
it is not finding the MySQL-python interface library
10. At this point, you'll need to either (a) have payed attention to the
directories the Windows Installers used, or (b) go surfing around your=20
hard drive until you find where Zope, Python, and MySQL-python were=20
placed. For me it was (b).
11. Identify the files needed for MySQL-python. Since MS-Window's
management system doesn't provide an "rpm -ql" equivalent, I guessed
MySQLdb/ [dir with all contents]
...then I copied those files into the directory
That "Demo" is the name of the directory Zope was installed
12. Restart Zope.
Is is working? Seems to be... I can talk to the database from
Zope. It is correct and stable? Fsck if I know.