- Zope - Zope lists

ZODB question, again
by Garry Hodgson 20 Mar '00

20 Mar '00

ok, persistent fool that i am, i'm still trying to figure out how to use ZODB in an External Method to do some simple (ha!) database stuff. so i built a very simple app, to implement a counter. each time you invoke the "Count" method, you get a number back, and it increments. running the script (see below) by hand, it works fine. referencing it from Zope, using this dtml fragment: <dtml-var "Count( 'chickens' )"> or just pointing my browser at: http://kestrel.sage.att.com:8080/Garry/ZODB/Count?name=chickens to reference an External Method called Count, which refers to the Count function in this script, i get: Error Type: AttributeError Error Value: Counter if i then click the reload button, i get: Could not lock the database file. There must be another process that has opened the file. and i'm locked out until i restart zope. can someone please help? this is getting really discouraging. a simple explanation of where i'm going wrong would be greatly appreciated. a small working example of a working app would be terrific. thanks -------------------------------------------------------------- script follows: import ZODB, ZODB.FileStorage import Persistence class Counter(Persistence.Persistent): """A Persistent Counter""" def __init__( self, name ): self.name = name self.value = 0 def Count( name ): "Get counter value, then increment, creating if necessary" db = ZODB.DB( ZODB.FileStorage.FileStorage( '/tmp/CountDB.fs' ) ) connection = db.open() root = connection.root() if not root.has_key( name ): counter = Counter( name ) root[ name ] = counter else: counter = root[ name ] counter.value = counter.value + 1 get_transaction().commit() connection.close() return counter.value if __name__ == '__main__': print Count( 'chickens' ) -- Garry Hodgson Every night garry(a)sage.att.com a child is born Software Innovation Services is a Holy Night. AT&T Labs - Sophia Lyon Fahs

4 5

NEWBIE: dtml-in and subobjects
by geoff＠northernwastes.org 20 Mar '00

20 Mar '00

So... I'm sure the answer to this question is painfully obvious, but I've pounded on the docs and I can't find it for the life of me. I have created a subclass as per the instuctions in the Zope Developers Guide. I am doing this specificly to avoid my inner class polluting the global product list. (There will ulimately be a large number of these inner classes if I can figure this out.) So far, so good. Using the dtml-var tag I can display any property of any instance of my newly created subclass. But I also need to build a table that iterates though all instances of this subclass and displays several of it's properties. I suspect this involves the use of the dtml-in tag, but I can't for the life of me figure out what the syntax should look like. The discussion of dtml-in tag seems to imply a list of objects in a folder, and what I have is a list of subobjects in an object. Hints anyone? How-To? FAQ? TIA, Geoffrey L. Wright

3 3

mimetools -- an example, I hope this helps
by Clarence.Pate＠bridge.bellsouth.com 20 Mar '00

20 Mar '00

I had to play around to get mime stuff to work right. I needed to email messages to about 1500 people. Every person reaceived a couple of documents that were the same, and each person received one document that was unique for that individual. I also through in a timer loop to provide a one minute delay between each email message. (Our mail server could not handle the load.) I am enclosing the code that worked for me. Of course ymmv :) pull_contacts : this is an sql method which pulls user information out of an Access database. Most of the variables listed come out of this database. dtml-log : I used the logger product to create some logs so that I could see that my mail messages went out. I don't think this worked the way I wanted it to work. mime tag : I added some custom code to the mime stuff because the mime stuff does not add the mime version 1.0 header. This may not cause problems for everyone else, but it does cause problems for HP OpenMail and Lotus Notes. I do not know if anyone has fixed this in the standard zope code, but it was not working when I did this mailout. "_[QUESTION].data" : this was what I had to do to pull in the unique object for each individual. (I imported all of my documents into the zodb.)   <dtml-log severity=INFO subsystem=ContactReports> <dtml-logdetail> ;, ; start timer: ; stop timer: ; </dtml-log> <dtml-try>  Subject: !!!This is an email message!!! To:   TO : ,   EMAIL:  FROM : dilbert EMAIL: dilbert(a)dilbert.com This is part of the message from dilbert      <p> mailed;;;;;;;;; </p> <dtml-except> <p> failed;;;;;;;;; </p> </dtml-try>  There was no data matching this  query.  <h2>Thanks for playing the game!</h2>  Clarence T. Pate

1 0

SiteAccess breaks FTP!
by Chris Withers 20 Mar '00

20 Mar '00

Hi, I'm trying to sort out the relative URLs of some virtually hosted Zope sites. In a nutshell, there some sites visible to the outside world as www.site1.com, www.site2.com, etc These are in /site1, /site2, etc folders off Zope's root. The redirection is done using Apache's Proxy method, but I need to sort out BASE, URL, and absolute_url() type things, which I'm doing using the following Site Access Rule: <dtml-in virtual_hosts> <dtml-if "REQUEST.environ['HTTP_HOST']==_['sequence-item']"> <dtml-call "REQUEST.set('SiteRootPATH','/')"> </dtml-if> </dtml-in> and blank SiteRoot objects in /site1, /site2, etc. The only problem is that since I did this, I get the following whenever I try to FTP into Zope (which used to work fine and which we use quite heavily for content editing with Dreamweaver): 550 Could not list directory. Why do I get this? How do I stop it happening? (preferably without stopping using SiteAccess...) If anyone has any experience with this, I'd appreciate the help... Chris

2 3

FastCGI - what happened?
by Frank Tegtmeyer 20 Mar '00

20 Mar '00

Does anybody know what happened to the FastCGI-Site at idle.com? I try to get the snapshot version of mod_fastcgi for a week now without success. Can anybody help out? Regards, Frank

1 0

Lost Objects after System Crash (Zope 2.1.5 on Win32)
by Alexandre Ratti 20 Mar '00

20 Mar '00

Hello, I upgraded to Zope 2.1.5 (Win 32) Saturday and carried out changes in the database (eg. created new ZClasses, added ZClass instances, etc.) I had a nasty system crash (Win 95) around midnight Saturday. When I reopened Zope I realised the database was back to its 16:22 status: - All new objects had vanished. - The last transaction logged in the Undo list is dated about 16:22. - The very Data.fs in the filesystem is stamped 16:22 if you can believe it. I checked the Z2.log and it shows these missing changes. So I didn't dreamt doing them. I suppose these changes are lost? Cheers. Alexandre

1 0

Site Access Rules and Permissions
by Chris Withers 20 Mar '00

20 Mar '00

Hi, I have the following access rule: <dtml-if "_.has_key('virtual_host') and REQUEST.environ['HTTP_HOST']==virtual_host"> <dtml-call "REQUEST.setURL(path='/')"> </dtml-if> The idea being that if a folder represents a virtual host (see the thread 'REQUEST vraible methods' on this list for background...) you can just give that folder a virtual_host property which the above rule checks for, and if it matches that in the header, if sets the base path to '/'. However, if I try and access any folder with this rule in it, I get challenged for authentication and get 'Authorization failed' no matter what username and password I use, including the root ones! What is going on? Chris

4 14

Re: [Zope] Zope 2.1.5 release and *security update*
by Chris Allen 20 Mar '00

20 Mar '00

Yeh, and now that ZSQLMethods don't work neither does GUF with MySQL - e.g., the following code fails: <dtml-in "sqlGetUserRoles(username=username)"> <dtml-call "REQUEST.set('ret', ret + ' ' + _['sequence-item'].rolename)"> </dtml-in> <dtml-return ret> With the error message: "You are not authorised to access 'rolename'" The method has a Proxy role with appropriate access to the MySQL method. It just doesn't seem able to access the results variable!? Regards, Chris "Graham Chiu" <anon_emouse(a)hotmail.com> wrote in message news:<Gl2o8NAvI$04EwL1(a)compkarori.com>... > In article <613145F79272D211914B0020AFF6401914DE7D(a)gandalf.digicool.com> > , Brian Lloyd <Brian(a)digicool.com> writes > > o It also came to our attention that the DTML code in > > ZSQLMethod objects was not subject to the same security > > constraints as the DTML code in DTMLMethods and DTML > > Documents. > > Hmm. This update has broken all my zsqlmethods I've tested so far. I've > reverting to 2.1.4. > > Eg when testing from the management interface: > > File D:\zope2\lib\python\Shared\DC\ZRDB\DA.py, line 459, in __call__ > (Object: sqlShowComment) > TypeError: too many arguments; expected 4, got 5 > > SQLSESSION has also died with this version release. > > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz > http://www.compkarori.com/dynamo - The Homebuilt Dynamo > http://www.compkarori.com/dbase - The dBase bulletin >

2 1

restrict method to IPs
by Dyon Balding 20 Mar '00

20 Mar '00

i want to restrict a particular method of my product to a set of IPs. i was thinking of creating a user limited to those IPs, and assigning it a local role which corresponds to the particular method. is there a better way? thanks -d -- Adroit | Dyon Balding dyon(a)adroitnet.com.au Internet | http://www.adroitnet.com.au/ Solutions | work: +613 98888522, mobile: +61 0414992604

2 1

w3m and the management interface
by R. David Murray 20 Mar '00

20 Mar '00

There was a recent mention of using Lynx to access the management interface of Zope. I'd like to use w3m. It produces a more pleasing page given all those little spacer images Zope uses. Also, it automatically launches vi for me when I hit return on the edit screen's text input area, which is *way* cool <grin>. However, it doesn't seem to be handling the management interface correctly. If I descend into a management link, I get the 'view' panel for the link instead of the manage_main screen. Worse, I tried to 'rename' an index_html method, and it renamed the index_html in the *parent* folder! This is most weird. Anyone know what Zope could be emitting that w3m is not handling correctly? I'd guess redirects, but I'm surprised I end up in the view screen in that case... I'm currently running w3m beta-991203. Anyone know if whatever-it-is is fixed in a later version, assuming there is one? --RDM

2 2