January 2001 - Zope - Zope lists

HOW TO UNLOCK????
by Rommel Novaes Carvalho 10 Jan '01

10 Jan '01

WE NEED TO UNLOCK A VERSION THAT DOES NOT EXIST ANY MORE!! HOW CAN WE DO IT?! A USER DELETED A VERSION THAT SOMEONE ELSE WAS USING, AND WE CAN NOT QUIT THIS VERSION!! AND WE CANNOT UNDO!!! HELP US!!

1 0

Design/DTML question
by Timothy Wilson 10 Jan '01

10 Jan '01

Hi everyone, I'm working on a Web page for our local school board. I'd like to create a table that would display links to past board meeting minutes. The table would look like this: (Note: dates are bogus) +---------------------------------------+ | Meeting Minutes | | | | Monday, Jan. 10 Monday, Mar. 7 | | Tuesday, Jan. 24 Monday, Mar. 20 | | Monday, Feb. 7 Monday, Apr. 5 | | Monday, Feb. 27 Tues., Apr. 19 | | | | 1999 | 2000 | 2001 | +---------------------------------------+ By default, dates for the current year would be displayed, but clicking on the years at the bottom of the table would display those dates. Right now, I've got the dates stored in a TinyTable. I can iterate through that list and generate the links, but I can't figure out how to display the table in two columns. <dtml-in meetingDateTable> <tr><td><dtml-var meeting_date></td></tr> </dtml-in> will print the dates in a single column, but how can I iterate through and refer to two different dates in one <dtml-in> pass? (Does that make sense?) The second thing I'm tring to figure out is how to make the year links at the bottom generate the new table of dates from a different TinyTable. Maybe I should use the same TinyTable for all of the meeting dates and pull out whichever year I need when the table is rendered. I'm also wondering if I should implement these meeting minutes and agendas in a ZClass. At first it seemed like this would be too simple to bother with, but now I'm wondering if a ZClass would be a better approach. I'd appreciate any comments. -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.k12.mn.us/ | http://www.zope.org/ W. St. Paul, MN | | http://slashdot.org/ wilson(a)visi.com | <dtml-var pithy_quote> | http://linux.com/

1 0

RE: [Zope] get property of type 'list'
by Max Møller Rasmussen 10 Jan '01

10 Jan '01

From: Andrei Belitski [mailto:andrei.belitski@student.uni-tuebingen.de] >I add a list property to a DTML document of type 'tokens' (e.g. '[1, 2, >3]') wenn i try to retrieve it with _.getitem i get '[1,' '2,' '3]' >instead of '1' '2' '3' >How can I get Zope to interpret my property like a list not a string or >whatever else? Actually it IS treating it as a list: <dtml-var "tokens[0]"> Should return '1' This should list each item: <dtml-in tokens> <dtml-var sequence-item><br> </dtml-in> Regards Max M

1 0

RE: [Zope] SQL Method, dtml-with and namespace weirdness
by Mayers, Philip J 10 Jan '01

10 Jan '01

Ok, using Postgresql 7.0.2-2, PoPo 2.0.1, ZPoPyDA 1.1-pre2, Zope 2.2.5, here's a reproducible scenario: Create the following tables in your database: create table bugtest1 ( name text, domain text, ); create table bugtest2 ( name text, domain text, refer text, foreign key(refer) references bugtest1(name) ); insert into bugtest1 values ('a','aa'); insert into bugtest1 values ('b','bb'); insert into bugtest1 values ('c','cc'); insert into bugtest2 values ('w','ww','a'); insert into bugtest2 values ('x','xx','a'); insert into bugtest2 values ('y','yy','a'); insert into bugtest2 values ('z','zz','a'); insert into bugtest2 values ('g','gg','b'); insert into bugtest2 values ('h','hh','b'); insert into bugtest2 values ('i','hh','b'); Create the following folder structure: /root dbconn (ZPoPyDA connection to whatever database you just put the tables in) index_html get_host (Z SQL method) get_alias (Z SQL method) /alias show /host show /root/get_host select * from bugtest1 /root/get_alias select * from bugtest2 <dtml-sqlgroup where> <dtml-sqltest name column=refer type=string> </dtml-sqlgroup> /root/alias/show <TR><TD></TD><TD>&dtml-name;</TD><TD>&dtml-domain;</TD></TR> /root/host/host <TR><TD>&dtml-name;</TD><TD>&dtml-domain;</TD></TR> /root/index_html: 1: <dtml-var standard_html_header> 2: <TABLE> 3: <dtml-in get_host> 4: <dtml-with host><dtml-var show></dtml-with> 5: <dtml-in "get_alias(name=name)"> 6: <dtml-let name2=name 7: domain2=domain> 8: <dtml-with alias> 9: <TR><TD>POINT A</TD><TD>&dtml-name;</TD><TD>&dtml-domain;</TD></TR> 10: <TR><TD>POINT B</TD><TD>&dtml-name2;</TD><TD>&dtml-domain2;</TD></TR> 11: <dtml-var show> 12: </dtml-with> 13: <TR><TD>POINT C</TD><TD>&dtml-name;</TD><TD>&dtml-domain;</TD></TR> 14: <TR><TD>POINT D</TD><TD>&dtml-name2;</TD><TD>&dtml-domain2;</TD></TR> 15: </dtml-let> 16: </dtml-in> 17: </dtml-in> 18: </TABLE> 19: <dtml-var standard_html_footer> The output of all that is (a bit hard to read): a aa POINT A a aa POINT B w ww a aa POINT C w ww POINT D w ww POINT A a aa POINT B x xx a aa POINT C x xx POINT D x xx POINT A a aa POINT B y yy a aa POINT C y yy POINT D y yy POINT A a aa POINT B z zz a aa POINT C z zz POINT D z zz <snipped for clarity> So: at point A, the "name" and "domain" variables have been overwritten with the "name" and "domain" variables as they were on line 6/7, *BUT* name2 and domain2 haven't been overwritten (point B). BUT, outside the dtml-with tab (point C) "name" and "domain" are at their correct values. So - given that the dtml-with tag "must" work, I'm clearly not understanding *how* it works. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

1 0

RE: [Zope] SQL Method, dtml-with and namespace weirdness
by Mayers, Philip J 10 Jan '01

10 Jan '01

Sorry - I'm being unclear: the result is exactly the same either way i.e. the variables "name" and "domain" seem to be reset to the values from outside the dtml-in block when entering the dtml-with block. I'm wondering if it's a bug in the postgres DA, since I can't reproduce it with a quick gadfly test. I'm just going to try it out now. I'm using Zope 2.2.5, PoPy 2.0.1 from SourceForce, and ZPoPyDA-1.1-pre2 - I couldn't get any (potentially more stable) combination of PoPy or ZPoPyDA to work. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: 10 January 2001 13:30 To: Mayers, Philip J Cc: 'zope(a)zope.org' Subject: Re: [Zope] SQL Method, dtml-with and namespace weirdness "Mayers, Philip J" wrote: > > > Change your show method in root to be as follows: > > > > <dtml-in get_machine_hosts> > > <dtml-var show_row> > > <dtml-in get_host_aliases> > > <dtml-var show_row> > > </dtml-in> > > </dtml-in> > > > > And add another DTML method in root as follows: > > > > show_row: > > <TR> > > <TD><dtml-var ip missing></TD> > > <TD>&dtml-name;</TD> > > <TD>&dtml-domain;</TD> > > </TR> > > > > so you have: > > /root > > get_machine_hosts (SQL method) > > get_host_aliases (SQL method) > > show (dtml method) > > show_row (dtml method) > That was how I had the code originally. Didn't help. What happens when you try that? Errors? Unexpected values? > I've already read the > Zope 'book' Yes, it is frustrating how long it's taking for that to get printed, I wonder what's holding it up? > (if I were using 2.3 (which I can't, because LoginManager > doesn't work OOTB), I remember seeing the posts relating to that, did you ever find out why it wasn't working? > I'd be using Python methods to do most of this instead. > I'm not, I'm using 2.2.5) Wise choice, but you mean python scripts in 2.3 ;-) You can actually download Python _Methods_ right now and use them in 2.2.5: http://www.zope.org/Members/4am/PythonMethod cheers, Chris

2 1

RE: [Zope] Special-name of variables called 'name' or 'domain'
by Mayers, Philip J 10 Jan '01

10 Jan '01

That was how I had the code originally. Didn't help. I've already read the Zope 'book' (if I were using 2.3 (which I can't, because LoginManager doesn't work OOTB), I'd be using Python methods to do most of this instead. I'm not, I'm using 2.2.5) Thanks anyway. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+ -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: 10 January 2001 13:09 To: Mayers, Philip J Cc: 'zope(a)zope.org' Subject: Re: [Zope] Special-name of variables called 'name' or 'domain' "Mayers, Philip J" wrote: <snip> Try this: Change your show method in root to be as follows: <dtml-in get_machine_hosts> <dtml-var show_row> <dtml-in get_host_aliases> <dtml-var show_row> </dtml-in> </dtml-in> And add another DTML method in root as follows: show_row: <TR> <TD><dtml-var ip missing></TD> <TD>&dtml-name;</TD> <TD>&dtml-domain;</TD> </TR> so you have: /root get_machine_hosts (SQL method) get_host_aliases (SQL method) show (dtml method) show_row (dtml method) Does that solve your problem? (I know it doesn't sovle any concerns you have about dtml-with and SQL method, but your posting wasn't exactly to reproduce, and so even if submitted to the collector, isn't likely to get followed up) > While I'm at it, is <dtml-with foldername><dtml-var dtmlmethod></dtml-with> > really the best way to call a DTML method of a folder? Mostly, yes... BTW, checkout http://www.zope.org/Members/michel/ZB/ and have a good read :-) cheers, Chris

2 1

Special-name of variables called 'name' or 'domain'
by Mayers, Philip J 10 Jan '01

10 Jan '01

I've got some SQL method, and a folder structure, and am seeing some *very* annoying results. Namely, <dtml-with> seems to cancel out variable assignments from an enclosing <dtml-in> /root get_machine_hosts (SQL method) get_host_aliases (SQL method) show (dtml method) /host show (dtml method) /alias show (dtml method) get_machine_hosts takes 'machineid' and returns 'name','domain','ip', e.g. (for a 5-homed box) get_machine_hosts('535252'): www,random.com,192.168.3.2 mail,hosting.com,192.168.3.3 news,random.com,192.168.3.4 sqldb,random.com,192.168.3.5 workstation,random.com,192.168.3.6 get_host_aliases takes 'ip' and returns 'name','domain' e.g. get_host_aliases('192.168.3.3') [mail.random.com] 'pop3','random.com' 'smtp','random.com' 'mail','random.com' 'imap','random.com' But, I'm having problems with the 'in' and 'with' tags using the variable 'name'. The DTML methods are: /root/show <dtml-in get_machine_hosts> <dtml-with host><dtml-var show></dtml-with> </dtml-in> /root/host/show <TR> <TD>&dtml-ip;</TD> <TD>&dtml-name;</TD> <TD>&dtml-domain;</TD> </TR> <dtml-in get_host_aliases> <dtml-comment>POINT A</dtml-with> <dtml-with alias> <dtml-comment>POINT B</dtml-with> <dtml-var show> </dtml-with> </dtml-in> /root/alias/show <TR> <TD></TD> <TD>&dtml-name;</TD> <TD>&dtml-domain;</TD> </TR> Now, assuming I'm looking at machineid 535252 (mail.random.com) I get this: | 192.168.3.3 | mail | hosting.com | | | mail | hosting.com | | | mail | hosting.com | | | mail | hosting.com | | | mail | hosting.com | That is, the variable 'name' and 'domain' aren't set correctly. But, if I modify /root/host/show as follows: <TR> <TD>&dtml-ip;</TD> <TD>&dtml-name;</TD> <TD>&dtml-domain;</TD> </TR> <dtml-in get_host_aliases> <dtml-comment>POINT A</dtml-with> <TR> <TD></TD> <TD>&dtml-name;</TD> <TD>&dtml-name;</TD> </TR> <dtml-with alias> <dtml-comment>POINT B</dtml-with> <dtml-var show> </dtml-with> </dtml-in> I get: | 192.168.3.3 | mail | hosting.com | | | pop3 | random.com | | | mail | hosting.com | | | imap | random.com | | | mail | hosting.com | | | smtp | random.com | | | mail | hosting.com | | | webmail | random.com | | | mail | hosting.com | It would appear that the <dtml-with alias> tag wipes out the 'name' and 'domain' variables back to the values they had outside the <dtml-in get_host_aliases> tag, so calling /root/alias/show gives wrong data. Very odd. *BUT*, if I use 'aliasname' and 'aliasdomain' as the variable names, everything is OK. WTF? While I'm at it, is <dtml-with foldername><dtml-var dtmlmethod></dtml-with> really the best way to call a DTML method of a folder? Regard, Phil

2 1

Memory problems
by Tom Deprez 10 Jan '01

10 Jan '01

Hi, Since a few days I'm experiencing some response problems on my zope site. At some moments calling a page goes very fast a few seconds later, recalling this page takes very long! At the end, every page takes long time, if they ever appear.... If I use a simple memory checker program, then I see that memory leaks away.... (memory goes from 48Mfree to 41M in 15min!! and eventially it ends at a few thousands K) However, I've no idea if it is comming from Zope 2.2.5 or from my database adapter in zope, or from somewhere else.... Is there a good way to check memory leaks and to pinpoint them? If I ask to show me the processes on my Linux box, I see the following related ones : /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (root) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) /usr/local/zope/bin/python /usr/local/zope/z2.py -Z /home/httpd/zope/var/zProcess.pid (nobody) gds_inet_server # Interbase Database Remote Server (root) gds_inet_server # Interbase Database Remote Server (root) Is it normal that zope opens so much processes? Thanks in advance, Tom.

1 0

REPOST: dtml-with doesn't work
by Mayers, Philip J 10 Jan '01

10 Jan '01

Hopefully that will get someone's attention. I have an SQL method that returns (name,domain,otherstuff) I have a DTML method (/root/host/show) that looks like this: <dtml-comment> 'name' and 'domain' are set to the primary hostname and domain at this point by whatever calls this DTML method POINT A </dtml-comment> <dtml-in "HDB_get_ip_aliases(ip=ip)"> <dtml-comment>POINT B</dtml-comment> <dtml-let name2=name domain2=domain> <dtml-with alias> <dtml-comment>POINT C</dtml-comment> <dtml-with "_.namespace(name=name2,domain=domain2)"> <dtml-comment>POINT D</dtml-comment> <dtml-var show> </dtml-with> </dtml-with> </dtml-let> </dtml-in> The folder structure is: /root /alias show /host show At the points marked B and D, <dtml-var name> and <dtml-var domain> work fine, but at point B, name and domain have been reset to what they were at point A. Why? This is totally broken - I'm *this* far from downloading the servlet engine and giving up completely. Zope appears to be completely non-intuitive in many respects, and combined with the generally lamentable documentation, is taking up more of my time than I'm willing to spend on a theoretically simple task. Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

1 0

RE: [Zope] Caching/http-acceleration and proxying Zope-served con tent
by sean.upton＠uniontrib.com 10 Jan '01

10 Jan '01

Hmm. That's been my thought on squid as well, given its ground-up design for caching in the first place. My worry, though, is that with squid I lose support for virtual hosts on seperate boxes, because I need to support Zope, static content, and some legacy stuff running ColdFusion on an NT box. My impression is that Squid's http accelerator mode (inverse transparent proxy, or whatever you want to call it) is somewhat of an afterthought compared to the standard proxy use case. If it supports the ability to direct traffic based upon the virtual host address, then squid works - if not, I think I have to go the Apache route... I also wonder just how good Apache's mod_proxy caching is? Any thoughts? Sean -----Original Message----- From: Shane Hathaway [mailto:shane@digicool.com] Sent: Monday, January 08, 2001 12:59 PM To: zope(a)zope.org Subject: Re: [Zope] Caching/http-acceleration and proxying Zope-served content sean.upton(a)uniontrib.com wrote: > > I have a question, for anyone experienced in working with Zope and caching > proxies: > > I'm setting up a load-balanced server farm that has nodes that will run > Apache and proxy (via mod_proxy) to ZEO clients running ZServer. This farm > is routed (both ways) through a layer 4 load-balancing appliance, and all > these boxes (both nodes and the balancer) are sitting inside a DMZ with > private IP addresses. The public world will access these servers via a > firewall box running transparent proxy (actually, I guess, similar to > squid's http_accel mode; the semantics here are a bit tricky, as it's more > of a inverse trans-proxy). Between Apache and Zope, there would be several > virtual hosts, and I'd be using the SiteAccess product. It gets a bit > tricky in that I need to access several different virtual hosts inside the > DMZ (one for the ZEO farm, and another for a dedicated CGI-based ad server > on another box) via the proxy. A more detailed (ascii art) diagram of what > I am trying to do, is at http://209.132.8.98/server_ascii_art.txt > > My question is this: does anybody have any thoughts on the merits of Squid > (http accelerator mode) versus Apache/mod_proxy in terms of caching, virtual > hosts, and the like when working with Zope sites? Any big pitfalls to this > kind of setup with Zope sites? I would prefer Squid since its only purpose in life is caching. It follows the "do one thing and do it well" mantra. But whatever your choice, I hope you make use of the new CacheManagement feature in Zope 2.3. It is designed to make things like this straightforward and easy. There's a recent news announcement that links to everything you need--including complete help docs! Shane _______________________________________________ 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 )

4 3