August 2005 - Zope - Zope lists

Aquisition
by Timur Izhbulatov 11 Aug '05

11 Aug '05

Hi All, Sorry for long message. I have a simple Zope product which is an ObjectManager descendant and contains a database connection and a ZSQL method. It creates these objects during its initialisation. >>> app.inventory <Inventory instance at b7300f20> >>> app.inventory['db-connection'] <Connection instance at b724a980> >>> app.inventory.list <SQL instance at b724a8f0> Everything is OK except one thing. A problem appears when I go to the manage_main page of the ZSQL method. It can't find any database connection using the SQLConnectionsIDs function from the ${ZOPE_HOME}/lib/python/Products/ZSQLMethods/SQL.py module. The function is called from ${ZOPE_HOME}/lib/python/Products/ZSQLMethods/dtml/edit.dtml To investigate the problem I have added some debugging output statements to this function: def SQLConnectionIDs(self): """Find SQL database connections in the current folder and above This function return a list of ids. """ ids={} have_id=ids.has_key StringType=type('') LOG('ZSQL', INFO, 'self.aq_chain: %s' % self.aq_chain) LOG('ZSQL', INFO, 'self.id: "%s"' % self.id) while self is not None: if hasattr(self, 'objectValues'): for o in self.objectValues(): try: LOG('ZSQL', INFO, 'o.id: %s' % (o.id())) except: LOG('ZSQL', INFO, 'o.id: %s' % (o.id)) if (hasattr(o,'_isAnSQLConnection') and o._isAnSQLConnection and hasattr(o,'id')): id=o.id if type(id) is not StringType: id=id() if not have_id(id): if hasattr(o,'title_and_id'): o=o.title_and_id() else: o=id ids[id]=id if hasattr(self, 'aq_parent'): self=self.aq_parent else: self=None ids=[ (item[1], item[0]) for item in ids.items() ] ids.sort() LOG('ZSQL', INFO, 'ids: %s' % (ids)) return ids The output shows that SQLConnectionsIDs is called in wrong context. 2005-08-11T10:57:31 INFO(0) ZSQL self.aq_chain: [<Application instance at b73483b0>, <RequestContainer instance at b767ccb0>] ------ 2005-08-11T10:57:31 INFO(0) ZSQL self.id: "<bound method Application.id of <Application instance at b73483b0>>" ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: acl_users ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: Control_Panel ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: temp_folder ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: session_data_manager ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: browser_id_manager ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: error_log ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: standard_error_message ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: standard_template.pt ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: index_html ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: standard_html_header ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: standard_html_footer ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: virtual_hosting ------ 2005-08-11T10:57:31 INFO(0) ZSQL o.id: inventory ------ 2005-08-11T10:57:31 INFO(0) ZSQL ids: [] Any help is greatly appreciated. Thanks, -- Timur Izhbulatov OILspace, 26 Leninskaya sloboda, bld. 2, 2nd floor, 115280 Moscow, Russia P:+7 095 105 7245 + ext.205 F:+7 095 105 7246 E:TimurIzhbulatov@oilspace.com Building Successful Supply Chains - One Solution At A Time. www.oilspace.com

1 0

[ANN] Zope 2.8.1 final released
by Andreas Jung 11 Aug '05

11 Aug '05

Hi all, on behalf of Zope Corporation and the Zope community I am pleased to announce the release of Zope 2.8.1. You can download Zope 2.8.1 from http://www.zope.org/Products/Zope/2.8.1/ Some new features of Zope 2.8: - ZODB 3.4 with MVCC (multi version concurrency control) support. MVCC solves nearly every problem with ZODB read-conflict errors which is very important for high-traffic Zope sites. - Extension Classes were rewritten as Python new-style classes making all features of Python new-style classes available in Zope objects. This includes support for cyclic garbage collection. - Integration of Zope 3 technologies through Five (see http://codespeak.net/z3/five/) For more information on what is new in this release, see the CHANGES.txt files for the release: http://www.zope.org/Products/Zope/2.8.1/CHANGES.txt See also: http://www.zope.org/Wikis/DevSite/Projects/Zope2.8/OverView Please bring all the bugs you have found to the Zope bugtracker: http://collector.zope.org/Zope":http://collector.zope.org/Zope For more information on the available Zope releases, guidance for selecting the right distribution and installation instructions, please see: http://www.plope.com/Books/2_7Edition/InstallingZope.stx Please also keep in mind that Zope 2.8.1 requires Python 2.3.5. Zope 2.8.1 is not certified for any Python 2.4.x versions. So using Python 2.4 is neither recommended nor supported and any related questions or problems are likely to be ignored until 2.4 is an officially support Python version for Zope. -- Andreas Jung (andreas at zopyx dot com)

1 0

How to set an object's last modification time
by Gabriel Genellina 11 Aug '05

11 Aug '05

Hello I want to set an object's last modification time to match a certain date. I see that this comes from the _p_mtime attribute and in cPersistence.c it is derived from _p_serial. But when I try to set explicitely _p_serial, there is a ConflictError: ZODB.POSException.ConflictError: database conflict error (oid 0x104a, serial this txn started with 0x035cfc6333333333 2005-05-01 10:11:12.000000, serial currently committed 0x035f10fe1d242e66 2005-08-03 02:38:06.830000) Writting _p_serial used to work fine at least until Zope 2.6.x (http://mail.zope.org/pipermail/zope-dev/2000-March/004020.html) Now I'm using Zope 2.7.7. Maybe I should not be playing with _p_serial, but how can I set the object's last modification time? I want it to be in sync with an external representation (stored in CVS). This is a test script: import Zope from Acquisition import aq_base from ZODB.TimeStamp import TimeStamp from OFS.Folder import Folder from DateTime import DateTime Zope.configure('..\etc\zope.conf') root = Zope.app() # create a test folder, if it does not exist if not 'test' in root.objectIds(): print 'Creating test folder' test = Folder(id='test') root._setObject('test',Folder(id='test')) get_transaction().commit() # I want to change its last-modification-time target = aq_base(root.test) print 'Test folder: %s _p_serial=%s _p_mtime=%s b_m_t=%s' % (target.id, target._p_serial, DateTime(target._p_mtime), target.bobobase_modification_time()) ts = TimeStamp(2005,5,1,10,11,12) # a sample timestamp target._p_serial = repr(ts) target._p_changed = 1 get_transaction().commit() print 'target._p_serial modified OK' print 'Test folder: %s _p_serial=%s _p_mtime=%s b_m_t=%s' % (target.id, target._p_serial, DateTime(target._p_mtime), target.bobobase_modification_time()) #output: #Test folder: test _p_serial=_þ$.f _p_mtime=2005/08/02 23:38:06.830 GMT-3 b_m_t=2005/08/02 23:38:06.830 GMT-3 #Traceback (most recent call last): # File "C:\Prog\Zope\Questor\bin\testserial.py", line 22, in ? # get_transaction().commit() # File "C:\Prog\Zope\ZopeServer\lib\python\ZODB\Transaction.py", line 241, in commit # ncommitted += self._commit_objects(objects) # File "C:\Prog\Zope\ZopeServer\lib\python\ZODB\Transaction.py", line 356, in _commit_objects # jar.commit(o, self) # File "C:\Prog\Zope\ZopeServer\lib\python\ZODB\Connection.py", line 454, in commit # s=dbstore(oid,serial,p,version,transaction) # File "C:\Prog\Zope\ZopeServer\lib\python\ZODB\FileStorage.py", line 782, in store # serials=(oserial, serial)) #ZODB.POSException.ConflictError: database conflict error (oid 0x104a, serial this txn started with 0x035cfc6333333333 2005-05-01 10:11:12.000000, serial currently committed 0x035f10fe1d242e66 2005-08-03 02:38:06.830000) Gabriel Genellina Softlab SRL

3 3

howto i18n?
by Vlada Macek 10 Aug '05

10 Aug '05

Hi, for now I use the Zope 2.7.5 tarball. I write freelance (not bound in a product) page template and wish it to be i18n'ed. I have appropriate tags inside and the domain set at the top. There is also Plone with its products in that instance. Where should I put the PO files, so the messages can be substituted? Thanks. -- \//\/\ (Sometimes credited as 1494 F8DD 6379 4CD7 E7E3 1FC9 D750 4243 1F05 9424.)

3 2

funny-looking events in the event.log
by Jim Abramson 10 Aug '05

10 Aug '05

Just found these in the event log of a relatively low-traffic Zope 2.7.4 instance. Does this just seem like a local network connectivity issue or should I be concerned? (If yes, any advice where to begin diagnosing this kind of a report?) Thanks, Jim 2005-06-08T11:32:55 ERROR(200) ZServer uncaptured python exception, closing chan nel <ZServer.HTTPServer.zhttp_channel connected 66.240.66.2:4869 at 0x42d2f66c c hannel#: 566 requests:> (socket.error:(110, 'Connection timed out') [/usr/local/ Python-2.3.5/lib/python2.3/asynchat.py|handle_read|88] [/home/zope/Zope-2.7.4-0/ lib/python/ZServer/medusa/http_server.py|recv|423] [/usr/local/Python-2.3.5/lib/ python2.3/asyncore.py|recv|356]) ------ 2005-06-10T14:14:32 ERROR(200) ZServer uncaptured python exception, closing chan nel <ZServer.HTTPServer.zhttp_channel connected 66.240.66.2:4426 at 0x410ddb2c c hannel#: 635 requests:> (socket.error:(110, 'Connection timed out') [/usr/local/ Python-2.3.5/lib/python2.3/asynchat.py|handle_read|88] [/home/zope/Zope-2.7.4-0/ lib/python/ZServer/medusa/http_server.py|recv|423] [/usr/local/Python-2.3.5/lib/ python2.3/asyncore.py|recv|356]) ------ 2005-06-13T11:53:21 ERROR(200) ZServer uncaptured python exception, closing chan nel <ZServer.HTTPServer.zhttp_channel connected 66.240.66.2:1967 at 0x410ecd4c c hannel#: 639 requests:> (socket.error:(110, 'Connection timed out') [/usr/local/ Python-2.3.5/lib/python2.3/asynchat.py|handle_read|88] [/home/zope/Zope-2.7.4-0/ lib/python/ZServer/medusa/http_server.py|recv|423] [/usr/local/Python-2.3.5/lib/ python2.3/asyncore.py|recv|356])

2 1

Database Connections
by Asad Habib 10 Aug '05

10 Aug '05

Has anyone had problems with Zope hanging on to database connections? I am using MySQL with Zope and when I last checked there were 25 connections (both active and sleeping connections included). I only have 5 Zope database objects so I don't know how so many connections were created. Any help would be greatly appreciated. Thanks. - Asad

2 1

REStructuredText and Title
by Justin Fletcher 10 Aug '05

10 Aug '05

I am adding ReStructuredText documents through the ZMI and I noticed that I am unable to set the 'Title' attribute. Am I missing something? When adding a document the 'ID' also shows up in the 'Title' section, and I can't find a way through the interface to change the 'Title'. Perhaps there is a way to hack it in? Any help, tips, or pointers would be appreciated. Platform: (Zope 2.7.5-final, python 2.3.5, freebsd5) Thanks, -Justin

2 1

Changing Properties With ZPT
by Dyyryath 10 Aug '05

10 Aug '05

I'm trying to figure out how I can change the properties of a template with ZPT. For example, let's say I've got a Page Template with a property called 'name' and I want to change it in response to something in the HTTP request: <div tal:condition="python:'name' in context.REQUEST"> SOME CODE TO CHANGE THE PROPERTY TO EQUAL context.REQUEST['name'] </div> I haven't seen anyway to do this with ZPT so I'm assuming that I'll need to use a python script of some sort, but I'm not sure how to access the template's properties without hardcoding the template's name. Anybody got any suggestions?

3 3

Zope service being shut down automatically on Windows
by michael nt milne 10 Aug '05

10 Aug '05

Does anyone have experience of their Zope/Plone instance being closed down mysteriously on windows XP or other windows platforms. A microsoft demon? I keep having to re-start it. Michael

1 0

Streaming files
by Sinang, Danny 10 Aug '05

10 Aug '05

Dear List, Am a newbie so please bear with me. I need Zope to stream files to my users when they click on a link. Exactly how is this done ? Is it by the use of the Request.Write () method ? If so, can you give me sample code and some reference links ? Thanks. Danny

2 1