August 2002 - Zope - Zope lists

dtml method calling a second dtml method: how?
by rruth＠computer.org 22 Aug '02

22 Aug '02

Yes, I am new to Zope ... I am tring to use a Formulator form instead of the form generated by Z Search Interface because I can easily validate the data returned by the Formulator form before the query is sent to the MySQL database. My problem: when the submit button is pressed the "feedback" dtml method calls Formulator and does validation. If there are no errors I want this "feedback" dtml method to call the "report" dtml method that was previously generated by the Z Search Interface ... but all I see is the raw "report" code ... not processed. How do I get one dtml-method to call a second dtml-method and have the dtml in the second method processed? The following, from the first, "feedback" dtml-method, does not work: <dtml-var expr="report"> where "report" is the Id of the second dtml method. Richard rruth(a)computer.org

2 1

what does _. mean?
by Bryan C. Andregg 22 Aug '02

22 Aug '02

Thisis really basic, but in dtml that begins with _., such as _.SecurityGetUser, what does the _. represent? -- Bryan C. Andregg Duke University Medical Center Programmer Dept. of Anesthesiology e <bryan.andregg(a)duke.edu> p +1 919 684 6201

2 2

Virtual Host Monster, Win 98, ZopeBook2.6
by Danny Morgan 22 Aug '02

22 Aug '02

I'm attempting to set up virtual hosting on my development machine which is running Win 98 only. In chapter 18 of of the online Zope Book (http://www.zope.org/Documentation/Books/ZopeBook/2_6Edition/VirtualHosting.…) there are instructions and a couple of examples. I've created a VHM object and tested it with a vhm_test folder and index_html method. The results of that test were positive. The next step did not produce the desired results, however. As instructed, I created an alias in my system's 'c:/windows/hosts' file (which is in slightly different place than it would be for NT, but the only such named file on my computer). The alias is: 127.0.0.1 www.example.com I also added the line: www.example.com:8080/vhm_test to the VHM's 'Mappings' tab. When I enter 'www.example.com:8080' in my browser, I get an 'Invalid syntax error/Page Cannot Be Displayed'. Is Win 98 not able to handle this, or have I done something wrong, or ?? Thanks, Danny

4 4

Re: [Zope-DB] Re:MySQL problems (Adam Shallcross)
by working4aliving 22 Aug '02

22 Aug '02

I would kill the w2k windows "~" directories by uninstalling and then installing in something simple. (C:\zope) Don't install python, it'll get installed automatically w/ zope. Install mysql-3.23.51-win.zip (from mysql.org) if you want a local mysql server. (probably?) install Mysql-python-0.9.1.win32.py2.1.exe then install that exe that I had posted before. Give it a try. Good luck, keep the faith.. it'll be worth it. ----- Original Message ----- From: "Adam Shallcross" <aes(a)starfishuk.com> To: "working4aliving" <working4aliving(a)hotmail.com>; <zope-db(a)zope.org> Sent: Thursday, August 22, 2002 12:56 PM Subject: RE: [Zope-DB] Re:MySQL problems (Adam Shallcross) HI there again... Forgive me for disturbing you again, but I am still having major problems trying to get this to work. Is there any chance you could give me a quick rundown of the process I have to go through from beginning to end. I am new to Zope and Python and am keen to learn what I am doing wrong. My setup is:- Zope Version (Zope 2.5.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32) Python Version 2.1.3 (#35, Apr 8 2002, 17:47:50) [MSC 32 bit (Intel)] System Platform win32 SOFTWARE_HOME C:\PROGRA~1\DISCOV~1\lib\python INSTANCE_HOME C:\PROGRA~1\DISCOV~1 CLIENT_HOME C:\PROGRA~1\DISCOV~1\var Still get the error Traceback (most recent call last): File "C:\PROGRA~1\DISCOV~1\lib\python\OFS\Application.py", line 531, in import_product product=__import__(pname, global_dict, global_dict, silly) File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\__init__.py", line 91, in ? import DA File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\DA.py", line 92, in ? from db import DB File "C:\PROGRA~1\DISCOV~1\lib\python\Products\ZMySQLDA\db.py", line 89, in ? import _mysql ImportError: No module named _mysql I have tried the executable that you recommended and it had no effect. I restarted Zope after installing the .exe and it still had no effect. Your hopefully Adam Shallcross Programmer/Developer aes(a)starfishuk.com Office: +44 (0) 20 8674 9161 Fax: +44 (0) 20 8674 2849 Telephone: +44 (0) 70 0390 2293 www.starfishuk.com www.teamstarfish.com WARNING: For your own safety all email attachments should be virus scanned prior to opening. This communication contains information which is confidential and may be privileged. If you are not the addressee, you may not copy or otherwise use the information. Please note that the opinions expressed in this communication are not necessarily those of Starfish Media UK Ltd. If you receive this email by mistake, please notify us immediately at: info(a)starfishuk.com Thank you. -----Original Message----- From: working4aliving [mailto:working4aliving@hotmail.com] Sent: 22 August 2002 13:08 To: zope-db(a)zope.org Subject: [Zope-DB] Re:MySQL problems (Adam Shallcross) Adam, there is a MYSQLdb binary (windows msi installer) version available. This, coupled with the link below ...ch.fhm.edu... should be all you need. (I think). You shouldn't have to do any compiling on the w2k box version. ----- Original Message ----- From: <zope-db-request(a)zope.org> To: <zope-db(a)zope.org> Sent: Wednesday, August 21, 2002 12:00 PM Subject: Zope-DB digest, Vol 1 #252 - 2 msgs > Send Zope-DB mailing list submissions to > zope-db(a)zope.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.zope.org/mailman/listinfo/zope-db > or, via email, send a message with subject or body 'help' to > zope-db-request(a)zope.org > > You can reach the person managing the list at > zope-db-admin(a)zope.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Zope-DB digest..." > > > Today's Topics: > > 1. Fw: MySQLDA and Windows - a perennial problem (Dan Smith) (working4aliving) > 2. MySQL problems (Adam Shallcross) > > --__--__-- > > Message: 1 > From: "working4aliving" <working4aliving(a)hotmail.com> > To: <zope-db(a)zope.org> > Date: Tue, 20 Aug 2002 13:19:56 -0400 > Subject: [Zope-DB] Fw: MySQLDA and Windows - a perennial problem (Dan Smith) > > Hey Dan, check out the following... It "unbroke MySQLda" > > http://www.cs.fhm.edu/~ifw00065/downloads/ZMySQLDA-Zope24.exe > > > ----- Original Message ----- > From: "working4aliving" <working4aliving(a)hotmail.com> > To: <zope-db(a)zope.org> > Sent: Monday, August 19, 2002 12:28 PM > Subject: Re: MySQLDA and Windows - a perennial problem (Dan Smith) > > > > Alas, dear Dan, fore I too have the same issue (me thinks), without any > > result. > > I have a "broken product" for MYSQLda. > > > > > --__--__-- > > Message: 2 > Date: Wed, 21 Aug 2002 11:13:28 +0100 > From: "Adam Shallcross" <aes(a)starfishuk.com> > To: <zope-db(a)zope.org> > Subject: [Zope-DB] MySQL problems > > Hello everyone.. > > I need some quick help please. I am new to the Zope and Python fields > and am very interested in learning the product. > > I have downloaded the latest release of Zope and the latest release of > MySQL. Also I have downloaded the latest versions of MySQLdb and > ZMySQLda....i am trying to get the modules to work in Zope, however I am > having problems getting the module to install properly. > > The error I get in the command window is=20 > > building '_mysql' extension > cl.exe /c /nologo /Ox /MD /W3 /GX -Ic:\mysql\include -IC:\Py > ysql.c /Fobuild\temp.win32-2.2\Release\_mysql.obj > error: command 'cl.exe' failed: No such file or directory > > I understand that I need to have a C comiler installed on my system, but > I do not know where to get a decent free c compiler. The only help I > have found so far is telling me to install Microsoft Visual C++, which I > don't want to do really. There must be a way of doing this without > installing this package. > > I am using a Windows 2000 box. > > Thanks=20 > > > Adam Shallcross > Programmer/Developer > aes(a)starfishuk.com > > Office: +44 (0) 20 8674 9161 > Fax: +44 (0) 20 8674 2849 > Telephone: +44 (0) 70 0390 2293 > > www.starfishuk.com <http://www.starfishuk.com/>=20 > www.teamstarfish.com <http://www.teamstarfish.com/>=20 > > WARNING: For your own safety all email attachments should be=20 > virus scanned prior to opening. This communication contains=20 > information which is confidential and may be privileged. If you are not=20 > the addressee, you may not copy or otherwise use the information.=20 > Please note that the opinions expressed in this communication are=20 > not necessarily those of Starfish Media UK Ltd. > > If you receive this email by mistake, please notify us immediately at: > info(a)starfishuk.com > > Thank you. > > > > > --__--__-- > > _______________________________________________ > Zope-DB mailing list > Zope-DB(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-db > > > End of Zope-DB Digest > _______________________________________________ Zope-DB mailing list Zope-DB(a)zope.org http://lists.zope.org/mailman/listinfo/zope-db

1 0

RE: [Zope] LDAPUserFolder Question
by Meilicke, Scott 22 Aug '02

22 Aug '02

There are 8 groups associated. From the web page after clicking on the user entry: LDAP Groups for cn=Scott.Meilicke,cn=Recipients,ou=North America 3,o=Crane Then a list of eight groups. However, on the exchange server, there are only 8 non-hidden distributions lists (groups), and this user only belongs to a few of them, but not all. Yet the web page shows all the groups listed. Also, none of the check boxes next to any of the groups are checked - should the groups the user belongs to be checked? Something that just came to mind - I'm using anonymous access to the LDAP directory. Would that affect user authentication? Thanks for your continued help Jens. - Scott -----Original Message----- From: Jens Vagelpohl [mailto:jens@zope.com] Sent: Wednesday, August 21, 2002 8:25 PM To: Meilicke, Scott Cc: 'zope(a)zope.org' Subject: Re: [Zope] LDAPUserFolder Question does that user record have any groups associated with it? search for it again and then click on it to get the detailed view. it seems that it does not have any group association, which makes that lookup fail during authentication. jens On Wednesday, August 21, 2002, at 10:32 , Meilicke, Scott wrote: > (9) Aug 21 07:27:53: scott.meilicke not found (getUser) > > More info: > > When I do a search for meilicke against the cn within the users tab: > > cn=Scott.Meilicke,cn=Recipients,ou=North America 3,o=Crane > > I am using: > > cn=Recipients,ou=North America 3,o=Crane > > as the Users Base DN. > > When I change Login Name Attribute from cn to sn and try to login I get a > traceback from zope, attached below. No entry in the LDAPUserFolder log. > > Thanks for helping out. > > Traceback: > > Zope has encountered an error while publishing this resource. > > Error Type: INAPPROPRIATE_AUTH > Error Value: {'desc': 'Inappropriate authentication'} > > Troubleshooting Suggestions > > * The URL may be incorrect. > * The parameters passed to this resource may be incorrect. > * A resource that this resource relies on may be encountering an error. > > For more detailed information about the error, please refer to the HTML > source for this page. > > If the error persists please contact the site maintainer. Thank you for > your > patience. > > Traceback (innermost last): > File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 223, in > publish_module > File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 187, in > publish > File D:\PROGRA~1\inside\lib\python\Zope\__init__.py, line 226, in > zpublisher_exception_hook > (Object: portal_ldap) > File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 162, in > publish > File D:\PROGRA~1\inside\lib\python\ZPublisher\BaseRequest.py, line 450, > in > traverse > File > D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, > line 614, in validate > (Object: acl_users) > File D:\PROGRA~1\inside\lib\python\AccessControl\User.py, line 616, in > validate > (Object: acl_users) > File > D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, > line 594, in authenticate > (Object: acl_users) > File > D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, > line 505, in getUser > (Object: acl_users) > File > D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, > line 262, in _lookupuser > (Object: acl_users) > File > D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, > line 845, in _searchResults > (Object: acl_users) > INAPPROPRIATE_AUTH: (see above) > > > -----Original Message----- > From: Jens Vagelpohl [mailto:jens@zope.com] > Sent: Wednesday, August 21, 2002 4:57 AM > To: Meilicke, Scott > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] LDAPUserFolder Question > > > could you provide the exact text of the log entry that says "First.Last not > found"? that enables me to check where in the code it failed. > > jens > > > On Tuesday, August 20, 2002, at 07:07 , Meilicke, Scott wrote: > >> Hi - I am trying to authenticate against LDAPUserFolder 1.5. I'm using >> a >> MS >> Exchange 5.5 directory (I know, I know...). I can connect, and search for >> members based on both the cn and sn, but can't authenticate using CMF 1. >> 1 >> and the CMFLDAP tools. I'm trying to authenticate using the cn. When >> I >> do >> a search, the cn shows as First.Last. When I try to logon using >> First.Last, >> I get a logon failure, and the log set at debugging level(9) shows >> First.Last not found. >> >> Any thoughts on being able to authenticate? >> >> Thanks - Scott >> > The information contained in this email message may be privileged and is > confidential information intended only for the use of the recipient or any > employee or agent responsible for delivering it to the intended recipient. > Any unauthorized use, distribution or copying of this information is > strictly prohibited and may be unlawful. If you have received this > communication in error, please notify the sender immediately and destroy > the > original message and all attachments from your electronic files. > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.

2 1

File List
by eric.n.dunn＠bankofamerica.com 22 Aug '02

22 Aug '02

I'm looking for a way to list all files (DTML Documents etc) created in for the past two days. I found this http://www.zope.org/Members/hawkfish/zpt_list_files article but would like to know how to edit it to list all files created after certain dates or previous two days. Eric Dunn

2 1

RE: Holding ref to database connection
by MKinsley＠empirecorp.org 22 Aug '02

22 Aug '02

Thank you Alan! The example below does match our structure. A big help! -----Original Message----- From: alan runyan [mailto:runyaga@runyaga.com] Sent: Thursday, August 22, 2002 10:40 AM To: MKinsley(a)empirecorp.org Subject: Re: Holding ref to database connection no you dont have to import anything.. the ZODB and the Ext Mount has done everything you want. create a python script, say in the root of your ZODB. (it could be anywhere). lets assume your structure is / - root of ZODB aka 'app' --- / mcif (a Folder) --- / externalDB (a External Mount) in a Python Script that in the root of your ZODB you can get to the externalDB object by simply print context.mcif.externalDB.getId() return printed if you are in mcif you would write print context.externalDB.getId() return printed lets say you wanted to recurssively print all the stuff in your externalDB, create a python script called 'printChildren' and it has a parameter called obj you script would look like #parameters: obj (in a text input) if obj.isPrincipiaFolderish: for o in obj.objectValues(): context.printChildren(obj) else: print obj.getPhysicalPath() return printed now you simply create a Script lets say in mcif that calls the printChildren we can call the script doPrintExternalDBTree (assuming that printChildren is in this folder) for zopeobject in context.externalDB.objectValues(): context.printChildren(zopeobject) return 'fin' ~runyaga ----- Original Message ----- From: <MKinsley(a)empirecorp.org> To: <runyaga(a)runyaga.com> Sent: Thursday, August 22, 2002 8:33 AM Subject: RE: Holding ref to database connection > Hi alan, > > Thanks for your reply. I have a folder called "mcif" with a subfolder > "externalDB" which is the mount point to my database. Do I place the line of > code in Python script within Zope or an External Method? > Do I have to import the app module? > > Thanks again for your support. > > -----Original Message----- > From: alan runyan [mailto:runyaga@runyaga.com] > Sent: Wednesday, August 21, 2002 3:27 PM > To: MKinsley(a)empirecorp.org > Subject: Re: Holding ref to database connection > > > thats the point.. you dont "grab the ZODB DB object" > > you just traverse to it. everything is a big graph. > > o=app.somefolder.somesubfolder.somesubsubfolder.object > print o.getId() > > ~runyaga > > ----- Original Message ----- > From: <MKinsley(a)empirecorp.org> > To: <runyaga(a)runyaga.com> > Sent: Wednesday, August 21, 2002 11:20 AM > Subject: RE: Holding ref to database connection > > > > Hi alan, > > > > I have successfully mounted the mcif.fs using the ExternalMount product to > > our Zope instance. Thanks for your help. So, its mounted to my Zope > > instance, How do I grab the ZODB "DB" object it supposedly returns and > open > > a database connection? > > > > Thank you again! > > > > -----Original Message----- > > From: alan runyan [mailto:runyaga@runyaga.com] > > Sent: Friday, August 16, 2002 5:30 PM > > To: MKinsley(a)empirecorp.org > > Subject: Re: Holding ref to database connection > > > > > > if that is the case you need to Mount the mcif.fs into a node in the > Data.fs > > ZODB. > > http://www.zope.org/About <- note the exMount > > http://www.zope.org/Members/jim/ZODB/MountedDatabases <- Wiki > > > > this is waht you want.. this way you have one logical ODB you are dealing > > with. > > > > ~runyaga > > > > ----- Original Message ----- > > From: <MKinsley(a)empirecorp.org> > > To: <runyaga(a)runyaga.com> > > Sent: Friday, August 16, 2002 4:08 PM > > Subject: RE: Holding ref to database connection > > > > > > > Thanks again Alan. Please reply one more time. > > > > > > Yes. Zope is built/operates using ZODB. We are also using ZODB outside > of > > > Zope , to store data, our data, about our products, services, membership > > > info etc. I am using a different file storage than Data.fs, namely > > mcif.fs. > > > We are using Zope > > > as a web management tool for our web application infrastructure mostly > > > written in Python and DTML. > > > > > > Does this shed some more light? > > > > > > > > > > > > > > > -----Original Message----- > > > From: alan runyan [mailto:runyaga@runyaga.com] > > > Sent: Friday, August 16, 2002 4:51 PM > > > To: MKinsley(a)empirecorp.org > > > Subject: Re: Holding ref to database connection > > > > > > > > > > Thank you for your reply. We would like to use Zope and ZODB to > > > > intelligently query data. There will be several DTML document pages > > > involved > > > > using external methods to query ZODB, particularly for ad-hoc > querying. > > > > Instead of opening the data connection each time I call an external > > > method, > > > > we had hoped to keep the connection to the data open so performance is > > > > maximized during ONE CLIENT's session. Openning a connection to the > data > > > is > > > > slow, approximately 15 seconds a try for us. > > > > > > yes. you do not open/close connetions. I dont know enough about your > > > application. > > > it sounds like you are going against the grain. and it doesnt. If you > > are > > > using ZOPE > > > you are using the ZODB. You dont need to open up another connection. > > > When you are in the /manage interface -- you are looking at ZODB. > Please > > > read Zope Bible. > > > > > > > Does this clear up some of the confusion? By the way, I am an > > experienced > > > > software developer assigned to learn, validate, and potentially > > implement > > > this technology for the > > > > organization. > > > > > > ZOPE is an incredible technology. But its vastly different from other > > > technologies. Mainly > > > because ZOPE is based on and uses a Object Databse to store its > > application > > > space data. > > > Your application defnition *has* to be in the ZODB in some way. > > > > > > > I'm new to the whole environment but I clearly know this is an > > > > issue that should be a simple answer from anyone more familiar than > > myself > > > > with Zope and ZODB. Heck, I've got this working on one page already. I > > > just > > > > need to push this through to other pages. > > > > > > please. take a second. maybe you are approaching this (as everyone > said) > > > in such a way > > > that is not "Pythonic" or "Zopeful" . You really need to give me more > > > information for me to > > > help. and I'm rather busy. But please understand if you are *using* > ZOPE > > > you are *using* > > > the ZODB and do not need to have a connection open to the Database. > > > > > > > I appreciate your response and sincerity. > > > > > > sure. I am a consultant and I believe you may need a hour or two to > clear > > > up your confusions > > > about the Zope Application Server. External Methods *live* in the ZODB. > > If > > > you want > > > another ZODB (physical) -- basically a point in the ZODB can be mounted > to > > > another ZODB. > > > This can be done by "Mounting" another ZODB inside a point. ZODBs can > > > connect to each other. > > > > > > cheers, > > > ~runyaga > > > p.s. alot of people fail with ZOPE becasue they are not open to the > > > paradigm. Unless you are a > > > smalltalk or OO fanatic -- you can easily be lose on the paradigm of > ZOPE. > > > > > >

1 0

Sort by date: Script to DTML
by Patrick Romano 22 Aug '02

22 Aug '02

I have created this script which allows me to sort a certain number of kubes by content creation date in the right way showing : DD/MM/YY : import time for items in sequence.sort(context.objectValues('Kube'), (('content_creation_date','cmp', 'desc'),)): data=items.getProperty('content_creation_date') data2=time.strptime(data,("%Y-%M-%d")) print time.strftime(("%d-%M-%Y"),data2) print items.title return printed How can I achieve the same result of the script, but within a DTML- document? (or method, or even page template) I'm not sure about what I can use there or how I can import the script correctly... -patrick _________________________________________________________________ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com

1 0

tal:condition --SOLUTION
by zope 22 Aug '02

22 Aug '02

Hi All Thanks once again for all the suggestions . I tried out almost every method and I have come up with a mixed version of all the suggestions which eventually does the work. <div tal:condition="exists:request/form/lkid" tal:omit-tag=""> <div tal:define="global mName python:here.oms.Users.lib.pset_links(lkid=request.form['lkid'])"> </div> <div metal:use-macro="container/zptmac_memPLall/macros/?mName"> </div> </div> Now the first time the page loads I dont see any macro. After the page is reloaded with the variable "lkid" having a value I get the desired macro running. I hope this can be of use to everyone.One of the reasons I was having problems was that the macro is actually a table and the XML was not being able to render the table tag inside the div tag. Thanks and Best Regards John Kunchandy --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.381 / Virus Database: 214 - Release Date: 8/2/2002

1 0

Pluggable brains and the record class
by Etienne Labuschagne 22 Aug '02

22 Aug '02

Hi there, All the examples I find show how to use pluggable brains IF you already know the field names you are going to use - I don't and want to discover them in run-time. I know the records object has a names() method, but that doesn't help, because the single record object doesn't know about the records object. I want to write a pluggable brains class that takes all the fields and values and wraps them in an XML string, now I know that I can write a method that operates on the records object, but hoped I could use pluggable brains for this. It seems as if the record object is a list/dict like object (I can both use self[0] or self.fieldName - but there is no keys() equivalent and I have also tried dir, __dict__ on all the base classes, but to no avail). Thanks Etienne.

1 0