March 2001 - Zope - Zope lists

Greetings Zope Newbies
by Spicklemire, Jerry 28 Mar '01

28 Mar '01

Hi Zope fans, Many newbies are jumping in to Zope and it can be pretty overwhelming, at first. Well, at can stay overwhelming for awhile, too. That can make it all the more difficult to discern the forest when all you can see is the next tree you're about to slam into. On the other hand, for those who have been Zoping for awhile, it is hard not to notice the signs of a trend upward in Zope development. Can you say "exponential"? Taking a moment to scan the big Zope picture, here's a summary of several critical Core Zope releases recently announced on these lists: Zope 2.3.1 approaching final release: http://lists.zope.org/pipermail/zope-announce/2001-March/000393.html Zope CMF (aka PTK) approaching v.1 final release: http://lists.zope.org/pipermail/zope-announce/2001-March/000383.html Zope Page Templates v.1 http://lists.zope.org/pipermail/zope/2001-March/086591.html Zope Parsed XML v.1 http://lists.zope.org/pipermail/zope-announce/2001-March/000394.html Pyperl v.1.0.1 http://lists.zope.org/pipermail/zope-perl/2001-March/000242.html plus lot's of books and documentation underway, including: http://lists.zope.org/pipermail/zope-announce/2001-March/000386.html http://www.dieter.handshake.de/pyprojects/zope/book/chap1.html http://lists.zope.org/pipermail/zope-announce/2001-March/000380.html and of course, work on Python continues apace: http://mail.python.org/pipermail/python-list/2001-March/034942.html Finally, just a small sample of links to an ever growing list of contributed modules, How-Tos, and handy extensions from the Global Zope Community, below: http://lists.zope.org/pipermail/zope-announce/2001-March/000379.html http://lists.zope.org/pipermail/zope-announce/2001-March/000381.html http://lists.zope.org/pipermail/zope-announce/2001-March/000384.html http://www.zope.org/Members/aeg/ZDatabaseTool_first_release http://lists.zope.org/pipermail/zope-announce/2001-March/000387.html http://www.zope.org/Members/Kaivo/EvalTag_HowTo/EvalTag Be prepared for EXCITING Times in Zopetopia! Jerry S.

1 0

Re: Fwd: [Zope] Performance under load using SQL (Postgresql)
by Federico Di Gregorio 28 Mar '01

28 Mar '01

Scavenging the mail folder uncovered Paolo Comitini's letter: > > 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) hi, to test psycopg we did 10,000 requests (10 reqs per sec) and zope+psycopg didn't show any problem. i don't know what happens with the HEAD from cvs (a lot of stuff changed) but i don't think you are using that. ciao, federico -- Federico Di Gregorio MIXAD LIVE Chief of Research & Technology fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org All programmers are optimists. -- Frederick P. Brooks, Jr.

1 0

syntax check
by Jonathan Cheyne 28 Mar '01

28 Mar '01

what simple error am I making? <dtml-if expr="(type==['course','event'])"> which i hoped would proceed on either basis but in fact always fails. ... <dtml-if expr="(type=='course')"> works ... Jonathan

4 3

Can ZClass and ZCatalog do this?
by Brad Clements 28 Mar '01

28 Mar '01

I've done all of my Zope work using an SQL backend. One of my customers wants to distribute his Zope "site" on CDROM, so I'm thinking that ZCatalog and ZClasses are the better way to go for his project. He needs to store information on about 1500 companies. Each company can be in one or more categories, have company description, contact info, maybe a .gif.. Each company has one or more products with product info, maybe a .gif Companies should be able to edit some, but not all, of their own attributes through the web. So a company might be able to change it's own address or telephone number, but not it's company name. Anonymous users want to lookup data by category selection, or full text search of company descriptive text or product text. (here's the hard part) But the results must be listed sorted by "those with web sites, email address and telephone number first alpha by company name", then "those with just email and telephone alpha by company name", then "those with telephone alpha by company name" then all the rest, alpha by company name. In SQL I'd just use a "order by website, email, telephone, companyname" because Interbase throws Nulls to the end. How do I do this in ZCatalog? What's the best way to allow companies to change their own objects? I was thinking of making a ZCompany based on a ContentManager, then put a user folder in the instantiated ZCompany objects. But how do I control access to limit which properties a "not-full-owner" can change? Suggestions welcome.. Also I think this data could be freely distributed later, if folks want to use it as an example application. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0

RE: [Zope] ZServer dying
by Mayers, Philip J 28 Mar '01

28 Mar '01

No, I run: su -l zope -c 'nohup /usr/local/Zope/start -X -w 8080 &' I'm stumped. Sven, are you running Postgresql? If so, what version? Next time it dies and the process is there, try strace'ing it with "strace -p pid -d" Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: 28 March 2001 13:48 To: Sven Cc: zope(a)zope.org Subject: Re: [Zope] ZServer dying Sven wrote: > > so i just have to restart zope, and some other times, it freezes but i still > can see the processes (then killal and restart). > > my developpement version does this between 1 and 10 times a day (redhat 7 / > zope 2.3.0 too) Do you run both setups with the -D option? cheers Chris _______________________________________________ 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

ZServer dying
by Mayers, Philip J 28 Mar '01

28 Mar '01

I'm having trouble with Zope periodically dying: 1474 /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 8080 1479 \_ /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 8080 1484 \_ /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 8080 1485 \_ [python <defunct>] 1486 \_ /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 80 1487 \_ /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 80 1488 \_ /usr/bin/python /usr/local/Zope/z2.py -D -u zope -X -w 80 The top-level process is doing a wait4() on it's child. Normally, it's child is doing a select() on the 8080 port, any open connections and a FIFO (which it presumably will use to communicate with the children). When the child's top-level child dies, strace shows: [wait(0x137f) = 1479] pid 1479 stopped, [SIGSTOP] I'm presuming that 1484-8 are threads, since I can't strace/ltrace them. I'm stumped - how can I debug this? Is one of the threads dying - what is it likely to be? I've turned on full debugging on the SQL side of things, I'm pretty certain it's not the server-side connection dying Help! (Zope 2.3.0 in RedHat 7.0 SMP kernel - Booting with the UP kernel didn't help) Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

3 2

Webdrive/FTP woes
by Chris Withers 28 Mar '01

28 Mar '01

Hi, Dunno whether this is a Webdrive or a Zope FTP Server problem so I though I'd ask here first. I really like Webdrive, but when using it to edit Python Scripts using Zope's FTP server, it has a habit of cutting the script in half and loosing the second half :-( Have any other Webdrive/Zope users experienced this? Did anyone find a solution? cheers, Chris

1 0

Counter Rentrancy
by David Kyte 28 Mar '01

28 Mar '01

Hi, If I have a DTML document for generating and tracking say order numbers, is the code rentrant/Atomic? <dtml-call "REQUEST.set('counter', counter + 1)"> <dtml-call "manage_changeProperties( counter=REQUEST['counter'] )"> <dtml-return counter > What I'm really asking is how many threads run in parallel, and how would multiple threads accessing this code react. Do I need some form of transation or locking? Thanks in anticipation David Kyte

2 1

Re: [Zope] ZMySQLDA connection error when adding
by Gitte Wange 28 Mar '01

28 Mar '01

It says a file is missing ... is that a permissions problem ? I have chowned my entire Zope directory to nobody.nobody but the problem is still there ? What should I look for ? Gitte On 28 Mar 2001 10:15:49 +0100, Phil Harris wrote: > Permissions problem > > ----- Original Message ----- > From: "Gitte Wange" <gitte(a)mmmanager.org> > To: <zope(a)zope.org> > Sent: Wednesday, March 28, 2001 9:08 AM > Subject: [Zope] ZMySQLDA connection error when adding > > > > Hello again, > > > > I hope not you are tired of my newbie questions already :-) > > Finally I succeed in adding MySQL functionality to Zope but I can't add > > a connection. > > This is the error I get when I try: > > > > Error Type: IOError > > Error Value: [Errno 2] No such file or directory: > > > '/usr/local/Zope-2.3.0-linux2-x86/lib/python/Shared/DC/ZRDB/connectionAdd.dt > ml > > > > 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/Zope/__init__.py, > > line 221, in zpublisher_exception_hook > > (Object: ApplicationDefaultPermissions) > > 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: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/ZPublisher/Publish.py, line > > 112, in call_object > > (Object: manage_addZMySQLConnectionForm) > > File /usr/local/Zope-2.3.0-linux2-x86/lib/python/App/special_dtml.py, > > line 127, in __call__ > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 479, in __call__ > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 408, in cook > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 400, in read > > (Object: manage_addZMySQLConnectionForm) > > File > > /usr/local/Zope-2.3.0-linux2-x86/lib/python/DocumentTemplate/DT_String.py, > line 580, in read_raw > > (Object: manage_addZMySQLConnectionForm) > > IOError: (see above) > > > > > > Any good ideas ? > > > > Regards, > > > > -- > > ************************ > > Gitte Wange Jensen > > > > System Squid Developer > > MMManager Aps > > +45 29 72 79 72 > > > > gitte(a)mmmanager.org > > ************************ > > > > > > _______________________________________________ > > 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 ) -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte(a)mmmanager.org ************************

2 1

FW: Filling lists from SQL methods
by Norman Khine 28 Mar '01

28 Mar '01

> Hello, > Can any one help me understand the concept behind this example: > > In the How-To from http://www.zope.org/Members/AlexR/SelectionLists sub > section Filling lists from SQL methods, we have a method > > <SELECT name="myList"> > <dtml-in mySQLQuery> > <OPTION VALUE='<dtml-var Field1 null="">'> > <dtml-var Field2 null=""> > </dtml-in> > </SELECT> > > How can I create a second list so that when I select Field1, the list is > updated from another SQL query using the value of Field1 as the variable. > > So for example, I have two tables: ProductGroups and Products > ProductGroups has ProductGrpID, Description > Product has ProductID, Description and FK_ProductGrpID > > Therefore if the user select ProductGrp =1 then the second drop-down menu > will only select Products where FK_ProductGrp = 1. > > Thanks > > Norman

1 0