- Zope - Zope lists

GenericUserSource LoginManager with PythonScripts.
by Steve Drees 08 Mar '01

08 Mar '01

Zope 2.3.0 RHL 6.2 RPM install userExists [PythonScript] ------------ return 1 userAuthenticate [PythonScript] ------------ return 1 userRoles [PythonScript] ------------ return 'Manager' Trying to access the protected folder gives the following traceback. Any ideas? Error Type: TypeError Error Value: no arguments expected <!-- Traceback (innermost last): File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 222, in publish_module File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 187, in publish File /usr/share/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /usr/lib/python1.5/site-packages/ZPublisher/Publish.py, line 162, in publish File /usr/lib/python1.5/site-packages/ZPublisher/BaseRequest.py, line 444, in traverse File /var/zope/Products/LoginManager/LoginManager.py, line 237, in validate (Object: ProviderContainer) File /var/zope/Products/LoginManager/LoginMethods.py, line 147, in findLogin (Object: PlugInBase) File /var/zope/Products/LoginManager/LoginManager.py, line 194, in getItem (Object: ProviderContainer) File /var/zope/Products/ZPatterns/Rack.py, line 59, in getItem (Object: ProviderContainer) File /var/zope/Products/LoginManager/UserSources.py, line 510, in retrieveItem (Object: ProviderContainer) File /usr/share/zope/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: userExists) File /usr/share/zope/lib/python/Shared/DC/Scripts/Bindings.py, line 353, in _bindAndExec (Object: userExists) File /usr/share/zope/lib/python/Products/PythonScripts/PythonScript.py, line 330, in _exec (Object: userExists) (Info: ({'script': <PythonScript instance at 87ce2d0>, 'context': <GenericUserSource instance at 87fae28>, 'container': <LoginManager instance at 8753088>, 'traverse_subpath': []}, (<GenericUserSource instance at 87fae28>, <h3>form</h3><table></table><h3>cookies</h3 ><table><tr valign="top" align="left"><th>zmi_use_css</th><td>'1'</ td></tr><tr valign="top" align="left"><th>__cp</th><td>'x%da%d3%60b%60 %60%c8%04b%86hf%20%a1%01%22%8aA%dcb%16%20%91%91%98%9c%5d,%08dT%94%16%a7%169% 96%96d%a4%e6%95d%26%27%96%a4bS%c8%0dS%e8Z%91Y%5cR%8cM%09%17LIP%7eNj1%00%92%c 4%1a%7e'</td></tr><tr valign="top" align="left"><th>tree-s</th><td>'eJyLjlZ3hANP W3UdhWiEiIe7o616LBAAALzfCe4'</td></tr><tr valign="top" align="left"><th>dtpref_cols</th><td>'60'< /td></tr><tr valign="top" align="left"><th>zmi_top_frame</th><td>'1'&lt ;/td></tr><tr valign="top" align="left"><th>dtpref_rows</th><td>'20'< /td></tr></table><h3>other</h3><table><t r valign="top" align="left"><th>__cp</th><td>'x%da%d3%60b%60 %60%c8%04b%86hf%20%a1%01%22%8aA%dcb%16%20%91%91%98%9c%5d,%08dT%94%16%a7%169% 96%96d%a4%e6%95d%26%27%96%a4bS%c8%0dS%e8Z%91Y%5cR%8cM%09%17LIP%7eNj1%00%92%c 4%1a%7e'</td></tr><tr valign="top" align="left"><th>dtpref_rows</th><td>'20'< /td></tr><tr valign="top" align="left"><th>PUBLISHED</th><td>&lt;Py thon Method object at 8663ca0&gt;</td></tr><tr valign="top" align="left"><th>URL0</th><td>'http://localho st/hack/manage_workspace'</td></tr><tr valign="top" align="left"><th>BASE3</th><td>'http://localh ost/hack/manage_workspace'</td></tr><tr valign="top" align="left"><th>URL2</th><td>'http://localho st'</td></tr><tr valign="top" align="left"><th>BASE1</th><td>'http://localh ost'</td></tr><tr valign="top" align="left"><th>BASE0</th><td>'http://localh ost'</td></tr><tr valign="top" align="left"><th>zmi_use_css</th><td>'1'</ td></tr><tr valign="top" align="left"><th>URL1</th><td>'http://localho st/hack'</td></tr><tr valign="top" align="left"><th>SERVER_URL</th><td>'http://l ocalhost'</td></tr><tr valign="top" align="left"><th>zmi_top_frame</th><td>'1'&lt ;/td></tr><tr valign="top" align="left"><th>tree-s</th><td>'eJyLjlZ3hANP W3UdhWiEiIe7o616LBAAALzfCe4'</td></tr><tr valign="top" align="left"><th>URL</th><td>'http://localhos t/hack/manage_workspace'</td></tr><tr valign="top" align="left"><th>AUTHENTICATED_USER</th><td>L oggingInUser</td></tr><tr valign="top" align="left"><th>LOGIN_METHODS</th><td>[]< /td></tr><tr valign="top" align="left"><th>TraversalRequestNameStack</th>< td>[]</td></tr><tr valign="top" align="left"><th>BASE2</th><td>'http://localh ost/hack'</td></tr><tr valign="top" align="left"><th>dtpref_cols</th><td>'60'< /td></tr><tr valign="top" align="left"><th>URL0</th><td>http://localhos t/hack/manage_workspace</td></tr><tr valign="top" align="left"><th>URL1</th><td>http://localhos t/hack</td></tr><tr valign="top" align="left"><th>URL2</th><td>http://localhos t</td></tr><tr valign="top" align="left"><th>BASE0</th><td>http://localho st</td></tr><tr valign="top" align="left"><th>BASE1</th><td>http://localho st</td></tr><tr valign="top" align="left"><th>BASE2</th><td>http://localho st/hack</td></tr><tr valign="top" align="left"><th>BASE3</th><td>http://localho st/hack/manage_workspace</td></tr></table><h3>enviro n</h3><table><tr valign="top" align="left"><th>DOCUMENT_ROOT</th><td>/home/ httpd/html</td></tr><tr valign="top" align="left"><th>SERVER_ADDR</th><td>192.168. 1.136</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT_ENCODING</th><td&gt ;gzip, deflate</td></tr><tr valign="top" align="left"><th>PCGI_NAME</th><td>Zope</t d></tr><tr valign="top" align="left"><th>SERVER_PORT</th><td>80</t d></tr><tr valign="top" align="left"><th>PATH_TRANSLATED</th><td>/hom e/httpd/cgi-bin/Zope/hack/manage_workspace</td></tr><tr valign="top" align="left"><th>REMOTE_ADDR</th><td>192.168. 1.136</td></tr><tr valign="top" align="left"><th>SERVER_SOFTWARE</th><td>Apac he/1.3.14 (Unix) (Red-Hat/Linux) PHP/3.0.18</td></tr><tr valign="top" align="left"><th>REQUEST_METHOD</th><td>GET&l t;/td></tr><tr valign="top" align="left"><th>SCRIPT_NAME</th><td></td& gt;</tr><tr valign="top" align="left"><th>HTTP_REFERER</th><td>http:// localhost/manage_menu?tree-e=eJyLVneEA09bdR0FON/D3dFWPRYAf/MHxg</td>&l t;/tr><tr valign="top" align="left"><th>PCGI_EXE</th><td>/usr/bin/py thon</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT_LANGUAGE</th><td&gt ;en-us</td></tr><tr valign="top" align="left"><th>PCGI_PUBLISHER</th><td>/var/ zope/pcgi_nullpublisher.py</td></tr><tr valign="top" align="left"><th>GATEWAY_INTERFACE</th><td>CG I/1.1</td></tr><tr valign="top" align="left"><th>SERVER_NAME</th><td>gfa.grco mputing.net</td></tr><tr valign="top" align="left"><th>HTTP_CONNECTION</th><td>Keep -Alive</td></tr><tr valign="top" align="left"><th>HTTP_USER_AGENT</th><td>Mozi lla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)</td></tr><tr valign="top" align="left"><th>Z_REALM</th><td>/var/zope/Zo pe.cgi</td></tr><tr valign="top" align="left"><th>PCGI_DISPLAY_ERRORS</th><td> 1</td></tr><tr valign="top" align="left"><th>HTTP_ACCEPT</th><td>image/gi f, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, */*</td></tr><tr valign="top" align="left"><th>REQUEST_URI</th><td>/hack/ma nage_workspace</td></tr><tr valign="top" align="left"><th>PATH</th><td>/sbin:/usr/sbin :/bin:/usr/bin:/usr/X11R6/bin</td></tr><tr valign="top" align="left"><th>QUERY_STRING</th><td></td ></tr><tr valign="top" align="left"><th>SCRIPT_FILENAME</th><td>/hom e/httpd/cgi-bin/Zope</td></tr><tr valign="top" align="left"><th>HTTP_HOST</th><td>localhost& lt;/td></tr><tr valign="top" align="left"><th>SCRIPT_URL</th><td>/hack/man age_workspace</td></tr><tr valign="top" align="left"><th>Z_DEBUG_MODE</th><td>1</t d></tr><tr valign="top" align="left"><th>PCGI_PID_FILE</th><td>/var/r un/zserver.pid</td></tr><tr valign="top" align="left"><th>SERVER_SIGNATURE</th><td>&am p;lt;ADDRESS&gt;Apache/1.3.14 Server at gfa.grcomputing.net Port 80&lt;/ADDRESS&gt; </td></tr><tr valign="top" align="left"><th>SCRIPT_URI</th><td>http://gf a.grcomputing.net/hack/manage_workspace</td></tr><tr valign="top" align="left"><th>PCGI_SOCKET_FILE</th><td>/va r/run/pcgi.soc</td></tr><tr valign="top" align="left"><th>SERVER_ADMIN</th><td>root@lo calhost</td></tr><tr valign="top" align="left"><th>PCGI_MODULE_PATH</th><td>/us r/share/zope/lib/python/Zope</td></tr><tr valign="top" align="left"><th>REMOTE_PORT</th><td>3005< /td></tr><tr valign="top" align="left"><th>PATH_INFO</th><td>/hack/mana ge_workspace</td></tr><tr valign="top" align="left"><th>HTTP_COOKIE</th><td>zmi_use_ css=&quot;1&quot;; dtpref_cols=&quot;60&quot;; zmi_top_frame=&quot;1&quot;; dtpref_rows=&quot;20&quot;; tree-s=&quot;eJyLjlZ3hANPW3UdhWiEiIe7o616LBAAALzfCe4&quot;; __cp=&quot;x%da%d3%60b%60%60%c8%04b%86hf%20%a1%01%22%8aA%dcb%16%20%91%91 %98%9c%5d,%08dT%94%16%a7%169%96%96d%a4%e6%95d%26%27%96%a4bS%c8%0dS%e8Z%91Y%5 cR%8cM%09%17LIP%7eNj1%00%92%c4%1a%7e&quot;</td></tr><tr valign="top" align="left"><th>PCGI_INFO_FILE</th><td>/home /httpd/cgi-bin/Zope</td></tr><tr valign="top" align="left"><th>INSTANCE_HOME</th><td>/var/z ope</td></tr><tr valign="top" align="left"><th>PCGI_ERROR_LOG</th><td>syslo g:local0</td></tr><tr valign="top" align="left"><th>SERVER_PROTOCOL</th><td>HTTP /1.1</td></tr></table>), {'username': 'steve'}, None)) TypeError: (see above)

2 1

dummy class security problem
by magnus/Websys＠websys.no 08 Mar '01

08 Mar '01

This is from one of the dtml-tree HOWTOs on zope.org. It doesn't work with the new security mechanism. When I test it I get the traceback at the bottom of the mail. Any suggestions for making the 'name' property of _dummy 'public' to Zope? -- From the HOWTO: ExternalMethods/PythonMethods A simple example notes to self tree doesn't set sequence-item - also doesn't support 'mapping'. can't be used from pythonmethods, then.. can't create classes in PMs (?) class _dummy: def __init__(self, name): self.name=name def child_lookup(parent): c = [] for i in range(0,5): c.append(_dummy("%s.%d"%(parent, i))) return c The DTML Method <dtml-let name="0"> <dtml-tree id=name branches_expr="child_lookup(parent=name)"> <b><dtml-var name></b> </dtml-tree> </dtml-let> This, with a couple of nodes expanded, looks something like .. -- Traceback Zope Error Zope has encountered an error while publishing this resource. Unauthorized Sorry, a Zope error occurred. Traceback (innermost last): File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: test_child) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: test_child) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 189, in __call__ (Object: test_child) File /usr/local/Zope-2.3.0-linux2- x86/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: test_child) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_Let.py, line 147, in render (Object: name="0") File /usr/local/Zope-2.3.0-linux2-x86/lib/python/TreeDisplay/TreeTag.py, line 154, in render (Object: a tree tag) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/TreeDisplay/TreeTag.py, line 260, in tpRender (Object: Traversable) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/TreeDisplay/TreeTag.py, line 514, in tpRenderTABLE (Object: Traversable) (Info: (['AAAAAAAAIEk=', []], {'childless_decoration': '', 'id': 'name', 'branches_expr': <method Eval.eval of Eval instance at 8a998f8>, 'url': 'tpURL'}, [['AAAAAAAAIEk=', []]], [['AAAAAAAAIEk=', []]])) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/TreeDisplay/TreeTag.py, line 315, in tpRenderTABLE File /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/VSEval.py, line 202, in eval (Object: child_lookup(parent=name)) File /usr/local/zope/lib/python/OFS/DTMLMethod.py, line 261, in validate (Object: test_child) File /usr/local/Zope-2.3.0-linux2- x86/lib/python/AccessControl/SecurityManager.py, line 144, in validate File /usr/local/Zope-2.3.0-linux2- x86/lib/python/AccessControl/ZopeSecurityPolicy.py, line 168, in validate Unauthorized: name

3 3

RE: [Zope] What are you doing with Zope?
by Harris Peter 08 Mar '01

08 Mar '01

>Message: 14 >From: D.Turpie(a)open.ac.uk >To: zope(a)zope.org >Date: Wed, 7 Mar 2001 09:33:21 -0000 >Subject: [Zope] What are you doing with Zope? > >I would be interested to learn what applications (Intranet, web site >Management, specific projects etc.) people are developing using Zope and any >benefits/limitations you may have found using zope. > >I work with the Open University library in the UK and we are going to use >Zope to pilot a small Intranet for library staff. > >Thanks. > >David. I'm replacing a crappy Windows-based helpdesk system that has license restrictions and horrible locking problems, with a Zope/PostgreSQL one that works the way I want (nearly). (http://f2w.sourceforge.net) Benefits: authentication and access control is handled for you, content management through the web means you don't need any fancy client-side tools, and the friendly user community goes without saying. Limitations: you have to be a programmer to do anything non-trivial with it. That's maybe just my limitation though. I am a programmer, so I always try programming first and look for other ways to do things if the programming gets too hard :-) Best of luck, I can see no reason not to use Zope for what you suggest. Peter Harris **************************************************************************** This message and any files transmitted with it are confidential. The contents may not be disclosed or used by anyone other than the addressee. If you have received this communication in error, please delete the message and notify JBB (Greater Europe) Plc immediately on 0141-249-6285. The views expressed in this email are not necessarily the views of JBB (Greater Europe) PLC. As it has been transmitted over a public network, JBB (Greater Europe) PLC makes no representation nor accepts any liability for the email's accuracy or completeness unless expressly stated to the contrary. Should you, as the intended recipient, suspect that the message has been intercepted or amended, please notify JBB (Greater Europe) Plc immediately on 0141-249-6285. ****************************************************************************

1 0

best way to pass form values when doing a redirect?
by shawn grant 08 Mar '01

08 Mar '01

What is the easiest way to make sure that the form variables passed to a page are sent on to the subsequent page, as when performing a redirect?

1 0

No User Sources or Login Methods in LoginManager
by Adam Schleter 08 Mar '01

08 Mar '01

Hi all, When I attempt to add a LoginManager object it has no User Sources or Login Methods to select from. The lists are blank. Does anyone know what this means and how I can fix it? I followed what documentation I could find and checked mailing lists, but was unable to find anything about it. I have the following versions: LoginManager 0.8.6 (source) ZPatterns 0.3.0 (binary) Zope 2.3.0 (binary release, python 1.5.2, linux2-x86) Thanks. -- Adam Schleter Prestige International aschleter(a)presinter.com.au

1 0

Sessions and authentication
by Gerald Gutierrez 08 Mar '01

08 Mar '01

For the past several weeks I've been looking in detail at Zope and PHP, and trying to decide which to use for a web application (as opposed to a dynamic web site). Zope has a lot helpful infrastructure, but PHP seems more flexible. One of the scenarios I've been thinking about is the authentication/authorization mechanism. It's clear to me how to do this with PHP and J2EE; I was hoping that someone can explain to me how to do this with Zope. - The app would use URL rewriting for session management. - When a user accesses the site, he has a session but is not logged in - He can log in through a form - Some pages can be accessed whether the user is logged in or not, other pages must have the user logged in - If the user tries to view a page where he must be logged in, the server forwards automatically to a login form, and goes to that page when he successfully logs in - User information is maintained in a database. Rules for matching of usernames and passwords is as yet undetermined (e.g. strings are stripped, compared case insensitively, possibly multiple passwords for a username, with each password authenticating the user into a different role) - Once the user is logged in, he is given a cookie with a random string as the value. That string also goes into the database - If a user accesses the site, is not logged in, and as the above described cookie, the server looks up that cookie and auto-logs the user in if possible (so he is then logged in without having to type in his username and/or password) - If the user logs out, he cookie is cleared, the random string is invalidated in the databse and the user is not auto-logged in at the next visit. So essentially, I need URL rewriting for session management, and a form based login, with a flexible set of rules for the actual authentication process. I need cookies to be used as an optional feature which can auto-log in a user. If the user uses cookies, he can be auto-logged in. If not, he can't and must do it manually each time he visits. I had tried some of this myself, but with little success. Core Session Tracking is well documented, but LoginManager was much more complicated than I had thought, using many jargons that were hard to understand. In the end, I couldn't get much of it working. If someone tell me whether this is all doable with current packages, and a brief explanation of how, I would appreciate it very, very much. Thanks. Gerald.

5 8

They mysteries of logging in zope.
by John Morton 08 Mar '01

08 Mar '01

In the process of building a new login method for the Login Manager product, I thought it would be a good idea to have the beast log various indications of state out to syslog for later examination. ZLogger's interface is nice and easy and it looked like all I had to do to get logging to go to syslog was to set an environment variable. Unfortunately it just doesn't work that easily. Setting ZSYSLOG to log via /dev/log causes zope to crash straight away, setting ZSYSLOG_SERVER causes it to crash after between 10 seconds and a minute, and setting STUPID_FILE_LOGGER does nothing at all. Wading into the code I discovered a few things, and made some other observations: 1. There are no less than three separate logging systems used in Zope - logging via ZServer, logging via ZLogger and some form of debug logging via DebugLogger. They all seem to have different APIs. 2. ZServer and ZLogger both use a copy each of Sam Rushing's syslog module, but while ZLogger calls it properly, ZServer simply isn't. It doesn't appear to pass it a port at all. 3. Further up the line, the code that creates the logging object seems to pass ZSYSLOG straight through as a server address. I expect that a pair of patches to ZServer and z2.py will be able to fix the problem, but I'm interested if anyone has found any other solutions. John

1 1

LoginManager, SQL, and PythonScripts - Can't we all just get along?
by Steve Drees 08 Mar '01

08 Mar '01

Has anybody successfully deployed a GenericUserSource LoginManager that stores user info in an SQL database using PythonScripts for userAuthenticate, userExists, and userRoles?

1 0

RE: ZODBC problem (and ZmxODBC)
by Bryan Baszczewski 08 Mar '01

08 Mar '01

Alan, Yes, I moved the mx folder and I got it to work today too and will put it through some excrutiatingly painful tests tomorrow. But so far, so good. ...I'll let you know how it goes. Keep me posted on your success. -----Original Message----- From: Capesius, Alan [mailto:CapesiusA@Sysmex.com] Sent: Wednesday, March 07, 2001 6:49 PM To: bryanbz(a)2s2i.com Cc: zope(a)zope.org Subject: RE: ZODBC problem (and ZmxODBC) Excellent. The ZmxODBC driver has resolved the problem for me. Performance is now unaffected by the slow queries. I'm using Access and SQL7 dbs, not sure if Access ODBC is multi-threaded, so I may need to run a mix of drivers, but the test server hasn't crashed yet. A note on the ZmxODBC install, the docs indicate that you should copy the mx folder to the Shared folder. This will not work (and is the default). The coding requires that you move the mx folder up one level after extraction it into the Zope tree. It should be at ZopePath\lib\python\mx Thanks Bryan, Alan >>>-----Original Message----- >>>From: Bryan Baszczewski [mailto:bryanbz@2s2i.com] >>>Sent: Wednesday, March 07, 2001 1:08 PM >>>To: 'Capesius, Alan'; zope(a)zope.org >>>Cc: zope-dev(a)zope.org >>>Subject: RE: [Zope-dev] RE: ZODBC problem >>> >>> >>>Alan, I am having a similar lock-out problem while >>>performing a complex >>>query on SQL Server 2K. All other hits cannot connect until >>>the query >>>returns the results. My research has so far taken me here: >>> >>>http://www.zope.org/Members/petrilli/DARoadmap >>>Which is telling me I am probably using at most a Level-2 DA >>>with my ZODBC. >>> >>>And then here: >>> >>>http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README >>>Which is a Level-3 mxZODBC DA (multithreaded). >>> >>>If anyone sees a problem with what I am about to do, let me >>>know. What do >>>you think? >>> >>> >>> >>>-----Original Message----- >>>From: zope-dev-admin(a)zope.org >>>[mailto:zope-dev-admin@zope.org]On Behalf >>>Of Capesius, Alan >>>Sent: Wednesday, March 07, 2001 12:31 PM >>>To: zope(a)zope.org >>>Cc: zope-dev(a)zope.org >>>Subject: [Zope-dev] RE: ZODBC problem >>> >>> >>>Thanks Dieter, I was kinda looking for a solution, I >>>reviewed the mailing >>>lists but do not see any solutions. I've done some more testing here: >>> >>>Summary: The user selects an involved financial report. The >>>report takes >>>about 55 seconds for Zope to prepare. The first second is >>>the SQL server >>>request and reply. The remaining time is Zope processing >>>(dual 200mhz NT >>>box). >>> >>>My queries are SELECT JOINS. No tables are modified at the server. >>> >>>The problem I see here is that Zope/ZODBCDA is holding the >>>connection to SQL >>>open via ODBC until all processing is complete and then >>>issuing an SQL >>>statement: IF @@TRANCOUNT>0 COMMIT TRAN >>> >>>Zope could free up this connection after one second. (at >>>least in this case) >>>Until Zope does the commit, other users are locked out. >>> >>>For read only queries, there is no need to have the request under >>>transaction control. In any case, Zope should be able to >>>early release the >>>SQL connection and then process on the results. >>> >>>Certainly increasing processor speed will mask this problem >>>and provide >>>better response to users, but I'm hoping for a real fix. >>> >>>Thanks, >>>Alan >>> >>>Network Monitor trace Wed 03/07/01 10:51:50 c:\cap1.TXT >>> >>>Frame Time Src MAC Addr Dst MAC Addr Protocol >>>1 4.413 006008F6062B COMPAQ851F04 TCP >>>2 4.413 006008F6062B COMPAQ851F04 TCP >>>3 4.413 006008F6062B COMPAQ851F04 TCP >>>[....] >>>193 5.072 006008F6062B COMPAQ851F04 TCP >>>194 5.073 COMPAQ851F04 006008F6062B TCP >>>195 5.090 COMPAQ851F04 006008F6062B TCP >>>196 5.090 006008F6062B COMPAQ851F04 TCP >>>197 5.090 006008F6062B COMPAQ851F04 TCP >>>198 5.091 COMPAQ851F04 006008F6062B TCP >>>199 5.109 COMPAQ851F04 006008F6062B TCP >>>200 5.127 COMPAQ851F04 006008F6062B TCP // SQL >>>server goes idle >>>after this >>> >>>// python DTML processing occurs here >>> >>> >>>201 10.834 006008F6062B COMPAQ851F04 TCP // not >>>sure what this is, >>>Data is 0xA8 >>>202 10.834 COMPAQ851F04 006008F6062B TCP // reply, >>>data is empty >>> >>>// page returns to user at 60 second mark >>>// then Zope closes the connection >>>203 60.385 COMPAQ851F04 006008F6062B TCP >>> SQL: IF @@TRANCOUNT>0 COMMIT TRAN >>>204 60.386 006008F6062B COMPAQ851F04 TCP >>>205 60.601 COMPAQ851F04 006008F6062B TCP >>> >>> >>>>Capesius, Alan writes: >>>> > ... >>>> > with further testing I >>>> > have determined that the Zope server itself is not >>>locking up, but >>>rather >>>> > requests to the database (MS SQL7 via ZODBCDA) seem to >>>be queueing up. >>> >>>>My memory tells me faintly that such an issue has already been >>>>discussed in the mailing lists (zope, zope-dev). >>>>When I remember right, ZODBCDA synchronizes all database requests >>>>--> searchable list archives... >>> >>> >>>>Dieter >>> >>>_______________________________________________ >>>Zope-Dev maillist - Zope-Dev(a)zope.org >>>http://lists.zope.org/mailman/listinfo/zope-dev >>>** No cross posts or HTML encoding! ** >>>(Related lists - >>> http://lists.zope.org/mailman/listinfo/zope-announce >>> http://lists.zope.org/mailman/listinfo/zope ) >>>

1 0

Re: [Zope] Make a Zope object single threaded
by Dieter Maurer 08 Mar '01

08 Mar '01

Tim Lakey writes: > Does anyone know how to force a Zope product to be single threaded within > Zope? I cannot tell you, how you can make a single product single threaded, but URL:http://www.dieter.handshake.de/pyprojects/zope/SharedResource.html will show you, how you can synchronize access to a resource using locks. Dieter

2 1