This message was created automatically by mail delivery software. A message that you sent could not be delivered to all of its recipients. The following address(es) failed: joe.nicholls@zope.co.uk: SMTP error from remote mailer after RCPT TO: <joe.nicholls@zope.co.uk>: host mail.zope.co.uk [212.67.208.19]: 550 5.7.1 <joe.nicholls@zope.co.uk>... Relaying denied ------ This is a copy of the message, including all the headers. ------ Return-path: <zope@zope.org> Received: from uwcmcm1m.uwcm.ac.uk ([193.63.112.49]) by crane2.cf.ac.uk with esmtp (Exim 3.03 #1) id 15EYor-0001LN-00 for joe.nicholls@zope.co.uk; Mon, 25 Jun 2001 17:02:33 +0100 Received: from UWCMCM1M/SpoolDir by UWCMCM1M.UWCM.AC.UK (Mercury 1.48); 25 Jun 01 17:02:47 GMT0BST Received: from SpoolDir by UWCMCM1M (Mercury 1.48); 25 Jun 01 17:02:26 GMT0BST Received: from UWCMCM1M/SpoolDir by UWCMCM1M.UWCM.AC.UK (Mercury 1.48) for <Wmljan.STF.MEDIA.DACS.CM@UWCMCM1M.UWCM.AC.UK>; 25 Jun 01 17:02:26 GMT0BST Resent-from: Wmljan.STF.MEDIA.DACS.CM@UWCMCM1M.UWCM.AC.UK Resent-to: joe.nicholls@zope.co.uk Resent-Date: Mon, 25 Jun 2001 17:02:26 GMT0BST X-Autoforward: 1 Received: from pigeon.cf.ac.uk (131.251.0.2) by UWCMCM1M.UWCM.AC.UK (Mercury 1.48) with ESMTP; 25 Jun 01 17:02:22 GMT0BST Received: from mail.python.org ([63.102.49.29]) by pigeon.cf.ac.uk with esmtp (Exim 3.22 #1) id 15EYoS-00019C-00 for nichollsja@cf.ac.uk; Mon, 25 Jun 2001 17:02:08 +0100 Received: from localhost.localdomain ([127.0.0.1] helo=mail.python.org) by mail.python.org with esmtp (Exim 3.21 #1) id 15EYnl-0008Cs-00; Mon, 25 Jun 2001 12:01:25 -0400 From: zope-request@zope.org Subject: Zope digest, Vol 1 #1487 - 8 msgs Reply-to: zope@zope.org X-Mailer: Mailman v2.0.5 (101270) MIME-version: 1.0 Content-type: text/plain To: zope@zope.org Sender: zope-admin@zope.org Errors-To: zope-admin@zope.org X-BeenThere: zope@zope.org X-Mailman-Version: 2.0.5 (101270) Precedence: bulk List-Help: <mailto:zope-request@zope.org?subject=help> List-Post: <mailto:zope@zope.org> List-Subscribe: <http://lists.zope.org/mailman/listinfo/zope>, <mailto:zope-request@zope.org?subject=subscribe> List-Id: Users of the Z Object Publishing Environment <zope.zope.org> List-Unsubscribe: <http://lists.zope.org/mailman/listinfo/zope>, <mailto:zope-request@zope.org?subject=unsubscribe> List-Archive: <http://lists.zope.org/pipermail/zope/> Message-Id: <E15EYnl-0008Cs-00@mail.python.org> Date: Mon, 25 Jun 2001 12:01:25 -0400 Resent-Message-Id: <E15EYor-0001LN-00@crane2.cf.ac.uk> Send Zope mailing list submissions to zope@zope.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.zope.org/mailman/listinfo/zope or, via email, send a message with subject or body 'help' to zope-request@zope.org You can reach the person managing the list at zope-admin@zope.org When replying, please edit your Subject line so it is more specific than "Re: Contents of Zope digest..." Today's Topics: 1. Re: A tale of two systems.... (Thomas B. Passin) 2. select_question (Kathrin Deubrecht) 3. Twin Cities (MN, USA) Zope User Group (Michael Fraase) 4. Re: [Zope-dev] Zcatalog bloat problem (berkeleydb is a solution?) (abel deuring) 5. Re: 2.4 beta1 on win2k doesnt run?? (Andy McKay) 6. Re: Restrict object list in folderish product, it works, but how? (Joachim Werner) 7. Re: A tale of two systems.... (Chris Beaumont) 8. File locking. (=?iso-8859-1?q?J=F8rgen=20Hermanrud=20Fjeld?=) --__--__-- Message: 1 From: "Thomas B. Passin" <tpassin@mitretek.org> To: <zope@zope.org> Subject: Re: [Zope] A tale of two systems.... Date: Mon, 25 Jun 2001 11:05:53 -0400 [Michael Sullivan]

Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?

Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set. I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well. Cheers, Tom P --__--__-- Message: 2 Date: Mon, 25 Jun 2001 17:12:05 +0200 (MET DST) From: Kathrin Deubrecht <kathrin@iei.tu-clausthal.de> Reply-To: Kathrin Deubrecht <kathrin@iei.tu-clausthal.de> To: zope@zope.org Subject: [Zope] select_question Hello , I have a folder 'project' with some subfolders (the projects). The subfolders have different properties. Now I created a form in which I can include new properties for a new subfolder. A DTML-method called 'project_prozessor' adds this new subfolder with its new properties to folder 'project'. Now my problem : I want to create a selection list with all my subfolders from folder 'project' and when I click on a subfolder, the properties which belong to my selected folder should be in the parts of the form , now. How can I generate my side with the form new? I don't know how can I realize it? I only want to do this with DTML-Syntax not with properties.sheets or so. I would be very happy about your answer. best regards kathrin --__--__-- Message: 3 Reply-To: <mfraase@farces.com> From: "Michael Fraase" <mfraase@farces.com> To: <zope@zope.org> Date: Mon, 25 Jun 2001 10:17:01 -0500 Organization: ARTS & FARCES LLC Subject: [Zope] Twin Cities (MN, USA) Zope User Group Any interest in forming a Twin Cities (Minneapolis, Saint Paul) Zope User Group? If so, please contact me directly. Thanks kindly. -- Michael Fraase ARTS & FARCES LLC mfraase@farces.com www.farces.com PGP Fingerprint: 3D85 F3F4 9E65 4949 176A 260C CB47 190D C864 9A96 --__--__-- Message: 4 Date: Mon, 25 Jun 2001 17:49:02 +0200 From: abel deuring <adeuring@gmx.net> Reply-To: a.deuring@satzbau-gmbh.de To: Giovanni Maruzzelli <maruzz@open4.it> CC: zope@zope.org, zope-dev@zope.org, erik@thingamy.net, barry@digicool.com, chrism@digicool.com Subject: [Zope] Re: [Zope-dev] Zcatalog bloat problem (berkeleydb is a solution?) Giovanni Maruzzelli wrote:

=

Hello Zopistas, =

we are developing a Zope 2.3.3 (py 1.5.2) application that will add, in= dex and reindex some tens of thousands objects (Zclass that are DTMLDocument on steroids) on some twenty prope= rties each day, while the absolute number of objects cataloged keeps growing (think at conten= t management for a big portal, where each day lots of content are added and modified and all t= he old content remains as a searchable archive and as material to recycle in the future). =

This seems for some aspects a task similar to what Erik Enge impacted c= ouple a weeks ago. =

We first derived from CatalogAware, then switched to manage ourselves t= he cataloging - uncataloging - recataloging. =

The ZODB still bloat at a too much fast pace. =

***Maybe there's something obvious we missed***, but when you have some=

4thousands object in the catalog, if you add and catalog one more objec= t the ZODB grows circa a couple of megabyte (while the object is some 1 k= of text, and some twelve boolean and datetime and strings properties). If = we pack the ZODB, Data.fs returns to an almost normal size (so the bloat a= re made by the transactions as tranalyzer.py confirms). =

Any hints on how to manage something like? We use both textindexes, fieldindexes, and keywordsindexes (textindex o= n string properties, fieldindexes on boolean and datetime, keywordindex o= n strings). Maybe one kind of indexes is to be avoided? =

Erik, any toughts? =

We are almost decided to switch to berkeleydb storage (the Minimal one)= to get rid of the bloating, we are testing with it, but it seems to be discontinued because of a lack of requests. =

Any light on it? Is it production grade?

Giovanni, I experienced similar problems trying to catalog =B7~200000 objects with ~500 MB text. Using CatalogAware objects will indeed lead to a "really fat" data base, and using the "find objects" for a ZCatalog requires considerable resources. A text index (more precise: the class UnTextIndex) works, as far as I understood it, this way: 1. The method UnTextIndex.index_object splits the text into single words, using the method [Globbing]Lexicon.Splitter. = 2. UnTextIndex.index_object looks up the wordID (an integer) of each word in the lexicon. If a word is not yet listed in the lexicon, it is added to the lexicon. = 3. All wordIDs are inserted into self._index, which maps wordIDs to the list of documents containing this word. 4. The "unindex" BTree , which maps the documentIds to the the list of all words appearing in an document is updated. If you are adding only one CatalogAware object during a transaction, this is quite expensive: Even if the indexed object contains only one new word, the entire lexicon needs to be updated. In my tests with the 200000 objects (containing ordinary German texts) the lexicon contained ~ 1 million words. (BTW, I had not had a very close look into the contents of the lexicon, so I don't know yet exactly, why it is so large. But I noticed quite many entries like "38-j=E4hrige", "42-j=E4hrig= e" ("NN-year-old") entries. So a configurable splitter method might help quite much to reduce the size of the lexicon.) Hence, the above mentioned step 2 alone can result in a really bloated data base. A solution might be a kind of "lazy catalog awareness": Instead of mangling a new object through one or more catalogs when it is created, this object could be added to a list of objects to be cataloged later. This way, the transaction to insert a new object would become much "cheaper". I'm working on this, but right now it is quite messy. (I'm new to Python and Zope, and hence I'm stumbling over a few, hmmm, trip-wires...) But even using such a "lazy catalog awareness", you might get into trouble. Using the ZCatalog's "find objects" function, I hit the limits of my Linux box: 640 MB RAM were not enough... As I see it, the main problem is that UnTextIndex.index_object tries to do all work at once: Updating the lexicon _and_ self._index _and_ self._unindex So I tried to separate these tasks by writing the data to be stored in self._index (wordId, documentId, score) into a pipe. This pipe is connected to sort(1). After all objects have been "scanned", the pipe is closed, the sorted results are read back and self._index is updated. This way, Zope needed "only", uuhh, somewhat aroud 200 or 300 MB RAM. A few weeks ago, I've posted this (admittedly not fully cooked) patch to this list, but did not get yet any response. Abel --__--__-- Message: 5 From: "Andy McKay" <andym@ActiveState.com> To: "bdorn@vup.at" <bdorn@mopa.at>, "Phil Harris" <phil.harris@zope.co.uk>, <zope@zope.org> Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run?? Date: Sat, 25 Aug 2001 08:36:51 -0700 Works fine for me too. We do get an intermittent problem with Zope 2.3.x not starting on windows though, sometimes after retrying it a few times, it works fine. Still havent had the time to investigate it much though... -- Andy McKay ----- Original Message ----- From: "bdorn@vup.at" <bdorn@mopa.at> To: "Phil Harris" <phil.harris@zope.co.uk>; <zope@zope.org> Sent: Monday, June 25, 2001 3:12 AM Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run??

it's already running form cmd debugging is enabled (-D) it's running at 8080 i haven't changed the bat so its default port is used - i think

the win2k box is my development box and i run four different zopes (not at the same time) but they all work - only this new release doesn't

it seems that it really doesn't do anything, because there is completely no output

????

thx bernd

----- Original Message ----- From: "Phil Harris" <phil.harris@zope.co.uk> To: "bdorn@vup.at" <bdorn@mopa.at>; <zope@zope.org> Sent: Monday, June 25, 2001 12:06 PM Subject: Re: [Zope] 2.4 beta1 on win2k doesnt run??

...

Works fine for me on w2k advanced server sp2.

Have you checked the port it's running on? Have you got anything else on that port?

Try running the start.bat file from a command prompt, in debug mode you should get some error message.

hth

Phil ----- Original Message ----- From: bdorn@vup.at To: zope@zope.org Sent: Monday, June 25, 2001 10:57 AM Subject: [Zope] 2.4 beta1 on win2k doesnt run??

does anybody know this problem ...

I installed Zope 2.4 b1 this morning on a win2k server

its running manually ( it should) - not as a service

but when I start z2.py it exits without any message immediately

thanks in advance, bernd

_______________________________________________ Zope maillist - Zope@zope.org 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 )

--__--__-- Message: 6 From: "Joachim Werner" <joe@iuveno-net.de> To: =?iso-8859-1?Q?Max_M=F8ller_Rasmussen?= <maxm@normik.dk>, "'Rene Pijlman'" <rpijlman@wanadoo.nl>, <zope@zope.org> Subject: Re: [Zope] Restrict object list in folderish product, it works, but how? Date: Mon, 25 Jun 2001 17:57:10 +0200 Organization: iuveno AG Stephan Richter's "OrderedFolder" (http://www.zope.org/Members/srichter/Products/OrderedFolder) has two new features now: - There is a "Subobjects" tab like in ZClasses (That's what you seem to be looking for) - You can switch on/off "Transparency" if you have installed Shane's TransparentFolder So the name of the thing should probably be "ConfigurableFolder" or so. If you think this thing could make your life easier, we can publish the new version as a standalone product. It was meant to be published with the next version of Kontentor. Just tell us what you think ... Joachim --__--__-- Message: 7 Date: Mon, 25 Jun 2001 08:54:02 -0700 To: "Thomas B. Passin" <tpassin@mitretek.org> From: Chris Beaumont <cbeaumon@msri.org> Subject: Re: [Zope] A tale of two systems.... Cc: zope@zope.org But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms.. Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux? Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible? -Chris

[Michael Sullivan]

...

Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?

Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set.

I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well.

Cheers,

Tom P

--__--__-- Message: 8 From: =?iso-8859-1?q?J=F8rgen=20Hermanrud=20Fjeld?= <jhf@hex.no> Organization: Fjeld Kurs og Konsulenttjenester To: zope@zope.org Date: Mon, 25 Jun 2001 17:57:15 +0200 Subject: [Zope] File locking. Hi. Is there a way to support file locking? It seems it is supported through WebDAV, although I haven't tried. But how doe's one do this with the management interface? The goal is to prevent several people from changing the same document at = the=20 same time. --=20 MVH J=F8rgen H. Fjeld --__--__-- _______________________________________________ Zope maillist - Zope@zope.org End of Zope Digest