September 2003 - Zope

people structuring
by Roman Bogoyev 27 Sep '03

27 Sep '03

> > >Why do you have containers for the different types of persons? > >A more natural thing would be to have just one container and >use catalog searches (or "topic"s) to determine the subsets >as necessary. > My thoughts were that people are spread across our organisiation in different groupings, and may belong to more than one grouping. Other 'objects' may contain these groups eg: a unit object has one or more lecturers, as well as many students. A committee object has members etc. What I wanted was to find a way to keep to the object oriented spirit of zope/python and to be able to express things like funCommittee.members.joe.shoeSize and mathsClass.lecturers.joe.shoeSize where joe's shoe size is not a property of 'joe the lecturer' or 'joe the committee member' but of 'joe the person'. And wouldn't it be nice if for some reason joe's feet swelled during lecturing and had a different size, and mathsClass.lecturers.joe.shoeSize could return the correct shoeSize in this context! (Something similar to aquisition but not quite as Units may not be within the Person structure). Maybe I want a "Link Object" product where 'joe the lecturer' is just a link to 'joe the person' but with aquisition rules following the link heirarchy. The above is probably mostly fantasy, so I'll investigate doing it with catalogues but don't know if it will be as pretty. Thanks, Roman.

5 5

[Warning] "No more ReadConflicts" patch can cause inconsistencies
by Dieter Maurer 27 Sep '03

27 Sep '03

Dear Zope community, I have to admit that my "No more ReadConflicts" patch can cause ZODB inconsistencies. Probability is low but not zero. Details can be found on <mailto:zodb-dev@zope.org>. This fault was revealed by one of the ZODB 3.1.2 InvalidationTests which can fail on high speed servers. The problem can not be fixed for ZODB 3.1. I will work on a patch for ZODB 3.2 which avoids this problem (by implementing part of Jeremy's MVCC proposal). Dieter

1 0

Simple way to programmatically merge several PDF files within Zope?
by Chris Beaumont 27 Sep '03

27 Sep '03

Hello everyone, I've been looking for the answer to this and come up blank. Maybe one of you can help. I have a number of PDF files in a LocalFS directory that I would like to programmatically merge into larger, combined files, preferably within Zope. Does anything come to mind, any ideas on a simple way to do this? Thank you, Chris

2 1

Zope version for RH 8.0 with Python 2.2?
by John Wheeler 27 Sep '03

27 Sep '03

I'm running RH 8.O with Python version 2.2. I tried Marcus Schopen's RPM ( http://ftp.dzug.org/Zope/redhat/8.0/zope-2.6.2b3-1.i386.rpm ) but I got an error opening http://localhost:8080/manage page. I get errors trying "rpm -i python2.3..." and "rpm -i --oldpackage python2.1...". Is there any version of Zope that actually works with python2.2.2 ? __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

2 2

RE: [Zope] User Login Screen
by Derek S. Wilson 27 Sep '03

27 Sep '03

Maybe I should have re-worded this. I want to create a password protected part of a zope website. How do I do that? I added the ACL_USERS folder but it doesn't ask for authentication. Thanks, Derek Wilson -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Friday, September 26, 2003 2:12 AM To: Derek S. Wilson Cc: zope(a)zope.org Subject: Re: [Zope] User Login Screen Derek S. Wilson wrote: > Does anyone know where I can find information on how to create a login > page that uses ?ACL_Users? ? I am working on my site, and It isn?t a CMF > site, just a regular Zope one. I created the ACL_USERS folder , but I > want to put a dialog on the page so they can login. http://hathaway.freezope.org/Software/CookieCrumbler Chris

3 2

Successful exUserFolder Plone implementation example! odbc conne ction, user authenticated in Plone ...
by Jason LeMonier 27 Sep '03

27 Sep '03

Hey all, Wanted to share some specifics because this shouldn't have taken 3 hours! Install exUserFolder Why? Want to authenticate users against a database or external source instead of Plone or Zope native acl_users. How long? Hopefully less than 1 hour with this doc! Environment: Windows 2000 Server, Plone 1.0.5 (Instead of speaking generically and full of theory and foo-bar crap and " ... " everywhere we NEED the fricking code example, I am going to list EXACT specifics for my environment.) Specific Steps: 1) At "Root Folder" in the ZMI, add (Z ODBC Database Connection) mine is: [bosdev_odbc] which connects to an Interbase (Borland) database. (It shouldn't matter what db you use. It's easy to test your connection with any sql you want. 2) Download exUserFolder http://www.zope.org/Members/TheJester/exUserFolder <http://www.zope.org/Members/TheJester/exUserFolder> 0-10-10 was latest non-dev release. Extract files to Product directory. Restart Zope. 3) In ZMI, Inside my plone site [/dev], (NOT at the root), deleted the acl_users folder. 4) In ZMI, in Plone site /dev, Added "ex User Folder" Choose Sources: Auth Source: MySql, Property Source: MySql, Membership Source: Basic, Group: Null MySQL Auth: (follow your own database schema of course) Database conn: "bosdev_odbc" Table: "login_user" Username column: "login_name" Password: "webpassword" Roles: "description" (not doing anything useful with this yet, but give it a valid field.) Edit Basic Membership: fill in site name & email, checked "member" for default role Choose Auth Type: Standard basic auth (for form login) Cache Timeout: 1800 After that ... /dev/acl_users in the ZMI yielded a list of 10 users ... and "Next 10 results" Had users in the ZMI, but the authentication didn't work yet. 5) How to make the Auth Work? What is Missing? This part wasn't documented (in readme or anywhere) w/ specifics None of the SQL in / <http://lemon:8238/dev/manage_workspace> dev/ <http://lemon:8238/dev/acl_users/manage_workspace> acl_users/ <http://lemon:8238/dev/acl_users/mysqlAuthSource/manage_workspace> mysqlAuthSource (left panel in ZMI) address authorizing a user. [P: is the root of my plone directory.] In P:\Data\Products\exUserFolder\mysqlAuthSource\mysqlAuthSource.py There's a comment about what has to be done: # # You can define this to go off and do the authentication instead of # using the basic one inside the User Object # remoteAuthMethod=None 6) Define remoteAuthMethod: Where? P:\Data\Products\exUserFolder\mysqlAuthSource\mysqlAuthSource.py Why? Because I chose "MySql" while setting up, that is the folder to modify the mysqlAuthSource.py. (it's in several directories) In this file, I had to add 3 chunks of code: 6a) define the dtml method # # You can define this to go off and do the authentication instead of # using the basic one inside the User Object # # remoteAuthMethod=None def remoteAuthMethod (self, username, password): """ Do auth! """ result=self.sqlAuthUser(username=username, password=password) return result 6b) Adding the SQL object # Already there ... def delSQLQueries(self): sqllist=self.objectIds('Z SQL Method') self.manage_delObjects(ids=sqllist) # Must add this inside the def delSQLQueries(self): sqlAuthUser=SQL( 'sqlAuthUser', 'Auth One User', self.connection, 'table=%s username:string password:string'%(self.table), _sqlAuthUser) self._setObject('sqlAuthUser', sqlAuthUser) 6c) The SQL (at the very bottom of the file) _sqlAuthUser=""" SELECT * FROM <dtml-var table> where <dtml-var usernameColumn>=<dtml-sqlvar username type=string> and <dtml-var passwordColumn>=<dtml-sqlvar password type=string> """ 7) Save file, restart zope, test login ... 8) Fix python errors ... restart zope :-) 9) Successful login! 10) Current Problems: Upon logging in correctly (case-sensitive user & pass), This site encountered an error trying to fulfill your request. The errors were: Error Details Error Type sql.error Error Value ('42000', -104, "[Easysoft][Interbase]Dynamic SQL Error, SQL error code = -104, Token unknown - line 2, char 28, 'key'") But, Upon logging in 2nd time, all is well -- the user properties get set, and the Home Directory is created. 11) 'key' is present here: Z SQL Method / <http://lemon:8238/dev/manage_workspace> dev/ <http://lemon:8238/dev/acl_users/manage_workspace> acl_users/ <http://lemon:8238/dev/acl_users/mysqlPropSource/manage_workspace> mysqlPropSource/ <http://lemon:8238/dev/acl_users/mysqlPropSource/sqlInsertProperty/manage_wo rkspace> sqlInsertProperty Arguments: key value username temp:int SQL: INSERT INTO UserProperties (prop_key, username, value, istemporary) VALUES(<dtml-sqlvar key type=string>, <dtml-sqlvar username type=string>, <dtml-sqlvar value type=string>, <dtml-sqlvar temp type=int>) So, something with my schema isn't ready for this yet. I'll post again with the details, but I wanted to get this out there since it seemed I wasn't the only one hurdling over this problem of getting exUserFolder going! cheers, jason Jason LeMonier Software Engineer Retail Technologies International Office 916.605.7262 Mobile 415.595.0969 Fax 916-914-2132 jlemonier(a)RetailPro.com I wish programmers would skip 85% of all theory and just paste snippets of code!

1 0

SV: [Zope] Are products the right approach?
by Carsten Gehling 27 Sep '03

27 Sep '03

> -----Oprindelig meddelelse----- > Fra: Alexis Roda [mailto:arv@si.urv.es] > Sendt: 18. september 2003 10:26 > Zope provides a very nice feature, the pluggable brains. In short, a > pluggable brain associates a class (python class) to a zsql method so > the rows returned by the query are wrapped with objects of the given > class. Its a kind of simple object persistance over a RDBMS system. > > To learn more about pluggable brains read the section "Binding Classes > to Result Objects", chapter "Relational Database Connectivity" of the > zope book. Hmm this might be what I'm looking for. Can I bind the same class to more than one ZSQL method? Say for example, that I want to do a join between a log entry and a Equipment record (assuming that I make Equipment as a table). Can I then apply the Equipment class to both this ZSQL method and a more "simple" one that just retrieves Equipment records? - Carsten

2 1

Newbie config problem: server only responds to localhost requests
by Jack Stephens 26 Sep '03

26 Sep '03

I've configured 2.6.2 on an in house server behind a shorewall firewall. Shorewall is forwarding port 8080 using a rule entry that differs only in port number from the NAT entry for traditional, port 80, requests; port 80 is being served correctly. Log entries show the 8080 packet being forwarded wget requests to localhost and the local IP address succeed; appropriate entries appear in var/log/zope.* External requests fail No entry turns up in the zope log(s). Any ideas? Thanks. Jack

2 1

rendered method in dtml document
by Thomas M G Bennett 26 Sep '03

26 Sep '03

Zope Version (Zope 2.6.1 (binary release, python 2.1, linux2-x86), python 2.1.3, linux2) Python Version 2.1.3 (#1, Sep 19 2002, 13:15:46) [GCC egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)] System Platform linux2 I have searched the Zope site, emails, lab, etc and haven't found what I hoped would be a shorter solution rather than write a python script. So, here is what I want to do. I am trying to make available to my web page editors a single tag which would display one URL on the local domain and a different URL to all others. Below I have pasted in my ZSQL and Method which work fine if you supply a record number in a form or in a URL. The Method displays an Online Database Title which is hyperlinked to the online database. If you are in our domain you get the hyperlink which allows access to the database per our IP domain. If you are outside our domain you get a hyper link that allows you to login to our server and use it as a proxy, then the database will allow you access. I've tried as a tag in another page several different permutations of: <dtml-call dbtitle(47)> I've also tried REQUEST.set, dtml-let, and dtml-set . If you put the url http://www.library.appstate.edu/dbtitle?mytitle=74 in the location bar of the browser (or any other number from 1 to 108) the method will disply the hyperlinked title to that databased based on record number. ==================================== DTML METHOD ip_add_flag returns a 1 or 0 depending on if you are in our domain or not ==================================== <dtml-call "REQUEST.set('hostname',ip_add_flag(REMOTE_ADDR))"> <dtml-in db_title_query size=1 start=query_start> <a href="http:// <dtml-if hostname> <dtml-var vdb_local_url null=""> <dtml-else> <dtml-var vdb_proxy_url null=""> </dtml-if> <dtml-var vdb_title null="">"></a> </dtml-in> =================================== Z SQL one argument: mytitle =================================== select vdb_title, vdb_local_url, vdb_proxy_url from vdb_data where vdb_rec=<dtml-var mytitle> Thanks, Thomas PS: Usually I don't need to ask for assistance because the answers are usually already posted here. Thanks to all of those responders that share their insight and knowledge here by answering these requests. ----------------------------------------------------------------- Use The Help Desk at http://linux.library.appstate.edu/help ----------------------------------------------------------------- Rock and Rule Zope Rocks -- http://www.zope.org Python Rules -- http://www.python.org ----------------------------------------------------------------- Thomas McMillan Grant Bennett Appalachian State University Computer Consultant III University Library Voice: 828 262 6587 FAX: 828 262 2797 "Windows: A 32-bit GUI on top of a 16-bit wrapper around an 8-bit interpretation of a 4-bit operating system written by a 2-bit company." -David Simmons

3 4

More ZClass Questions.....
by Bill Hewitt 26 Sep '03

26 Sep '03

How do I set specifc allowable subobjects for a ZClass? I have endusers that shold only be allowed to add certain objects to a Folderish type object, but when I subclass OFS:Folder, I get every product available as an "Add" choice -not good for easily confused endusers..... Under the "subobjects" tab, I get a multiselection, but due to the sort of the list, I cannot limit only to my choices... Any advice on how to set specific subobjects and no others? PS - I looked at OFS:Folder, but I dont see where it defines it's allowable subobjects.... TIA WPH

3 2