November 2002 - Zope

RE: [Zope] Zope intranets: hardware requirements
by sean.upton＠uniontrib.com 05 Nov '02

05 Nov '02

The question that Squid answers, perhaps? Sean -----Original Message----- From: Jo Meder [mailto:jo@meder.de] Sent: Tuesday, November 05, 2002 12:27 PM To: christof.robert Cc: zope(a)zope.org Subject: Re: [Zope] Zope intranets: hardware requirements Am 05.11.2002, 09:55 Uhr schreb christof.robert <christof.robert(a)wanadoo.fr>: > 2.700.000 hits by day, month ??? Ah, sorry, you're right. This small AMD-800MHz machine serves 2.700.000 hits per month of Zopish content and some more of misc static/CGI-stuff. 2.7 million a day would be a major breakthrough in Zoptimization I suppose. Jo. -- Internetmanufaktur Jo Meder ---------------------- Berlin, Germany http://www.meder.de/ ------------------- fon: ++49-30-417 17 63 33 Kollwitzstr. 75 ------------------------ fax: ++49-30-417 17 63 45 10435 Berlin --------------------------- mob: ++49-170- 2 98 89 97 Public GnuPG-Key ---------- http://www.meder.de/keys/jo-pubkey.txt _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Phantom object?
by Charlie Reiman 05 Nov '02

05 Nov '02

I've got some dtml that I wrote not more than a few weeks ago and it has this expression: <dtml-in r_specs prefix="tbl"> Everything works great, except r_specs appears to be missing. It's working and doing it's job (mapping multiple query args into a sequence), it's just not in the ZMI anymore. I've already run a find and it doesn't seem to be anywhere. Has anyone seen this? Not my object of course. I mean has anyone seen this behavior? I've search with the find tab from root and with a find & grep on the filesystem and I can only find the references to the object. There are no external methods with this name. And where did I leave my keys? Has anyone seen my keys? I could've sworn they were in my pocket...

1 1

RE: [Zope] Trigger/Auto ID on Gadfly DB
by sean.upton＠uniontrib.com 05 Nov '02

05 Nov '02

Um... just be careful. This won't scale to several simultaneous requests. You might want to be concerned about duplicate keys, conflict errors, and other such problems. Have you considered a random number and a check to see if it is in the db? Sean -----Original Message----- From: Micheál Healy [mailto:michael.healy@engitech.ie] Sent: Tuesday, November 05, 2002 8:23 AM To: zope(a)zope.org Subject: Re: [Zope] Trigger/Auto ID on Gadfly DB Thanks - I guess I'll just do a select and increment the thing myself. Sorry about the double post. for some reason, it took ages for the original one to appear on the list. Micheál ----- Original Message ----- From: "Matthew T. Kromer" <matt(a)zope.com> To: "Micheál Healy" <michael.healy(a)engitech.ie> Cc: <zope(a)zope.org> Sent: Tuesday, November 05, 2002 4:02 PM Subject: Re: [Zope] Trigger/Auto ID on Gadfly DB > Micheál Healy wrote: > > > Hi all, > > > > Is it possible to set a trigger on a gadfly database table? I would > > like to automatically generate an Id on a table each time I insert. > > In Oracle, I would create a sequence and then create a trigger on the > > table in question based on the sequence. I something similar possible > > with Gadfly? > > > > TIA, > > > > Micheál > > > Erm. > > No. > > Gadfly is a very light-weight database. It accepts SQL commands, but it > isn't a "full" database like you might think. > > I dont know if it has automatic sequence numbers -- that's your real > question. Each RDBMS tends to do automatic sequence number differently. > Oracle actually does it the most awkward way, by requiring you to set a > trigger on inserts. Most other RDBMS will let you specific an > auto-increment column some way. > > Granted, I could be wrong about Gadfly -- I only spent about 90 seconds > grepping the source for a likely auto-increment column operator. But I > do not believe Gadfly does this for you. > > -- > Matt Kromer > Zope Corporation http://www.zope.com/ > _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] advice needed
by sean.upton＠uniontrib.com 05 Nov '02

05 Nov '02

Big image databases can be just that: very big (I'm used to working with media-asset management systems for newspapers, and from that perspective, I can tell you that such a beast is likely best not done as a BLOB setup). I would think this suffers from scalability problems, regardless of which table handler backend you use in MySQL. If you have Terabytes of images, you want to store them as files across many volumes, which means you want to store them on disk volumes on scalable filesystems with logical volume management and good backup procedure. BLOBs in RDBMS won't scale with your hardware and won't let you use simple UNIX maintenance and backup tools. For example, try incrementally backing up half-a-dozen InnoDB table-space files using find+cpio (hint: you can't). I would approach this with MySQL, filesystem storage for binaries, and DirectoryStorage for ZODB (especially if this was a massive DB, which image DBs usually are). Sean -----Original Message----- From: Martin Gebert [mailto:Murphy@members.netsolution-net.de] Sent: Tuesday, November 05, 2002 2:27 PM To: gabecker(a)indiana.edu Cc: zope(a)zope.org Subject: Re: [Zope] advice needed Have you thought about storing the images as BLOBs in MySQL? I must admit I lack every experience how MySQL behaves under the load of many Long Objects, but in a small scale I've made good experiences till now with that (the concerning small application will go online the next days). Concerning the access restrictions, IMHO this would be handled the easiest way by roles and (in case of externel files or ZODB storage) different folders, if your special problem admits such an architecture. Martin gabecker(a)indiana.edu schrieb: >I am relatively new to Zope, but I plan to use it for an image database >system that I need to make for scientific purposes. What I have in mind >is to store the actual images externally in files (since there will be >many and large files), and the info about the image (where collected, >owner, codes etc etc) in a database like MySQL. Zope would form the >interface. > >My first question is what would be a suitable way to go from here: use >LocalFS or ExtImage for storage of many files (think of 50,000 or so)? I >will need to be able to differentiate between users: ie not every user >should have access to all files. > >Furthermore: if there are people that have already done something similar >I would appreciate to learn from their experience. Through a web search I >haven't been able to find such projects, at least not based on Zope. > >All best, >Gabriel > > > _______________________________________________ Zope maillist - Zope(a)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 )

1 0

RE: [Zope] advice needed
by sean.upton＠uniontrib.com 05 Nov '02

05 Nov '02

On the other hand, since you have a system writing files to disk, it might be better to have a security mechanism pre-built into your framework - instead of having to roll your own from scratch like you would with PHP. Zope wins in the security department too. Here's my advice: use the CMF. Create a content type that stores the binary externally. Decorate it with simple metadata (DCMES, and potentially other) stored in the object database, and write ZSQL methods, templates, and python scripts as skin methods that for that content type. Use the identifier/path of the object as a string-based key in your RDBMS for tabular data that decorates your main object. Make the UIs and methods that view and manipulate the said data CMF actions to add onto your object. IMHO, this is a powerful hybrid-storage design idea, and I hope this is helpful? Sean -----Original Message----- From: Jim Kutter [mailto:zope-list@ebizq.net] Sent: Tuesday, November 05, 2002 1:48 PM To: gabecker(a)indiana.edu; zope(a)zope.org Subject: Re: [Zope] advice needed I'll probably get shot for this, but a pure filesystem and MySQL implementation is better suited for PHP. If say, you wanted to store the image info in the ZODB, and the data elsewhere, then Zope is a good solution. Another nice thing about Zope you don't get with a language like PHP is much better managability of the presentation code. If that's important, then again, Zope is the way to go. -jim ----- Original Message ----- From: <gabecker(a)indiana.edu> To: <zope(a)zope.org> Sent: Tuesday, November 05, 2002 4:24 PM Subject: [Zope] advice needed > I am relatively new to Zope, but I plan to use it for an image database > system that I need to make for scientific purposes. What I have in mind > is to store the actual images externally in files (since there will be > many and large files), and the info about the image (where collected, > owner, codes etc etc) in a database like MySQL. Zope would form the > interface. > > My first question is what would be a suitable way to go from here: use > LocalFS or ExtImage for storage of many files (think of 50,000 or so)? I > will need to be able to differentiate between users: ie not every user > should have access to all files. > > Furthermore: if there are people that have already done something similar > I would appreciate to learn from their experience. Through a web search I > haven't been able to find such projects, at least not based on Zope. > > All best, > Gabriel > > > > > > > _______________________________________________ > Zope maillist - Zope(a)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 ) > _______________________________________________ Zope maillist - Zope(a)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 )

1 0

PS: Problem solved
by Peter Hiltner 05 Nov '02

05 Nov '02

Dear collegues, with regard to the call for help regarding the download of Zope I got the problem fixed by using the right mouse button for downloading. Thank you prh

3 2

Extracting Meta Tags for use in ZCatalog
by Niclas Kuehne 05 Nov '02

05 Nov '02

Hi! I would like to catalog all the keywords in the meta tag of HTML Pages uploaded by the users. Is there any way to extract these and put them into ZCatalog? Does anyone have any ideas on how to do such a thing? Thanks in advance, Nic

1 0

tal:repeat usage
by Andrew Athan 05 Nov '02

05 Nov '02

The code above doesn't work. Instead, I have to replace the content= with "python:foo[repeat['v'].index]['a']" Seems silly and cumbersome. Am I doing something stupid here (like forgetting the python syntax for creating objects on the fly so I can use a list of objects instead of a list of dictionaries)? Argh. Going back and forth between JavaScript, Python, Perl and Java is killing me. aathan <Andrew Athan>

4 5

Upgrading from 2.5.1 to 2.6.0 Problems
by Josef Meile 05 Nov '02

05 Nov '02

Hi, I'm trying to upgrade my Zope to the latest stable version. My test machine is running RedHat 7.3, python 2.1.3 (source), Zope 2.6.0 (source). The original data comes from a machine running suse 7.3, python 2.1.3 (source), and Zope 2.5.1 (source) When I start the new Zope with the Data.fs of the previous version, I get: 2002-11-05T20:54:06 ERROR(200) Zope Couldn't install OFSP Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: OFSP Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x08:', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 000000000000083a, serial was 0348a51f52d8776e, now 0000000000000000) ------ 2002-11-05T20:54:08 ERROR(200) Zope Couldn't install ZCatalog Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: ZCatalog Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x0e\xb6', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 0000000000000eb6, serial was 0348a51f6ab4c9a2, now 0000000000000000) I also get this warning which hadn't appeared in a long time ago: /usr/local/Zope/2.6.0/lib/python/SearchIndex/__init__.py:19: DeprecationWarning: The usage of the SearchIndex package is deprecated since Zope 2.4. This package is only kept for backwards compatibility for a while and will go away in a future release. Please use instead the re-factored modules in Products/PluginIndexes. warnings.warn("The usage of the SearchIndex package is deprecated since \ Then the server starts. Also, when trying to query the catalog through the manage interface I get the records I want, but this message appears several times on my log file: ------ 2002-11-05T20:59:36 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x01\x91+' Traceback (innermost last): Module ZODB.Connection, line 533, in setstate Module ZODB.Connection, line 192, in _persistent_load - __traceback_info__: . Module ZODB.Connection, line 131, in __getitem__ - __traceback_info__: Here comes a lot of characters that doesn't make any sense to me Could not load oid ., pickled data in traceback info may contain clues ------ At the end of all of this comes: ------ 2002-11-05T20:59:59 PROBLEM(100) ZODB Could not import class 'CADFolder' from module '*nskuqovTqw3NvqWvBdGN0g==' ------ 2002-11-05T21:00:05 PROBLEM(100) ZODB Could not import class 'EventFolder' from module '*aMUfubARz/CXaB9cEaCxFw==' Those are ZClasses that I've installed and that have worked in the previous version. Does anybody has a clue? Thanks in advanced, Josef.

1 0

A ZPT newbie question
by Wankyu Choi 05 Nov '02

05 Nov '02

Hi all, There must be a better way than: The following gives an attribute error if 'this_object' is None: test() seems to always evaluate both params no matter what. In a word, is there a ZPT equivalent to the following python code without nesting again and again? if this_object is not None and this_object.getSomethingBig(): result = self.getSomethingEvenBigger() I'm putting too many nests to prevent this annoying attribute error in NeoBoard skins. Any help will be appreciated. Regards, Wankyu Choi --------------------------------------------------------------- To the dedicated staff at NeoQuest, language is not a problem to be dealt with, but an art waiting to be performed. --------------------------------------------------------------- Wankyou Choi CEO/President NeoQuest Communications, Inc. 3rd Floor, HMC Bldg., 730-14, Yoksam-dong, Kangnam-gu Seoul, Korea Tel: 82-2 - 501 - 7124 Fax: 82-2-501-7058 Corporate Home: http://www.neoqst.com Personal Home: http://www.neoboard.net e-mail: wankyu(a)neoqst.com ---------------------------------------------------------------

4 3