September 2007 - Zope

Re: [Zope] convert python to dtml
by Jaroslav Lukesh 06 Aug '09

06 Aug '09

> Odesílatel: Exteam <exteam6(a)yahoo.co.in> > hi all, > i'm stuck at this point, > can some one convert thge following python code in to > dtml & help me. > i'm not able to convert it in to dtml. Why do you want to recode into DTML? I think that is piece of good code and much faster than DTML. You could try following replacing (original line of your code, follows with DTML code), but not tested: > rec = context.test_select_sql() <dtml-call "REQUEST.set(rec , test_select_sql())"> > print "Fields definitions" Fields definitions > recordset = rec.dictionaries() <dtml-let "recordset = rec.dictionaries()" > rownum = 1 <dtml-call "REQUEST.set(rownum,1)" > for record in recordset: <dtml-in recordset> > print "Row %d" % (rownum), "check", record Row <dtml-var rownum>, check <drml-var sequence-item><br> > rownum = rownum + 1 <dtml-call "REQUEST.set(rownum,rownum+1)" </dtml-in> and so on on the rest of code. > for key in record.keys(): > print key, "=", record[key] > print "-" * 80 > return printed

3 7

read-only-database
by Ulla Theiss 17 Mar '09

17 Mar '09

Hello list, I want to run the database in read-only mode from CD and configured it accordingly in the zope.conf: read-only-database on enable-product-installation off zserver-read-only-mode on Starting Zope, I get the following error: Traceback (most recent call last): File "\Programme\Zope\lib\python\Zope2\Startup\run.py", line 56, in ? run() File "\Programme\Zope\lib\python\Zope2\Startup\run.py", line 21, in run starter.prepare() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 98, in pre pare self.startZope() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 257, in st artZope Zope2.startup() File "E:\Programme\Zope\lib\python\Zope2\Startup\__init__.py", line 47, in sta rtup starter.setConfiguration(cfg) File "D:\Programme\Zope\lib\python\Zope2\App\startup.py", line 56, in startup File "D:\Programme\Zope\lib\python\DBTab\DBTab.py", line 96, in getDatabase File "D:\Programme\Zope\lib\python\DBTab\DBTab.py", line 113, in _createDataba se File "E:\Programme\Zope\lib\python\Zope2\Startup\datatypes.py", line 163, in o pen DB = self.createDB() File "E:\Programme\Zope\lib\python\Zope2\Startup\datatypes.py", line 160, in c reateDB return ZODBDatabase.open(self) File "D:\Programme\Zope\lib\python\ZODB\config.py", line 97, in open File "D:\Programme\Zope\lib\python\ZODB\config.py", line 133, in open File "D:\Programme\Zope\lib\python\ZODB\FileStorage\FileStorage.py", line 112, in __init__ File "D:\Programme\Zope\lib\python\ZODB\lock_file.py", line 57, in __init__ IOError: [Errno 13] Permission denied: '\\Zope-Instance/var/Data.fs.lock' r+ means opening the file for updating. This has not to do anything with read-only. Does anybody know what I have to configure additionaly, that read-only works? I run Zope 2.8.4 on windows. Many thanks in advance, Ulla.

4 6

Re: [Zope] Squid & ESI
by Chris Withers 01 Jun '08

01 Jun '08

Alan Milligan wrote: > We haven't had any problems in building Squid-3.x images ...with ESI enabled? > I've also heard of at least one other abandoned Squid3 rollout, and it's > quite possible that without Robert's participation, Squid3 isn't really > production strength. Yup, that and Squid 3's "not production quality" status makes the whole Squid/ESI thing a total non-starter, which is a shame... ...but I do wish, as a result, that people would stop touting it as a way to scale Zope apps. cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

6 7

python function to know the total number of records in a catalog object
by kamal hamzat 15 Oct '07

15 Oct '07

Hi, I need a python script or function to get the total number of records in a zcatalog. Thanks Kamal

2 3

[WARNING] Garbage collection may be disruptive
by Dieter Maurer 03 Oct '07

03 Oct '07

We currently face a strange problem in a high performance Zope setup. Its features are special such that not all of you may fear to face the same problem: The setup consists of a large number of Zope instances all talking to a ZEO. Almost every non-trivial request (all requests not delivering static content) write to the ZODB. This means, we are using the ZODB in a high frequency write szenario -- one, it has not been designed for. The problem: ZEO reports large amounts of "client blocked" occurrencies *BUT* neither the IO nor the CPU on the ZEO host is utilized significantly. This implies that it is not ZEO which is the bottleneck but the ZEO clients. Up to yesterday, I was extremely puzzled by the behaviour of the ZEO clients (i.e. the Zope processes). Usually, they worked quick and reliably but occasionally, everything and especially the IO seemed extremely slow. I added log messages to prominent IO operations and could (e.g.) see occational times for "stat" in the order of 5 to 20 s. The system is complex and there are many possible causes for such desastrous behaviour. One may be problems with the IO subsystem. Our administrators told me they could not see any unusual load on the IO subsystem. But, for them, too, the system is complex. I knew that the strange timings could mean two things: the IO is really that slow or the measurement is flawed. But all measurements went into the same direction. But all measurements used Python.... And this could mean that the Python thread scheduling (controlled by the GIL) is extremely distorted -- distorted in the order of 10 to 20 s. Yesterday (far too late), I decided to prove whether or not there are scheduling distortions. I put another thread in the Zope processes, scheduled periodically, which complains when there is too much discrepancy between the expected and the observed scheduling time. The thread proved: there are scheduling distortions at least in the order of 5 s. Next question: why? This morning I found a candidate: Python's garbage collector. Of course, it holds the GIL (and prevents Python thread scheduling) while it runs. From the documentation, I had the impression that it should be efficient and quick, even for full (generation 2) garbage collections -- but who knows. I disabled automatic garbage collection and replaced it with a peridic call to "gc.collect", logging the executions times. The times started with 0.6s but meanwhile increased to 1.9 s per run and I expect they will easily grow further until 5 to 6 s per run.... Moreover, scheduling distortions are reported precisely when the garbage collector runs... Usually, occasional garbage collection times of 5 to 6 s are not so problematic -- provided that they are not so frequent that they severely interfere with transaction commits. In our case, they do interfere with transaction commits and can severely slow down the complete ZEO client farm due to contention for the commit lock. The reason is a broken TextIndex implementation -- again maybe special for our installation. The aim of this message: should you see strangely behaving ZEO clients and lots of unexplainable "clients blocked" in your ZEO logfile, you may think of scheduling distortions caused by Python's garbage collector. -- Dieter

2 2

Problems with my ZMI
by Ken Winter 02 Oct '07

02 Oct '07

A year or so after installing this installation of Zope, I'm suddenly having trouble opening Python Scripts and Page Templates for editing in my ZMI. (Zope 2.9.6-final, python 2.4.3, win32.) Specifically: 1. When I click on the name of a script, I get this message: Site error This site encountered an error trying to fulfill your request. The errors were: Error Type IndexError Error Value string index out of range Request made at 2007/09/27 17:06:33.640 GMT-4 2. When I click on the name of a Template, the template's Edit tab opens, but the field containing the template body is shrunk to its minimal size (3 rows high x a few characters wide). An attempt to fix this by hitting (for example) the "Wider" button evokes: Site error This site encountered an error trying to fulfill your request. The errors were: Error Type ValueError Error Value invalid literal for int(): Request made at 2007/09/27 17:11:33.375 GMT-4 Restarting Zope doesn't help. Any fix for this? (Preferably a fix that don't involve reinstalling Zope and everything else built upon it.) In the meantime, any workarounds that will enable me to edit my objects? ~ TIA ~ Ken

3 4

tunneling via ...
by David Bear 01 Oct '07

01 Oct '07

I am in a situation will I may soon need to outsource the running of my apache server. This may be a good thing. However, I cannot outsource the running of my zope server. So I have the situation where apache will be running on a separate box from my zope server and I am wondering how to make sure I have a secure connection between the apache server that I don't control that will be using modproxy/rewrite rules to get content out of my zope server. Currently, zope only binds to 127.0.0.1 and apacy proxy connects. Using a remote apache server implies that I will need to have zope listen on a public interface. However, I will still need to secure it so I was considering openssl or something like that. in short I have APACHE HOST <------------------> ZOPE HOST I need to secure the connection between these two hosts. Any recommendations? -- David Bear phone: 602-496-0424 fax: 602-496-0955 College of Public Programs/ASU University Center Rm 622 411 N Central Phoenix, AZ 85007-0685 "Beware the IP portfolio, everyone will be suspect of trespassing"

4 3

ANN: Generating svn:externals by inspecting a repository - z3c.repoexternals
by Ross Patterson 30 Sep '07

30 Sep '07

z3c.repoexternals recursively retrieves subversion directory listings from the url or path and matches directories against a previous set of svn:externals if provided then against regular expressions and generates qualifying svn:externals lines. The defaults generate a set of svn:externals for all the trunks in a repository and keeps them up to date with the repository as new trunks are added when the previous externals are provided thereafter. http://cheeseshop.python.org/pypi/z3c.repoexternals Ross

1 0

Upload to database from a table
by Inspire 30 Sep '07

30 Sep '07

To update one entry into the database from the browser is straight-forward. I have not worked out how to enter multiple transaction yet. My stop gap solution is to enter such data; in this case issuing items from a store, from Paradox directly into the database (Postgres). It is probably pushing the boundary of Zope, however it would help if a searchable list of the store items are presented and the issue quantity can be inserted along side of the item. My Paradox input displays the item and its category with it sorted by category and subsorted by item. Any ideas out there thanks Max

2 1

FSDump for Controller Page Templates metadata
by Chris Crownhart 29 Sep '07

29 Sep '07

Hello, I have a bunch of pages/scripts that I'm trying to dump to the filesystem with FSDump. I have the latest version of FSDump, 0.9.3, and Zope 2.7.8. The dump includes all the files, and creates all the .metadata files, but the .metadata files only have the [default] section in them. They do not include [validators] or [actions]. Is there a way to get that information dumped for controller page templates? Thanks, Chris

2 1