- Zope - Zope lists

sql-method and dates
by Stephan Herschel 15 Nov '01

15 Nov '01

Hi, I'm trying to select values of type date from an interbase-database. When i create a 'z sql method' i get an error - it's compaining the type 'date'. How can i solve this problem? Thanks, Stephan -- Mag. Stephan HERSCHEL +43 662 450081 20 ProCeryon Biosciences GmbH http://www.proceryon.com Jakob Haringer Str. 3 A-5020 Salzburg

1 0

DCWorkFlow Error
by j.c.mcnulty＠open.ac.uk 15 Nov '01

15 Nov '01

Hi All, I have just installed a product called DCWorkflow but when I restart zope it says it is broken and I get an error message trying to view it: Traceback (most recent call last): File "/export/home/zope/Zope-2.4.3- src/lib/python/OFS/Application.py", line 563, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/export/home/zope/Zope-2.4.3- src/Products/DCWorkflow/__init__.py", line 92, in ? import DCWorkflow, States, Transitions, Variables, Worklists, Scripts File "/export/home/zope/Zope-2.4.3- src/Products/DCWorkflow/DCWorkflow.py", line 117, in ? from Transitions import TRIGGER_AUTOMATIC, TRIGGER_USER_ACTION, \ File "/export/home/zope/Zope-2.4.3- src/Products/DCWorkflow/Transitions.py", line 102, in ? from Guard import Guard File "/export/home/zope/Zope-2.4.3- src/Products/DCWorkflow/Guard.py", line 100, in ? from Expression import Expression, StateChangeInfo, createExprContext File "/export/home/zope/Zope-2.4.3- src/Products/DCWorkflow/Expression.py", line 98, in ? from Products.PageTemplates.Expressions import getEngine ImportError: No module named PageTemplates.Expressions Do I need other products to work along side it? Thanks James

3 2

Zope & PIL: ImageFile name conflict
by shawn grant 15 Nov '01

15 Nov '01

Using PIL 1.1.2 from within Zope 2.4.2 (python 2.1): the following call works from the command line but fails for me within Zope, font = ImageFont.load('/usr/lib/python2.1/site-packages/PIL/Images/base_pil/300/Verdana_10_300.pil') The open method in PIL's Image.py tries to open an image file (the corresponding Verdana_10_300.pbm file). It attempts to create an ImageFile object, which it should be importing from PIL/ImageFile.py but instead is getting App/ImageFile.py from Zope. How can I resolve this naming conflict?

1 0

Inserting objects in acquisition chain
by Oliver Bleutgen 15 Nov '01

15 Nov '01

Hi, in a python product, I want to insert an (folderish) object into the namespace like this: parent_object subobject Now I want that parent_object behave like subobject would be it's sq_parent, all other things should stay the same (acquisition from objects higher in the tree etc...). No other bells and whistles needed, I need exactly what I depicted above. Any hints? cheers, oliver

3 3

LocalFS DeprecationWarning
by Norman Khine 15 Nov '01

15 Nov '01

Hello, I just installed LocalFS on zope 2.4.1b1, but am now getting this error on start up: /usr/local/zope/2.4.1b1/lib/python/ts_regex.py:87: DeprecationWarning: the regex module is deprecated; please use the re module import regex, regsub #, Sync /usr/local/lib/python2.1/regsub.py:15: DeprecationWarning: the regsub module is deprecated; please use re.sub() DeprecationWarning) ------ Any ideas... Many thanks Norman

4 3

RE: [Zope] Zope as a service on NT
by Capesius, Alan 15 Nov '01

15 Nov '01

There are a few differences. When using a Windows C++ class library (MFC, VCL etc.) the classes take care of low level message handling. NT Services must implement their own message loop. NT Services must also implement start, stop (and pause) handling. Zope Tips and tricks for Windows NT and SQL =========================================== http://twsite.bizland.com/zopetips.htm >>>-----Original Message----- >>>From: Lennart Regebro [mailto:lennart@regebro.nu] >>>Sent: Thursday, November 15, 2001 10:37 AM >>>To: zope(a)zope.org >>>Subject: Re: [Zope] Zope as a service on NT >>> >>> >>>From: "Jeffrey Robinson" <Jeffrey.Robinson(a)MCICoach.com> >>>> I know on NT there are two ways to run Zope, either as a "standard" >>>program, >>>> or as a service. For our needs, I believed the service >>>would be ideal; >>>but >>>> according to one of the admins when Zope is run as a >>>service it is a >>>"hack" >>>> that launches the "standard" way of running Zope. >>> >>>Uhm. Thats basically what services are... >>>A program is a program is a program. A service is a program that runs >>>without a windows and writes things to the NT log instead of >>>putting it into >>>a stdout windows. If there are more differencies I'm not >>>aware of them (but >>>I haven't considered writing a service in 3 years, so maybe I forgot >>>something). >>> >>>> Personally, I had assumed that it was running in the >>>background like any >>>> other NT service (maybe simply because I never saw a >>>console window). >>> >>>I'm curious to what the difference would be. :-) >>>Services are no more "background" than anything else. >>> >>> >>> >>>_______________________________________________ >>>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 ) >>>

2 1

RE: [Zope] Zope as a service on NT
by Jeffrey Robinson 15 Nov '01

15 Nov '01

Thanks for the replies, folks. I come from more of a Linux background than NT, so I just wanted to make certain I had my facts straight about NT before I try to actually get into a conversation about what is and what is not happening. Jeff > -----Original Message----- > From: Meilicke, Scott [SMTP:scott.meilicke@intp.com] > Sent: Thursday, November 15, 2001 10:10 AM > To: 'Jeffrey Robinson'; zope(a)zope.org > Subject: RE: [Zope] Zope as a service on NT > > I'm not sure if it is a hack or not, but I run zope on two NT 4 boxes, and > one w2k box, and it behaves just the the rest of my services. It stops > and starts with a shutdown and startup of the box. I have never had to > manually stop or start outside of developmental efforts. > > -Scott > > -----Original Message----- > From: Jeffrey Robinson [ <mailto:Jeffrey.Robinson@MCICoach.com>] > Sent: Thursday, November 15, 2001 7:53 AM > To: zope(a)zope.org > Subject: [Zope] Zope as a service on NT > > > Hi folks; > > Currently we have Zope (2.4.2) running on a test Windows NT server as we > test different products for use as the framework for our corporate > Intranet. > > Zope is installed behind IIS using PCGI, but our admins have some concerns > > about how Zope runs, and I cannot verify with my limited knowledge of the > product. > > I know on NT there are two ways to run Zope, either as a "standard" > program, > or as a service. For our needs, I believed the service would be ideal; > but > according to one of the admins when Zope is run as a service it is a > "hack" > that launches the "standard" way of running Zope. > > Personally, I had assumed that it was running in the background like any > other NT service (maybe simply because I never saw a console window). > > The crux of the situation is (understandably) that the IT department does > not want to run anything that they manually have to restart. > > Is there any definitive answer/description available about how Zope runs > on > NT? Any info would be greatly appreciated. > > Thanks; > Jeff Robinson > Graphic Designer > Motor Coach Industries > > > > _______________________________________________ > 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

upload file to LoacalFS with form.
by Frank Löffler 15 Nov '01

15 Nov '01

Hi, i'm using this form to get data:

1 0

RE: [Zope] name based virtual hosts with squid
by sean.upton＠uniontrib.com 15 Nov '01

15 Nov '01

Putting squid in front of multiple Zope hosts on different boxes, ips, and ports will effectively require a redirector. The catch with different ports is how effectively you want to load-balance: Squid's built-in round-robining facility, if you have compiled Squid with --disable-internal-dns, can read from /etc/hosts multiple ips for a name, but this means if can only support one port one each of those hosts because the load-balancing is round-robin based upon name lookup. If you want t support multiple hosts, you need to build custom round-robin setups in a redirector. I would suggest looking at pyredir on freshmeat.net, it is easily hackable to fit your needs. This would work in conjunction with a VHM in Zope fro each host. Keep in mind that the more redirector-dependant you are, the faster the machine you will want to run Squid. Interesting portions of my squid.conf: http_port 80 #need external dns helper in Squid 2.4 if you want to use /etc/hosts #and you have compiled with --disable-internal-dns cache_dns_program /usr/local/squid/libexec/squid/dnsserver #redirector - heavy lifting is done here... redirect_program /usr/local/squid/libexec/squid/pyredir #redirect helpers children - enough to hanlde traffic redirect_children 32 #Don't rewrite the host header! redirect_rewrites_host_header off #Block the Zope Managment interface from working on particular #interface Zope is serving acl ZopeManagementInterface urlpath_regex /manage acl public_interface dst 209.132.98.0/255.255.255.0 http_access deny ZopeManagementInterface public_interface #You don't have to do virtual here if you use a redirector... httpd_accel_host nodes.uniontrib.com httpd_accel_port 80 httpd_accel_uses_host_header on #turn on logging of query terms in get requests strip_query_terms off Sean -----Original Message----- From: sebas ICK [mailto:sebas@ick-kupplungen.de] Sent: Thursday, November 15, 2001 2:22 AM To: zope(a)zope.org Subject: Fw: [Zope] name based virtual hosts with squid For the mailing list archives ... sebas. ----- Original Message ----- From: "Richard Barrett" <R.Barrett(a)ftel.co.uk> To: "sebas ICK" <sebas(a)ick-kupplungen.de> Sent: Wednesday, November 14, 2001 11:59 AM Subject: Re: [Zope] name based virtual hosts with squid At 16:00 14/11/2001 -0800, sebas ICK wrote: >I want to use squid as a front end server indeed and hide zope and apache >behind it. Squid can do some security checks and advanced caching for >frequently requested site. > >I wonder why it is this badly (maybe not at all) documented how to handle >multiple backend servers with squid. Well, I guess that's the trouble with open software. >This a cleaned up version of the *relevant* part of my squid.conf: > >------------------------------- > ># set port where squid listens to, enable logging >http_port 131.174.168.120:80 >emulate_httpd_log on > ># set security checks off for debugging purposes >http_access allow all > ># define virtual hosts for zope and apache >httpd_accel_uses_host_header on >httpd_accel_host zopedev.dhs.org #redirect this to apache on port 90 >httpd_accel_port 90 >httpd_accel_host zopedev-alpha.dhs.org #redirect this to zope on port 8080 >httpd_accel_port 8080 > I'll say from the start that my experience is with using Apache to serve its own content and transparently proxy for Zope servers. My interest in Squid has been using it as a regular (non-transparent) outbound proxy server for browsers running on machines inside our firewall. Still her goes. Looking at the Squid documentation (http://squid.visolve.com/squid24s1/contents.htm) I think I see a couple of problems with your squid.conf: 1. under httpd_accel_host it says: "This tag is used to set the hostname of the accelerated server. It's possible to have only one destination server, so you can have only one occurrence of this line. If you are going accelerate more than one server, or transparent traffic, you will have to use the word virtual instead of a hostname here" Note: "only one occurence", you are trying to specify two 2. under httpd_accel_port it says: "Accelerated requests can only be forwarded to one port: there is no table that associates accelerated hosts and a destination port. Squid will connect to the port that you set the httpd_accel_port value to ... If you want virtual port support then specify the port as "0" Note: "one port", you are trying to specify two Can we be clear about what you are trying to achieve. I'll make the following assumptions. If they are wrong then the argument collapses and will have to be remade on whatever set of objectives you do wish to pursue: 1. You want to run Squid on a machine with the IP number 131.174.168.120, listening on port 80. 2. You want Squid to act as a transparent proxy for Zope and Apache servers. From what you've said, it isn't clear whether these other servers are to be running on the same or different machines to Squid. 3. Each HTTP Request directed at 131.174.168.120:80 is to be passed transparently to one of the "hidden" Zope/Apache servers with the server chosen by analysis of the request headers. 4. Whether the hidden servers are running on the same machine as Squid or not will affect how incoming URLs must be structured. A separate Redirector program that you must identify to Squid has to take the incoming URL and, based on its contents, rewrite it to a URL suitable for one of the hidden servers. If the other servers are on the same machine but differentiable by the Host header of the request, the Redirector can potentially use that to rewrite the URL to reflect the different port number used by each server. If however, the servers are on different machines and cannot be differentiated by Host header then some part of the path in the URL will need to allow the identification of which server is to get the rewritten request. By my reckoning your squid.conf has to contain something like this: # set port where squid listens to, enable logging http_port 131.174.168.120:80 emulate_httpd_log on # set security checks off for debugging purposes http_access allow all # we are using virtual hosts httpd_accel_uses_host_header on httpd_accel_host virtual httpd_accel_port 0 # and defining the redirector which will rewrite the incoming URLs redirector_access allow redirect_program /path/to/you/redirector/program You need to consider the type of HTTP clients that will be in use. The Host header is an HTTP/1.1 feature which some older clients may not provide and a dependency on it in your redirector might bring you grief. A safer bet might be to use the path in the incoming URL as the means of selecting the server as this is HTTP version independent. Another point to consider is the issue of dealing with re-writing redirects from the hidden servers, achieving the equivalent of Apache's ProxyPassReverse directive with Squid. Possibly a bigger problem is checking for and rewriting returned content from the real servers which contains non-relative URLs that do not take account of the proxying that is taking place. For instance, how, with Apache, do you intend to resolve the sort of issues that are overcome by the use of Zope's Virtual Host Monster. >------------------------------- > >Maybe someone got another approach? > >kind regards, > >sebas. > If you are looking for simple solutions I'd urge you to consider using Apache as the primary server for its own content and which can also transparently proxy for Zope using ProxyPass, ProxyPassReverse and RewriteCond/RewriteRule in the Apache httpd.conf. Zope's VHM solves much of the content rewriting issue at source. Best of luck Richard >----- Original Message ----- >Sent: Wednesday, November 14, 2001 3:10 AM >Subject: Re: [Zope] name based virtual hosts with squid > > >If I understand you correctly, you want to hide Apache and Zope behind >Squid. If you want Squid to rewrite incoming URLs as appropriate to either >the Apache or Zope server you will need to provide what is referred to in >Squid documentation as a Redirector program. This program/script, which >you must supply, can rewrite the incoming URLs using whatever >transformation rules you choose to program. The effect is equivalent to >using ProxyPass and RewriteCond/RewriteRule with Apache. > >See the Squid documentation http://www.squid-cache.org/Doc/FAQ/FAQ-15.html >for more information. > >Then again why use Squid? You could achieve similar objectives by having >Apache ProxyPass/Rewrite directives to rewrite URLs to the Zope server. See >this list's archives for postings on this subject. Then again Squid would >probably work better with a high traffic levels. > >At 22:13 13/11/2001 -0800, Sebastian Kügler wrote: > >Hi group, > > > >Here's my problem, maybe someone's got better idea's ... > > > >I want to use squid to server apache and zope on one port. domains under > >zope.domain.org have tp be served by zope and domains with www.domain.org >by > >apache. I have the following in my squid.conf; > > > >----------------------------------------------------- > > > >httpd_accel_uses_host_header on > ># added port 80 here to listen to port 80 (doH!) edited by sebas > > http_port 80 > > emulate_httpd_log on # use NCSA https style logfile > > > ># http_access allow all > > httpd_accel_host zopedev.dhs.org > > httpd_accel_host virtual > > httpd_accel_port 90 # port where Apache is running > > > ># added port 80 here to listen to port 80 (doH!) edited by sebas > > http_port 80 > > emulate_httpd_log on # use NCSA https style logfile > ># this line replaces 'http_access deny all' > ># http_access allow all > > httpd_accel_host zopedev-alpha.dhs.org > > httpd_accel_host virtual > > httpd_accel_port 8080 # port where Zope is running > > > >------------------------------------------------------- > > > >As some of you might already have guessed: it does not work in the right > >way, squid does only seem to use the last http_port specified, just forgets > >about our first one. > > > >I tried different things with that config file, but none of them did the > >trick. > > > >Maybe some of you got it working, if so please tell me how. > > > >regards, > > > >sebas. > > > > > > > >_______________________________________________ > >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 ) _______________________________________________ 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

RE: [Zope] Zope as a service on NT
by Meilicke, Scott 15 Nov '01

15 Nov '01

I'm not sure if it is a hack or not, but I run zope on two NT 4 boxes, and one w2k box, and it behaves just the the rest of my services. It stops and starts with a shutdown and startup of the box. I have never had to manually stop or start outside of developmental efforts. -Scott -----Original Message----- From: Jeffrey Robinson [mailto:Jeffrey.Robinson@MCICoach.com] Sent: Thursday, November 15, 2001 7:53 AM To: zope(a)zope.org Subject: [Zope] Zope as a service on NT Hi folks; Currently we have Zope (2.4.2) running on a test Windows NT server as we test different products for use as the framework for our corporate Intranet. Zope is installed behind IIS using PCGI, but our admins have some concerns about how Zope runs, and I cannot verify with my limited knowledge of the product. I know on NT there are two ways to run Zope, either as a "standard" program, or as a service. For our needs, I believed the service would be ideal; but according to one of the admins when Zope is run as a service it is a "hack" that launches the "standard" way of running Zope. Personally, I had assumed that it was running in the background like any other NT service (maybe simply because I never saw a console window). The crux of the situation is (understandably) that the IT department does not want to run anything that they manually have to restart. Is there any definitive answer/description available about how Zope runs on NT? Any info would be greatly appreciated. Thanks; Jeff Robinson Graphic Designer Motor Coach Industries _______________________________________________ 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