- Zope - Zope lists

dtml-tree documentation
by Garry Saddington 27 May '08

27 May '08

Is there a complete documentation of the dtml-tree tag anywhere? The dtml reference of the Zope book has the following for some options: "This attribute is for advanced usage only" Where can I find out about this 'advanced usage'? Regards Garry

5 4

ZODB reverts to older state after ZEO restart
by dvs 16 May '08

16 May '08

Recently we restarted our zeo server and immediately noticed that we are missing good bit of recently added content. We seemed to have reverted back to a specific date in the past. All content updates since have disappeared. Restoring the Data.fs from a recent backup still had the same effect, the content all reverted back to one specific date. In the logs it does show that we restored the Data.fs from a backup, restarted, and migrated to a newer version of Zope/Plone (Zope 2.9.4 - 2.9.5, Plone 2.5.4 - 2.5.5). After the update, the site was fine and was running along smoothly. A few days later this came up in the event.log: 2008-01-24T19:05:44 ERROR ZServer uncaptured python exception, closing channel <ZServer.HTTPServer.zhttp_channel connected 72.249.81.93:56139 at 0x 1598d92c channel#: 45214 requests:> (socket.error:(54, 'Connection reset by peer') [/usr/local/lib/python2.4/asynchat.py|initiate_send|219] [/usr/l ocal/zope/295/lib/python/ZServer/medusa/http_server.py|send|417] [/usr/local/lib/python2.4/asyncore.py|send|332]) ------ 2008-01-24T19:05:45 ERROR ZEO.zrpc (27931) can't decode message: '(M\x06\xdcK\x00U\x06.reply(TC\x00\x01\x00(cOFS.Image\nP...' ------ 2008-01-24T19:05:45 ERROR ZEO.zrpc.Connection(C) (127.0.0.1:9999) Error caught in asyncore Traceback (most recent call last): File "/usr/local/lib/python2.4/asyncore.py", line 69, in read obj.handle_read_event() File "/usr/local/lib/python2.4/asyncore.py", line 391, in handle_read_event self.handle_read() File "/usr/local/zope/295/lib/python/ZEO/zrpc/smac.py", line 219, in handle_read self.message_input(msg) File "/usr/local/zope/295/lib/python/ZEO/zrpc/connection.py", line 387, in message_input msgid, flags, name, args = self.marshal.decode(message) File "/usr/local/zope/295/lib/python/ZEO/zrpc/marshal.py", line 50, in decode return unpickler.load() # msgid, flags, name, args MemoryError ------ 2008-01-24T19:05:45 INFO ZEO.ClientStorage (27931) Disconnected from storage: "('xxxxx.com', 9999)" ------ 2008-01-24T19:05:45 INFO ZEO.ClientStorage (27931) Testing connection <ManagedClientConnection ('72.249.81.93', 9999)> ------ 2008-01-24T19:05:45 INFO ZEO.zrpc.Connection(C) (127.0.0.1:9999) received handshake 'Z303' ------ 2008-01-24T19:05:45 ERROR ZODB.Connection Couldn't load state for 0x01868c Traceback (most recent call last): File "/usr/local/zope/295/lib/python/ZODB/Connection.py", line 732, in setstate self._setstate(obj) File "/usr/local/zope/295/lib/python/ZODB/Connection.py", line 786, in _setstate self._reader.setGhostState(obj, p) File "/usr/local/zope/295/lib/python/ZODB/serialize.py", line 604, in setGhostState state = self.getState(pickle) File "/usr/local/zope/295/lib/python/ZODB/serialize.py", line 597, in getState return unpickler.load() File "/usr/local/zope/295/lib/python/ZODB/serialize.py", line 471, in _persistent_load return self.load_oid(reference) File "/usr/local/zope/295/lib/python/ZODB/serialize.py", line 537, in load_oid return self._conn.get(oid) File "/usr/local/zope/295/lib/python/ZODB/Connection.py", line 201, in get p, serial = self._storage.load(oid, self._version) File "/usr/local/zope/295/lib/python/ZEO/ClientStorage.py", line 746, in load return self.loadEx(oid, version)[:2] File "/usr/local/zope/295/lib/python/ZEO/ClientStorage.py", line 769, in loadEx data, tid, ver = self._server.loadEx(oid, version) File "/usr/local/zope/295/lib/python/ZEO/ServerStub.py", line 192, in loadEx return self.rpc.call("loadEx", oid, version) File "/usr/local/zope/295/lib/python/ZEO/zrpc/connection.py", line 531, in call r_flags, r_args = self.wait(msgid) File "/usr/local/zope/295/lib/python/ZEO/zrpc/connection.py", line 621, in wait raise DisconnectedError() DisconnectedError ------ The persistent cache file has been saved, but looking at the archive it seems that you can't restore a Data.fs from the persistent cache (please correct me on this). Looking at the logs we can find what content was edited in this time frame and we can see that it did exist at one time, but the data itself is not in any of the backup Data.fs files we have. This is a bit perplexing in that when we restore from any of the backups it still reverts, what could cause this situation and if the data was in fact being saved, where could it have been saved? We were backing up the correct Data.fs (at least, it was the Data.fs that the zeo server was connected to) If the zeo server was read only this would make sense but then we wouldn't be able to make any content updates and it would be immediately evident. Any suggestions or ideas on how we could recover any of this data and the reasoning behind this happening is much appreciated. -- View this message in context: http://www.nabble.com/ZODB-reverts-to-older-state-after-ZEO-restart-tp17264… Sent from the Zope - General mailing list archive at Nabble.com.

2 2

Weird SQL Relay conversion error in Zope
by Mike Driscoll 16 May '08

16 May '08

Hi, I am working on a web app that interfaces with Microsoft SQL Server from Ubuntu through SQL Relay. I will be getting data from multiple databases. The issue seems to be that either Zope or SQL Relay cannot handle the Decimal type if the value is a null. If I do a query like this: SELECT * from myDatabase I get the following: <error> Site Error An error was encountered while publishing this resource. InvalidOperation Sorry, a site error occurred. Traceback (innermost last): * Module ZPublisher.Publish, line 194, in publish_module_standard * Module Products.PlacelessTranslationService.PatchStringIO, line 34, in new_publish * Module ZPublisher.Publish, line 146, in publish * Module Zope2.App.startup, line 222, in zpublisher_exception_hook * Module ZPublisher.Publish, line 115, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 41, in call_object * Module Shared.DC.ZRDB.Connection, line 115, in manage_test * Module Products.ZSQLRelayDA.db, line 86, in query * Module decimal, line 571, in __new__ * Module decimal, line 2267, in _raise_error InvalidOperation: (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: '@@plone') </error> If I change it to "SELECT empid, reg from myDatabase" it will work as long as reg is not a NULL. I can get it to work if I use "isnull" functions on all my decimal type fields, but I would like to avoid that. Is this a known issue with a workaround? I am using Zope 2.9.4-final on Ubuntu with SQL Relay 0.39.4. Mike Driscoll Applications Specialist MCIS - Technology Center

2 2

Confused about permissions
by Brenda Bell 16 May '08

16 May '08

I have a simple use case for Zope where a group of users need to be able to manage content stored in external files. I installed ExternalFile and it seems to be working as expected for the admin user. I've created a folder where all ExternalFile objects reside. I've defined a local role "Editor" for that folder, added a user and assigned that user to the Editor role. What I can't seem to do is get the permissions right such that a user in the Editor role can add new External Files. I've checked every box on the Security tab for the Editor role. Users in the Editor role can view and modify existing ExternalFile's but still cannot add new ones. I thought maybe the problem had to do with permissions on the ExternalFile product itself, but when reading the description on the Define Permissions tab I couldn't really figure out what it was trying to say: "The first column below lists the permissions for this object. The second specifies the permissions that should have this permission in this product or ZClass. For ZClass methods, only permissions that are defined for the ZClass are permitted. In general, any permissions that include operations that change (mutate) an object should be disabled." What exactly does this mean? More to the point: What permissions do I need to assign to my Editor role so users can add External Files?

4 3

Re: one zope instance per cpu
by Tres Seaver 14 May '08

14 May '08

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Pat McNamee wrote: >> Generally, the rule-of-thumb for scaling Zope on a multi-CPU box is to >> run an appserver instance per CPU, each talking to a shared storage... > > I came across the preceeding post while googling for info about the > one zope per cpu question. > > First, when you say one zope instance per cpu, do you count a quad-core > cpu as four cpus? Four: the idea is to split up the processes so that their threads make best use of the available CPUs. Python's global interpreter lock makes using more than one CPU within a single process problematic. > Also, I've been (unsuccessfully) searching all over for an answer to > the question: if you create one zope instance per cpu each talking > to a shared zeo instance, how do the instances know about the cpus? > Does each instance automagically use a separate cpu or what? Modern linux kernels will tend to migrate all the processes to separate CPUs (in steady state). > I thank you in advance for your reply, and I hope I'm not being > rude by emailing you instead of the Zope list. If this is rude > please tell me and I'll post to the list. CC'ing the list does leave the conversation open, and makes future searches likelier to show the "whole picture". Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 tseaver(a)palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIKni9+gerLs4ltQ4RAg9rAJ4xaklSySaGqR2bdZhxE6RVL2qOPACdEqWO lq2zMLDM4+G4q2WuqmAO2Gk= =D5M6 -----END PGP SIGNATURE-----

2 2

Strange property behaviour - why? (zope 2.10/Five)
by Piotr Chamera 14 May '08

14 May '08

Hello, I don't understand property behawiour in code bellow (I am not experienced programmmer, so I could missed something obivious). In example bellow: "list_items1" works as I expected - it returns list of objects from catalog but "list_items2" fails - I get Attribute Error or if it finds "items" through acquisition it returns this object. But, if I uncomment line "return [1,2,3]" in code below, then both functions return the same value - list [1,2,3]. Search of "catalog" by acquisition messes with class attribute lookup? <code> class Storage (SimpleItem): """ see IStorage interface """ implements(IStorage) title = FieldProperty(IStorage['title']) description = FieldProperty(IStorage['description']) def _get_items(self): """ Return list of items in storage (unsorted). """ #return [1,2,3] return [x.getObject() for x in self.catalog(storage=self.title)] items = property(_get_items) def list_items1(self): """ test """ return self._get_items() def list_items2(self): """ test """ return self.items </code> Piotr Chamera

2 3

centos
by Garry Saddington 13 May '08

13 May '08

Does anyone have any experience running Zope on Centos 5. I have some Python scripts which just will not work. They work on Windows, Ubuntu, and SuSe but just don't do anything on Centos. I have tried various Zope 2.9.0 and 2.9.6-final, various psycopg connectors and Postgres 8.1 and 8.3. Here is an example script that works everywhere except Centos(excuse email formatting): request=context.REQUEST datefrom=request.datefrom dateto=request.dateto today = DateTime(datefrom) end = DateTime(dateto) auth=request.auth year=request.year while today <= end: for result in context.getstudentsbyyear(year=year): studentid=result.studentid if context.getday(today=today): #picks out non-weekend days only if context.checkholidays(today=today): #picks out holidays pass else: \\\\\\\\context.insertabsence(entered=today,auth=auth,studentid=studentid) today += 1 return "<b class=red>Absences entered</b>" Any ideas because I am getting very frustrated here. Regards Garry

3 3

Getting records X to X+20 of catalog search
by Sinang, Danny 12 May '08

12 May '08

Dear All, How do we get records X to X+20 of a catalog search ? We're aware of the "limit" parameter of the search () function, but this only gives us the top Z rows. If I want to show records 90 to 100, I'm trying to avoid having to fetch records 1 to 89. Regards, Danny

2 1

first attempt to use RELSTORAGE
by David Bear 11 May '08

11 May '08

I installed relstorage using the instructions for easy_setup, i.e. 'easy_install RelStorage'. I realized as I read through more of the instructions that this likely put the relstorage modules in my python home rather than in my zope software home. I don't know if this would have caused the error I am seeing. However, after reading more through the instructions, and watching easy_install do its magic, I reached a point where I make a new zope instance, then when in to that instance home and modified the zope.conf to use relstorage instead of filestorage, I was ready to start my new instance. I was disappointed to have a traceback just running zopectl. I ran $INSTANCE_HOME/bin/zopectl and got the following traceback: Traceback (most recent call last): File "/servers/webenv1/lib/python/Zope2/Startup/zopectl.py", line 329, in ? main() File "/servers/webenv1/lib/python/Zope2/Startup/zopectl.py", line 287, in main options.realize(args) File "/servers/webenv1/lib/python/Zope2/Startup/zopectl.py", line 95, in realize ZDOptions.realize(self, *args, **kw) File "/servers/webenv1/lib/python2.4/site-packages/zdaemon-2.0.2-py2.4.egg/zdaemon/zdoptions.py", line 279, in realize self.load_schema() File "/servers/webenv1/lib/python2.4/site-packages/zdaemon-2.0.2-py2.4.egg/zdaemon/zdoptions.py", line 327, in load_schema self.schema = ZConfig.loadSchema(self.schemafile) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/loader.py", line 32, in loadSchema return SchemaLoader().loadURL(url) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/loader.py", line 66, in loadURL return self.loadResource(r) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/loader.py", line 187, in loadResource schema = ZConfig.schema.parseResource(resource, self) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/schema.py", line 27, in parseResource xml.sax.parse(resource.file, parser) File "/servers/webenv1//lib/python2.4/xml/sax/__init__.py", line 33, in parse parser.parse(source) File "/servers/webenv1//lib/python2.4/xml/sax/expatreader.py", line 107, in parse xmlreader.IncrementalParser.parse(self, source) File "/servers/webenv1//lib/python2.4/xml/sax/xmlreader.py", line 123, in parse self.feed(buffer) File "/servers/webenv1//lib/python2.4/xml/sax/expatreader.py", line 207, in feed self._parser.Parse(data, isFinal) File "/servers/webenv1//lib/python2.4/xml/sax/expatreader.py", line 300, in start_element self._cont_handler.startElement(name, AttributesImpl(attrs)) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/schema.py", line 99, in startElement getattr(self, "start_" + name)(attrs) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/schema.py", line 475, in start_schema keytype, valuetype, datatype = self.get_sect_typeinfo(attrs) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/schema.py", line 201, in get_sect_typeinfo datatype = self.get_datatype(attrs, "datatype", "null", base) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/schema.py", line 194, in get_datatype return self._registry.get(dtname) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/datatypes.py", line 398, in get t = self.search(name) File "/servers/webenv1/lib/python2.4/site-packages/ZConfig-2.5.1-py2.4.egg/ZConfig/datatypes.py", line 423, in search package = __import__(n, g, g, component) File "/servers/webenv1/lib/python/Zope2/Startup/datatypes.py", line 21, in ? import OFS.Uninstalled File "/servers/webenv1/lib/python/OFS/Uninstalled.py", line 20, in ? import SimpleItem, Globals, Acquisition File "/servers/webenv1/lib/python/OFS/SimpleItem.py", line 26, in ? import AccessControl.Role, AccessControl.Owned, App.Common File "/servers/webenv1/lib/python/AccessControl/__init__.py", line 17, in ? from Implementation import setImplementation File "/servers/webenv1/lib/python/AccessControl/Implementation.py", line 98, in ? setImplementation("C") File "/servers/webenv1/lib/python/AccessControl/Implementation.py", line 51, in setImplementation from AccessControl import ImplC as impl File "/servers/webenv1/lib/python/AccessControl/ImplC.py", line 18, in ? from cAccessControl import rolesForPermissionOn, \ File "/servers/webenv1/lib/python/AccessControl/SimpleObjectPolicies.py", line 82, in ? from DocumentTemplate.DT_Util import TemplateDict File "/servers/webenv1/lib/python/DocumentTemplate/__init__.py", line 21, in ? from DocumentTemplate import String, File, HTML, HTMLDefault, HTMLFile File "/servers/webenv1/lib/python/DocumentTemplate/DocumentTemplate.py", line 112, in ? from DT_String import String, File File "/servers/webenv1/lib/python/DocumentTemplate/DT_String.py", line 19, in ? from DT_Util import ParseError, InstanceDict, TemplateDict, render_blocks, str File "/servers/webenv1/lib/python/DocumentTemplate/DT_Util.py", line 67, in ? from ZPublisher.TaintedString import TaintedString File "/servers/webenv1/lib/python/ZPublisher/__init__.py", line 24, in ? from Publish import publish_module, Retry File "/servers/webenv1/lib/python/ZPublisher/Publish.py", line 24, in ? from zope.app.publication.browser import setDefaultSkin File "/servers/webenv1/lib/python/zope/app/publication/browser.py", line 33, in ? from zope.app.publication.http import BaseHTTPPublication File "/servers/webenv1/lib/python/zope/app/publication/http.py", line 27, in ? from zope.app.publication.zopepublication import ZopePublication File "/servers/webenv1/lib/python/zope/app/publication/zopepublication.py", line 46, in ? from zope.app.security.principalregistry import principalRegistry as prin_reg File "/servers/webenv1/lib/python/zope/app/security/principalregistry.py", line 20, in ? from zope.app.authentication.interfaces import IPasswordManager File "/servers/webenv1/lib/python/zope/app/authentication/__init__.py", line 20, in ? from zope.app.authentication.authentication import PluggableAuthentication File "/servers/webenv1/lib/python/zope/app/authentication/authentication.py", line 25, in ? from zope.app.component.site import SiteManagementFolder File "/servers/webenv1/lib/python/zope/app/component/site.py", line 35, in ? from zope.app.component import adapter File "/servers/webenv1/lib/python/zope/app/component/adapter.py", line 28, in ? class LocalSurrogate(zope.interface.adapter.Surrogate): AttributeError: 'module' object has no attribute 'Surrogate' for more information, there is another zope instance running on this machine however there is only 1 zope_home. Furthermore, what I couldn't discern from the install instructions for relstorage was configuration for postgresql. Since the instructions were silent, I assumed I at least needed a pg user for zope to connect as, and a database to contain the zodb. So I created these in pg so the dsn in zope.conf would at least have something valid to connect to. Any adivce? I think I will need to back out of what easy_install did to my pythonhome -- is there an easy way to undo what easy_install did ? -- David Bear College of Public Programs at ASU 602-464-0424

3 2

disappearing external methods
by Garry Saddington 10 May '08

10 May '08

I have recently moved our Zope installation over to a centos server. Since the move all the external methods periodically stop working for no apparent reason and the error is returned as: "external method can not be called because it is none" The thing is that it works well and then stops. Does anyone have any ideas about this? The installation was not initially compiled on centos as I have a large collection of software as part of the application which can be moved between servers with the Zope installation. The reason for the move to Centos is that DTMLTex fails when trying to run pdflatex on Ubuntu and this seems to be distro specific, with no apparent way to fix it, unless anyone knows any better? Kind Regards Garry

4 7