March 2001 - Zope - Zope lists

Performance under load using SQL (Postgresql)
by Mayers, Philip J 28 Mar '01

28 Mar '01

I seem to be able to kill Zope *very* easily (with about 5 requests/sec) if that request does a lot of SQL activity. Now, this activity is not avoidable, but that load is pretty puny. Also, it doesn't just seem to die either - it seems to hang completely under some circumstances. I'm using Postgresql (makes no different whether it's 7.0 or the 7.1RC1) with ZPoPyDA and/or psycopg - they both suffer from the problem. What happens is that the child threads of ZServer die, leaving me with the top-level process (doing a waitpid on it's child) and the child (doing a select on the PCGI socket) How can I debug this? The machine is plenty fast enough to handle this load, and with static pages it's fine - just the ones that make SQL calls. Surely it should degrade gracefully, rather than just *dying*? Cheers, Phil

2 1

Python Scripts: assignment error when namespace is bound
by J M Cerqueira Esteves 27 Mar '01

27 Mar '01

Greetings I just noticed that (with Zope-2.3.1b3, Python 1.5.2, under Debian 2.2) when namespace is bound (namespace=_) in Python Scripts, I can not use names accessible through the namespace as assignment targets. For instance, the top folder where I was testing had a string property named 'color_dm'. When the following simple script was called from a DTML Method color_dm = 42 return 14 I got Error Type: TypeError Error Value: no arguments expected This one: index_html = 42 return 14 resulted in Error Type: SystemError Error Value: Excessive recursion with the following repeating messages: File /usr/local/src/Zope-2.3.1b3-src/lib/python/OFS/DTMLMethod.py, line 182, in __call__ (Object: index_html) File /usr/local/src/Zope-2.3.1b3-src/lib/python/DocumentTemplate/DT_String.py, line 538, in __call__ (Object: index_html) File /usr/local/src/Zope-2.3.1b3-src/lib/python/Shared/DC/Scripts/Bindings.py, line 334, in __render_with_namespace__ (Object: serpent) There are no problems if namespace is not bound or the script is invoked directly in a URL (because of the resulting empty namespace, I believe). -- jmce: +351 919838775 ~ http://artenumerica.com/ ~ http://artenumerica.org/

3 2

Interesting Quote from zdnet
by Jeff Sasmor 27 Mar '01

27 Mar '01

Hi Zopistas. For your amusement: In this snippy article: http://dailynews.yahoo.com/h/zd/20010327/tc/bad_economy_s_good_for_open_sour ce_1.html I saw on ZDNews (via "my yahoo's" front page, hence, seen by many), some fellow named John Taschek uneloquently discusses the open source movement. The interesting quote: " Digital Creations, for example, has developed an open-source language called Python and built an open-source application server out of it called Zope" Wow, I didn't know that DC created Python! Great job guys :-) And great research, ZDNet.... Regards, Jeff Sasmor (and yes, I personally know that DC did not create Python).

2 1

ANN: ZImporter 0.2beta1
by Farrell, Troy 27 Mar '01

27 Mar '01

I'm thrilled and somewhat nervous to announce the release of ZImporter 0.2beta1. ZImporter is a Zope Product that allows a user to import .zexp files through the web(ttw). ZImporter is possibly a security disaster. By allowing the import of zexp files, it opens up your zope server to import of corrupt files or intentionally dangerous material(by authorized users). Please use caution with this product. All comments and questions are welcome. http://www.zope.org/Members/tfarrell/ZImporter Troy Farrell Video Operations Technician III Williams VYVX Services Business Media Services mailto:troy.farrell@wilcom.com

1 0

SQL call inside <dtml-let> (Somebody help please I'm goin' INSANE !!!!!!!!!)
by Δημήτρης Ανδρακάκης 27 Mar '01

27 Mar '01

(I think the subject says it all :-) So I've got this dtml method, which is called by a form. It used to be something simple like: <dtml-var standard_html_header> <dtml-call sqlInsertAnnouncement> <h2>Thank you</h2> <dtml-var standard_html_footer> Now I want to make it more sofisticated, so that the user enters less data. I came up with this: <dtml-var standard_html_header> <dtml-let date="_.str(ZopeTime())" folderid="date[5:7]+date[2:4]" fileid="file.filename[_.max(_.string.rfind(file.filename, '/'), _.string.rfind(file.filename, '\\'), _.string.rfind(file.filename, ':'))+1:]" link="folderid+'/'+fileid"> <dtml-comment> <dtml-call sqlInsertAnnouncement> </dtml-comment> <dtml-var link><br> <dtml-var ann_title><br> <dtml-var comment><br> <dtml-var category><br> </dtml-let> [there are more stuff here, but they work fine... what they do is upload a file] <dtml-var standard_html_footer> Notice the <comment>s around the sql call. Once I remove them. I get a "Bad Request". I've put the <dtml-var>s so I can see if the vars the sql method requires (link, ann_title, comment, category) are ok --and they are. I've tested it 1000s of times, it all works fine except for the <dtml-call>. Is it some bug ? Does the call not work inside <dtml-let> ? Is it something else I'm missing ? Any guru please, it's driven me crazy ! I'm using zope 2.2.2 behind apache 1.3 (.19 I think) and RH 6.2. Dimitris @ Nuclear

3 2

ZClass question
by Samuel D. Gendler 27 Mar '01

27 Mar '01

I think I remember seeing someone mention this in an email, but I couldn't find it... Has anyone thought about a method of allowing ZClasses to be CREATED inside a folder, rather than the Control Panel, so that users of shared zope environments such as hosting or inside CMF can build ZClass based products without access to Control Panel. I know that ZClasses are no longer considered the wave of the future, so maybe there is something being thought about by the CMF folks so that Product Development does not have to occur at such a high level within the security framework. --sam

1 0

Re: Re: [Zope] ZSQL & LIKE Operator
by Donald Braman 27 Mar '01

27 Mar '01

Thanks! That worked! -Don ---------Included Message---------- Date: Tue, 27 Mar 2001 23:00:27 +0100 From: "tom smith" <tom(a)othermedia.com> Reply-To: "tom smith" <tom(a)othermedia.com> To: <donald.braman(a)yale.edu>, <zope(a)zope.org> Subject: Re: [Zope] ZSQL & LIKE Operator on 3/27/01 10:56 PM, Donald Braman at donald.braman(a)yale.edu wrote: > I'm trying to get Zope to submit a "like" statement to MS Access (please > don't ask why I'm using MS Access; it's a temporary situation). Anyway, > I can't get a working ZSQL method LIKE and a wildcard. > > I try: > SELECT * > FROM Cases > WHERE Short_Case_Name LIKE 'Plessy v. Ferguson' > works fine; I try: > WHERE Short_Case_Name LIKE 'Plessy*' I use the % sign with Access and it seems to work OK WHERE Short_Case_Name LIKE 'Plessy%' Cheers tom -- tom smith | tom(a)othermedia.com http://www.othermedia.com/blog tel 020 8541 5355 | fax 020 8541 5507 11 penrhyn road, kingston-upon-thames, london KT1 2BZ ---------End of Included Message---------- Donald Braman donald.braman(a)yale.edu

1 0

Re: [Zope] interactive linking
by Dieter Maurer 27 Mar '01

27 Mar '01

paulousek writes: > I apologize for posting a maybe stupid newbie question, but: > what I intend to realize is a CM-system where editors can interactively > interlink documents (in the sense of creating HREFs). They must be able to > indicate the link's target, which might be either internal (another Zope > object/document), or external (a complete URL selected from a list) or even > void. The interface should not be typing the target's data/address in, but > selecting it from a form-element like a scrollable list. > Can this be done easily with Zope or will I have to prepare myself for long > Python-programming sessions? > (BTW: the same procedure for selecting content should be available for > images and downloadable files.) > > hope I haven't bothered the community... You have not... But I do not understand where your problem is: 1. build the scrollable list? 2. implement the linking? 1. is trivial once you know which elements should be part of the list and how to get them. For 2., I would use either a relational database or the ZCatalog if the links are not embedded arbitrary in the text but presented together at well defined places and query the database at these places to obtain the targets (identified via URL's). Dieter

1 0

Re: [Zope] ADD ACL USER?
by Dieter Maurer 27 Mar '01

27 Mar '01

=?iso-8859-1?Q?Daniel_Corr=EAa_de_Azevedo?= writes: > How could I create a document with a customized form for adding users to > Zope and to authenticate them? You build your form and use "acl_users/manage_users" either directly as action or indirectly. More details in the (searchable) mailing list archives (an excellent resource!). Search for "manage_users". Dieter

1 0

Re: [Zope] List of DB error
by Dieter Maurer 27 Mar '01

27 Mar '01

=?iso-8859-1?Q?Daniel_Corr=EAa_de_Azevedo?= writes: > Where can I find a list of the possible zope message errors types while > using a DB connection. > I need that because of need to implement all the <dtml-except ERROR_TYPE> > for operations with a DB. I guess there is no compiled list. All exceptions I have seen so far for database accesses came from the Python interface to the database, usually a DB-API interface. I think, there is a quasi-standard, to have an object called "error" in the implementing object and use that to report database problems. However, the module may raise standard errors as well, such as "ValueError". I fear, you will need to look at the documentation (or even source) of your specific database interface implementation. Dieter

1 0