July 2000 - Zope - Zope lists

Problem displaying Informix INTERVALs using DTML
by Raymond Kelly 01 Aug '00

01 Aug '00

Hi, I am using Zope on a PC running on NT and using ODBC to connect to a Informix database. I am running a query that returns a column of INTERVAL type, calculated by subtracting to DATE types. The query, when tested using the test tab, displays the results as I expected. However, when I try to display the results using either a search interface, or my own DTML method, NETSCAPE 4.7 refuses to display the results. Instead it reckons it cannot handle the resultant HTML from the DTML used to produce the results page. Instead, it decides the best thing to do is save the file but when it is reloaded it load just fine. IE5 does get a little further and it will display the page but there are numerous strange characters at the end of the expected interval field. This seems like some additional characters are coming back from the query and they may cause Netscape to trip up and IE5 to display odd characters. What I have tried to do, without sucess, is to get access to the DTML, within Zope, which produces the results of a test on an SQL query. This is where the solution lives!, but I plain just can't find it. I have tried formating the the INTERVAL type and truncating but nothing yields the same results as the 'test' DTML. Any ideas for a poor Zope newbie. Thanks Raymond

3 2

Re: [Zope] Starting Zope
by Cary O'Brien 01 Aug '00

01 Aug '00

> > Interesting argument. However, consider this: if you completely trust your > 'firewalled' box, then why not run the web server as root? One response, Protection of the system from simple mistakes by trusted users? Also root can do a lot more, such as putting interfaces into promiscious mode. So the idea is to just lift the bind-to-low-ports check. > in your case is the fact that you mention your trust on users(humans are > the most easy to compromise, however that argument is a bit OT). However, > do you trust all of your webserver code? Do you trust your cgi-bin > scripts and applications? And by trust I not only mean harmful intent by > the authors of software, but unintentional bugs which can be exploited, > and will be given the privilege to bind to <1024 ports even when they run > as a user with least privileges. > My revised thinking is that the patch should only lift the restriction for just the necessary ports. Another idea is to do it with groups, say let group n be a "net-privileged" group. -- cary > Just my opinion. > > nitesh. > > > On Sun, 30 Jul 2000, Cary O'Brien wrote: > > > > Cary O'Brien wrote: > > > > > > > Well... > > > > > > > > If you are running on Linux you could simply edit the kernel code to > > > > elimitate the check on being root to bind to low ports. That's what > > > > we did. > > > > > > Which is an even worse idea. > > > > > > > Why? On a sufficiently firewalled off box, where the few logins are > > completly trusted, what's the diff? If you were worried about people > > cracking a user account and getting underneath telnet, than limit the > > lifting of the restriction to port 80. If you are concerned that > > non-root users could launch attacks from low ports at other machines, > > assuming that only good guys can come from low ports is pretty naive. > > > > The whole business about not letting anyone but root bind to low ports > > makes sense for a public access machine where all the first year > > engineering students have an account, but for a dedicated application > > server it is kind of misdirected. You ought to be running next to > > nothing but the application, and you had better trust everyone that > > you give a login to, and you out to have the thing locked > > down/firewalled well. So the tiny bit of possible protection may not > > be worth the hassle/risks of writing your own suid-wrapper, or the > > complexity of having a redirect and messing with site-access so that > > the port numbers in the zope -- what it is that parameter -- base or > > whatever, comes out write. > > > > Just for fun - does NT have the same restriction? > > > > -- cary > > > > _______________________________________________ > > 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 ) > > > > > > > > --__--__-- >

3 2

dtml-tree question
by Jonothan Farr 01 Aug '00

01 Aug '00

What is the difference between using the dtml-tree tag in a dtml method and using it in a dtml document? I have code that works perfectly in a dtml method but when I try the exact same code in a dtml document it doesn't display anything. Is it because the document is at the top of the namespace stack instead of the request object in the dtml document case, but not in the dtml method case? My branches method is a zsqlmethod that acquires its parameter from the namespace. Here's the code, if that helps: <dtml-var standard_html_header> <dtml-tree branches=select_subprojects id=project_id> <a href="edit_project?project_id=&dtml-project_id;">edit</a>  <a href="view_project?project_id=&dtml-project_id;"><dtml-var project_name></a> </td> <td align=right valign=top><dtml-var task_count> </dtml-tree> <dtml-var standard_html_footer> select_subprojects is a zsqlmethod, the fields are project_id, project_name, and task_count. It takes one parameter, project_id which it acquires from the result set of the previous call to itself. I'm stumped. I could just use a dtml method instead of a document but I want to understand this. Thanks, --jfarr

2 2

How do I control iteration over XML elements?
by Jean Jordaan 01 Aug '00

01 Aug '00

Hi all If I have (in an XML Document): <teams> <team> <name>Name of team</name> <desc>White papers, brochures, case studies.</desc> <member class="leader">Tracey</member> <member>Eduan</member> <member>Jacqui</member> </team> </teams> Then: <dtml-in "teams[0].getElementsByTagName('team')"> <dtml-var "text_content('member')"> </dtml-in> gives me this: TraceyEduanJacqui I'd like to format the output, putting 's between all the names, for example. How do I do that? Cheers, -- jean

2 1

RE: [Zope] using sister folder methods ?
by Gijs Reulen 31 Jul '00

31 Jul '00

Thanks everybody for the tons of hints ! Works great now and I really start to understand some things. > Gijs Reulen wrote: > > > > Hi > > > > I have a root level folder with a DTML Document. From within > this document I > > want to use a DTML Method that is located in a sister folder; > another folder > > from the root. > > I tried the full path but that does not seem to work. > > What else ?

1 0

PTK question ..
by Jean Jordaan 31 Jul '00

31 Jul '00

Hi all I'm trying to get the PTK up and running. Everything works OK, but when I try to review a pending document, this is what I get: Resource not found Sorry, the requested Zope resource does not exist.Check the URL and try again.   The document is simply the default index_html document of the user 'test-portal' (a normal member user). I changed a few words and marked it pending. Then I logged out, logged in as the manager user, and tried to access http://roamer/portal/Members/test-portal/index_html This resulted in the above traceback. I notice that index_html was created by 'No owner'. If I create a document as 'test-portal', I can review it successfully as manager. Trying to access http://roamer/portal/Members/test-portal also results in the same traceback (with "Document instance at 0190FC70"). I intend to use the PTK for our company's intranet of 150+ employees, if at all possible. Is is ready for this? I'm running Zope-2.1.6-win32-x86.exe and ZopePTK-0.7.1.tar.gz (the PTK would require Zope 2.2, would it?). Any help would be most appreciated. Regards, -- jean

3 2

Re: [Zope] Passing 'document_title' to 'standard_html_header' from a method?
by Dieter Maurer 31 Jul '00

31 Jul '00

> I can't seem to get the 'document_title' from a method into a > standard header (when using '<dtml-var document_title>' in the header > file the generated page uses the title of the header file itself. I just read in "zope-ptk" that a namespace has an (undocumented) "this" attribute pointing to the DTML method/document that created the namespace. If this is true, you can use <dtml-var "_.this.title"> to get what you want. Dieter

1 0

Re: [Zope] dtml-in 'one record per page' problem
by Dieter Maurer 31 Jul '00

31 Jul '00

Cesar A. K. Grossmann writes: > I'm using a report that must return one instance by page, but it's not > working very well... If the query returns more than one result, Zope > presents only two pages. I'm using Zope 2.1.6 in a Linux box. What does is mean: "presents only two pages"? Probably, you get wrong navigation elements. This would be due to a bug for "<dtml-in size=1>". There is a patch for this at URL:http://www.dieter.handshake.de/pyprojects/zope/dt_in.pat In fact, the patch does more (allows for uniform navigation elements at both start and end of sequence batch). There was an announcement in this list around June 10, 2000. AFAIK, the patch is integrated into Zope 2.2. > Here are a excerpt of the dtml code used: > > <dtml-in > sqlQuery > size=1 > orphan=1 > .... You should use "orphan=0". "orphan=1" allows for one "orphan" to be moved, i.e. you may get 2 records on a page. Dieter

2 1

The Western Web Newsletter
by The Western Web 31 Jul '00

31 Jul '00

THE WESTERN WEB WEEKLY NEWS LETTER Week of July 24, 2000 Serving Over 75000 Recipients With your assistance "The Western Web" continues to improve and your input is helpful.Our goal is to make "The Western Web" THE one place stop for all your Horse, Livestock and Western Life Style needs. If You have added your site to our search engine, please make sure everything is correct. If you haven't noticed we have upgraded the look and capabilities of The Western Web search engine. You can now type in your search word and find all related site links. Don't forget to add your Web Site to our search engine too. http://www.searchthewesternweb.com This week you might take a look at our "Events Calendar" in our Classified Ad section. You can post your upcoming events in subcategories such as: Events, Shows, Cuttings, Team Roping, Gymkhana, Clinics, Trail, Auctions, Rodeos, Reining, Barrel Racing, Team Penning and Performance & Halter. We also have a subcategory for "Other" to place any event not categorized. These ads are free and you can add pictures, video and audio. A note to our subscribers who have posted ads, with you User Name and Password you can update your events. http://www.westernwebclassified.com/cgi-bin/classifieds/classifieds.cgi At last, an online service available with the horse lover in mind, The Sale Barn.Com (www.thesalebarn.com) The Sale Barn offers an online auction specifically for horse-related items, whether you are buying or selling. The Sale Barn auctions off 100s of items daily with many items in the Hot Items Listing starting at $1.00! Usually there are from 150 to 200 items starting at only $1.00. >From saddles, bridles, bits, spurs and unique gift items. Register now to qualify for our weekly drawing. The current prize is a 34 x 36 Wool Blend Show Blanket with wear leathers and silver conchos valued at $99.95! This item is featured on our Home Page at www.thesalebarn.com. Registration is free on our secure site with no credit card necessary. The Sale Barn is amongst the top 10 visited horse sites on the Internet with over 10,000 hits a day. A perfect opportunity to turn unneeded horse related items in to cash. The Sale Barn is the ebay of the horse world with categories directed to specific items such as saddles, headstalls, bits, spurs, ropes, gift items, horse trailers, etc. http://www.thesalebarn.com We appreciate you patronizing our sponsors. You to can have your web site on our front page along with Banks Power, Roo-hyde Saddlery, GMC, Bootbarn.com,Truckloads.net, Zig Zigler, Comforce, The Gaited Horse, Cowboy Tack, Painted Acres Ranch,The ShawnOshine,Tom Balding Bits & Spurs, Centenary of Federation and Stoxrus.com. You can find our reasonable rates at: http://www.thewesternweb.com/Advertising/Advertising.htm While at The Western Web site take a look at our message board: http://www.westernmessageboard.com/cgi-bin/Ultimate.cgi We can Design & Host your web site. Check out our low domain name registration prices at: http://www.thewesternweb.com/Web_Design/Domain_Name_Registration.htm For you convenience, there are links to these sites and more, from The Western Web Home Page. http://www.thewesternweb.com/ If you receive this message in error or want us to remove you from our newsletter e-mail list, please reply to this email address with the word "Remove" in the subject line. Thank You, http://www.thewesternweb.com

1 0

server dies
by Leichtman, David J 31 Jul '00

31 Jul '00

I was wondering if anyone else had experienced this problem: Ever since we installed the ZPoPy database adapter, the server has been occasionally crashing, and it gets worse and worse over time. Has anyone else experienced this problem? We're running Zope through Apache, on a Solaris box, with PostgreSQL. I'm really curious as to what could be causing this behavior. I know that that adapter is still in development, but it seems like that would be non-desirable behavior :) If there is some way that our setup is causing this, any input would be appreciated. We are also still running the last stable release of Zope (2.1.6, I think) with plans to upgrade next week. Thanks.

1 0