March 2001 - Zope-Dev

SAP DB <--> ZODB ?
by Steve Alexander 10 Mar '01

10 Mar '01

I just heard that the SAP DB has gone Free and Open Source. ---- SAP DB is an open, SQL-based, relational database management system that provides high availability and performance scaling from small to very large implementations. In addition, SAP DB goes beyond relational database technology by offering object orientation as well as support for managing unstructured data. It supports open standards including SQL, JDBC and ODBC; access from Perl and Python; and HTTP-based services with HTML or XML content. SAP DB is platform independent, so users can deploy it for a wide array of projects. Since 1994, the SAP e-Business Solution is available on SAP DB technology. Today SAP DB is being used by nearly 800 customers. On October 5, 2000, at Linux World SAP DB was announced to be made available as Open Source software using the GNU General Public License for the database kernel and the GNU Lesser General Public License for clients and programming interfaces. ---- http://freshmeat.net/projects/sapdb/ I'd never heard of SAP DB before, although I've heard of SAP. This looks as if it would be good for a ZODB storage. -- Steve Alexander Software Engineer Cat-Box limited

3 3

SECURITY ALERT and Zope hotfix release [2001-03-08]
by Brian Lloyd 09 Mar '01

09 Mar '01

Hello all - An issue has come to our attention (thanks to Randy Kern) that necessitates a Zope hotfix. Hotfix products can be installed to incorporate modifications to Zope at runtime without requiring an immediate installation upgrade. Hotfix products are installed just as you would install any other Zope product. This hotfix (Hotfix_2001-03-08)addresses an important security issue that affects Zope version 2.3.0 and the current 2.3.1 beta 1 release. The issue involves an error in the 'aq_inContextOf' method of objects that support acquisition. A recent change to the access validation machinery made this bug begin to affect security restrictions. The bug, with the change to validation, made it possible to access Zope objects via acquisition that a user would not otherwise have access to. This issue could allow users with enough internal knowledge of Zope to perform actions higher in the object hierarchy than they should be able to. We *highly* recommend that any Zope site running Zope 2.3.0 final or any alpha or beta version of 2.3.0 or 2.3.1 beta 1 have this hotfix product installed to mitigate the issue. Zope 2.3.1 beta 2 will contain a fix for the issue, at which time the hotfix can be removed. Zope versions prior to 2.3.0 are not affected by this issue. - http://www.zope.org/Products/Zope/Hotfix_2001-03-08/README.txt - http://www.zope.org/Products/Zope/Hotfix_2001-03-08/Hotfix_2001-03-08.tgz Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

Zope/Win2K/Crash ...
by Bryan Baszczewski 09 Mar '01

09 Mar '01

Anyone else using Zope on Win2K? We have recently installed Zope as a production server on Win2K (SP4) and everything was fine for the first couple of weeks. We started a little monitoring program which hits Zope every 5 seconds, and noticed Zope started to crash intermitently. In the NT Event Log I find: "The description for Event ID ( 3 ) in Source ( PythonService ) could not be found. It contains the following insertion string(s): <Error getting traceback - traceback.print_tb() failed, pywintypes.api_error, (1450, 'CreateProcess', 'No error message is available')." What is this telling me? That I ran out of memory? Bryan Baszczewski Software Engineer/Technology Strategist 2s2i, Inc. www.2s2i.com phone: (703)534-9800 x-203 fax: (703)995-4866 "Because word of mouth has gone global, there's e-Intelligence from 2s2i."

1 0

Re: [Zope-dev] Saving attributes for a DataSkin
by Johan Carlsson 09 Mar '01

09 Mar '01

> > Hi Johan, > > Could you give a more complete traceback? It's hard to tell > from just the error type.. > > thanks! > -steve Of course, here it comes. Regards, Johan Traceback (innermost last): File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ProviderContainer) File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: changeUser) File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: changeUser) File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/Shared/DC/Scripts/Bindings.py, line 324, in __call__ (Object: changeUser) File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/Shared/DC/Scripts/Bindings.py, line 353, in _bindAndExec (Object: changeUser) File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/Products/PythonScripts/PythonScript.py, line 330, in _exec (Object: changeUser) (Info: ({'script': <PythonScript instance at 8a1ffc8>, 'context': <LoginManager instance at 89d56e8>, 'container': <LoginManager instance at 89d56e8>, 'self': <TemplateDict object at 8a1e948>, 'traverse_subpath': []}, ('a', 'a', 'a', 'a', 'a'), {}, None)) File Script (Python), line 3, in changeUser File /bigshare/zopeservers/Zope-2.3.0-src/lib/python/Products/PythonScripts/zbytecodehacks/VSExec.py, line 429, in __setattr__ TypeError: (see above) > >>>>> "JC" == Johan Carlsson <johanc(a)torped.se> writes: > > JC> Hi, I'm having some trouble figuring out how to write a method > JC> and a skinscript to save attributes of a DataSkin. > > JC> Specialist is the LoginManager. > > JC> DataSkin is: > > JC> class EasyGroupUser(LoginUser): ... def getRoles(self): ... > JC> def getDomains(self): ... def authenticate(self, password, > JC> request): ... > > JC> SkinScripts are: WITH QUERY sql_getUserFor(username=self.id) > JC> COMPUTE username, password, challenge_question, > JC> challenge_answer, admin_email > > JC> WHEN OBJECT CHANGED STORE password, challenge_question, > JC> challenge_answer, admin_email USING sql_changeUser( > JC> username=self.id, newpassword=password, > JC> challenge_question=challenge_question, > JC> challenge_answer=challenge_answer, admin_email=admin_email, > JC> oldpassword=OLD['oldpassword'] ) SAVING oldpassword = password > > JC> Current Attribute Handling: admin_email Getters: SkinScript, > JC> line 1 Setters: SkinScript, line 10 Deleters: SkinScript, line > JC> 10 challenge_answer Getters: SkinScript, line 1 Setters: > JC> SkinScript, line 10 Deleters: SkinScript, line 10 > JC> challenge_question Getters: SkinScript, line 1 Setters: > JC> SkinScript, line 10 Deleters: SkinScript, line 10 password > JC> Getters: SkinScript, line 1 Setters: SkinScript, line 10 > JC> Deleters: SkinScript, line 10 > > > JC> The getter works alright, but when trying to set attributes > JC> (that supposedly would be handle by the setter) with the > JC> following Script (Python) I get the following error: > > JC> ## Script (Python) "changeUser" ##bind container=container > JC> ##bind context=context ##bind namespace=self ##bind > JC> script=script ##bind subpath=traverse_subpath > JC> ##parameters=username,password,challenge_question,challenge_answer,admin_email > JC> ##title= ## user = context.getItem(username) > JC> user.password=password > JC> user.challenge_question=challenge_question > JC> user.challenge_answer=challenge_answer > JC> user.admin_email=admin_email > > JC> ERROR MESSAGE: Error Type: TypeError Error Value: > JC> attribute-less object (assign or del) > > JC> So what am I doing wrong here? Any clues appreciated. > JC> TIA/Johan Carlsson > > > > JC> _______________________________________________ Zope-Dev > JC> maillist - Zope-Dev(a)zope.org > JC> http://lists.zope.org/mailman/listinfo/zope-dev ** No cross > JC> posts or HTML encoding! ** (Related lists - > JC> http://lists.zope.org/mailman/listinfo/zope-announce > JC> http://lists.zope.org/mailman/listinfo/zope ) >

1 0

Re: [Zope-dev] TransWarp preview release (AOP tools only)
by Shane Hathaway 09 Mar '01

09 Mar '01

"Phillip J. Eby" wrote: > > At 12:39 PM 3/2/01 -0500, Shane Hathaway wrote: > >This could be achieved by generating a new Python module for each portal > >instance, but that would mean sys.modules would have to be pre-loaded > >with the information about each portal instance and that's not the ZODB > >way. It would be better to create a new class loader that can weave a > >new class on the fly based on persisted component metadata. Note that > >class loading is currently quite simple; see > >lib/python/Zope/ClassLoader.py (sp?). It could bear some complexity. > >:-) > > There's actually a simpler way. Aspect objects can be pickled as long as > all the objects in them can be pickled. Which means that as long as all > their methods are Zope objects, and all the nested classes are also Aspect > objects, you can save an aspect into the ZODB, and load it at a future > time. Further, since adding aspects together makes new aspects, you can > save the combined aspects, so you only have to perform one call to > transform the aspect into a family of classes. That still means some > load-time complexity, however. Perhaps... but as I see it, pickling the aspect weaving information into each object makes it harder to vary the aspect weaving after objects have been created. I would want to be able to create a portal, add some content, then change the aspects that apply to the content after it has been created. That means that either the objects have a class definition that references a centralized component or all content objects have to be re-woven every time you change the centralized component. I'm also planning outside the ZODB. The goal is to design apps using pure and simple ZODB and not be required to do anything special to make it work later with other forms of storage. Other databases will not be able to store aspect information. > It would be interesting if you could take an arbitrary Zope service object > (like a portal), and go to its "Aspects" tab, and add or remove aspects to > be woven with its class family. But I suspect it will be a long time > before I'll have a need for that personally or professionally, as I am > focused primarily on TransWarp as a CASE tool and Python application > toolkit at present. That's actually the kind of functionality we have now, but we're using subobjects rather than tabs and we achieve many of the things AOP would give us through simple delegation. You should check out the CMF as soon as the beta is released. Shane

2 2

Re: [Zope-dev] dtml-in: next-batches
by Brett Carter 08 Mar '01

08 Mar '01

I tried accessing keys off the 'data' object, and I just get an 'unathorized' error. -Brett >>>>> "Dieter" == Dieter Maurer <dieter(a)handshake.de> writes: Dieter> Brett Carter writes: >> I'm running Zope 2.2.2, and I'm trying to use the batching stuff for >> the dtml-in tag, however, I can't seem to access any attributes off >> the 'next-batches' or 'previous-batches' mapping object that's >> supposed to be available, with the attributes 'batch-start-index', >> 'batch-end-index', and 'batch-size'. >> .... >> I wrote an external method to dir the 'next-batches' object, and it >> seems the only attributes available are: >> ['data', 'items', 'query_string', 'start_name_re'] Dieter> The attributes your are looking for are in fact keys Dieter> of the mapping 'data'. Dieter> Dieter

2 1

ZSQl Cache
by Bryan Baszczewski 08 Mar '01

08 Mar '01

Anyone have an idea of what the optimal cache time is (all things considered .. "normal" circumstances) for a ZSQL query <= 50 rows? Does Zope tend to lag or suck too much memory at some point? Bryan Baszczewski Software Engineer/Technology Strategist 2s2i, Inc. www.2s2i.com phone: (703)534-9800 x-203 fax: (703)995-4866 "Because word of mouth has gone global, there's e-Intelligence from 2s2i."

1 0

(Newbie Alert)- How to change multiple properties from a selection list
by stefano.ciccarelli＠thewhitebird.com 08 Mar '01

08 Mar '01

Hi, I am trying to assign more than one property from a form selection list. I have a ZClass "Course Description" that holds ..a course description (title, learning objectives, agenda, prerequisites,link to docs,etc.) and another ZClass "Course session" that holds the course time and space related data(start date, end date, summary,location, etc.) Trainers create courses and course managers (CM) decide when and where to have these courses. Once the CM wants to set up a session, he adds a Course session, selects the course title from a selection list and decides when and where to have this course. The selection list is generated by a catalog search. What I would like to do, is the following: Since the title is not unique, what the CM really chooses is the Course id. Based on the selected id I would like to : copy the title property of the Course Description to the title property of Course Session. update the "link to Agenda" property of the Course Session with the path to the selected Course Description. I know how to do this singularly, but not all at hte same time. Any Idea? Here follows some code I am using for the selection list <th>Title of event</th> <td><select name="id1:int"> <dtml-in "Catalog(meta_type='Course Description')"> <OPTION value='<dtml-var data_record_id_>'><dtml-var title></OPTION> </dtml-in> </select> </td> Thank you very much, Stefano

1 0

RE: [Zope-dev] dtml-in: next-batches
by Bryan Baszczewski 08 Mar '01

08 Mar '01

I found this in some Zope documentation. It wont give you "1,2,3,4,5...10" it gives "(1-10)(11-20)(21-30)...". Monkey with it a little and you'll get it. Beware it will call your External Method or ZSQL as many times/10. <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" previous orphan=1 size=10 start=qs> <dtml-in previous-batches mapping> <dtml-unless sequence-start>, </dtml-unless> <a href="<dtml-var document_id><dtml-var sequence-query >qs=<dtml-var batch-start-number>"> (<dtml-var batch-start-number> - <dtml-var batch-end-number>)</a> </dtml-in> </dtml-in> <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" next orphan=1 size=10 start=qs> <dtml-in next-batches mapping> <dtml-unless sequence-start>, </dtml-unless> <a href="<dtml-var document_id><dtml-var sequence-query >qs=<dtml-var batch-start-number>"> (<dtml-var batch-start-number> - <dtml-var batch-end-number>)</a> </dtml-in> </dtml-in> <dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" orphan=1 size=10 start=qs> <dtml-var sequence-index>)"> <dtml-var expr="_.getitem('sequence-item')[1]"> <dtml-var expr="_.getitem('sequence-item')[2]"> </dtml-in> -Bryan -----Original Message----- From: zope-dev-admin(a)zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Brett Carter Sent: Wednesday, March 07, 2001 6:34 PM To: zope-dev(a)zope.org Subject: [Zope-dev] dtml-in: next-batches Does anybody have an example of how to use the supposed next-batches mapping returned by dtml-in? I'm trying to build a google-like pageing feature into my application, so we just show the first 5 results, then have a link to each next page, ie "1,2,3,4..." Thanks, -Brett _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://lists.zope.org/mailman/listinfo/zope-dev ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope )

1 0

FYI. I've removed my Base64 MIME encoding
by Johan Carlsson 07 Mar '01

07 Mar '01

FYI. I've removed my Base64 MIME encoding. Thanks to Dieter for alerting me to the problem. Regards, Johan Carlsson

1 0