- Zope - Zope lists

experience w/ filestorage mount points? maximum?
by Christoph Berendes 16 Nov '05

16 Nov '05

I am writing to tap the list's experience with running a single zope instance with a large number (30, 500, 2000?) of mount points. We're hosting a number of client sites, and for each client, e.g. clientX, we have a mount point: > <zodb_db clientX> > mount-point /clientX > <filestorage> > path $INSTANCE/var/clientX/Data.fs > </filestorage> > </zodb_db> Currently, we have about a dozen of these. This works well. Of course, more clients will increase server load, but so long as that is more or less linear and gradual, that's fine. Questions for the list: - What's the greatest number of mount points that folks have set up this way(50? 1000? more?) and what's been the experience, particularly with non-linear responses (e.g. "it all goes to pot after n=100")? - Are there any theoretical limits on the number of mount points? Thanks.

2 3

Re: zope 2.8.4 on windows 98
by Fernando Martins 15 Nov '05

15 Nov '05

Andreas Jung wrote: >> On Sat, 12 Nov 2005 03:52:28 -0800, Fernando Martins >> <fernando at cmartins.demon.nl> wrote: >> >>> I understand the problem, but is it the intention that zope is not >>> supported on win98? >> >> Yes, I believe this is intentional. Windows 98 is a seven year old OS >> with insufficient infrastructure to reliably run server tasks anyway. At >> least get Windows 2000, which has a decent kernel. >> > > However that does not mean that Zope won't run on Windows 98. For a recent > project where we ship and install Zope on all customers desktop machines I > had to do a lot of testing especially on Windows 98. I've been using zope 2.7.4 on win 98 for some development/testing, not as a real server. But I'm confused by your statement: if zope 2.8.4 is calling an NT security function, not available in win98, then it does NOT run on win98?? DO you mean there is something wrong with my win98 setup or that zope 2.8.4 could be patched to overcome this issue? Thanks, Fernando

4 6

Setting a session's domain
by Pablo Ziliani 15 Nov '05

15 Nov '05

Hi all, I'm developing a site that has multiple subdomains (i.e.: http://atlanta.website.com, http://nyc.website.com, etc.). Can anybody point me how can I get the session to be shared across these different subdomains? Unless someone can give me an opposite advise, I think I need to specify a "domain" to the cookie which is trivial for regular cookies but I just can't find how to do it with sessions (notice that I am I'm using Zope's regular request.SESSION). Thanks in advance, Pablo

3 5

Problems using forms to upload files to Zope
by Mike Jakowlew 15 Nov '05

15 Nov '05

Here's what I'm trying to accomplish: 1. The user fills out a form page with various fields 2. The user selects a file to upload 3. when the user hits submit two things should happen: - The file selected is uploaded - all the filled out form fields are written to the database (MS SQL) This is my current problem: The writting to the database part works fine on it's own, but when combined with the file upload I get this error *Error Type: AttributeError* *Error Value: 'NoneType' object has no attribute 'headers'* My code: *********HTML FORM********** <html> <h1 tal:content="template/title">title</h1> <p>Fill out the form below to update the website with the appropriate info:</p> <form action="uploadForm.py"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="16%" height="27" align="right"><strong>Your Dept: </strong></td> <td width="84%"><input type="text" name="department"></td> </tr> <tr> <td height="27" align="right"><strong>Document Title:</strong></td> <td><input type="text" name="title"></td> </tr> <tr> <td height="30" align="right"><strong>Filename:</strong></td> <td><input type="file" name="upload_filename" ></td> </tr> <tr> <td height="28" align="right"><strong>Version of File :</strong></td> <td><input type="text" name="version"></td> </tr> <tr> <td height="28" align="right"><strong>URL:</strong></td> <td><input type="text" name="url"></td> </tr> <tr> <td height="33" align="right"><strong>Owner Approved:</strong></td> <td><input type="text" name="ownerapp"></td> </tr> <tr> <td align="right"><strong>ISO Approved:</strong></td> <td><input type="text" name="isoapp"></td> </tr> <tr> <td height="41" align="right"><strong>Comments: </strong></td> <td rowspan="2"><textarea name="comments" cols="60" rows="5"> </textarea></td> </tr> <tr> <td height="85" align="right" valign="top"> </td> </tr> <tr> <td height="29" align="right"><strong>Date</strong></td> <td><input type="text" name="date"></td> </tr> <tr> <td height="62" align="right"></td> <td><p> <input type="submit" id="submit" name="submit" /> </p> </td> </tr> </table> <p> </form> <hr> <p>Return to the <a href="NewsTable">News page</a></p> </html> ******uploadForm.py******** def writeDB(): # get sql method insert=container['insert_fileapps'] REQUEST=context.REQUEST department = REQUEST.form.get('department') title = REQUEST.form.get('title') filename = REQUEST.form.get('upload_filename') content_type=filename.headers['Content-Type'] if content_type.find('image')!=-1: context.manage_addImage(id, file, title) else: context.manage_addFile(id, file, title) return 'Finished' version = REQUEST.form.get('version') url = REQUEST.form.get('url') ownerapp = REQUEST.form.get('ownerapp') isoapp = REQUEST.form.get('isoapp') comments = REQUEST.form.get('comments') date = REQUEST.form.get('date') filename=id filename = filename.split('\\')[-1] # call it, passing arguments insert( department=department, title=title, filename=filename, version=version, url=url, ownerapp=ownerapp, isoapp=isoapp, comments=comments, date=date) # return a confirmation page page=container['thanks.html'] return page() writeDB() ************************ Any help provided would be greatly appreciated Thanks in advance, mjakowlew ************************ PS: I'm sorry if I went about posting this in the wrong spot or the wrong way, I'm new to this

4 5

still having problems
by Dennis Allison 15 Nov '05

15 Nov '05

ZEO 3.4.2 Zope 2.8.4 ZODB 3.4.2 as relesed with Zope 2.8.4B Python 2.4.2 or 2.3.5 MySQL 4.0.20 MySQL-Python 1.2.0 MYSQLDA 2.0.9 We have just moved from Zope 2.7.6 to Zope 2.8.4 motivated, in part, but the ability to avoid read conflicts under ZODB 3.4.2. We have been having a lot of problems: more conflict errors, release of unreleased locks in MySQL transactions, loss of session variables, and others. We use session variables and MySQL very heavily. All database tables are now transactional (innodb) migrated from the MyISAM tables in use earlier. The connection string, by the way, does not use either the '-' or '+' prefix but relies on a run-time test for the table to be determined to be transactional. All our Zope instances run with ZEO and use a Temporary Store instance for session variables. The ZEO configuration is: <filestorage 1> path $INSTANCE/var/Data.fs </filestorage> # temporary storage has to be ZEO side %import tempstorage <temporarystorage temp> name temporary storage for sessioning </temporarystorage> and is matched to the Zope configuration: <zodb_db main> mount-point / # ZODB cache, in number of objects cache-size 5000 <zeoclient> server 192.168.0.92:8301 storage 1 var $INSTANCE/var # ZEO client cache, in bytes cache-size 20MB # Uncomment to have a persistent disk cache client group1-zeo </zeoclient> </zodb_db> # # ZEO temporary storage # <zodb_db temporary> <zeoclient> server 192.168.0.92:8301 storage temp name zeostorage var $INSTANCE/var </zeoclient> mount-point /temp_folder container-class Products.TemporaryFolder.TemporaryContainer </zodb_db> Are these configurations correct? The snippet of log shown below show the problem that plagues us: ------ 2005-11-14T06:20:40 ERROR txn.4100 Error in tpc_abort() on manager <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x42c6a52c> at 1186514860> Traceback (most recent call last): File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 462, in _cleanup rm.tpc_abort(self) File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 548, in tpc_abort self.manager.tpc_abort(txn) File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, in abort try: self._abort() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort self._tlock.release() error: release unlocked lock ------ 2005-11-14T06:20:40 INFO ZODB conflict error at /classes/class_applications/classaccess/topic_html (658 conflicts since startup at 2005-11-11T01:26:40) ------ 2005-11-14T06:20:40 ERROR txn.4100 Failed to abort object: Surrogate oid=<object object at 0x4009d470> Traceback (most recent call last): File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort self.manager.abort(o, txn) File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, in abort try: self._abort() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort self._tlock.release() error: release unlocked lock ------ 2005-11-14T06:20:40 ERROR txn.4100 Failed to abort resource manager: <MultiObjectResourceAdapter for <Products.ZMySQLDA.db.DB instance at 0x42c6a52c> at 1186514860> Traceback (most recent call last): File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 489, in abort rm.abort(self) File "/usr/local/src/zope/Zope2.8/lib/python/transaction/_transaction.py", line 562, in abort self.manager.abort(o, txn) File "/usr/local/src/zope/Zope2.8/lib/python/Shared/DC/ZRDB/TM.py", line 64, in abort try: self._abort() File "/opt/zope/zproducts/standard/ZMySQLDA/db.py", line 389, in _abort self._tlock.release() error: release unlocked lock which is a pattern typical of the many such entries: a log entry for an abort which raises a lock error, a report of a conflict error, a report of a failure to abort a Surrogate oid, followed by a second abort of the first instance. We also see frequent KeyError failures in the session variable data structure which suggests that the copy-out/modify/copy-in mechanism used to tickle the persistence mechanism does not run to completion and so the Zope persistence fail and the session variable structure is pruned or removed at some random later time. Some diagnostics are seen which report that the REQUEST['SESSION'] is occasionally removed. Questions: ~~~~~~~~~~ What is the cause of the locking problem? Does ZMySQLDA/MySQL-Python/Zope have some path which should have called begin to get a lock and did not? What needs to be done to make session variables stable? Does the Temporary Storage method need to be extended to allow for rolling back a transaction? (What's a good approch if this is necessary? Is there any existing product supporting this?) Any other help or advice would be appreciated.

4 3

ZClass in 2.8.4 - error help
by Jake 15 Nov '05

15 Nov '05

I am trying to get an old, old product to work in 2.8.4 and I am getting the following error: Traceback (innermost last): Module ZPublisher.Publish, line 113, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 40, in call_object Module Shared.DC.Scripts.Bindings, line 311, in __call__ Module Shared.DC.Scripts.Bindings, line 348, in _bindAndExec Module App.special_dtml, line 175, in _exec Module DocumentTemplate.DT_Let, line 76, in render Module DocumentTemplate.DT_In, line 643, in renderwob Module DocumentTemplate.DT_In, line 771, in sort_sequence Module ZODB.Connection, line 704, in setstate Module ZODB.Connection, line 760, in _setstate Module ZODB.serialize, line 495, in setGhostState Module ZODB.serialize, line 488, in getState Module ZODB.serialize, line 399, in _persistent_load Module ZODB.serialize, line 372, in _get_class Module Zope2.App.ClassFactory, line 29, in ClassFactory Module OFS.Uninstalled, line 61, in Broken File "<string>", line 1 class <class 'ZDTopic_ZPropertySheetsClass'>(BrokenClass): ' '; __module__=None ^ SyntaxError: invalid syntax I know, that it has something to do with the new extension class, but I can't seem to find any documentation on the new classes, how to write them or how to convert old classes? Any pointers? Jake http://www.ZopeZone.com "Zoping for the rest of us"

2 1

Problem Inserting zsql query result
by Ivan Stout 15 Nov '05

15 Nov '05

Greetings, I would like to insert the results of a query into another table and am doing this from a python script. I am setting the results of a queryequal to a variable with the following: variable = container.zsql_method(paramater=value)[0][0] This gives the results I want (in this case "0"), but when I try to insert this variable using another zsql method, I get the following error: "MySQL server version for the right syntax to use near '0\n)'" The value I want is there, but it has a newline character also. I try removing using .replace but then I get the following error: 'long' object has no attribute 'replace' I would greatly appreciate it if someone could point me in the right direction. Than you very much, Ivan

5 9

Re: [Zope] filename splitter
by Peter Bengtsson 15 Nov '05

15 Nov '05

Please keep it on the list. > > Why don't you use a ZCTextIndex, which supports globbing? Then you will be > able to search using '*' and '?' suffixes (wildcards). > Globbing isn't good enough. If a file is called "UniRoss.log" I don't want people to be able to find it if they search for "unir" or "iro". -- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com

1 0

help with url rewriting
by Faheem Mitha 15 Nov '05

15 Nov '05

Dear People, I running Apache 2.0 and Zope 2.7 on Debian Sarge. I've configured a zope (Plone) instance located /var/lib/zope2.7/instance/dulci. This can be accessed via http://machine_address:9673/dulci. 9673 is the point on which Zope runs on Debian. I'm trying to configure Apache so that all requests of the form http://machine_address/plone are sent to https://machine_address:9673/dulci and that the urls returned by Plone are consistent. I added the following lines to my Apache config, representing my best guess as to how this should work. The rewriting seems to work, since when I go to http://machine_address/plone the log says [Wed Nov 09 03:30:26 2005] [error] [client ...] client denied by server configuration: proxy:http://127.0.0.1:9673/VirtualHostBase/https/machine_address:443/dulci/VirtualHostRoot/_vh_plone However, something must be broken. This seems to be a relatively straighforward matter, but I've already spent a substantial amount of time on it, so I'd be obliged if someone can point out if I am missing something obvious, as I probably am. Please cc me on any reply. Thanks in advance. ******************************************************************** NameVirtualHost * <VirtualHost *> [...] <IfModule mod_proxy.c> ProxyVia On </IfModule> <IfModule mod_rewrite.c> RewriteEngine On RewriteRule ^/plone(/.*)?$ http://127.0.0.1:9673/VirtualHostBase/https/%{HTTP_HOST}:443/dulci/VirtualH… [L,P] </IfModule> </VirtualHost> ******************************************************************* Faheem.

3 11

ssh tunnelling webdave
by David Bear 15 Nov '05

15 Nov '05

I am having trouble getting webdav to work through ssh tunnels. I hope someone may be able to offer a suggestion. running zope 2.7.4 on FreeBSD 4.9 python 2.4. my zope.cnf file has the following under webdav-source <webdav-source-server> # valid keys are "address" and "force-connection-close" address 8088 force-connection-close off </webdav-source-server> the server address is set as follows: ip-address 127.0.0.1 <http://127.0.0.1> To clarify things, I front this with apache and connect to it using fastcgi connecting to localhost:8089. This works fine and has been for 2 years. I only want to add webdav capability. Since I haven't seen any documentation passing webdav through apache, I thought I would have to resort to stunnel or tunneling through ssh. So, on my ssh client, I do the follwoing ssh -L 8088:localhost:8088 zopeserver.asu.edu <http://zopeserver.asu.edu> I connect and properly authenticate. However, when I attempt to load cadaver on the client, I get a connection timeout. Partial output from netstat -an indicates that all zservers are listening where they should: tcp4 0 0 127.0.0.1.8089 *.* LISTEN tcp4 0 0 127.0.0.1.8088 *.* LISTEN tcp4 0 0 127.0.0.1.8080 *.* LISTEN (this done on the zopeserver) Any advice would be greatly appreciated. -- David Bear What's the difference between private knowledge and public knowledge?

2 1