[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