March 2002 - Zope - Zope lists

Re: [Zope] What causes the community to stall so often?
by BZ 13 Mar '02

13 Mar '02

I am not sure if it is the community stalling so much as hitting the peaks and valleys of the development cycle. Besides, the Zope Corp people I am sure that most of us have full time (or at least part time) jobs that are non Zope. I have had mostly-full time Zope jobs and when I was doing that I was more involved in writing tips, how-tos, products, etc. I think Zope documentation (not the Zope product) suffers from the critical mass. There has to be enough people in the pot to be able to both develop and document. Right now, most of us are focusing on developing products, applications, websites and not on documentation. It is also clear that documentation itself does not provide income. If I build out another website in Zope, I can build a community and another revenue source. If I write a how-to, well, I get a gold star in the community (maybe) and it that good open source "warm feeling." So, it comes down to economics. That being said, there are now 3 (maybe 4) books out there on Zope and I can easily remember the day when there was a total of 0. There are more and more products being developed and not just stupid discussion boards :) but real, meaty products that people can make money with. That trend is a good trend. As the economy picks back up, there will be more work for consultants, more consulting and more demand and production of documentation. Do we need more books, websites, help areas, FAQ's, etc? Yes. Will they come? Yes. I have at least two of those in (not telling which ones) in the works. But time is money and money is the key. BZ

22 55

RE: [Zope] Inserting values into db - problems
by Joel Burton 13 Mar '02

13 Mar '02

Put it in the ZSQL Method; that way we can see *exactly* what it gets. Then: * can you test the ZSQLMethod (with the test tab) and have it work? * can you call the ZSQLMethod w/a hand-crafted URL and does it work? Don't understand the question about an if block? What are you talking about? Joel BURTON | joel(a)joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant > -----Original Message----- > From: Wayne Pascoe [mailto:wayne.pascoe@ehsrealtime.com] > Sent: Wednesday, March 13, 2002 8:42 AM > To: Joel Burton > Subject: Re: [Zope] Inserting values into db - problems > > > On 13/3/02 1:26 pm, "Joel Burton" <joel(a)joelburton.com> wrote: > > > Hmm. I don't see anything wrong. > > > > Try putting a <dtml-raise> in your method with that will show > you the value > > of "client". It might be obvious once you see what it thinks client is. > > > > BTW, small point: now() is deprecated syntax in PostgreSQL. In > the future, > > you want to use CURRENT_TIMESTAMP (not a function, no parens), > which is the > > SQL standard compliant. > > Stupid question - Where would I put the dtml-raise ? Does it go in the > dtml-document that calls the Z SQL method or does it go in the Z > SQL method > ? > > Also, do I have to use an if block like in the example at Zope ? > > Thanks, > > -- > Wayne Pascoe <wayne.pascoe(a)ehsrealtime.com> > > The price of freedom is eternal vigilance > - Thomas Jefferson >

1 0

Redirecting
by Antonio Beamud Montero 13 Mar '02

13 Mar '02

Hello again: I have a form, and the action of this form is used by some forms in diferent parts of my site, I want to redirect te return of this action to the proper site... I have done something like this: def process(self, name, REQUEST=None): ... (blah, blah, blah...) if REQUEST is not None: return REQUEST.RESPONSE.redirect(REQUEST.get('HTTP_REFERER')) Is the correct form? Thanks. -- Microsoft merges technologoies: Windows CE + Windows ME + Windows NT = Windows CEMENT ---- Antonio Beamud Montero Agora Systems S.A. http://www.agoratechnologies.com

1 0

Inserting values into db - problems
by Wayne Pascoe 13 Mar '02

13 Mar '02

Hi all, Part of a site I'm working on needs to be able to insert job numbers into a database. I'm using PostgreSQL as the backend and psycopg as the connecter. I am able to select values from the database without problems. However, I can insert anything. I have a dtml document that prompts for values called addJobNumber. This has an action of another dtml document named commitJob. commitJob has a dtml-call to insert_job which is a Z SQL method. The Z SQL method is as follows: insert into y8 values( now(), now(), <dtml-sqlvar client type="string"> <dtml-sqlvar description type="string">, <dtml-sqlvar product type="string">, nextval('y8_number'), <dtml-sqlvar description type="string">, <dtml-sqlvar client_job_number type="string">, <dtml-sqlvar client_po_number type="string">, <dtml-sqlvar client_contact type="string">, <dtml-sqlvar tech_contact type="string">, <dtml-sqlvar job_close_date type="string"> ) When I try this, I get an error saying : Missing input variable, client Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: localhost) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: commitJob) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: commitJob) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 414, in __call__ (Object: insert_job) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: <string>) File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 99, in render (Object: client) Missing Input: (see above) If I remove the dtml-call in the commitJob document and just print each value using <dtml-var client><br><br> All values print as expected (as entered on the previous form) Is there anything obvious that I'm missing here that could be causing this problem ? TIA, -- Wayne Pascoe <wayne.pascoe(a)ehsrealtime.com> The price of freedom is eternal vigilance - Thomas Jefferson

2 2

STATISTIC] Is there a way to have statistic of a Zope site use ?
by Fr�d�ric Lemaitre 13 Mar '02

13 Mar '02

Hello, A have my Intranet Zope production site since few days (GREAT !!!). I would like to know if there is a way (without manualy analyse the access log) to know : - How many users have been authentified since the site is on-line ? - How many times a page has been seen ? - The top visited pages ? - Statistic of when, how much, etc.. users use the site ? In fact, is there a Zope functionnality to do something like that whithout using an other software (like Webtrend) ? Thanks in advance. Fred.

4 3

Re: What causes the community to stall so often?
by Terry Hancock 13 Mar '02

13 Mar '02

(I can't believe this thread is still going, but what the hey ... here's my 2 cents, I can hope it'll have some impact) I think the reason that Zope documentation is poor, and in particular why Zope developers don't write much is because they would much rather add features than fix bugs and oversights in their earlier work (or even think about them). Take ZPT. *Another* language? Zope already maintains one and depends heavily on another. They themselves declare DTML a failure, but they've got it all right this time? "Fool me once, shame on you. Fool me twice, shame on me!" ;) And ZPT is completely different, doesn't work in all the same places, and is (IMHO) ridiculously cumbersome and non-intuitive. Maybe I haven't given it a fair review yet, but the reality is, I just don't have time for it. Certainly it is not a natural extension to DTML, nor a replacement for it. Why not just fix DTML so it isn't so ridiculously hard to document and use? Consider just a couple of really obvious problems (dozens of more subtle problems can no doubt be unearthed): GET RID OF THE STUPID DASHES! "sequence-item" -- Oh come on! Where'd that come from? Other languages (including Python), use a "." for this kind of purpose (e.g. why not represent "sequence" as a Python class with "item", "index" attributes and/or "odd()" "even()" methods). That would probably make the most sense. Barring that, why not simply substitute "_" for "-". Then at least, we could use: sequence_item.absolute_url() (for example), instead of the ridiculous work-around: _.getitem('sequence-item').absolute_url() "_." -- Why do we have this? In a Python script we use builtins as builtins, now they're all methods of this mysterious object. Why? And is it REALLY that hard to fix? Actually namespaces in Zope are altogether a mess. I'm not sure I even understand them now, but it seems to me that some simplification may be in order. DTML would be SOOOO much easier to understand (and explain) if it only made sense to begin with. (It's also notable that the above criticisms are actually of the Python API which exists inside DTML expressions. The worst criticism of this is that it is inconsistent with the Python API in Python Scripts). And I emphasize that DTML is actually a very good concept -- DTML is like a rough sketch of a good idea. The problem is that it needs to be redrafted to capture that idea better. I did recently discover a rationalization which I applaud: Previously, the filesize of Image and File types was acquired from the "getSize()" method, while DTML Documents and Methods used "get_size()". In Zope 2.4.3, both methods are available for both sets of classes, though I haven't figured out which is preferred (the rationalization is not reported in the Zope 2.5 API online at www.zope.org) Zope is a good thing already. It doesn't need more junk. What it needs is a whole lot of straightening up. And if it were straightened up, it'd be a whole lot easier for people like me, who *like* to write, to write documentation for it. Right now I wouldn't touch it with a ten-foot pole! In short, the documentation is poor, because even the people who would write it can't figure Zope out. Contrast with how carefully the Python syntax options are reviewed (not just by Python developers, but by Python programmers worldwide) before they allow additions. That kind of conservativism can be frustrating, but it also keeps the API pretty clear of debris, and makes the way a lot easier for experienced and new developers alike. Zope developers obviously appreciate this, or they wouldn't have developed in Python to begin with, so why not apply it to Zope? What I'm waiting for is the day when *www.zope.org* will print this message that www.python.org has had (e.g. on the 2.1.2 release page) for some time: "we've been very careful to fix only bugs and not add new features." That is such a warm feeling! I wish I could feel that way about Zope. IMHO, of course, Terry -- ------------------------------------------------------ Terry Hancock hancock(a)anansispaceworks.com Anansi Spaceworks http://www.anansispaceworks.com P.O. Box 60583 Pasadena, CA 91116-6583 ------------------------------------------------------

6 6

Re: [Zope] ftp and virtual hosting question
by Richard Barrett 13 Mar '02

13 Mar '02

At 13:44 12/03/2002 -0500, Jiann-Ming Su wrote: >On Tue, 12 Mar 2002, Richard Barrett wrote: > > > Are you asking whether standard Zope can accept an FTP login and, > depending > > on the user ID presented, automatically do an FTP cd to the user's "home" > > folder, having determined where that is by computation from which acl_user > > folder their user ID is defined in? > > > >Yes, that's what I'm asking. What's the alternative for doing a wholesale >upload? Is WebDAV the solution? The database being handled by Zope is a tree rooted at '/'. From your earlier posts you have sub-trees below the root each of which constitutes a web site. When delivering data to users via HTTP, you are using Apache Proxypass/RewriteRule with Zope's the Virtual Host Monster to give the appearance of multiple separate web sites. However, viewed through Zope direct interfaces i.e. through the TCP interfaces it provides, regardless of protocol, be it HTTP, FTP or WebDAV, the fact that the 'virtual web sites' all exist within a common hierarchical structure cannot be totally hidden. So the answer to the question is No, not through Zope's direct interfaces. But bearing in mind what you said previously the effects of this can be mitigated. At 10:21 12/03/2002 -0500, Jiann-Ming Su wrote: >That is, if I have an acl_uers/ folder in /VirtualHost/Host1, how do I >get a defined user for Host1 to ftp directly into /VirtualHost/Host1? > >Right now, I have to authenticate through the acl_users/ in the root folder, >which gives me access to a bunch of other folders as well. You may be able to achieve part of what you want to do as follows : 1. You do not have to put have all the user ids declared in acl_users in the root '/' folder. 2. You can declare the user ids, per virtual host, in acl_users within each virtual host's 'root' folder as per the following example layout. /--| |--hosta--| | |--vhost1--| | | |--acl_users | | | | | | |--vhost2--| | | |--acl_users | | | 3. Remove the 'FTP Access' privilege for everybody except role Manager from '/' and 'hosts'. 4. Assign your users the local role of Member for the 'home' virtual host folder. 5. Give the Member role 'FTP Access' privilege for each of the virtual host folder. 6. With this set up each user can FTP login and then FTP cd to their 'home' virtual host folder. 7. The fact that the user do not have 'FTP Access' privilege over '/' folder, indeed that their user id doesn't exist at the root folder level doesn't prevent them FTP logging in. 8. The user's can successfully FTP cd to their 'home' virtual host folder having logged in but will be prevented from FTP cd'ing to any other virtual host folder. 9. Users cannot discover by examination the content of intermediate folders between '/' and their 'home' virtual host folder as they cannot FTP cd to these intermediate folders or perform FTP ls operations on them. 10. The downside is that the users have to know the path to their 'home' virtual host folder from '/'. How well this will work from the user standpoint depends to some extent on the FTP access tools the user chooses. a. I find that with this arrangement I can access and upload directory trees and their contents using IE5 under Win2K using a ftp scheme URLs of the form ftp://<userid>:<passwd>@wickwar.ftel.co.uk:8021/hosts/vhost1/. But note the need to embed the user id and password in the URL. You do not get a prompt for credentials with ftp scheme URLs like you do with http scheme URLs. You have to present them as part of the URL. This is nasty in that someone looking over your shoulder can see them on the screen on they are 'visible' un-encrypted in transit between your browser and the server to any intermediate proxies. In the worst case they might even appear in some logs. b. WS_FTP works OK as long as the the Remote Site Folder for the connection is preset to the correct value. Otherwise, WS_FTP tries to list the folder it first gets to: typically '/'. This fails if the user doesn't have 'FTP Access' permissions and WS_FTP then regards the connection attempt as having failed. Security should be better in that this is proper connection oriented working and the credentials are only exposed at login time. c. Linux command line FTP presents no particular problems in use. As for WebDAV, I cannot say how this would work as I'm not familiar with using it. Hope this helps your thinking on the topic. >-- >Jiann-Ming Su jsu2(a)emory.edu 404-712-2603 >Development Team Systems Administrator >General Libraries Systems Division

1 0

Re: [Zope] Re: Dear Listowner...
by Stephan Goeldi 13 Mar '02

13 Mar '02

>Hmm, so you're tyring to tell us humble Winblows lusers that we are not as >technical as you oh so powerful and experienced *nix/TOS/AmigaOS or >whatever >it is you use these days users. yes. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com

1 0

Remove ZEO
by Gilles Durys 13 Mar '02

13 Mar '02

Hi, I got here a zope installation with zeo that I didn't install myself. My boss asked me to remove zeo so that zope runs on its own. I have no experience with zeo so I'm asking you if: 1. is this possible ? 2. is this easily done ? Thanks -- Gilles Durys

2 1

Re: [Zope] Inserting values into db - problems
by Harry Wilkinson 13 Mar '02

13 Mar '02

Well the first thing I notice is that you have 'description' in there twice. I don't know if that's the problem you're encountering now, but it could be a bad thing. Harry > Hi all, > > Part of a site I'm working on needs to be able to insert job numbers into a > database. I'm using PostgreSQL as the backend and psycopg as the connecter. > I am able to select values from the database without problems. However, I > can insert anything. > > I have a dtml document that prompts for values called addJobNumber. This > has an action of another dtml document named commitJob. commitJob has a > dtml-call to insert_job which is a Z SQL method. > > The Z SQL method is as follows: > > insert into y8 values( > now(), > now(), > <dtml-sqlvar client type="string"> > <dtml-sqlvar description type="string">, > <dtml-sqlvar product type="string">, > nextval('y8_number'), > <dtml-sqlvar description type="string">, > <dtml-sqlvar client_job_number type="string">, > <dtml-sqlvar client_po_number type="string">, > <dtml-sqlvar client_contact type="string">, > <dtml-sqlvar tech_contact type="string">, > <dtml-sqlvar job_close_date type="string"> > ) > > When I try this, I get an error saying : > > Missing input variable, client > > > Traceback (innermost last): > File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in > publish_module > File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in > publish > File /usr/local/zope/lib/python/Zope/__init__.py, line 158, in > zpublisher_exception_hook > (Object: localhost) > File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in > publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in > mapply (Object: commitJob) > File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in > call_object > (Object: commitJob) > File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in > __call__ (Object: commitJob) > File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, > in __call__ > (Object: commitJob) > File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 414, in > __call__ > (Object: insert_job) > File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, > in __call__ > (Object: <string>) > File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 99, in > render > (Object: client) > Missing Input: (see above) > > If I remove the dtml-call in the commitJob document and just print each > value using > <dtml-var client><br><br> > All values print as expected (as entered on the previous form) > > Is there anything obvious that I'm missing here that could be causing this > problem ? > > TIA,

1 0