[Zope] ZMySQLDA on Win32 - connect then crash

[William BC Crandall]

Phil Harris wrote:

> What version of MySQL are you using and also what version of the Zope
> Adapter?

> MySQL Server version: 3.23.21-beta-debug

Was using: ZMySQLDA-1.1.3-nonbin, as per your How-To.

Just got: ZMySQLDA-1-1-4 (most recent stable). Same problems.
Non-results SQL, 'use tmm', works, but 'show tables'
crashes Python/Zope.

I installed contents of ZMySQLDA-1-1-4 in:
     <zope-dir>/lib/python/Products/ZMySQLDA


Thanks again,

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





>
> ----- Original Message -----
> From: "William BC Crandall" <wcra@beest.midat.de>
> To: <phil.harris@zope.co.uk>
> Cc: <zope@zope.org>
> Sent: Wednesday, August 09, 2000 12:56 PM
> Subject: [Zope] ZMySQLDA on Win32 - connect then crash
>
> > Dear Phil:
> >
> > Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)".
> > And for your inquiry about troubles with the set up.
> >
> > Following the steps you outlined, I was able to establish
> > a (very) minimal working connection. That is to say, I can
> > use Zope's 'Z MySQL Database Connection' 'Test' page with
> > the SQL command 'use tmm' (tmm is the name of my database),
> > with success:
> >
> > This statement returned no results.
> > -----------------------------------
> >
> > SQL Used:
> >
> > use tmm
> >
> >
> > But, when I 'test' any more complex command
> > ('show tables', or 'select * from city'  --
> > all without the surrounding quotes ' ), Zope crashes.
> >
> > Specifically, I get a Window's message:
> >
> > 'Python: This program has performed an
> > illegal operation and will be shut down.'
> >
> > Details:
> > PYTHON executed an invalid instruction in
> > module <unknown> at 0000:01670d74.
> > Registers:
> > EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286
> > EBX=00000001 SS=0167 ESP=01c8fa90 EBP=01670d70
> > ECX=1e10f91f DS=0167 ESI=ffffffff FS=1307
> > EDX=00000000 ES=0167 EDI=012d2a50 GS=0000
> > Bytes at CS:EIP:
> > f0 a2 2d 01 30 19 46 01 3d 43 3a 5c 02 00 00 00
> > Stack dump:
> > 00764580 1e16f958 00764580 00000000
> > 00764580 1e10f831 00b4bb40 00764580
> > 00000000 00b4bb40 00f169f4 1e10e74c
> > 00b4bb40 00764580 00000000 00b04400
> >
> >
> > I am running MySQL with the --console option,
> > which recorded:
> >
> > C:\mysql\bin\mysqld.exe: ready for connections
> > 000809 12:53:27  Aborted connection 3 to db: 'tmm'
> > user: 'root' host: `localhost' (Unknown error)
> > 000809 12:53:27  Aborted connection 2 to db: 'tmm'
> > user: 'root' host: `localhost' (Unknown error)
> >
> >
> > My 'Z MySQL Database Connection' page shows:
> >
> > The Media Machine (connected) Status
> > Id         tmm_db
> > Title      The Media Machine
> > Database Connection String     tmm root
> >
> > The database connection is open.
> >
> >
> > My environment:
> > Windows 98 4.10.98
> > MySQL Server version: 3.23.21-beta-debug
> > Zope version: Zope 2.2.0 (binary release, python 1.5.2, win32-x86)
> > Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)]
> > Computer: Acer Extensa 710TE, PentiumII, 160MB RAM
> >
> > Thanks in andvance for any thoughts.
> >
> > William BC Crandall
> > Wiesbaden,  Germany
> > wcra@beest.midat.de
> >
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )