[Zope] ZMySQLDA on Win32

[William BC Crandall]

[Re-sending w/o attachments -- too big for mail servers.]

William BC Crandall wrote:
> 
> Chasing down MySQL question, I get here:
> 
> (Besides having a strong urge to return to Linux ;)
> 
> I now have three MySQL.pyd modules (attached for your
> inspection -- labeled 01,02,03). The oldest file (01) 'works',
> in that it imports into PythonWin (once the name is changed
> back to MySQL.pyd), and read its __doc__ files, etc.
> The other two break on import:
> 
>         ImportError: DLL load failed: One of the library files
>         needed to run this application cannot be found."
> 
> The one remaining MySQL.pyd module 'works': PythonWin loads it
> __doc__: 'MySQLmodule-1.4: A Python interface to the MySQL database.'
> And with it in <zope>/bin/lib, "Z MySQL Database Connection"s
> are available in Zope/manage.
> 
> But, trying to 'test' a connection, with anything stronger than
> 'use tmm' crashes Zope:
> 
>         PYTHON caused an invalid page fault in
>         module MYSQL.PYD at 015f:012d3827.
> 
> MySQL (3.23.21-beta), for it's part, hears Zope calling, and
> try's to respond (the two tests in Zope were 'use tmm'
> and 'select * from country'):
> 
>         C:\mysql\bin\mysqld.exe, Version: 3.23.21-beta-debug-log, started with:
>         Tcp port: 3306  Unix socket: MySQL
>         Time                 Id Command    Argument
>         000814 12:18:13       1 Connect    root@localhost on
>                               1 Init DB    tmm
>         000814 12:18:44       1 Query      use tmm
>         000814 12:19:02       1 Query      select * from country
> 
> Then it waits politely to be shut down:
> 
>         000814 12:21:42       2 Connect    root@localhost on
>                               2 Shutdown
> 
> Is there a problem with MySQL.pyd, or perhaps something with my
> login procedure?
> 
> Zope has difficulty 'Computing default hostname' at start-up,
> and ends up using 'lap_will'.
> 
> Or am I formatting test queries in Zope incorrectly?
> When I run the same queries ('use tmm'; 'select * from country')
> in the mysqlc monitor, the log shows the transactions thus:
> 
>         C:\mysql\bin\mysqld.exe, Version: 3.23.21-beta-debug-log, started with:
>         Tcp port: 3306  Unix socket: MySQL
>         Time                 Id Command    Argument
>         000814 12:26:14       1 Connect    wcra@localhost as anonymous on
>                               1 Query      show databases
>                               1 Query      show tables
>         000814 12:26:31       1 Init DB    tmm
>                               1 Query      show databases
>                               1 Query      show tables
>                               1 Field List city
>                               1 Field List country
>                               1 Field List newspaper
>         000814 12:26:42       1 Query      select * from country
>         000814 12:26:47       1 Quit
>         000814 12:26:50       2 Connect    root@localhost on
>                               2 Shutdown
> 
> Thanks to any and all for suggestions.
> 
> [Phil, I tried your pointer to http://www.dustman.com, but cannot
> his server seems dead or gone.]
> 
>   ------------------------------------------------------------------------
>                   Name: MySQL03.pyd
>    MySQL03.pyd    Type: unspecified type (application/octet-stream)
>               Encoding: base64
> 
>                   Name: MySQL02.pyd
>    MySQL02.pyd    Type: unspecified type (application/octet-stream)
>               Encoding: base64
> 
>                   Name: MySQL01.pyd
>    MySQL01.pyd    Type: unspecified type (application/octet-stream)
>               Encoding: base64

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