May 2005 - Zope - Zope lists

Zope Sybase database connection keeps closing
by Abhilasha Chaudhary 11 May '05

11 May '05

My zope Sybase database connections keep closing for no apparent reason. When I try to reopen the connections they sometimes give me the following error: *Invalid connection string: *|database: , password: access, server: SYBTIGR, transactional: Y, user: access When I make a copy of the connection object that is giving this error, the original connection reopens automatically. This behavior seems really bizarre and is causing our Zope website to remain unavailable. Abhilasha

2 1

RE: [Zope] Re: ZODB question
by Pascal Peregrina 11 May '05

11 May '05

Thanks -----Message d'origine----- De : zope-bounces(a)zope.org [mailto:zope-bounces@zope.org]De la part de Tres Seaver Envoyé : mercredi 11 mai 2005 15:47 À : zope(a)zope.org Cc : zodb-dev(a)zope.org Objet : [Zope] Re: ZODB question ********************************************************************** 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 ********************************************************************** -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pascal Peregrina wrote: > In a Zope / Zeo configuration (2.7.6), is there a way, on the Zope instance, > to know when the database (Zeo) was last packed ? > > Thanks. Repozo knows this for the underlying FileStorage: http://www.zope.org/Wikis/ZODB/FileStorageBackup AFAIK, there is no wire-protocol-level way to check for it in the ZEOClientStorage. BTW, this question would get better-informed response on the zodb-dev list (which I have CC'ed). Tres. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCggzv+gerLs4ltQ4RAqkUAJ46baO6FeV2mKXpd9CQq7c7pvSSugCcDkU0 OJyFipH9BLTmy1mc31kb1to= =4W8m -----END PGP SIGNATURE----- _______________________________________________ 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 ) ********************************************************************** 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

LDAPUserFolder and roles/groups assignment Problem
by Bernard Lange 11 May '05

11 May '05

Hi , I've instantiated a Group User Folder object for my Zope+Plone application and configured it to take users from an LDAP server in order to get users id and passwords validated against LDAP. So far, so good users can log in using their LDAP credentials. The underlying users’ source is a LDAPUserFolder. I have configured it so that the groups are not stored on LDAP. Consequently the groups' source is default UserFolder.I have also configured Anonymous,Member as default roles to LDAP users. I'm using ZOPE (ver.Zope 2.7.5-final, python 2.3.5, linux2) and Plone (2.0.4.3)with GRUF version: 3.1.1 and LDAPUserFolder 2.4 on Debian box. All except LDAPUserFolder installed from debian packages. I have encountered problems with assigning other roles to users. When I enter acl_users/Users tab of my Plone site check one of the users and the role I want to assign, confirm it I get the following error: ******************** Site error: This site encountered an error trying to fulfill your request. The errors were: Error Type AttributeError Error Value 'NoneType' object has no attribute 'find' Request made at 2005/05/11 11:04:33.681 GMT+2 ********************** The full stack trace from error log is as follows: ******************** Exception Details Back to Error Log Time 2005/05/11 11:07:35.111 GMT+2 User Name (User Id) zopeadmin (zopeadmin) Request URL http://myhost:9673/copy_of_plone/acl_users/changeOrCreateUsers Exception Type AttributeError Exception Value 'NoneType' object has no attribute 'find' Traceback (innermost last): * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.GroupUserFolder.GroupUserFolder, line 1372, in changeOrCreateUsers * Module Products.GroupUserFolder.GroupUserFolder, line 1110, in _updateUser * Module Products.GroupUserFolder.GroupUserFolder, line 1057, in _doChangeUser * Module Products.GroupUserFolder.LDAPUserFolderAdapter, line 138, in _doChangeUser * Module Products.LDAPUserFolder.LDAPUserFolder, line 1497, in manage_editUserRoles AttributeError: 'NoneType' object has no attribute 'find' Display traceback as text REQUEST form changeOrCreateUsers 'Change' default_password '<password obscured>' new_users [] users ['bernard'] roles ['Reviewer'] cookies cookieTest '1' __ac_name 'bernard' tree-s 'eJzTyCkw5NLIKTDiClZ3hANXW3WuAmOuRKCECUjWFEXWFyRrBpY1B8laAGVDci1LowJtQTKWXIlAABQ3NEDS5pxfDpI0NOSCyCFb6JqbD5YzhsqZIMn5ZTuC5UzBpuoBAF0OLNI' __ac 'YmVybmFyZDoxMjNhYmM%3D%0A' _ZopeId '63617490A10pAKsRfQA' lazy items SESSION <bound method SessionDataManager.getSessionData of <SessionDataManager instance at 420c05f0>> other TraversalRequestNameStack [] roles ['Reviewer'] AUTHENTICATED_USER zopeadmin URL 'http://myhost:9673/copy_of_plone/acl_users/changeOrCreateUsers' SERVER_URL 'http://myhost:9673' AUTHENTICATION_PATH '' PATH_INFO '/copy_of_plone/acl_users/changeOrCreateUsers' PUBLISHED <bound method GroupUserFolder.changeOrCreateUsers of <GroupUserFolder instance at 41924da0>> default_password '<password obscured>' new_users [] ACTUAL_URL 'http://myhost:9673/copy_of_plone/acl_users/changeOrCreateUsers' users ['bernard'] URL0 http://myhost:9673/copy_of_plone/acl_users/changeOrCreateUsers URL1 http://myhost:9673/copy_of_plone/acl_users URL2 http://myhost:9673/copy_of_plone URL3 http://myhost:9673 BASE0 http://myhost:9673 BASE1 http://myhost:9673 BASE2 http://myhost:9673/copy_of_plone BASE3 http://myhost:9673/copy_of_plone/acl_users BASE4 http://myhost:9673/copy_of_plone/acl_users/changeOrCreateUsers environ HTTP_COOKIE 'cookieTest=1; tree-s="eJzTyCkw5NLIKTDiClZ3hANXW3WuAmOuRKCECUjWFEXWFyRrBpY1B8laAGVDci1LowJtQTKWXIlAABQ3NEDS5pxfDpI0NOSCyCFb6JqbD5YzhsqZIMn5ZTuC5UzBpuoBAF0OLNI"; _ZopeId="63617490A10pAKsRfQA"; __ac="YmVybmFyZDoxMjNhYmM%3D%0A"; __ac_name="bernard"' SERVER_SOFTWARE 'Zope/(Zope 2.7.5-final, python 2.3.5, linux2) ZServer/1.1 Plone/2.0.4' SCRIPT_NAME '' REQUEST_METHOD 'POST' HTTP_KEEP_ALIVE '300' SERVER_PROTOCOL 'HTTP/1.1' channel.creation_time 1115802248 CONNECTION_TYPE 'keep-alive' HTTP_ACCEPT_CHARSET 'ISO-8859-1,utf-8;q=0.7,*;q=0.7' HTTP_USER_AGENT 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050324 Debian/1.7.6-1' HTTP_REFERER 'http://myhost:9673/copy_of_plone/acl_users/manage_users?FORCE_ALL=1' SERVER_NAME 'myhost.man.poznan.pl' REMOTE_ADDR '150.254.149.174' PATH_TRANSLATED '/copy_of_plone/acl_users' SERVER_PORT '9673' CONTENT_LENGTH '124' HTTP_HOST 'myhost:9673' HTTP_ACCEPT 'text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5' GATEWAY_INTERFACE 'CGI/1.1' CONTENT_TYPE 'application/x-www-form-urlencoded' REMOTE_HOST 'ldaphost.man.poznan.pl' HTTP_ACCEPT_ENCODING 'gzip,deflate' PATH_INFO '/copy_of_plone/acl_users' ************************************************* I get similiar error message when I try to assign a user to any group. Another problem is that I sometimes when I click on the Users' tab I get a list of users who already logged in, sometimes I get no users and I have to use separate link to force their retrieval (there is a message: "It is reported that 106 users stand in the various user sources.It might be very long to retreive the whole list but you can force it by Clicking here."). Has anybody any idea how to get this things to work? I must be able to assign Reviewers role to some of my users, otherwise nobody would be able to publish anything.... Bernard

2 1

container and context for folderish objects
by Milos Prudek 11 May '05

11 May '05

I created a very simple folderish product. Everything works fine. But I was surprised that "context" and "container" seem to behave differently for folderish object than for normal Folder. Here's the problem: my product's instance "a" contains a DTML Document "doc" and some photos "img1", "img2". A simple ZPT "lst" queries object ids: <p><li tal:repeat="item python:here.objectIds()" tal:content="item"></p> <p><li tal:repeat="item python:container.objectIds()" tal:content="item"></p> I need to call this ZPT as follows: /a/doc/lst and I expect to get a list of objects contained in "a". The problem is that lst does not provide that. The first line shows nothing, and the second line shows content of the parent Folder! I would have expected that "container" is the "a", the folderish object. Why does it not work? I \know that I can get my list by calling /a/lst, but unfortunately I cannot do that. -- Milos Prudek

1 1

RE: [Zope] Exporting Plone objects to Zope CMF
by Kanealii, Priam Mr KRS 10 May '05

10 May '05

Thanks jcc. I didn't consider FTP at all. I FTP-ed the CMF site to my laptop, reorganized and pruned things filesystem-wise (where grep and friends helped out), then FTP-ed the sanitized tree up to my local Zope instance. With two browsers, gvim, ExternalEditor, and good old copy/paste, it didn't take long to get into a rhythm. One thing to note is that when the files on the filesystem were FTP-ed up to Zope, some got lost when I uploaded them directly into a CMF folder. I gave them their own folder in the top of the ZMI and everything of substance wound up as a file or a DTML document. Aloha, Priam >Kanealii, Priam Mr KRS wrote: >> Dear Zope-list, >> >> Running with Zope 2.7.5 Plone 2.0.5.. >> >> What "nice" method exists, if any, to export CMF-ish things like >> documents, events, and news items from Plone to ZopeCMF? (Or, what >> search terms may have escaped me?) >> >> Ideally, I'd like to be able to export folders in Plone and import >> them to Zope CMF such that Plone-ized CMF items were magically >> de-Ploned (and allow for sufficiently Plone-ized things to remain >> broken). Unfortunately, importing folders or most other objects >> raises a Copy Error:: >> >> "Object *broken* does not support this operation." >> >> I'm just wondering if there are options to porting content by hand >> ..which will be less than a day's work in this case (we're just >> getting started). In absence of a nice method, I'm curious what >> methods others may have applied in a similar situation. > > I don't think that's a very common task. Plone over-rides most (or all) > of the basic CMF types, and so you wouldn't be able to import them in a > site without the Plone software installed. > > Though, perhaps, you can use FTP to download from one and upload to the > other. May lose workflow state and maybe other metadata that way, though. > > If that's a problem, see CMFSetup and CMFSetupExtensions, which will > allow you to export/import your site in XML, retaining metadata. You > might have to go and edit the type fields in the XML, though. Though if > doing it by hand will only take a day, I might not bother. > > --jcc

1 0

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