June 2004 - Zope - Zope lists

Problem: Call Zope and wait for user input from another server ...
by Eddie Moench 08 Jun '04

08 Jun '04

Hello all, We have the problem that we need to call Zope from a middleware server written in Java, present a web page with forms to the user, wait for the input from the user and then give the filled forms back. The problem with a simple URL-call is that when we call the forms page we for sure get only the empty forms page back. But we need the user input, thus the action-page of the forms-page. Does anyone have an idea how to solve such a problem? Cheers, Eddie. -- Dipl. Wi.-Ing. Eddie Moench Director Web-Application-Development, ontoprise GmbH

2 1

Zope memory problem
by Tim Edwards 08 Jun '04

08 Jun '04

Hi, We have a Zope 2.6.2 server running on a Windows 2000 Server with 1.5GB of RAM running an application that connects to an SQL Server database. We have found that the Zope service (python.exe) continually builds up RAM usage until it finally crashes. After restarting the service it rapidly builds up to 20-50MB. Within a day or 2 it will reach 200MB and after a week or 2 it will reach a little over 1GB (often after or during a period of heavy usage) and will crash and have to be restarted. It never seems to go down - even during quiet times when no one is using the system it doesn't release any memory, the memory usage of the Python process just keeps climbing. Any ideas why this could be so? (The application uses external methods to create objects of classes and return them to be used in the ZPT) Tim Edwards Trainee Analyst Programmer Henry Walker Eltin Phone: 02 9887 6393 Email: tim.edwards(a)hwe.com.au

2 1

Accessing sys.exc_info() from python script
by Jim Cain 08 Jun '04

08 Jun '04

I need access to error info inside of an except in a Python script. How do I get that? Specifically, I'm executing an Oracle stored procedure, and if I catch an exception, I want to include the error message in the return value. Here's a greatly simplified example using sys.exc_info if I could actually import and use it: import sys try: context.my_proc print 'OK' except: print 'Error: ' + sys.exc_info()[1] return printed Is there a Zope-ish way to access the info returned by exc_info()? Thanks, Jim

3 2

Updating Caches
by Tiller, Michael (M.M.) 08 Jun '04

08 Jun '04

I've got a site that I've spent some time on optimizing. I have used both Ram caches and a proxy cache (in front of the site). My problem is that the site is not accessed very often. As a result, the caches are often empty when somebody happens to hit the site and then they pay the cost of filling the caches. How do people normally handle this? Is it possible to some how "schedule" a request in Zope to make sure that the caches are always filled? In order to fill the proxy server caches, I suppose the request has to originate from outside of Zope? Anyway, I'd be interested in hearing if other people have these kinds of issues and what they do about them. Thanks. -- Mike

4 3

Upgrade 2.6 to 2.7 broke PythonScript access to ZSQL results
by Brad Clements 08 Jun '04

08 Jun '04

(also see new information at the bottom) Hi all, I've upgraded a Zope instance from 2.6 to 2.7.0 and now Pythonscripts cannot access attributes of ZSQL_Method results. Even when logged in with the manager role, I get an unauthorized exception. This doesn't seem to be a binding/context security issue. I'm using gvibDA 0-9-7 on Python 2.3.3 RedHat Linux 8 As Manager, for example, I can test this ZSQL_Method: --- SQL_Get_User -- select userid as username,userpassword,userrole,orgid,peopleid from People where userid = <dtml-sqlvar username type=string> -- I can use the test tab and lookup userid 'brad' and I get the results I expect. The SQL_Get_User ZSQL_Method is in the same folder as my acl_users folder. Also in this folder is the PythonScript GetOrgId. --- r = context.SQL_Get_User(username=username) if not r: return '' return r[0].orgid -- (I get the same error if I use container instead of context in this script) When I test GetOrgId as a manger (or anyone else for that matter) I get a traceback that says I am not allowed to access 'orgid' in this context. That makes me think that the object being return from the DA doesn't have the correct security attributes. I don't recall reading about any changes in DA or DB.py regarding this. Any ideas? I did recompile all python scripts. --- Traceback (innermost last): Module ZPublisher.Publish, line 100, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 40, in call_object Module Shared.DC.Scripts.Bindings, line 306, in __call__ Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec Module Products.PythonScripts.PythonScript, line 318, in _exec Module None, line 7, in GetOrgId - <PythonScript at /Strader/P/GetOrgId> - Line 7 Unauthorized: You are not allowed to access 'orgid' in this context ---- Oh wait, if I create a new python script with the same code, it works! Hmm, how do I upgrade all my pythonscripts. I can't retype them all. -- Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax http://www.wecanstopspam.org/ AOL-IM: BKClements

2 1

CMFTopic friendly date criterion
by Hauan, Michael J 08 Jun '04

08 Jun '04

I've looked for answers to this elsewhere but haven't found any, so hopefully turn to you all! Situation: adding a Topic to find items that are less than, for example, 2 weeks old. I'm using Zope 2.7.0, CMF1.4.2, and Plone 2.0-final. Problem 1: when I set the "friendly" date criteria to "less than", "2 weeks", and "old" and hit save, the "less than" is changed to "more than" and the Topic returns no results. Problem 2: when I set the "friendly" criteria to "within", "2 weeks", and "old" and hit save, the parameters are saved but the Topic still returns no results. In short, I cannot get any useful results when using any time-related criteria. I look forward to your helpful suggestions!! mjh

1 0

RE: [Zope] Product for Out-of-Process jobs
by Passin, Tom 08 Jun '04

08 Jun '04

> From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On > Florian Reiser wrote at 2004-6-7 15:32 +0200: > > ... > >But I am working on windoze and don't have a shell where I set a & > >behind the command and send it into the background. My task > is simply > >the following: ... > > Sorry, I cannot help you with Windows questions... > You do have a shell - it is a "Command Prompt". Just run a program using the "start" command. That will detach it from the console you started it from (applies to NT, Win2000, WinXP. Win95/98/Me do not have the start command IIRC). Cheers, Tom P

1 0

Symantec AntiVirus/Filtering for Domino detected a virus in a document you authored.
by ntlotus00/comune_di_udine/it%UDINE＠comune.udine.it 08 Jun '04

08 Jun '04

Please contact your system administrator. The scanned document was QUARANTINED. Virus Information: The attachment message.scr contained the virus W32.Netsky.P@mm and could NOT be repaired.

1 0

Re: Performance issues - excessive object loads
by Casey Duncan 08 Jun '04

08 Jun '04

On Tue, 8 Jun 2004 09:33:52 -0400 "Gerry Kirk" <gerry(a)faithonline.com> wrote: > Hi, > > I'm trying to improve performance of my Plone 2 site. I read in the > plone docs that under normal circumstances, there shouldn't be more > than 1000 object loads per hour. Looking at my activity this morning, > I have over 10000 object loads in the past hour, on a site that isn't > very active. Looking at the undo log, there are about 10 or so entries > for this morning. > > My cache setting is 2000 objects, and one cache connection has 2000 > and the other about 1000. So, increasing cache size doesn't seem to be > the answer. Generally increasing the cache size is the most effective way to reduce loads. Try increasing the cache to say 15000 (assuming you have enough RAM on the server) and see how that affects the load rate. 2000 is a relatively low setting, but that really depends on the size of the ZODB. How many objects are in your ZODB? Are you using ZEO? (I assume not) -Casey

2 1

RE: [Zope] Serious problem with PlacelessTranslationService
by Jean-Francois.Doyon＠CCRS.NRCan.gc.ca 08 Jun '04

08 Jun '04

Well those log messages at least are perfectly normal. The "home" for the PTS is at http://sf.net/projects/collective. I understand the best place to get support for it is from the Plone community ... I don't compile my PO files into anything and it works just fine, so you can leave them as is. As for the error itself, I don't know ... I would've expected PTS to require Zope 2.7/Python 2.3 though (Since it's a backport from Zope 3) ... Might that be it? J.F. -----Original Message----- From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org]On Behalf Of Peter Bengtsson Sent: June 8, 2004 6:40 AM To: ZOPE.org Subject: [Zope] Serious problem with PlacelessTranslationService The latest ZWiki requires PlacelessTranslationService so I installed the latest version (1.0fork-rc7). When I start my Zope (2.6.1) I get these messages:: 2004-06-08T11:24:32 INFO(0) PlacelessTranslationService Applying patch *** Patching ZPublisher.Publish with the get_request patch! ***------ 2004-06-08T11:24:56 INFO(0) PlacelessTranslationService Initialized: ['en.po', 'es.po', 'ga.po', 'fr.po', 'it.po', 'pt-BR.po', 'zh-CN.po', 'zh-TW.po', 'fr-CA.po'] from /home/peterbe/zope261/lib/python/Products/ZWiki/i18n ------ When I try to create a ZWiki I get this error:: Error Type: RuntimeError Error Value: Shouldn't load state for '\x00\x00\x00\x00\x00\x00R\x96' when the connection is closed With this traceback:: Traceback (innermost last): * Module ZPublisher.Publish, line 98, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Shared.DC.Scripts.Bindings, line 252, in __call__ * Module Shared.DC.Scripts.Bindings, line 283, in _bindAndExec * Module App.special_dtml, line 174, in _exec * Module Products.PlacelessTranslationService.TranslateTags, line 68, in render __traceback_info__: translate * Module Products.PlacelessTranslationService, line 74, in translate * Module ZODB.Connection, line 505, in setstate RuntimeError: Shouldn't load state for '\x00\x00\x00\x00\x00\x00R\x96' when the connection is closed I read on http://plone.org/documentation/howto/HowToInstallAndUsePlacelessTranslationS ervice that I have to compile the .po files with something called 'msgfmt'. I don't have that on any of my linux machines, nor cygwin nor win XP. On my Debian, it doesn't even find a package called 'msgfmt'. Any ideas anyone? [By the way, does PlacelessTranslationService have a homepage? Can't even figure out from where I got this release] -- Peter Bengtsson, http://www.peterbe.com _______________________________________________ Zope maillist - Zope(a)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 )

1 0