[Zope-Checkins] SVN: Zope/trunk/utilities/tracelog.py Simple script to analyze trace logs.
Log message for revision 41425: Simple script to analyze trace logs. Changed: A Zope/trunk/utilities/tracelog.py -=- Added: Zope/trunk/utilities/tracelog.py === --- Zope/trunk/utilities/tracelog.py2006-01-24 22:36:17 UTC (rev 41424) +++ Zope/trunk/utilities/tracelog.py2006-01-24 23:38:54 UTC (rev 41425) @@ -0,0 +1,223 @@ +## +# +# Copyright (c) 2006 Zope Corporation and Contributors. +# All Rights Reserved. +# +# This software is subject to the provisions of the Zope Public License, +# Version 2.1 (ZPL). A copy of the ZPL should accompany this distribution. +# THIS SOFTWARE IS PROVIDED AS IS AND ANY AND ALL EXPRESS OR IMPLIED +# WARRANTIES ARE DISCLAIMED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED +# WARRANTIES OF TITLE, MERCHANTABILITY, AGAINST INFRINGEMENT, AND FITNESS +# FOR A PARTICULAR PURPOSE. +# +## +Yet another trace log analysis tool + +$Id$ + + +import datetime, optparse, sys + + + +class Request: + +output_bytes = '-' + +def __init__(self, start, method, url): +self.method = method +self.url = url +self.start = start +self.state = 'input' + +def I(self, input_time, input_bytes): +self.input_time = input_time +self.input_bytes = input_bytes +self.state = 'app' + +def A(self, app_time, response, output_bytes): +self.app_time = app_time +self.response = response +self.output_bytes = output_bytes +self.state = 'output' + +def E(self, end): +self.end = end + +@property +def app_seconds(self): +return (self.app_time - self.input_time).seconds + +@property +def total_seconds(self): +return (self.end - self.start).seconds + +def parsedt(s): +date, time = s.split('T') +return datetime.datetime(*( +map(int, date.split('-')) ++ +map(int, time.split(':')) +)) + +def main(args=None): +if args is None: +args = sys.argv[1:] + +options, args = parser.parse_args(args) +if options.event_log: +restarts = find_restarts(options.event_log) +else: +restarts = [] + +restarts.append(datetime.datetime.utcnow()+datetime.timedelta(1000)) + +[file] = args +lmin = ldt = None +requests = {} +input = apps = output = n = 0 +spr = spa = 0.0 +restart = restarts.pop(0) +for record in open(file): +record = record.split() +typ, rid, dt = record[:3] +min = dt[:-3] +dt = parsedt(dt) +if dt == restart: +continue +while dt restart: +print_app_requests(requests, ldt, + options.old_requests, + options.app_requests, + \nLeft over:) +requests = {} +input = apps = output = n = 0 +spr = spa = 0.0 +restart = restarts.pop(0) +ldt = dt + +if min != lmin: +if lmin is not None: + +print lmin.replace('T', ' '), %4d I=%3d A=%3d O=%3d % ( +len(requests), input, apps, output), +if n: +print N=%4d %10.2f %10.2f % (n, spr/n, spa/n) +else: +print + +if apps options.apps: +print_app_requests(requests, dt, + options.old_requests, + options.app_requests, + ) +lmin = min +spr = 0.0 +spa = 0.0 +n = 0 + +if typ == 'B': +input += 1 +requests[rid] = Request(dt, *record[3:5]) +elif typ == 'I': +if rid in requests: +input -= 1 +apps += 1 +requests[rid].I(dt, record[3]) +elif typ == 'A': +if rid in requests: +apps -= 1 +output += 1 +requests[rid].A(dt, *record[3:5]) +elif typ == 'E': +if rid in requests: +output -= 1 +request = requests.pop(rid) +request.E(dt) +spr += request.total_seconds +spa += request.app_seconds +n += 1 +else: +print 'WTF', record + +print_app_requests(requests, dt, + options.old_requests, + options.app_requests, + Left over:) + +def find_restarts(event_log): +result = [] +for l in open(event_log): +if l.strip().endswith(Zope Ready to handle requests): +
[Zope-dev] Zope tests: 8 OK
Summary of messages to the zope-tests list. Period Mon Jan 23 12:01:02 2006 UTC to Tue Jan 24 12:01:02 2006 UTC. There were 8 messages: 8 from Zope Unit Tests. Tests passed OK --- Subject: OK : Zope-2_6-branch Python-2.1.3 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:02:48 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004082.html Subject: OK : Zope-2_6-branch Python-2.3.5 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:04:18 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004083.html Subject: OK : Zope-2_7-branch Python-2.3.5 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:05:48 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004084.html Subject: OK : Zope-2_7-branch Python-2.4.2 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:07:18 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004085.html Subject: OK : Zope-2_8-branch Python-2.3.5 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:08:48 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004086.html Subject: OK : Zope-2_8-branch Python-2.4.2 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:10:19 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004087.html Subject: OK : Zope-2_9-branch Python-2.4.2 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:11:49 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004088.html Subject: OK : Zope-trunk Python-2.4.2 : Linux From: Zope Unit Tests Date: Mon Jan 23 21:13:19 EST 2006 URL: http://mail.zope.org/pipermail/zope-tests/2006-January/004089.html ___ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
[Zope-dev] Zope - PERFORMANCE PROBLEMS
Dear Sir/Madam! I'm writing on behalf of KFKI ISYS Information Systems Ltd. which is themost decisivepart of the biggest system integratorcompany in Hungary. We have a client where we have used Zope Application Serversince 1st of January 2004.We madea continuousexpansion in last 2 yearsso at the moment we have more than 100 users who use the system day by day. Related to this big user number we blundered a big performance problem which couldn't be solved by ourselves,so we needa person who is very expert in Zope andhas a lot of experiences in the fine tuning and parameteringof Zope. This situation is a really big problem to our client and for us, so weneedanemergency help- personal consultancy or support -A.S.A.P. Please send me yoursuggestions how we can get in. Some additional information about our environment: Apache: Apache/1.3.27 (Linux/SuSE) Zope: (Zope 2.6.1 (source release, python 2.1, linux2) [SuSE Linux], python 2.1.3, linux2) PsyCopg: 1.1.12 Python: 2.1.3 (#1, Mar 28 2003, 06:28:54) [GCC 3.3 20030226 (prerelease) (SuSE Linux)] FastCGI: 2.4.0 PostGreSQL: (PostgreSQL) 7.3.9 SERVER Configuration: SuSE Linux 8.2, RAM 1 GByte, 2,4 GHz I'm waiting for your response. Yours Sincerely, Zoltán PINCZÉS Project Manager KFKI ISYS Information Systems Ltd. H-1134 Budapest, HungaryTüzér utca 39-41 Phone: +36-1-452-1311, +36-1-452-1300 Fax: +36-1-236-6790 Mobile: +36-70-452-1302 E-mail: [EMAIL PROTECTED] ___ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope-dev] Zope - PERFORMANCE PROBLEMS
V-Bári Béla wrote at 2006-1-24 17:41 +0100:-A ... Related to this big user number we blundered a big performance problem which couldn't be solved by ourselves, so we need a person who is very expert in Zope and has a lot of experiences in the fine tuning and parametering of Zope. This situation is a really big problem to our client and for us, so we need an emergency help - personal consultancy or support - A.S.A.P. Please send me your suggestions how we can get in. Use a profiler (e.g. ZopeProfiler) to find out where the time is spent... -- Dieter ___ Zope-Dev maillist - Zope-Dev@zope.org http://mail.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope )
Re: [Zope] nxmldocument product and zope 2.8.1
[EMAIL PROTECTED] wrote: mod = imp.load_module(modname, None, found, ('.dll', 'rb', imp.C_EXTENSION)) ImportError: DLL load failed: The specified procedure could not be found. Looks like nXMLDocument is expecting a procedure that isn't in the DLL it's found. Incorrect version of the DLL? cheers, Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] TinyMCE
Garito wrote: Don't like kupu because is very difficult to install and very very difficult to use I find that a suprising statement... What problems did you experience? cheers, Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] 2.8.5/Win32 image opening error
Hi, I installed Zope 2.8.5 for Windows (to use with Plone, moving from 2.7.4). I cannot start Zope in debug mode since I get errors about missing images. At least SiteErrorLog and OFSP complains about missing icons, though files are there. Looks like Zope just can't find them. IOError: [Errno 2] No such file or directory: 'images/version.gif' This happens on two machines I have tested. I might be doing something wrong in my setup/installation, but don't know what. Any hints to fix it? -Mikko Stdout: NOTICE global_symbols.py:22:Tue Jan 24 12:55:30 2006: 'Starting C:\\runtime- workspace\\hrm\\Data\\Products\\GroupUserFolder at 4 debug level' 2006-01-24 12:55:30 WARNING Init Class Products.GroupUserFolder.GroupUserFolder. GroupUserFolder has a security declaration for nonexistent method 'isLUFMappingCorrect' 2006-01-24 12:55:30 WARNING Init Class Products.GroupUserFolder.GroupUserFolder. GroupUserFolder has a security declaration for nonexistent method 'isLUFMappingCorrect' 2006-01-24 12:55:30 ERROR Zope Could not import Products.OFSP Traceback (most recent call last): File C:\runtime-workspace\hrm\Zope\lib\python\OFS\Application.py, line 698, in import_product product=__import__(pname, global_dict, global_dict, silly) File C:\runtime-workspace\hrm\Zope\lib\python\Products\OFSP\__init__.py, line 43, in ? misc_={ File C:\runtime-workspace\hrm\Python\Lib\site-packages\PIL\ImageFile.py, line 70, in __init__ self.fp = open(fp, rb) IOError: [Errno 2] No such file or directory: 'images/version.gif' Traceback (most recent call last): File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\Startup\run.py, line 56, in ? run() File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\Startup\run.py, line 21, in run starter.prepare() File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\Startup\__init__.py, line 98, in prepare self.startZope() File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\Startup\__init__.py, line 257, in startZope Zope2.startup() File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\__init__.py, line 47, in startup _startup() File C:\runtime-workspace\hrm\Zope\lib\python\Zope2\App\startup.py, line 45, in startup OFS.Application.import_products() File C:\runtime-workspace\hrm\Zope\lib\python\OFS\Application.py, line 675, in import_products import_product(product_dir, product_name, raise_exc=debug_mode) File C:\runtime-workspace\hrm\Zope\lib\python\OFS\Application.py, line 698, in import_product product=__import__(pname, global_dict, global_dict, silly) File C:\runtime-workspace\hrm\Zope\lib\python\Products\OFSP\__init__.py, line 43, in ? misc_={ File C:\runtime-workspace\hrm\Python\Lib\site-packages\PIL\ImageFile.py, line 70, in __init__ self.fp = open(fp, rb) IOError: [Errno 2] No such file or directory: 'images/version.gif' ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Security issue with manage_page_header
On 1/24/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: My site, including the bug, is currently public and to be demoed in two days. Any assistance or guidance is greatly appreciated. Switch on VerboseSecurity in etc/zope.conf; this will give you much more info on what the security engine state is when denying access. -- Martijn Pieters ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Strange behaviour - 3 links which should be the same don't
On 1/24/06, Sasha Vincic [EMAIL PROTECTED] wrote: Following 3 URLs should return the same content but they don't, why? Without tracebacks we have little to go on to help you. Please provide them. -- Martijn Pieters ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] TinyMCE
Chris Withers escribió: Garito wrote: Don't like kupu because is very difficult to install and very very difficult to use I find that a suprising statement... What problems did you experience? cheers, Chris Hi, Chris! I ask to the list some months ago but no solution was proposed (at least not a good one for me) I try to install it and use but the behavior of kupu is, in my opinion, unacceptable for my needs I'm working on a framework where the most important question is easyness and kupu doesn't meet these condition I need a WYSIWYG editor to override some TextAreaField from Formulator to render WYSIWYG Kupu is hard to install and hard to configure like I need For that, I'm waiting for someone who need something like me or do it for myself when I have a moment free Sorry -- Mis Cosas http://blogs.sistes.net/Garito/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Strange behaviour - 3 links which should be the same don't
On 1/24/06, Martijn Pieters [EMAIL PROTECTED] wrote: On 1/24/06, Sasha Vincic [EMAIL PROTECTED] wrote: Following 3 URLs should return the same content but they don't, why? Without tracebacks we have little to go on to help you. Please provide them. Well I don't have any tracebacks, no errors just different output even though it should be the same dtml method called. It is probably the same method called but on the first link without the trailing / the utf8 encoded content is displayed right but not in the other two links. Seems as if dtml-var abstract is behaving different for the links. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Zope vs Plone: performance issues!
Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. They also have zeo + 2 zope instances running in the same machine. I've never seen this in my life... only 3 machines running 2 zope instances + zeo instance, separately. Do you think Zope(logic)+MySQL(content)+Apache(HTTP server) is better solution than Zope+Plone ??? TIA -- Hugo Ramos - [EMAIL PROTECTED] Senior Zope consultant ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] SSL over Multiple Zope/Plone sites?
HiI've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation:http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server.ThanksMichael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 24 Jan 2006, at 14:30, michael nt milne wrote: Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. You can run SSL on virtual hosts, but Apache cannot present different server certificates to the browser based on virtual hosts. So every virtual host with a hostname that does not match the certificate Apache presents on the IP will produce nasty popup boxes on clients. To prevent those warnings you *must* use separate IPs for every SSL- secured hostname you plan on serving, so the statement one SSL site per IP is basically correct. I don't know if making Zope serve out SSL directly helps that (I doubt it) because I wouldn't consider using it. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
michael nt milne schrieb: Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. Not entirely correct. You can run ssl over VirtualHosts but they have to bind to different IP addresses. NameBasedVHosts (only) cannot serve different ssl-certificates. As said, if you have one IP address per certificate you can easily set up Apache Vhosts as proxy to zope with ssl. HTH Tino Wildenhain ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Jens Vagelpohl schrieb: ... I don't know if making Zope serve out SSL directly helps that (I doubt it) because I wouldn't consider using it. No, it does not. You only add the hassle to deal with nasty zope patches to the scene. Only IP per ssl-host helps :-) Regards Tino ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
Hugo Ramos wrote: Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. They also have zeo + 2 zope instances running in the same machine. I've never seen this in my life... only 3 machines running 2 zope instances + zeo instance, separately. Do you think Zope(logic)+MySQL(content)+Apache(HTTP server) is better solution than Zope+Plone ??? I think the problem has more to do with Plone than with Zope or the ZODB. We have a couple 'barebones' zope applications here that serve public website. Hosting is on a shared server (behind apache) with no zeo, no cache, no tuning, no fancy configuration, and performances are pretty good - even with search. For the record, we've tried Plone on the same server, and even with almost no content, it *is* *very* slow. -- bruno desthuilliers développeur [EMAIL PROTECTED] http://www.modulix.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 24 Jan 2006, at 14:59, Tino Wildenhain wrote: Jens Vagelpohl schrieb: ... I don't know if making Zope serve out SSL directly helps that (I doubt it) because I wouldn't consider using it. No, it does not. You only add the hassle to deal with nasty zope patches to the scene. Only IP per ssl-host helps :-) Yes, the fact that all those make Zope speak HTTPS-solutions consist of patches and hacks is the exact reason why I would never consider them. I wanted to stay polite. ;) jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
bruno desthuilliers wrote: I think the problem has more to do with Plone than with Zope or the ZODB. We have a couple 'barebones' zope applications here that serve public website. Hosting is on a shared server (behind apache) with no zeo, no cache, no tuning, no fancy configuration, and performances are pretty good - even with search. For the record, we've tried Plone on the same server, and even with almost no content, it *is* *very* slow. Me? I couldn't _possibly_ comment ;-) Chris . o O ( me? say Plohn is slow? no... never) -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 24 Jan 2006, at 15:12, michael nt milne wrote: Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts? No I don't. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Hugo Ramos [EMAIL PROTECTED] wrote: Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. They also have zeo + 2 zope instances running in the same machine. I've never seen this in my life... only 3 machines running 2 zope instances + zeo instance, separately. Do you think Zope(logic)+MySQL(content)+Apache(HTTP server) is better solution than Zope+Plone ??? No. That problem is Plone/CMF, and most of the problem is in the skins. It's a combination of how portal_skins work, and the fact that Plones skins are not very optimized. CPS, who also uses portal_skins, are faster than an empty Plone site, for example, but still not as fast as a pure Zope-site can be. Zope 3 and Five both promises to solve that by it's View paradigm, but neither Plone nor CMF uses that fully yet, so if you use a lot of standard products that probably will not help you. I'm not a speed guru, but load balancing with ZEO would probably be the easiest way of improving the performance in this case. That's my guess. -- Lennart Regebro, Nuxeo http://www.nuxeo.com/ CPS Content Management http://www.cps-project.org/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Hugo Ramos [EMAIL PROTECTED] wrote: Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. They also have zeo + 2 zope instances running in the same machine. I've never seen this in my life... only 3 machines running 2 zope instances + zeo instance, separately. Do you think Zope(logic)+MySQL(content)+Apache(HTTP server) is better solution than Zope+Plone ??? Yes! But not good enough. Most performance issues with Plone can be solved by caching. Don't underestimate it. I know some companies that use Plone for content management but push out the content in a very non-Plone way and cache that heavily and you get a great result. But, you're not going to get away from the 10 sec catalog search problem. I doubt a ZCatalog search takes this long. Once in there it should be possible to do a search on millons of bytes of text under 1 sec. I have a ZCatalog instance here with roughly 55,000 cataloged objectindices which corresponds to about 1.3Gb of text data. When the IssueTrackerProduct does a search on this, the function _searchCatalog() does 6 different searches on that catalog each!! and here's a copy of some debug output Search took 0.149714946747 Search took 0.271862030029 Search took 0.0381798744202 Search took 0.0339410305023 Search took 0.0346419811249 Search took 0.0137779712677 Search took 0.0435471534729 It's a 1Gb RAMed, Intel Mobile 1.6Mhz thinkpad laptop!! Conclusion, ZCatalog is very fast and so is a correctly cache-headed website with Squid. TIA -- Hugo Ramos - [EMAIL PROTECTED] Senior Zope consultant ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) -- Peter Bengtsson, work www.fry-it.com home www.peterbe.com hobby www.issuetrackerproduct.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts? On 1/24/06, Jens Vagelpohl [EMAIL PROTECTED] wrote: On 24 Jan 2006, at 14:59, Tino Wildenhain wrote: Jens Vagelpohl schrieb: ... I don't know if making Zope serve out SSL directly helps that (I doubt it) because I wouldn't consider using it. No, it does not. You only add the hassle to deal with nasty zope patches to the scene. Only IP per ssl-host helps :-)Yes, the fact that all those make Zope speak HTTPS-solutions consist of patches and hacks is the exact reason why I would neverconsider them. I wanted to stay polite. ;)jens___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!**(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Indexing files
Hei again. I have installed TextIndexNG and indexed my Zope DTML Methods objects and Zope Files objects, and enabled Document converters (PDF, Word etc.) As indexed attributes I use SearchableText,PrincipiaSearchSource,getFile, but the indexes related to the pdf files are still empty. Is it correct to upload my pdf document as a Zope File object? Thanks, Sune On 21 Jan 2006, at 13:02, Sune Christiansen wrote: Hei All. I have the following problem: I am building up a ZCatalog and indexing my DTML methods. I use the index type ZCTextIndex and the object function PrincipiaSearchSource. It works fine. But when I try to index my Files (type File) with index type ZCTextIndex and the object function SearchableText it finds no words and the index is empty. Am I using the wrong object function? Zope File objects do not support indexing their textual content. You will need to implement your own text retrieval or use some of the other indices out there like Andreas Jung's TextIndexNG which come with suitable modules that can pull text out of various file formats. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Indexing files
--On 24. Januar 2006 16:58:52 +0100 Sune Christiansen [EMAIL PROTECTED] wrote: Hei again. I have installed TextIndexNG and indexed my Zope DTML Methods objects and Zope Files objects, and enabled Document converters (PDF, Word etc.) As indexed attributes I use SearchableText,PrincipiaSearchSource,getFile, but the indexes related to the pdf files are still empty. Is it correct to upload my pdf document as a Zope File object? Is your external PDF converter installed _properly_? -aj pgpXSzHHpLRQd.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
michael nt milne schrieb: Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts? Well to really puzzle you, ssl can work with more then one certificate per IP - but not https (http-ssl). You can work with all protocols (SMTP, IMAP, ...) which support start-tls. However this does not help with your current project and was just a sidenote to be complete. Regards Tino ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
I guess though that the pop-up for the certificate only happens once for each client when they enter the site? On 1/24/06, Jens Vagelpohl [EMAIL PROTECTED] wrote:On 24 Jan 2006, at 15:12, michael nt milne wrote: Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts?No I don't.jens___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!**(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 24 Jan 2006, at 15:46, michael nt milne wrote: On 1/24/06, Jens Vagelpohl [EMAIL PROTECTED] wrote: On 24 Jan 2006, at 15:12, michael nt milne wrote: Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts? No I don't. I guess though that the pop-up for the certificate only happens once for each client when they enter the site? yes jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
standard products that probably will not help you. I'm not a speed guru, but load balancing with ZEO would probably be the easiest way of improving the performance in this case. That's my guess. If he's got a dual cpu'd machine and is running two zeo instances, he's fine unless he's got a ram problem. To be running 2 zeo instances on the same machine, they have to be doing some type of load balancing or faking load balancing so that ea. zeo client can respond to requests. One thing that might help is CRANK up your on disk zeo cache as high as you can afford - it's just disk space. If this hasn't been done, the zeo clients might be spending a lot of time 'requesting' objects from the zeo storage server when you can be caching them on the zeo clients. Some substantial effort would likely be required to optimize the Plone installation. If you choose this route, look at the skins - there's lots, lots of layers, and lots of searches going on you could eliminate or rewrite to be more efficient. If you go down the Zope/MySQL path, this would require some substantial effort also. I would recommend, if you're going to be putting substantial effort into the application, look at a CMF/Five implementation, relying heavily on using the View paradigm Lennart references. Another option, not knowing your technical level, is to implement in Zope 3. I personally am liking Zope 3 alot. IIRC, there is a Zope 3 CMS project out there. Andrew Sawyers ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Use a wildcard certificate, if all of your subdomains on the server belong to a single domain. Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael _ Slobodan Jovcic Teaching Enhancement Center Office of Instructional Development, UCLA (310) 794 2099 ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
ok, they're not technically subdomains but full domains in their own right but served from a single server which has its own domain. Would a wild card work with that? Would the pop-ups still be present when a user enters the site? On 1/24/06, Slobodan Jovcic [EMAIL PROTECTED] wrote: Use a wildcard certificate, if all of your subdomains on the serverbelong to a single domain. Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael_ Slobodan JovcicTeaching Enhancement CenterOffice of Instructional Development, UCLA(310) 794 2099___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!**(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 24 Jan 2006, at 17:31, michael nt milne wrote: ok, they're not technically subdomains but full domains in their own right but served from a single server which has its own domain. Would a wild card work with that? Would the pop-ups still be present when a user enters the site? This will nor work, no. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Um, not really. In order for the wildcard cert e.g. *.mydomain.com to work, all the sites have to be on subdomains like site1.mydomain.com, site2.mydomain.com, etc. It doesn't matter if the sites are on virtual hosts or not. Serving the cert on anything that doesn't end with "mydomain.com" will activate a pop-up.For single-domain certificates, yes, you have to have each domain on a separate IP address.Jovca _Slobodan JovcicTeaching Enhancement CenterOffice of Instructional Development, UCLA(310) 794 2099 On Jan 24, 2006, at 9:31 AM, michael nt milne wrote:ok, they're not technically subdomains but full domains in their own right but served from a single server which has its own domain. Would a wild card work with that? Would the pop-ups still be present when a user enters the site? On 1/24/06, Slobodan Jovcic [EMAIL PROTECTED] wrote: Use a wildcard certificate, if all of your subdomains on the serverbelong to a single domain. Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael_ Slobodan JovcicTeaching Enhancement CenterOffice of Instructional Development, UCLA(310) 794 2099___Zope maillist - Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding! **(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Indexing files
when you say external PDF converter, do you mean the pdf converter I created the pdf file with? I have tried to index a microsoft word file also, but the result is the same: an empty index. - Sune --On 24. Januar 2006 16:58:52 +0100 Sune Christiansen [EMAIL PROTECTED] wrote: Hei again. I have installed TextIndexNG and indexed my Zope DTML Methods objects and Zope Files objects, and enabled Document converters (PDF, Word etc.) As indexed attributes I use SearchableText,PrincipiaSearchSource,getFile, but the indexes related to the pdf files are still empty. Is it correct to upload my pdf document as a Zope File object? Is your external PDF converter installed _properly_? -aj ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
ok, so for single different domains, hosted virtually on one single IP address I will have to brave the SSL pop up occurring when users enter the login area for Plone. I'm only going to have it on the login areas so it's not so bad. Better than having no SSL at all on logon. There must be lots of people running Zope/Plone sites with un-secured logon areas. Really easy to hack and then change the content of the site etc. On 1/24/06, Slobodan Jovcic [EMAIL PROTECTED] wrote: Um, not really. In order for the wildcard cert e.g. *.mydomain.com to work, all the sites have to be on subdomains like site1.mydomain.com, site2.mydomain.com, etc. It doesn't matter if the sites are on virtual hosts or not.Serving the cert on anything that doesn't end with mydomain.com will activate a pop-up.For single-domain certificates, yes, you have to have each domain on a separate IP address. Jovca _Slobodan JovcicTeaching Enhancement CenterOffice of Instructional Development, UCLA(310) 794 2099 On Jan 24, 2006, at 9:31 AM, michael nt milne wrote:ok, they're not technically subdomains but full domains in their own right but served from a single server which has its own domain. Would a wild card work with that? Would the pop-ups still be present when a user enters the site? On 1/24/06, Slobodan Jovcic [EMAIL PROTECTED] wrote: Use a wildcard certificate, if all of your subdomains on the server belong to a single domain. Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael_ Slobodan JovcicTeaching Enhancement CenterOffice of Instructional Development, UCLA(310) 794 2099___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. Setup a rewrite rule in apache for port 443 for mysecure_domain.com You could use a self signed cert to experiment. When user logs in request login page goes to site1 - http://domain_one.com: You would need to make your login go to you login page https://mysecure_domain/site1/login site2 - http://domain_two.com: https://mysecure_domain/site2/login Once logged in goes to whatever you have in your vhm http://www.domain_one.com/site1 in vhm http://www.domain_two.com/site2 in vhm in vhm you'd have: www.domain_one.com /site1 www.mysecure_domain/site1/site1 www.domain_two.com /site2 www.mysecure_domain/site2/site2 The problem here will be the session since when you login secure and switch back to the regular site, your ssl session will expire automatically but you'll need to pass it to nonssl to stay alive when you go back to nonssl. I think a solution might be to store it, go to nonssl and then retreive it when you do your redirect back to non-ssl. I have not tried this yet. Alternatively you could always stay in ssl from that point forward. Any technique from someone on this would be helpful since I am also interested in what possibilities there might be. This should not give you a problem with the cert because identity on cert would match the ip. I think otherwise you are in a situation where you will need a dedicated server setup to have one ip per site and then you can just do a single rewrite per ip or use chained ssl if you have sub domains that you want to tie together under a single cert over one or more ips on one or more servers. Regards, David ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Ok, that's really interesting. Thanks. Yes I could just stay using SSL after the login if there's a problem with going non-sslI understand the setting up the single secure domain bit linked to the IP address but don't quite get how I would link each site's login areas to that? Basically are you saying you would, using re-write rules, just call http://www.plonesiteone.com/login_form - http://mysecure_domain.com/plonesiteone/login_form ?It would be the same Plone login page but just have a different URL in the address bar, a https one? Also would you need to use VHM because I've got Apache virtual hosts set-up without actually doing anything in Zope. As long as VHM is on it is all fine.ThanksMichael On 1/24/06, David Pratt [EMAIL PROTECTED] wrote: I think this should be doable for single cert with multiple domains.Setup you exising ip with one domain (ie. mysecure_domain.com). Get thecert on this domain.Setup a rewrite rule in apache for port 443 for mysecure_domain.com You could use a self signed cert to experiment. When user logs inrequest login page goes tosite1 - http://domain_one.com:You would need to make your login go to you login page https://mysecure_domain/site1/loginsite2 - http://domain_two.com:https://mysecure_domain/site2/login Once logged in goes to whatever you have in your vhmhttp://www.domain_one.com/site1 in vhmhttp://www.domain_two.com/site2 in vhm in vhm you'd have:www.domain_one.com /site1www.mysecure_domain/site1/site1www.domain_two.com /site2www.mysecure_domain/site2/site2The problem here will be the session since when you login secure and switch back to the regular site, your ssl session will expireautomatically but you'll need to pass it to nonssl to stay alive whenyou go back to nonssl. I think a solution might be to store it, go tononssl and then retreive it when you do your redirect back to non-ssl. I have not tried this yet. Alternatively you could always stay in ssl fromthat point forward. Any technique from someone on this would be helpfulsince I am also interested in what possibilities there might be. This should not give you a problem with the cert because identity oncert would match the ip. I think otherwise you are in a situation whereyou will need a dedicated server setup to have one ip per site and then you can just do a single rewrite per ip or use chained ssl if you havesub domains that you want to tie together under a single cert over oneor more ips on one or more servers.Regards,David ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Hi Jens. I tried something similar to this about a year ago as an experiment. I think the problem I had at the time with with session expiring and I was thinking about storing the session data in the database and retrieving it back when user went back to non-ssl. This was a while ago and I did not follow it through at the time. I am use CMF not Plone however. Regards, David Jens Vagelpohl wrote: On 24 Jan 2006, at 18:10, David Pratt wrote: I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. snip Have you tested this? The authentication machinery uses cookies, and the browser will not send cookies that were set by the secure login host to the unsecured sites. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] TinyMCE
Garito wrote: Chris Withers escribió: Garito wrote: Don't like kupu because is very difficult to install and very very difficult to use I find that a suprising statement... What problems did you experience? cheers, Chris Hi, Chris! I ask to the list some months ago but no solution was proposed (at least not a good one for me) I try to install it and use but the behavior of kupu is, in my opinion, unacceptable for my needs I'm working on a framework where the most important question is easyness and kupu doesn't meet these condition I need a WYSIWYG editor to override some TextAreaField from Formulator to render WYSIWYG Kupu is hard to install and hard to configure like I need For that, I'm waiting for someone who need something like me or do it for myself when I have a moment free I think they'd really like details. What problems do you encounter on install? What sort of configuration do you want to do that is difficult? I'm afraid easiness is not set explicitly. --jcc -- Building Websites with Plone http://plonebook.packtpub.com/ Enfold Systems, LLC http://www.enfoldsystems.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Hi Michael. First you need a way to get to the root of your site two different ways. First is using the domain you have your ssl on and the other for your other domain name(s) www.domain_one.com /site1 www.mysecure_domain.com/site1/site1 If you have apache proxy then you can set up yoru ssl on port 443 to secure the domain you have the cert for. Under this domain you can have any number of sites so long as the domain and ip are the same. ie www.mysecure_domain.com/site1 www.mysecure_domain.com/site2 www.mysecure_domain.com/site3 ... So you will be able to get to the same site by either using ie http://www.domain_one.com or https://www.mysecure_domain.com/site1 http://www.domain_two.com or https://www.mysecure_domain.com/site2 http://www.domain_three.com or https://www.mysecure_domain.com/site3 since in VHM they are both pointing to the same root (/site1 ) As far as the login on Plone, I do not use Plone but you would have to modify the zpt and script that calls the login to modify these links to the url to for the other domain. This is where I cannot be sure of what I did a year ago. I know for sure I had not completely worked it through and would need to look at this again. I tried this on CMF. Give me a day or two and I will see if I can locate anything more on this in my stuff. I wish I had a better memory but a year seems like a long time ago. :-) Regards, David michael nt milne wrote: Ok, that's really interesting. Thanks. Yes I could just stay using SSL after the login if there's a problem with going non-ssl I understand the setting up the single secure domain bit linked to the IP address but don't quite get how I would link each site's login areas to that? Basically are you saying you would, using re-write rules, just call http://www.plonesiteone.com/login_form - http://mysecure_domain.com/plonesiteone/login_form ? It would be the same Plone login page but just have a different URL in the address bar, a https one? Also would you need to use VHM because I've got Apache virtual hosts set-up without actually doing anything in Zope. As long as VHM is on it is all fine. Thanks Michael On 1/24/06, *David Pratt* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. Setup a rewrite rule in apache for port 443 for mysecure_domain.com You could use a self signed cert to experiment. When user logs in request login page goes to site1 - http://domain_one.com: You would need to make your login go to you login page https://mysecure_domain/site1/login site2 - http://domain_two.com: https://mysecure_domain/site2/login https://mysecure_domain/site2/login Once logged in goes to whatever you have in your vhm http://www.domain_one.com/site1 in vhm http://www.domain_two.com/site2 in vhm in vhm you'd have: www.domain_one.com /site1 www.mysecure_domain/site1/site1 www.domain_two.com /site2 www.mysecure_domain/site2/site2 The problem here will be the session since when you login secure and switch back to the regular site, your ssl session will expire automatically but you'll need to pass it to nonssl to stay alive when you go back to nonssl. I think a solution might be to store it, go to nonssl and then retreive it when you do your redirect back to non-ssl. I have not tried this yet. Alternatively you could always stay in ssl from that point forward. Any technique from someone on this would be helpful since I am also interested in what possibilities there might be. This should not give you a problem with the cert because identity on cert would match the ip. I think otherwise you are in a situation where you will need a dedicated server setup to have one ip per site and then you can just do a single rewrite per ip or use chained ssl if you have sub domains that you want to tie together under a single cert over one or more ips on one or more servers. Regards, David ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
RE: [Zope] Strange behaviour - 3 links which should be the same don't
Your two busted links work fine in Firefox 1.5. Kaw usa -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sasha Vincic Sent: Tuesday, January 24, 2006 12:19 AM To: zope@zope.org Subject: [Zope] Strange behaviour - 3 links which should be the same don't Hi, Following 3 URLs should return the same content but they don't, why? Link 1 (works) http://reports.eea.eu.int/briefing_2005_3/da Link 2 3 (content borked) http://reports.eea.eu.int/briefing_2005_3/da/ http://reports.eea.eu.int/briefing_2005_3/da/index_html Enviroment: Zope 2.7.3 upgraded from 2.6.4 The objects in the url are from ZClasses and index_html is a DTML Method. If I do abstract.decode() the links would work, but since this is a very OLD site and one of the links works I would like to know why before I start changing couple years old templates. Title and Abstract text are UTF8 encoded in a textfield. ZMI form is UTF8 encoded and looks good when you edit it. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Andrew Sawyers [EMAIL PROTECTED] wrote: If he's got a dual cpu'd machine and is running two zeo instances, he's fine unless he's got a ram problem. To be running 2 zeo instances on the same machine, they have to be doing some type of load balancing or faking load balancing so that ea. zeo client can respond to requests. I totally forgot that he was running ZEO already. That actually makes it even easier. since I was thinking of buying more machines. ;) Processing power is cheap today. Buying another machine (or two) would not cost much, and probably half the processing time (unless there is something actually wrong). As always, profiling is probably a good idea *before* trying to fix performnce problems. ;) -- Lennart Regebro, Nuxeo http://www.nuxeo.com/ CPS Content Management http://www.cps-project.org/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
Michael. I found a bookmark for something that might help. I remember this person had written a bit of a howto on some of this for Plone. His name was Eric Vought and his howto was SSL redirect around March of last year. His document which is now an orphan was at: http://www.diversityink.com/documents/2005/1Q/howto-apache-zope-ssl I don't know where he is any longer but perhaps someone on the plone list could help find the doc or Eric. If you happen to find a copy of the howto somewhere, I would be great if you could send a fresh link to me. I remember communicating with Eric at the time when I was trying to work this out for myself with CMF. Regards, David David Pratt wrote: Hi Michael. First you need a way to get to the root of your site two different ways. First is using the domain you have your ssl on and the other for your other domain name(s) www.domain_one.com /site1 www.mysecure_domain.com/site1/site1 If you have apache proxy then you can set up yoru ssl on port 443 to secure the domain you have the cert for. Under this domain you can have any number of sites so long as the domain and ip are the same. ie www.mysecure_domain.com/site1 www.mysecure_domain.com/site2 www.mysecure_domain.com/site3 ... So you will be able to get to the same site by either using ie http://www.domain_one.com or https://www.mysecure_domain.com/site1 http://www.domain_two.com or https://www.mysecure_domain.com/site2 http://www.domain_three.com or https://www.mysecure_domain.com/site3 since in VHM they are both pointing to the same root (/site1 ) As far as the login on Plone, I do not use Plone but you would have to modify the zpt and script that calls the login to modify these links to the url to for the other domain. This is where I cannot be sure of what I did a year ago. I know for sure I had not completely worked it through and would need to look at this again. I tried this on CMF. Give me a day or two and I will see if I can locate anything more on this in my stuff. I wish I had a better memory but a year seems like a long time ago. :-) Regards, David michael nt milne wrote: Ok, that's really interesting. Thanks. Yes I could just stay using SSL after the login if there's a problem with going non-ssl I understand the setting up the single secure domain bit linked to the IP address but don't quite get how I would link each site's login areas to that? Basically are you saying you would, using re-write rules, just call http://www.plonesiteone.com/login_form - http://mysecure_domain.com/plonesiteone/login_form ? It would be the same Plone login page but just have a different URL in the address bar, a https one? Also would you need to use VHM because I've got Apache virtual hosts set-up without actually doing anything in Zope. As long as VHM is on it is all fine. Thanks Michael On 1/24/06, *David Pratt* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. Setup a rewrite rule in apache for port 443 for mysecure_domain.com You could use a self signed cert to experiment. When user logs in request login page goes to site1 - http://domain_one.com: You would need to make your login go to you login page https://mysecure_domain/site1/login site2 - http://domain_two.com: https://mysecure_domain/site2/login https://mysecure_domain/site2/login Once logged in goes to whatever you have in your vhm http://www.domain_one.com/site1 in vhm http://www.domain_two.com/site2 in vhm in vhm you'd have: www.domain_one.com /site1 www.mysecure_domain/site1/site1 www.domain_two.com /site2 www.mysecure_domain/site2/site2 The problem here will be the session since when you login secure and switch back to the regular site, your ssl session will expire automatically but you'll need to pass it to nonssl to stay alive when you go back to nonssl. I think a solution might be to store it, go to nonssl and then retreive it when you do your redirect back to non-ssl. I have not tried this yet. Alternatively you could always stay in ssl from that point forward. Any technique from someone on this would be helpful since I am also interested in what possibilities there might be. This should not give you a problem with the cert because identity on cert would match the ip. I think otherwise you are in a situation where you will need a dedicated server setup to have one ip per site and then you can just do a single rewrite per ip or use chained ssl if you have sub domains that you want to tie together under a single cert over one or more ips on one or more servers. Regards, David ___ Zope
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Peter Bengtsson [EMAIL PROTECTED] wrote: On 1/24/06, Hugo Ramos [EMAIL PROTECTED] wrote: Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding snip Yes! But not good enough. Most performance issues with Plone can be solved by caching. Don't underestimate it. Yes Plone is slow but with caching you get very good performance. I have boosted performance on plone sites from default 1-3req/s to 100req/s and then it was the bandwith that was the bottleneck. The sites where serving both anonymous and authenticated content. I recommend to check out the CacheFu product and documentation in the collective. /Sasha Lovely Systems - www.lovelysystems.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: SSL over Multiple Zope/Plone sites?
Ok thanks very much for this. Much appreciated. On 1/24/06, michael nt milne [EMAIL PROTECTED] wrote: Would it work if you carried the SSL through and continued the session? On 1/24/06, David Pratt [EMAIL PROTECTED] wrote: Hi Jens. I tried something similar to this about a year ago as an experiment. I think the problem I had at the time with with session expiring and I was thinking about storing the session data in the database and retrieving it back when user went back to non-ssl. This was a while ago and I did not follow it through at the time. I am use CMF not Plone however. Regards, David Jens Vagelpohl wrote: On 24 Jan 2006, at 18:10, David Pratt wrote: I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. snip Have you tested this? The authentication machinery uses cookies, and the browser will not send cookies that were set by the secure login host to the unsecured sites. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Zope vs Plone: performance issues!
Check out CacheFu and it's accompanying tutorial. http://plone.org/products/cachefu http://plone.org/products/cachefu/documentation/how-to/crash-course CacheFu is being used on plone.org at the moment. Neither Zope nor Plone are proper delivery systems, and if you want performance, you should read up on caching. -- Alexander Limi On Tue, 24 Jan 2006 06:08:44 -0800, Hugo Ramos [EMAIL PROTECTED] wrote: Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. They also have zeo + 2 zope instances running in the same machine. I've never seen this in my life... only 3 machines running 2 zope instances + zeo instance, separately. Do you think Zope(logic)+MySQL(content)+Apache(HTTP server) is better solution than Zope+Plone ??? TIA -- Hugo Ramos - [EMAIL PROTECTED] Senior Zope consultant ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) -- _ Alexander Limi · Chief Architect · Plone Solutions · Norway Consulting · Training · Development · http://www.plonesolutions.com _ Plone Co-Founder · http://plone.org · Connecting Content Plone Foundation · http://plone.org/foundation · Protecting Plone ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] [ANN] iungoCMS 06.01
Hi, if you search an fast-and-flexible-and-easy-to-install-and-maintain Zope-based CMS for the typical little website, which is maintained by a little group of people, have a look at iungoCMS... http://www.iungo.org What is iungo? -- Based on the web-application-server Zope iungo provides a solid system to build up object-oriented web-databases, easy-to-use-wikis, content-, document- and knowledge-management-systems. iungo targets users and developers, who trust in the Keep it simple-philosophy and want to maintain control over their work. iungo tries to connect people with information. Features? - - Strict separation of content and application: your content can be moved between different zope-instances and iungo-versions without the fear of breaking anything. - Folderish-Content: In the web all entities are links, not folders, documents or files... no more headaches for users what content-type to use... in the default iungo-install there's only one for all...;) - Placeless-Content: All objects have a unique id (autogenerated per default) and can be moved around within the repository without breaking any links between objects. - KISS (Keep it simple stupid): It's easy to develop a custom layout with a basic knowledge of DTML or ZPT. - Expandable: Create new content-types for webdatabases with some clicks in the ZMI. What's new? --- - iungo is based on the paradigm of placeless content, so all documents can be moved in the hierarchy without breaking any links between documents. iungo now supports and delivers nice bookable urls for all documents, which was an often requested feature for the default-installation. Cheers, Maik ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: Zope vs Plone: performance issues!
On 24 Jan 2006, at 20:36, Alexander Limi wrote: Check out CacheFu and it's accompanying tutorial. http://plone.org/products/cachefu http://plone.org/products/cachefu/documentation/how-to/crash-course CacheFu is being used on plone.org at the moment. Neither Zope nor Plone are proper delivery systems, and if you want performance, you should read up on caching. Zope by itself can be a very capable delivery system. Not sure what you're talking about. It's all about the application you put on top of Zope. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
Hugo Ramos wrote at 2006-1-24 11:08 -0300: ... Let's talk about performance issues... Plone is VERY SLOW responding requests. All content is stored in ZODB objects and zcatalog is used to search. But even if you request the intranet home only, it takes about 10 seconds to load. The hardware is very good and lots of ram is used in the servers. Use a profiler to find out where the time is spent (e.g. ZopeProfiler). Maybe, your site it badly configured (running in debug mode, ZODB cache too small, missing skin cache, ...) -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] 2.8.5/Win32 image opening error
Mikko Ohtamaa wrote at 2006-1-24 11:04 +: I installed Zope 2.8.5 for Windows (to use with Plone, moving from 2.7.4). I cannot start Zope in debug mode since I get errors about missing images. At least SiteErrorLog and OFSP complains about missing icons, though files are there. Looks like Zope just can't find them. IOError: [Errno 2] No such file or directory: 'images/version.gif' Obviously, the file is refered to by a relative pathname and the working directory is not adequate for this relative access. Filesystem objects should always be referenced with absolute pathnames. ... in import_product product=__import__(pname, global_dict, global_dict, silly) File C:\runtime-workspace\hrm\Zope\lib\python\Products\OFSP\__init__.py, line 43, in ? misc_={ File C:\runtime-workspace\hrm\Python\Lib\site-packages\PIL\ImageFile.py, line 70, in __init__ self.fp = open(fp, rb) IOError: [Errno 2] No such file or directory: 'images/version.gif' This looks like an import order problem. Zope has itself an ImageFile module. Apparently, mistakenly, the PIL ImageFile is used instead. And it behaves very differently. Obviously, PIL is before Zope's software home in your PYTHONPATH (aka sys.path). Try to prevent this... -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] repozo problem
Gerhard Schmidt wrote at 2006-1-23 10:59 +0100: I have some problems with repozo. I have setup repozo for backup of our Data.fs about two years ago and it worked without problem until 4 weeks ago. Since than it behaves very strange. I am running repozo with den follwing parameters. /usr/local/bin/python /usr/local/www/Zope/bin/repozo.py -v -z -B -f /data/zope/zeo/var/Data.fs -r /data/share/backup/data.fs/ and I get the following error. ... Traceback (most recent call last): File /usr/local/www/Zope/bin/repozo.py, line 501, in ? main() File /usr/local/www/Zope/bin/repozo.py, line 494, in main do_backup(options) File /usr/local/www/Zope/bin/repozo.py, line 431, in do_backup reposz, reposum = concat(repofiles) File /usr/local/www/Zope/bin/repozo.py, line 248, in concat bytesread += dofile(func, ifp) File /usr/local/www/Zope/bin/repozo.py, line 192, in dofile data = fp.read(todo) File /usr/local/lib/python2.3/gzip.py, line 224, in read self._read(readsize) File /usr/local/lib/python2.3/gzip.py, line 289, in _read self._read_eof() File /usr/local/lib/python2.3/gzip.py, line 308, in _read_eof raise IOError, CRC check failed IOError: CRC check failed Looks as if some of the concated files is corrupted (as seen by a wrong CRC checksum). I would try to discard all incremental backups and make a full one. -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Strange behaviour - 3 links which should be the same don't
Sasha Vincic wrote at 2006-1-24 09:19 +0100: Following 3 URLs should return the same content but they don't, why? Link 1 (works) http://reports.eea.eu.int/briefing_2005_3/da Link 2 3 (content borked) http://reports.eea.eu.int/briefing_2005_3/da/ http://reports.eea.eu.int/briefing_2005_3/da/index_html Enviroment: Zope 2.7.3 upgraded from 2.6.4 The three links may be different with respect to the effective base URL. Look at the HTML source code for the pages and watch out for the base tag in the head of the page. -- Dieter ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
You can have one HTTPS/SSL per IP per port. I use Pound instead of Apache, and can run an instance for each port. I use HTTPS on port 444, and 445 for testing/staging arrangements that match the production HTTPS on 443. I can set up a self-signed or 3rd party certificate for each port, and the domain is set in each new certificate. And simply use a standard web page to redirect to the new HTTPS port. (https://stagingarea.something.com:444/directory) Also, you can use Pound to virtual host SSL sites, but the certificate will not match, and a warning to the user. If you accept the warning, you are secure, but not very friendly. Pound can be found at http://www.pound.ch/pound and is very Zope friendly. This is not a user-friendly solution for production-level sites, but great for staging/testing/experimental/admin needs. Not sure, if this helps, -Jon michael nt milne wrote: Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) -- Jonathan Cyr http://www.cyr.info http://www.weddingweblog.com [EMAIL PROTECTED] ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Hugo Ramos [EMAIL PROTECTED] wrote: Well... They were already using Zope's cache and Squid to proxy some static HTML I guess the problem is Plone itself... Skins etc... As I said and Limi, check out CacheFu. With it you can cache most of your site not just some static HTML and you cache it with Squid so Zope will have more time for the none cachable stuff. Doing profile on your site is something you should always do when optimizing. Follow Dieters recommendation and then CacheFu. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Zope vs Plone: performance issues!
Chris Withers wrote: Me? I couldn't _possibly_ comment ;-) Mr. Chris FU Withers, you might very will think so. -- hilsen/regards Max M, Denmark http://www.mxm.dk/ IT's Mad Science ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Strange behaviour - 3 links which should be the same don't
On 1/24/06, Dieter Maurer [EMAIL PROTECTED] wrote: The three links may be different with respect to the effective base URL. The first two have the same base URL which is the same as second link. The third link doesn't have any base, which is strange. Well I got something more to check then. /S ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
How did you go about caching authenticated content? Any simple personalization element like the user name in the corner disqualifies the whole page from effective participation in downstream proxying/caching. The only thing you can do with such page is to cache it for one particular user hoping that s/he may need the same page again (which is not likely). I have an extreme situation when 90% of visitors are authenticated. Moreover, they participate in dozens of groups that define their access to individual content elements. Users are being granted and revoked participation in groups very actively, it is a normal situation that a few such changes occur within one session. And to finish the picture - publication and access times are important for records purposes so the current server time should be displayed on all pages. I use RAM caches for parts/macros of pages that may be identical for all users or some of the groups. They help, but the performance is still far from being perfect. Any success stories/best practices for such cases? Thanks. zope 2.7.6, plone 2.0.5 (going to upgrade soon), freebsd 4.10 Sasha Vincic wrote: Yes Plone is slow but with caching you get very good performance. I have boosted performance on plone sites from default 1-3req/s to 100req/s and then it was the bandwith that was the bottleneck. The sites where serving both anonymous and authenticated content. I recommend to check out the CacheFu product and documentation in the collective. /Sasha Lovely Systems - www.lovelysystems.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
er Pound can be found at http://www.apsis.ch/pound -Jon Jonathan Cyr wrote: You can have one HTTPS/SSL per IP per port. I use Pound instead of Apache, and can run an instance for each port. I use HTTPS on port 444, and 445 for testing/staging arrangements that match the production HTTPS on 443. I can set up a self-signed or 3rd party certificate for each port, and the domain is set in each new certificate. And simply use a standard web page to redirect to the new HTTPS port. (https://stagingarea.something.com:444/directory) Also, you can use Pound to virtual host SSL sites, but the certificate will not match, and a warning to the user. If you accept the warning, you are secure, but not very friendly. Pound can be found at http://www.pound.ch/pound and is very Zope friendly. This is not a user-friendly solution for production-level sites, but great for staging/testing/experimental/admin needs. Not sure, if this helps, -Jon michael nt milne wrote: Hi I've got a few Plone sites set-up using Apache through Zope. The question is, I'd like to implement SSL on the site login etc, as it's not secure without this. There's also one site I'd like to serve completely over https. However. I'm told that you can't run SSL on virtual hosts and can only have once SSL site per IP address. What would be the way round this? I know I could set-up SSL on Zope only using the following documentation: http://www.zope.org/Members/Ioan/ZopeSSL but if I can't carry this through to Apache then I'd have to run Zope as the web server as well as the application server. Thanks Michael ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) -- Jonathan Cyr http://www.cyr.info http://www.weddingweblog.com [EMAIL PROTECTED] ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] exUserFolder Product Install Problems in Windows XP
Well this is no help, butI havent tried in 6 months, however last time I did, I was not able to run exUserFolder on Zope 2.8.x. It was working fine on 2.7.x though. I never did find what the problem was, and my issue probably has nothing to do with yours, but I thought it was worth mentioning in case it did. Does it work for you in 2.7? Kind of a hassle to test, but if it works, maybe it will help in troubleshooting?GregOn 1/23/06, José Carlos Senciales [EMAIL PROTECTED] wrote:HelloI have downloaded the exUserFolder Product and copy the folder into my directory Products of Zope butwhen restar my zope i found this error:: File C:\Archivos deprograma\Zope-2.8.4-final\lib\python\Products\exUserFolder\AuthSources\etcAuthSource\etcAuthSource.py ,line 124, in ?from Products.exUserFolder.fcrypt.fcrypt import cryptImportError: No module named fcrypt.fcryptanyone know why this is happening? . there is a folder CryptoSources whitthe module fcrypt into, in the exUserFolder Product folder. I have install Zope 2.8.4-final, python 2.3.5, win32I´m working in Windows XP SP2.Thanks.___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!**(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )-- Greg Fischer1st Byte Solutionshttp://www.1stbyte.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] TinyMCE
J Cameron Cooper escribió: Garito wrote: Chris Withers escribió: Garito wrote: Don't like kupu because is very difficult to install and very very difficult to use I find that a suprising statement... What problems did you experience? cheers, Chris Hi, Chris! I ask to the list some months ago but no solution was proposed (at least not a good one for me) I try to install it and use but the behavior of kupu is, in my opinion, unacceptable for my needs I'm working on a framework where the most important question is easyness and kupu doesn't meet these condition I need a WYSIWYG editor to override some TextAreaField from Formulator to render WYSIWYG Kupu is hard to install and hard to configure like I need For that, I'm waiting for someone who need something like me or do it for myself when I have a moment free I think they'd really like details. What problems do you encounter on install? What sort of configuration do you want to do that is difficult? I'm afraid easiness is not set explicitly. --jcc I have some problems to create a data-centric kupu The default behaviour is to edit a page with the editor but I need to use kupu on a form, perhaps with more than one editor per form I think I can use kupu data-centered instead of page-centered isn't it? Thanks! -- Mis Cosas http://blogs.sistes.net/Garito/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
I'm no expert in this realm, but: Find Chris M's presentation on scaling zope, somewhere on plope.com. It doesn't go into great detail on this topic, but basically, IIRC the strategy is to push personalization (and final page composition) downstream. This generally means either: - Squid and ESI - client-side (javascript) Then the parts of the page that are *not* personalized can still be cached very effectively by squid, and you greatly reduce the load on zope. The JS approach may allow for browser-side caching of (some of) the personalization data, if it can be re-used across pages. -PW On Tue, Jan 24, 2006 at 11:27:39PM +0100, Michael Vartanyan wrote: How did you go about caching authenticated content? Any simple personalization element like the user name in the corner disqualifies the whole page from effective participation in downstream proxying/caching. The only thing you can do with such page is to cache it for one particular user hoping that s/he may need the same page again (which is not likely). I have an extreme situation when 90% of visitors are authenticated. Moreover, they participate in dozens of groups that define their access to individual content elements. Users are being granted and revoked participation in groups very actively, it is a normal situation that a few such changes occur within one session. And to finish the picture - publication and access times are important for records purposes so the current server time should be displayed on all pages. I use RAM caches for parts/macros of pages that may be identical for all users or some of the groups. They help, but the performance is still far from being perfect. Any success stories/best practices for such cases? Thanks. zope 2.7.6, plone 2.0.5 (going to upgrade soon), freebsd 4.10 Sasha Vincic wrote: Yes Plone is slow but with caching you get very good performance. I have boosted performance on plone sites from default 1-3req/s to 100req/s and then it was the bandwith that was the bottleneck. The sites where serving both anonymous and authenticated content. I recommend to check out the CacheFu product and documentation in the collective. /Sasha Lovely Systems - www.lovelysystems.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) -- Paul Winkler http://www.slinkp.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
On 1/24/06, Michael Vartanyan [EMAIL PROTECTED] wrote: How did you go about caching authenticated content? Any simple personalization element like the user name in the corner disqualifies the whole page from effective participation in downstream proxying/caching. The only thing you can do with such page is to cache it for one particular user hoping that s/he may need the same page again (which is not likely). Well I did cache the page for each user, because most of the content on a site isn't that dynamic that has to be reloaded every second. Should content on a page change you invalid them for everyone. Even if the cache is for short period it's worth it. How: I used CacheFu and the description there. And to finish the picture - publication and access times are important for records purposes so the current server time should be displayed on all pages. Well this is a problem, here you have something that invalidates the page every second or at least minut, but still caching one minute is worth alot on an active site. There are probably ways to do this with JS so it's on the client side instead but then you can't be 100% that it's the same time as on server but it shouldn't diff that much if you initiate the JS with right time. If your dynamic parts are not to complicated I would consider Squid3 and ESI. /Sasha ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: SSL over Multiple Zope/Plone sites?
Would it work if you carried the SSL through and continued the session? On 1/24/06, David Pratt [EMAIL PROTECTED] wrote: Hi Jens. I tried something similar to this about a year ago as an experiment. I think the problem I had at the time with with session expiring and I was thinking about storing the session data in the database and retrieving it back when user went back to non-ssl. This was a while ago and I did not follow it through at the time. I am use CMF not Plone however. Regards, David Jens Vagelpohl wrote: On 24 Jan 2006, at 18:10, David Pratt wrote: I think this should be doable for single cert with multiple domains. Setup you exising ip with one domain (ie. mysecure_domain.com). Get the cert on this domain. snip Have you tested this? The authentication machinery uses cookies, and the browser will not send cookies that were set by the secure login host to the unsecured sites. jens ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Zope vs Plone: performance issues!
Well... They were already using Zope's cache and Squid to proxy some static HTML I guess the problem is Plone itself... Skins etc... On 1/24/06, Sasha Vincic [EMAIL PROTECTED] wrote: On 1/24/06, Peter Bengtsson [EMAIL PROTECTED] wrote: On 1/24/06, Hugo Ramos [EMAIL PROTECTED] wrote: Hi all, I'm responsible for a big corporate intranet and corporate portal. They were using Zope/Plone before I got here and the problems are too many. Let's talk about performance issues... Plone is VERY SLOW responding snip Yes! But not good enough. Most performance issues with Plone can be solved by caching. Don't underestimate it. Yes Plone is slow but with caching you get very good performance. I have boosted performance on plone sites from default 1-3req/s to 100req/s and then it was the bandwith that was the bottleneck. The sites where serving both anonymous and authenticated content. I recommend to check out the CacheFu product and documentation in the collective. /Sasha Lovely Systems - www.lovelysystems.com -- Hugo Ramos - [EMAIL PROTECTED] http://otugga.blogspot.com/ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] SSL over Multiple Zope/Plone sites?
On 1/24/06, michael nt milne [EMAIL PROTECTED] wrote: Ok, thanks. The annoying thing is that I am renting a virtual dedicated server which allows multiple domain names obviously but not multiple IP addresses. Or it probably costs more for that. Do you reckon SSL will ever be available for virtual single IP based hosts? I believe you can use SSL and name based virtual hosts if you use unique ports for each vhost. I've never done it myself, but I remember reading that somewhere in Apache documentation that it was possible. Jeff D ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] exUserFolder Product Install Problems in Windows XP
Thanks but Andrew Milton send me a mail to try with the CVS copy and in the CVS version this problem is fixed and the product work properly with my Win XP and Zope 2.8. Thanks. Jose Carlos - Original Message - From: Greg Fischer To: José Carlos Senciales Cc: zope@zope.org Sent: Tuesday, January 24, 2006 11:45 PM Subject: Re: [Zope] exUserFolder Product Install Problems in Windows XP Well this is no help, butI havent tried in 6 months, however last time I did, I was not able to run exUserFolder on Zope 2.8.x. It was working fine on 2.7.x though. I never did find what the problem was, and my issue probably has nothing to do with yours, but I thought it was worth mentioning in case it did. Does it work for you in 2.7? Kind of a hassle to test, but if it works, maybe it will help in troubleshooting?Greg On 1/23/06, José Carlos Senciales [EMAIL PROTECTED] wrote: HelloI have downloaded the exUserFolder Product and copy the folder into my directory Products of Zope butwhen restar my zope i found this error::File "C:\Archivos deprograma\Zope-2.8.4-final\lib\python\Products\exUserFolder\AuthSources\etcAuthSource\etcAuthSource.py ",line 124, in ?from Products.exUserFolder.fcrypt.fcrypt import cryptImportError: No module named fcrypt.fcryptanyone know why this is happening? . there is a folder CryptoSources whitthe module fcrypt into, in the exUserFolder Product folder. I have install Zope 2.8.4-final, python 2.3.5, win32I´m working in Windows XP SP2.Thanks.___Zope maillist- Zope@zope.orghttp://mail.zope.org/mailman/listinfo/zope** No cross posts or HTML encoding!**(Related lists -http://mail.zope.org/mailman/listinfo/zope-announcehttp://mail.zope.org/mailman/listinfo/zope-dev )-- Greg Fischer1st Byte Solutionshttp://www.1stbyte.com ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope-DB] Warnings from mxODBC in 2.8.5
M.-A. Lemburg wrote: Well, given that in Zope 2.9.0 it also doesn't catch the following warning that you get on startup: /home/lemburg/zope/Zope-2.9.0/lib/python/App/ImageFile.py:21: DeprecationWarning: Using OFS.content_types is deprecated (will be removed in Zope 2.11). Instead use zope.app.contenttypes. from OFS.content_types import guess_content_type Did you put in a specific warn filter for this? this doesn't sound surprising. Perhaps there's a bug in the Zope filter code ?! Well, the above was a bug that I think has already been fixed... I haven't seen it though, as it's only in 2.9 and we're using 2.8 Our next version will only be available for Zope 2.7 onwards and will remove much of the old-style interface logic which we still have to keep around for backwards compatibility reasons. When's this due to land? Sorry, but we don't have an ETA yet. *sulk* ;-) Chris -- Simplistix - Content Management, Zope Python Consulting - http://www.simplistix.co.uk ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
Re: [Zope-DB] Warnings from mxODBC in 2.8.5
Chris Withers wrote: M.-A. Lemburg wrote: Well, given that in Zope 2.9.0 it also doesn't catch the following warning that you get on startup: /home/lemburg/zope/Zope-2.9.0/lib/python/App/ImageFile.py:21: DeprecationWarning: Using OFS.content_types is deprecated (will be removed in Zope 2.11). Instead use zope.app.contenttypes. from OFS.content_types import guess_content_type Did you put in a specific warn filter for this? Yes, one that's supposed to catch exceptions.DeprecationWarning (basically, I just uncommented the example in the zope.conf file). this doesn't sound surprising. Perhaps there's a bug in the Zope filter code ?! Well, the above was a bug that I think has already been fixed... I haven't seen it though, as it's only in 2.9 and we're using 2.8 -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Jan 24 2006) Python/Zope Consulting and Support ...http://www.egenix.com/ mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ mxODBC, mxDateTime, mxTextTools ...http://python.egenix.com/ ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db
[Zope-DB] Ape, postgresql and plone: UnmanagedJar instance and 'exportFile' attribute errors
Ape 1.0 is set to store in postgresql 7.4.6. Things seem work fine until I go to add a Plone Site in the ZMI. The following error shows up in the main html frame: Error Type: AttributeError Error Value: UnmanagedJar instance has no attribute 'exportFile' and the following in $INSTANCEROOT/log (snipped out all the upgrading messages) ... 2006-01-24T16:12:31 INFO(0) Plone Upgrade to: 2.0.5, completed -- 2006-01-24T16:12:31 INFO(0) Plone Attempting to upgrade from: 2.0.5 -- 2006-01-24T16:12:31 ERROR(200) Plone Upgrade aborted -- 2006-01-24T16:12:31 ERROR(200) Plone Error type: exceptions.AttributeError -- 2006-01-24T16:12:31 ERROR(200) Plone Error value: UnmanagedJar instance has no attribute 'exportFile' -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/CMFPlone/MigrationTool.py, line 274, in upgrade newv, msgs = self._upgrade(newv) -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/CMFPlone/MigrationTool.py, line 371, in _upgrade res = function(self.aq_parent) -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/CMFPlone/migrations/v2_1/alphas.py, line 29, in two05_alpha1 convertPloneFTIToCMFDynamicViewFTI(portal, out) -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/CMFPlone/migrations/v2_1/alphas.py, line 1264, in convertPloneFTIToCMF DynamicViewFTI migrateFTI(portal, 'Plone Site', name, fti_meta_type) -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/CMFDynamicViewFTI/migrate.py, line 41, in migrateFTI actions.append(action._getCopy(action)) -- 2006-01-24T16:12:31 ERROR(200) Plone File /var/zope-2.7.8/Products/Ape/lib/apelib/zope2/setup/patches.py, line 29, in _getCopy return self._real_getCopy(container) -- 2006-01-24T16:12:31 ERROR(200) Plone File /usr/local/zope-2.7.8/lib/python/OFS/CopySupport.py, line 458, in _getCopy self._p_jar.exportFile(self._p_oid,f) Is there some zope add on product that offers 'exportFile'? Or is it just no implemented in Ape? -- Jeff Macfarland ([EMAIL PROTECTED]) GPG Key ID: 0x5F1CA61B GPG Key Server: hkp://wwwkeys.pgp.net ___ Zope-DB mailing list Zope-DB@zope.org http://mail.zope.org/mailman/listinfo/zope-db