April 2002 - Zope - Zope lists

Zope and IIS (again)
by Igor Leturia 15 Apr '02

15 Apr '02

Hi!! After some time trying the different proposals for my question, I've learned a bit and obtained some conclusions, but now I've got some other doubts. I'll tell briefly what the problem was. I've got a server with Zope and IIS, and each has some services or pages that I want to access from outside. I put each server on a different port (80 and 8080), but I saw that some of the outside clients that try to access to the pages have firewalls that block every port except 80. So I need all communications from the outside to my server to be on port 80. I obtained two possible solutions from this list. Both of them said that I could put Zope and IIS on ports different from 80 (81 and 8080, for example) and then install some sort of proxy server that would attend the requests on port 80, ask to Zope or IIS on their ports and send the response back to the client on port 80. One of the solutions was installing Microsoft Proxy Server and the other was installing Apache an rewrite rules. I tried Microsoft Proxy Server first. It doesn't exist any more, it is now Microsoft ISA Server. I installed and configured it correctly. But this is what happens: The client makes the request in port 80. The request is attended by ISA Server, which sends another request to Zope on port 8080 or to IIS on port 81. When ISA Server obtains the response, it sends it to the client through port 80. All is fine up to now. The problem is both Zope and IIS include '<base href>' tags or absolute URLs with 'www.mydomain.com:8080' or 'www.mydomain.com:81' in the pages, so after that the client requests all the objects in the pages (images, frames, etc.) on ports 8080 and 81, and as they're blocked they are not shown properly. I can fix my Zope pages not to include those tags or absolute URLs, but not the Zope management interface or the IIS pages. So the solution I need is that ISA Server (or whatever software I install as front-end to Zope and IIS) would delete all the ':8080' and ':81's from the pages before serving them to the client, so that the client would do subsequent requests for the images, etc. on the pages again in port 80. Does anyone know how to do this in ISA Server? Or does anyone know if Apache can do it? And any other web proxy server? Thanks in advance, Igor Leturia

4 3

Using persistent DBI handle in PerlExternalMethod
by Robin Smidsrød 15 Apr '02

15 Apr '02

If I create a normal Z DBI database connection, is there a way to use this handle to directly get the corresponding DBI $dbh for that connection? I would like to use the persistence of Zope to get rid of connection-penalty, but I need to use the DBI API to be able to make advanced scripts which calls multiple SQL-statements without the need to make Z SQL Methods for each one... I've looked over Zope.pm (zoperl), and taken a small look at the relevant ZDBI_DA files, but the solution isn't obvious. Can I use it something like this? ----------------- cut here ---------------------- package ZopeExt::return_something; use Zope; # dbi_database_connection is defined in the Zope object tree # DBH is the field described in the Zope.pm BEGIN sub. # Is this correct? my $dbh=$Zope::DBH{'dbi_database_connection'}; my $sth=$dbh->prepare('select * from table'); $sth->execute; my @row=$sth->fetchrow; return @row; 1; ---------------- cut here ----------------------- BTW: I sent this to the zope-perl mailinglist, but it doesn't look like there is much activity on that list.

2 1

email
by micho fr 15 Apr '02

15 Apr '02

michofr(a)hotmail.com _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com

1 0

Folders with same name
by Marie ROBICHON 15 Apr '02

15 Apr '02

>Our development site has approx the following structure: > >Top level folders: >- About >- Jobs >- Beamlines >- Machine >etc > >under the About section there is also subfolder GuidedTour with a >Machine folder. > >Inside each folder is a contents_html document. The index_html is at >the root and displays this content under a generic banner with drop >down menus (Javascript)with links to the top level folders and their >subfolders. > >Local navigation is generated via a treemenu in each top level folder >with the name attribute as the id of the top level folder, and which >generates absolute_urls. > >However we get the follwing error when clicking a link in the >treemenu, to http://mysite/About/GuidedTour >____________________________________________________________________ > >Zope Error > > Zope has encountered an error while publishing this >resource. > > Error Type: KeyError > Error Value: Parameters > > > > Troubleshooting Suggestions > > This resource may be trying to reference a nonexistent >object or variable Parameters. > The URL may be incorrect. > The parameters passed to this resource may be >incorrect. > A resource that this resource relies on may be >encountering an error. > > For more detailed information about the error, please >refer to the HTML source for this page. > > If the error persists please contact the site maintainer. >Thank you for your patience. > > > > >Traceback (innermost last): > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/ZPublisher/Publish.py, line 150, in publish_module > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/ZPublisher/Publish.py, line 114, in publish > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/Zope/__init__.py, line 158, in >zpublisher_exception_hook > (Object: GuidedTour) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/ZPublisher/Publish.py, line 98, in publish > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/ZPublisher/mapply.py, line 88, in mapply > (Object: index_html) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/ZPublisher/Publish.py, line 39, in call_object > (Object: index_html) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/OFS/DTMLMethod.py, line 127, in __call__ > (Object: index_html) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ > (Object: index_html) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/OFS/DTMLMethod.py, line 120, in __call__ > (Object: javascript) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ > (Object: javascript) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/DocumentTemplate/DT_With.py, line 76, in render > (Object: Machine) > File /zope/Zope-2.5.0-solaris-2.6- >sparc/lib/python/DocumentTemplate/DT_With.py, line 60, in render > (Object: Parameters) >KeyError: (see above) > >____________________________________________________________________ > >NB The 'Parameters' folder is located under the top level >folder 'Machine'. > >Does this mean that in Zope no two folders can have the same id? >This would cause problems when our contributors edit their parts of >our site. Is there a way around this other than naming the folders >differently? > >TAI > >Marie Robichon >Web Task Force >European Synchrotron Radiation Facility >Grenoble > >Tel 33 476 88 21 86 >Fax 33 476 88 24 27

1 0

Re: [Zope] Object without Undo?
by Garikoitz Araolaza 15 Apr '02

15 Apr '02

Thanks!! That sounds interesting to me... And how do you avoid Zope giving a 404 error because those objects don't exist in the ZODB? Gari At 12:59 15/04/02, Phil Harris wrote: >You don't need PathHandler for that, Python Scripts and Page Templates are >able to do that with the traverse_subpath variable: > >in a python script: > >return traverse_subpath > >in a page template: > ><span tal:replace="traverse_subpath"/> > >hth > >Phil >----- Original Message ----- >From: "Garikoitz Araolaza" <gari(a)eibar.org> >To: "Terry Hancock" <hancock(a)anansispaceworks.com>; <zope(a)zope.org> >Sent: Monday, April 15, 2002 11:50 AM >Subject: Re: [Zope] Object without Undo? > > > > > > Have you tried PathHandler ? > > > > It never gives a 404 error, and gives you a list with the URL that doesn't > > exist in your site. > > > > Let's say you name it Top > > > > So, when a user requests the URL /Top/Computers/Software , Top will >give > > you ['Computers','Software'] so you can use them in your program to do > > whatever you want... ;-) > > > > You don't need to create Computers nor Software, they simply don't exist. > > > > > > Gari > > > > At 22:55 12/04/02, Terry Hancock wrote: > > >Well, I actually have more than one application, but the > > >simplest is a variable-size image: You want to be able > > >to get at the image at a desired scale, and you may not > > >know what size you want in advance. Furthermore, you > > >may decide in six months you don't like that size, and you > > >don't want to keep it that way, or you may want your > > >users to decide for themselves what size it should be. > > >Consider "avatars" -- usually square, but sizes vary from > > >50x50 to 100x100 or larger depending on the location. So > > >why not save them at 200x200 or so and then just deliver > > >to order? E.g: > > > > _________________________________________________________ > > Aurki Euskara hutsezko bilatzailea > > http://www.aurki.com > > Zure laguntza behar dugu. Egin zaitez editore! > > > > > > > > _______________________________________________ > > 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 ) _________________________________________________________ Aurki Euskara hutsezko bilatzailea http://www.aurki.com Zure laguntza behar dugu. Egin zaitez editore!

2 1

Re: [Zope] Object without Undo?
by Terry Hancock 15 Apr '02

15 Apr '02

> From: Paul Winkler <pw_lists(a)slinkp.com> > On Fri, Apr 12, 2002 at 06:47:11AM -0700, Terry Hancock wrote: > > Hi All, > > > > I'm creating an "infinite-set" type product which generates > > objects on-the-fly based on their URL. In general many > > more objects are possible than are reasonable to store, > > yet relatively few would be used at any one time. Hence, > > a sensible approach is to provide a cache of recently > > requested objects and serve from the cache whenever > > feasible. > > Interesting and weird idea... > I'm having a hard time imagining an application. > Why do you need so many objects? Well, I actually have more than one application, but the simplest is a variable-size image: You want to be able to get at the image at a desired scale, and you may not know what size you want in advance. Furthermore, you may decide in six months you don't like that size, and you don't want to keep it that way, or you may want your users to decide for themselves what size it should be. Consider "avatars" -- usually square, but sizes vary from 50x50 to 100x100 or larger depending on the location. So why not save them at 200x200 or so and then just deliver to order? E.g: http.../myvarimage --> is the original image http.../myvarimage/f32x32 --> is the image scaled to 32x32 pixels It's pretty easy to see that the number of possible URL/images is enormous. Add a few options (preserve aspect fit vertical, preserve aspect fit horizontal, preserve aspect fit within box, fit exact), and it's even larger. Now imagine you have 1000 such images. You can see it would be sort of annoying to resize them all outside of Zope, and port them all back into it, even if you only forsaw changes on the development timescale. Furthermore, who wants to keep track of them all? More complex examples would include images composed of multiple images or dataplots. I probably will have some of those in my application, too, so why not use the same approach for those? Why use a new URL? Because then it will get cached automatically by the browser and any intervening caches. As I said, I do have a working version, and it's very convenient. However, it's badly designed technically -- it uses a single "resized_image" buffer which I now realize is static and so not thread-safe. If you hit it for simultaneous requests of the same image at different sizes (as would happen on a sampler page in my testing configuration, or about 1 zillion times a day in a production environment with real users), Zope logs a "write conflict" error, the hard drive starts thrashing and Zope never recovers. Eventually the server would crash, I think. Or Zope would. I usually restart Zope first. I definitely need a better implementation! :-( > So, I'm wondering if (via Zope's API, as this is a Python-based > > product), there's a way to mark an object as not undoable -- > > i.e. when it gets deleted, it's really gone. > > Well, if your objects don't inherit from something which is > persistent, they won't get stored in the ZODB at all, > AFAIK. They'll simply exist in memory until > deleted or until zope restarts, whichever comes first. Hmm. I only really expect them to last a few minutes, the question is just whether Zope will be able to find them at all. (Also how to avoid using persistent! -- I assume ObjectManager does, I guess it would mean rewriting a lot of code as I don't think there's such a thing as anti-inheriting (keyword "disown"? there's a suggestion for the next version of Python! :D ) > But I haven't really looked into it closely. Well, maybe I can make it work. Thanks for the idea. Terry -- ------------------------------------------------------ Terry Hancock hancock(a)anansispaceworks.com Anansi Spaceworks http://www.anansispaceworks.com P.O. Box 60583 Pasadena, CA 91116-6583 ------------------------------------------------------

5 4

ZSqlMethod and Brain Class
by Delarue Christophe 15 Apr '02

15 Apr '02

This is my first Zope usage ... I've an ODBC Connection for two tables : FA -- ref name Done --- ref correction This Done table may not have a ref entry event if FA has. To edit the FA, I've got a ZSqlMethod SQLQuery which take a `ref' as arg. I edit this by http://host/SQLQuery/Ref/3414/EditRef the EditRef is a DtmlMethod which want to display something if there is data in the Done table. Thus I choose to associate a Brain Class to SQLQuery in which I use a ZSqlMethod SQLQueryDone which retrieve the full content of the Done table for a given ref. class Result: def treat(self): return self.SQLQueryDone(Ref=self.Ref) In the EditRef I've written : <dtml-if treat> <dtml-with treat> <dtml-var correction> </dtml-with> </dtml-if> If execute the query, I've got an Error : Error Type: KeyError Error Value: correction I suppose I've got a namespace problem. I do not understand. thank's for any help. NOTE : I've tried a SELECT xxx FROM xxx LEFT JOIN xxx but this is not understood by the ZODBCDA driver. -- Christophe DELARUE E-Generis Tel.: (+33) 299 842052 Fax.: (+33) 299 639331 13, sq. du Chene Germain / 35510 Cesson-Sevigne / France mailto:cdelarue@e-generis.com

3 3

Replicating ZSyncer
by Dianne Van Dulken 15 Apr '02

15 Apr '02

Hi all, I was wondering if anyone had ever replicated ZSyncer in their site. The problem I am having is that I have several portals on one Zope server. I want the managers of one portal to only be able to Sync the information for that portal (actually, only the content information, not the actual procedures too). However, whenever I use ZSyncer, it shows all the portals. I had a look at the ZSyncer python script, but can't really work out how to replicate the display of the items to be synced. I'm, alas, not that well versed in python (I'm working on it), and the bits that I have copied from it just die horribly, right at the start when I am calling globals. Has anyone done this, and can you then give me a starting point? I really just need to know where to start. Thanks! Di

2 1

page templates and wysiwyg-editors
by Thomas 15 Apr '02

15 Apr '02

Hi, I try to edit page templates wth dreamweaver 4. I read Michel Pelletiers HowTo on zope.org, but at the main point I'm really confused. He says: Now, log into your Zope and create a folder called FileLib. In this folder, create a page template called index_html by selecting Page Template from the add menu, specifying the id index_html in the form, and clicking Add. Now, with your editor, save the above HTML to the URL http://your.zope/FileLib/index_html/source.html. Notice that the URL to save the index_html page ends in source.html. Because page templates are dynamic, you need a way to edit the raw source of the template, unrendered by the page template language. Appending source.html to a page template gives you this raw source. My question is, how can I save source.html to /index_html/source.html if index_html is a page template and not a folder? I tried it without success (Zope 2.5.1, win2k pro). Best regards Thomas

4 3

Object without Undo?
by Terry Hancock 15 Apr '02

15 Apr '02

Hi All, I'm creating an "infinite-set" type product which generates objects on-the-fly based on their URL. In general many more objects are possible than are reasonable to store, yet relatively few would be used at any one time. Hence, a sensible approach is to provide a cache of recently requested objects and serve from the cache whenever feasible. After several design iterations, and one (mostly) working model, which unfortunately didn't scale too well, I've decided on actually inheriting from "ObjectManager" and storing the objects in the main object. As objects expire from the cache, they are deleted. However, with the way Zope's database works, I have to wonder if I'm actually acheiving anything -- the deleted files are still taking up space until the database is packed! So, I'm wondering if (via Zope's API, as this is a Python-based product), there's a way to mark an object as not undoable -- i.e. when it gets deleted, it's really gone. The alternative would seem to be to pack the whole database frequently. Which is what I'll do if there's no other way. It appears that I can get the desired behavior by overloading the _getOb() method of ObjectManager and catching the case of a request for a non-existent object -- if it happens, I just call the code to make the object, add it with _setObject() and then let _getOb() continue with the request, which should now succeed. I presume this would make the cached object visible to Zope calls in all the usual ways (e.g. URL: "parent/cached_obj", Python: "parent.cached_obj", etc). My previous implementation used __getattr__() directly and only worked for the URL approach. Any comments or ideas appreciated, thanks! Terry -- ------------------------------------------------------ Terry Hancock hancock(a)anansispaceworks.com Anansi Spaceworks http://www.anansispaceworks.com P.O. Box 60583 Pasadena, CA 91116-6583 ------------------------------------------------------

3 3