[Zope] Zope & MySQL on Win98

William BC Crandall wcra@beest.midat.de
Thu, 10 Aug 2000 14:20:43 +0200


Hello Zope and MySQL users,

I'm trying to access MySQL through Zope.
I hope someone can point out my set-up error(s).

Environment: 
Windows98:     4.10.98
MySQL Server:  3.23.21-beta-debug
Zope v.:       2.2.0 (binary release, python 1.5.2, win32-x86) 
Python v.:     1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] 
ZMySQLDA v.:   1.1.4 (nonbinary)  
               (in: <zope-dir>/lib/Products/ZMySQLDA/)
MySQL.pyd      'MySQLmodule-1.4: A Python interface to the MySQL
database.' 
               (this from MySQL.__doc__)
               (in: <zope-dir>/bin/lib/)

MySQL works fine through the mysqlc monitor and Python scripts 
using odi and odbc. But I keep crashing Zope/Python with even 
the simplest queries.

Here's what I do, followed by the mysqld -log file entries.

Start MySQL:   C:\mysql\bin\mysqld.exe --console --log
Start Zope:    C:\Program Files\<zope-dir>\start.bat 
               (Which is, out-of-the-box:
                "C:\Program Files\TotipotentZope\bin\python.exe" 
                "C:\Program Files\TotipotentZope\z2.py" -D 
                %1 %2 %3 %4 %5 %6 %7 %8 %9)

Zope says:
        2000-08-10T11:44:08 PROBLEM(100) ZServer Computing default
hostname
        ------
        2000-08-10T11:44:08 INFO(0) ZServer Medusa (V1.16.4.2) 
                  started at Thu Aug 10 13:44:08 2000
            Hostname: LAP_WILL
            Port:8080
        (Other than PROBLEM(100), all looks fine.)

Start Netscape   (Communicator 4.7 -- but same results with IE5)
Go to:            http://localhost:8080/manage;    login
Go to:            folder with  'Z MySQL Database Connection'
Open:             Database Connection object> 'The database connection
is open.'
Go to:            'Properties' click 'Change'   (without changing
anything) 
Crash:            'PYTHON caused an invalid page fault in
                  module MYSQL.PYD at 015f:012d3827.'


MySQL log files (tmm is a DB on MySQL):

    C:\mysql\bin\mysqld.exe, Version: 3.23.21-beta-debug-log, started
with:
    Tcp port: 3306  Unix socket: MySQL
    Time                 Id Command    Argument
    000810 13:56:23	      1 Connect    root@localhost on 
    		      1 Init DB    tmm
    000810 13:56:35	      2 Connect    root@localhost on 
    		      2 Init DB    tmm
    		      1 Quit      


Many thanks for any suggestions.


William BC Crandall
Wiesbaden,  Germany
wcra@beest.midat.de