- Zope - Zope lists

Error calling a Z SQL method
by Asad Habib 10 May '05

10 May '05

I am calling a Z SQL method from within a DTML method that is called by a DTML document. The Z SQL method is contained within a folder called 'selects'. The error I get is as follows: Error Type: ValueError Error Value: Strings are not allowed as input to the in tag. The following is the syntax I use to call the DTML method from the DTML document: <dtml-call "initialize_parameters(REQUEST, _)"> And, the following is the code I use to call the Z SQL method (i.e. retrieve_data_sql) from within the DTML method (i.e. initialize_parameters): <dtml-in "selects.retrieve_data_sql()"> </dtml-in> I have used this same piece of code in other places without a problem. Any help would be greatly appreciated. Thanks. - Asad

4 6

Re: Zope Digest, Vol 12, Issue 10 (No Long works at NZX : from 10 May 2005)
by Claire Sherrington 10 May '05

10 May '05

1 0

ZEO and session variables.
by Dennis Allison 10 May '05

10 May '05

I am hoping someone with more experience that I with multi-headed Zope/ZEO installations can point out my problem. I am using with Zope 2.7.6-final and Python 2.4.1. Yes, I know I am jumping the gun with 2.4.1 but I expect that it is not the source of the problem. Hardware is an Athlon dual processor CPU running Linux (RH 7.3). I am trying to configure multiple Zope heads with a ZEO with shared session variables. This means that the session variables need to be in a temporary folder associated with the ZEO instance rather than the Zope instance. The logs seem to indicate both ZEO and the ZEO temporary storage is properly hooked up. My setup dies with an unhandled exception during startup with a ConnectionStateError. Since it appeared when I moved temporary storage from Zope to ZEO, I suspect the problem is somewhere in that space. The traceback appended below is truncated for some reason. I was running the zope instance with the ``runzope`` program with output appended to the controlling terminal. The relevant part of the zope.conf the configuration file is: # ZEO client storage: # <zodb_db main> mount-point / # ZODB cache, in number of objects cache-size 5000 <zeoclient> server 192.168.0.92:8301 storage 1 var $INSTANCE/var # ZEO client cache, in bytes cache-size 20MB # Uncomment to have a persistent disk cache client zeo1 </zeoclient> </zodb_db> # # ZEO temporary storage # <zodb_db temporary> <zeoclient> server 192.168.0.92:8301 storage temp name zeostorage var $INSTANCE/var </zeoclient> mount-point /temp_folder container-class Products.TemporaryFolder.TemporaryContainer </zodb_db> And the relevant portion of the zeo.conf configuration file is: <zeo> address 192.168.0.92:8301 read-only false invalidation-queue-size 100 pid-filename $INSTANCE/var/ZEO.pid # monitor-address PORT # transaction-timeout SECONDS </zeo> <filestorage 1> path $INSTANCE/var/Data.fs </filestorage> # temporary storage has to be ZEO side %import tempstorage <temporarystorage temp> name temporary storage for sessioning </temporarystorage> Running with this configuration, dies with an exception: 2005-05-09T23:01:43 INFO(0) ZCS:10522 ClientStorage (pid=10522) created RW/normal for storage: '1' ------ 2005-05-09T23:01:43 INFO(0) ZEC:/opt2/zope/zinstances/leibnitz/var/c1-zeo1-0.zec ClientCache: storage='1', size=20971520; file[0]='/opt2/zope/zinstances/leibnitz/var/c1-zeo1-0.zec' ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Testing connection <ManagedClientConnection ('192.168.0.92', 8301)> ------ 2005-05-09T23:01:43 INFO(0) zrpc-conn(C):192.168.0.92:8301 received handshake 'Z201' ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Server authentication protocol None ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Connected to storage: ('x-epaul', 8301) ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Verifying cache ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Waiting for cache verification to finish ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 Waiting for cache verification to finish ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 endVerify finishing ------ 2005-05-09T23:01:43 INFO(0) ZCS:10522 endVerify finished ------ 2005-05-09T23:01:43 INFO(0) ZODB Opening database for mounting: '1087156928_1109278350.209647' ------ 2005-05-09T23:01:43 INFO(0) ZODB Mounted database '1087156928_1109278350.209647' at /temp_folder ------ 2005-05-09T23:01:43 INFO(0) Zope Ready to handle requests Unhandled exception in thread started by <class ZServer.PubCore.ZServerPublisher.ZServerPublisher at 0x40467d4c> Traceback (most recent call last): File "/usr/local/src/zope/Zope2.7/lib/python/ZServer/PubCore/ZServerPublisher.py", line 23, in __init__ response=response) File "/opt2/zope/zproducts/standard/ZopeProfiler/MonkeyPatcher.py", line 35, in __call__ return self._function(*args,**kw) File "/opt2/zope/zproducts/standard/ZopeProfiler/ZopeProfiler.py", line 335, in _profilePublishModule _hookApplicationManager() File "/opt2/zope/zproducts/standard/ZopeProfiler/ZopeProfiler.py", line 383, in _hookApplicationManager R._p_jar.close() File "/usr/local/src/zope/Zope2.7/lib/python/Products/ZODBMountPoint/Mount.py", line 210, in close self._real_close() File "/usr/local/src/zope/Zope2.7/lib/python/ZODB/Connection.py", line 306, in close raise ConnectionStateError("Cannot close a connection joined to " ZODB.POSException.ConnectionStateError: Cannot close a connection joined to a transaction While the ZEO log shows 2005-05-09T22:46:35 INFO(0) ZD:10284 daemonizing the process ------ 2005-05-09T22:46:35 INFO(0) ZD:10284 set current directory: '/opt2/zope/zeoinstances/leibnitz' ------ 2005-05-09T22:46:35 INFO(0) ZD:10284 daemon manager started ------ 2005-05-09T22:46:35 INFO(0) ZD:10284 spawned process pid=10285 ------ 2005-05-09T22:46:36 INFO(0) RUNSVR created PID file '/opt2/zope/zeoinstances/leibnitz/var/ZEO.pid' ------ 2005-05-09T22:46:36 INFO(0) RUNSVR opening storage '1' using FileStorage ------ 2005-05-09T22:46:36 INFO(0) RUNSVR opening storage 'temp' using TemporaryStorage ------ 2005-05-09T22:46:36 INFO(0) ZSS:10285 StorageServer created RW with storages: 1:RW:/opt2/zope/zeoinstances/leibnitz/var/Data.fs, temp:RW:temporary storage for sessioning ------ 2005-05-09T22:46:36 INFO(0) zrpc:10285 listening on ('192.168.0.92', 8301) ------ 2005-05-09T23:01:43 INFO(0) ZSS:10285 new connection ('192.168.0.92', 57425): <ManagedServerConnection ('192.168.0.92', 57425)> ------ 2005-05-09T23:01:43 INFO(0) zrpc-conn(S):192.168.0.92:57425 received handshake 'Z201' ------ 2005-05-09T23:07:20 INFO(0) ZSS:10285/192.168.0.92:57425 disconnected

2 2

DreamWeaver files -> ZPTs: How?
by Ken Winter 10 May '05

10 May '05

Is there any way to configure Zope so that a *.htm file newly created in DW, when uploaded for the first time to Zope, would be created as a ZPT instead of as a DTML document? I know you can do it by naming the file in DW with the *.pt extension. But the trouble with this is, subsequently DreamWeaver doesn't recognize it as anything that it can edit. I know you can do this by manually creating an empty ZPT in Zope, then uploading the already created contents of the same-named .htm file using the ZMI, but this is clunky and error-prone. - Thanks, Ken

4 4

RE: [Zope] asyncore.py exception
by Pascal Peregrina 10 May '05

10 May '05

Thanks. Pascal -----Message d'origine----- De : Dieter Maurer [mailto:dieter@handshake.de] Envoyé : lundi 9 mai 2005 19:25 À : Pascal Peregrina Cc : 'zope(a)zope.org' Objet : Re: [Zope] asyncore.py exception Pascal Peregrina wrote at 2005-5-9 13:54 +0200: >Does anyone know what can cause this type of error : > >ERROR(200) ZServer uncaptured python exception, closing channel ><ZServer.HTTPServer.zhttp_channel connected 10.168.77.5:38607 at 0x3ed2006c >channel#: 1546210 requests:> (socket.error:(32, 'Broken pipe') The client closed the connection while the server was writing to it. Nothing to worry about... -- Dieter ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

1 0

formatting tuple to feed to mysql
by David Siedband 10 May '05

10 May '05

I'm have a tuple that I want to pass to a zSQL query to so I can based on items in the tuple. I get the sequence from a zSQL query that selects a single field, and I'm postprocessing it with the following: <dtml-let SelectedIDs="[ai[0] for ai in queries.selectDOdocIDs().tuples()]"> Which puts the sequence in brackets like this: [211, 873, 515, 516, 589] but mysql seems to want them in parenthesis... because when I try this select ThemeWords.* from DocThemes, ThemeWords where DocThemes.DocID in <dtml-var SelectedIDs> and DocThemes.ThemeID = ThemeWords.ID I get a KeyError. Also, is it possible to pass a list using dtml-sqlvar? thanks -- David

3 2

GetObjects FilterFolder everywhere
by Juan Antonio Garrido 09 May '05

09 May '05

Hi everybody... I like obtain content(objects) of a FilterFolder I create (background/images_bank) from a zpt call everywhere . I try with function objectValues, but it can't access to objects if it isn't called in correctly site(container background/images_bank). How can i do it without calling to the catalog? Thanks -- ------------------------------------------- Juan Antonio Garrido Mata Emergya, Soluciones Tecnológicas Tel. +34 954 98 10 53 FAX +34 954 98 11 79 Avda. Luis Montoto, 105. E41007 - Sevilla(España) jagarrido(a)emergya.info http://www.emergya.info -------------------------------------------

2 1

asyncore.py exception
by Pascal Peregrina 09 May '05

09 May '05

Hi, Does anyone know what can cause this type of error : ERROR(200) ZServer uncaptured python exception, closing channel <ZServer.HTTPServer.zhttp_channel connected 10.168.77.5:38607 at 0x3ed2006c channel#: 1546210 requests:> (socket.error:(32, 'Broken pipe') [/lmn/build/Frontier/F2BUILDS/F2.05-20050413/opt/Python-2.3.5/lib/python2.3/ asynchat.py|initiate_send|218] [/lmn/build/Frontier/F2BUILDS/F2.05-20050413/opt/Zope-2.7.5-final/lib/python /ZServer/medusa/http_server.py|send|417] [/lmn/build/Frontier/F2BUILDS/F2.05-20050413/opt/Python-2.3.5/lib/python2.3/ asyncore.py|send|337]) Can it just be some user closing a browser before getting a response back ? Thanks. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

2 1

Zope stops responding on hpux
by Samuel Bieri 09 May '05

09 May '05

Dear list-members I am desperately trying to get our zope application run on hpux, and any help is greatly appreciated. I have the following problem: When I click on a tal-object ("Page Template") to edit it, then zope stops responding. No error is logged, nothing. I even cannot stop zope anymore with "zopectl stop" or control-c if started with runzope. It seems that zope silently crashes... However, I can create a tal-object, it only happens when I try to edit. The last entries in tracert.log are: <snip> B 1087990040 2005-05-07T22:52:27 GET /temp_folder/tz/manage_workspace I 1087990040 2005-05-07T22:52:27 0 A 1087990040 2005-05-07T22:52:27 302 370 E 1087990040 2005-05-07T22:52:27 B 1087991560 2005-05-07T22:52:27 GET /temp_folder/tz/pt_editForm I 1087991560 2005-05-07T22:52:27 0 ----crash---- The last entries in Z2.log: <snip> 127.0.0.1 - admin [07/May/2005:22:51:57 +0200] "POST /temp_folder/manage_addProduct/PageTemplates/manage_addPageTemplate HTTP/1.1" 302 215 "http://localhost:8080/temp_folder/manage_addProduct/PageTemplates/manage_ad…" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3" 127.0.0.1 - admin [07/May/2005:22:51:57 +0200] "GET /temp_folder/manage_main HTTP/1.1" 200 15638 "http://localhost:8080/temp_folder/manage_addProduct/PageTemplates/manage_ad…" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3" 127.0.0.1 - admin [07/May/2005:22:51:57 +0200] "GET /misc_/PageTemplates/zpt.gif HTTP/1.1" 304 258 "http://localhost:8080/temp_folder/manage_main" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3" 127.0.0.1 - admin [07/May/2005:22:52:27 +0200] "GET /temp_folder/tz/manage_workspace HTTP/1.1" 302 370 "http://localhost:8080/temp_folder/manage_main" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.7) Gecko/20050414 Firefox/1.0.3" ---crash---- My configuration are: Python 2.3.3 compiled from source downloaded from the HP site: http://hpux.connect.org.uk/hppd/hpux/Languages/python-2.3.3/ This is the only python I manage to compile with-threads enabled. Zope 2.7.6-final compiled from source hpux version: $ uname -a HP-UX zuse B.11.11 U 9000/800 647349392 unlimited-user license Zope Version (Zope 2.7.6-final, python 2.3.3, hp-ux11) Python Version 2.3.3 (#40, May 3 2005, 09:18:26) [GCC 3.4.3] System Platform hp-ux11 I have also compiled and run zope versions 2.7.0/3/5, with no luck and always the same problem. Has anyone seen a similar problem with zope? Is anyone running zope successfully on hpux? Information on zope on hpux is very scarce, so I fear that I am very lonely in the field... Any hint is greatly appreciated where I can look at or how I could debug zope. Thank you very much Samuel

6 8

Re: [Zope] Finding an object in a folder
by Dieter Maurer 09 May '05

09 May '05

Please stay on the list! Readded... Allen Huang wrote at 2005-5-8 11:10 -0700: >Thanks for responding, but what is "aq_inner.aq_explicit"?? To understand "aq_inner" and "aq_explicit", you need to understand acquisition. You find something in the "Name lookup" section of <http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html> and in Jim's acquisition talk (which your probably can locate via a search for "Jim Fulton acquisition containment before context"). Once you understood acquisition, you know "aq_self", "aq_parent" and implicit and explicit acquisition wrappers. Now, you can understand "aq_inner" and "aq_explicit". To determine "aq_inner" from an acquisition wrapper, you follow its "aq_self" recursively, until "aq_self" is not an acquisition wrapper. The "aq_explicit" attribute of an acquisition wrapper returns an explicit acquisition wrapper with the same "aq_self" and "aq_parent". -- Dieter

1 0