[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 at :01670d74. Registers: EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286 EBX=0001 SS=0167 ESP=01c8fa90 EBP=01670d70 ECX=1e10f91f DS=0167 ESI= FS=1307 EDX= ES=0167 EDI=012d2a50 GS= 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 00764580 1e10f831 00b4bb40 00764580 00b4bb40 00f169f4 1e10e74c 00b4bb40 00764580 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 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] ZMySQLDA on Win32 - connect then crash
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: /lib/python/Products/ZMySQLDA Thanks again, William BC Crandall Wiesbaden, Germany [EMAIL PROTECTED] > > ----- Original Message - > From: "William BC Crandall" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > 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 at :01670d74. > > Registers: > > EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286 > > EBX=0001 SS=0167 ESP=01c8fa90 EBP=01670d70 > > ECX=1e10f91f DS=0167 ESI= FS=1307 > > EDX= ES=0167 EDI=012d2a50 GS= > > 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 > > 00764580 1e10f831 00b4bb40 00764580 > > 00b4bb40 00f169f4 1e10e74c > > 00b4bb40 00764580 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 > > [EMAIL PROTECTED] > > > > > > ___ > > Zope maillist - [EMAIL PROTECTED] > > 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Zope & MySQL on Win98
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: /lib/Products/ZMySQLDA/) MySQL.pyd 'MySQLmodule-1.4: A Python interface to the MySQL database.' (this from MySQL.__doc__) (in: /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\\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 CommandArgument 000810 13:56:23 1 Connectroot@localhost on 1 Init DBtmm 000810 13:56:35 2 Connectroot@localhost on 2 Init DBtmm 1 Quit Many thanks for any suggestions. William BC Crandall Wiesbaden, Germany [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Simple DTML date-stamp
Just starting to set things up, and I would like a standard_html_footer with a date-stamp. As a start, I tried: Last modified: Why does this break? Minimal format breaks in the same way: Last modified: In either case, View generates: Zope Error Zope has encountered an error while publishing this resource. KeyError Sorry, a Zope error occurred. Traceback (innermost last): File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\TotipotentZope\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\TotipotentZope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: standard_html_footer) File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: standard_html_footer) File C:\Program Files\TotipotentZope\lib\python\OFS\DTMLMethod.py, line 167, in __call__ (Object: standard_html_footer) File C:\Program Files\TotipotentZope\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: standard_html_footer) File C:\Program Files\TotipotentZope\lib\python\DocumentTemplate\DT_Var.py, line 276, in render (Object: date) KeyError: date ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Why is 'Shutdown' an Error?
Another start-up question. Why does the Control Panel "Shutdown" button generate an Error: Zope Error Zope has encountered an error while publishing this resource. exceptions.SystemExit Zope has exited normally. Traceback (innermost last): File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\TotipotentZope\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_shutdown) File C:\Program Files\TotipotentZope\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_shutdown) File C:\Program Files\TotipotentZope\lib\python\App\ApplicationManager.py, line 383, in manage_shutdown (Object: ElementWithAttributes) SystemExit: 0 ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Start-up log? was[ZMySQLDA on Win32]
Phil, Thanks for the send and resend. The pack you sent is version: 'ZMySQLDA-1-1-3'. I was getting SOME success with 1.1.4 (MySQL log files would show activity). When I replace the set I had with what you sent, I do not even find 'Z MySQL Database Connection' as an object to create in the Zope manage pages. There are also error messages which scroll of the Zope console start-up window (cannot find a .dll...). Which brings me to my current most pressing question: Is there a log file that records Zope's start-up news? (I've looked at /var/Z2.log, but it doesn't show the start-up tales.) Thanks again for helping the new guy. Regards, Phil Harris wrote: > > William, > > I sent this to you a few days ago, but it bounced back. > > Phil > > - Original Message ----- > From: "Phil Harris" <[EMAIL PROTECTED]> > To: "William BC Crandall" <[EMAIL PROTECTED]> > Sent: Wednesday, August 09, 2000 3:39 PM > Subject: Re: [Zope] ZMySQLDA on Win32 - connect then crash > > > William, > > > > attached, my latest version of the mysql adapter (not written by me, just > > compiled by me). ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Start-up log?
G'morning all. Simple question: Does Zope generate a log file noting each transaction, including start-up complaints? (I get error messages that scroll out of sight when I run START.BAT.) Thanks! ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Simple DTML date-stamp
Holger, Peter, and Luis, Thanks for your emails. This: gave me what I was looking for. "http://www.zope.org/Members/AlexR/CustomDateFormats" Was also a good pointer. For those into historical trivia, what or who is "bobo"? Regards, ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] ZMySQLDA on Win32
[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 /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 CommandArgument > 000814 12:18:13 1 Connectroot@localhost on > 1 Init DBtmm > 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 Connectroot@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 CommandArgument > 000814 12:26:14 1 Connectwcra@localhost as anonymous on > 1 Query show databases > 1 Query show tables > 000814 12:26:31 1 Init DBtmm > 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 Connectroot@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.pydType: unspecified type (application/octet-stream) > Encoding: base64 > > Name: MySQL02.pyd >MySQL02.pydType: unspecified type (application/octet-stream) > Encoding: base64 > > Name: MySQL01.pyd >MySQL01.pydType: unspecified type (application/octet-stream) > Encoding: base64 -- William BC Crandall Wiesbaden . Germany [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Zope culture (Was: [Zope] Simple DTML date-stamp)
Hello Chris, Thanks for the historical pointer. Also explains why 'Add Z Gadfly Database Connection' pops up a strange sounding comment for new Zopers: Additional data sources may be created by making additional directories in the var/gadfly subdirectory of your Principia installation. ^ Another question of 'Zope Culture': Is the anti Win98 feeling I get an accurate assessment of the Zopista community? I've been having more than a little difficulty installing MySQL-Zope tools on Win98 ('ZMySQLDA on Win32'). Only one person (Phil Harris) has been willing to answer questions. But the mailing list, by volume and quality, gives clear evidence of an active and intelligent Zope community. Andy Dustman's documentation for what seems like a nice MySQL interface puts it clearly: Windows is not a supported platform. I currently function in two worlds, Win98 and Linux. Would I be right to say that 90% of Zopers live in world number two? Regards, ___ Zope maillist - [EMAIL PROTECTED] 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 )