- Zope - Zope lists

Images and Zope1.10.2
by Shaw, Howard 09 Mar '99

09 Mar '99

I have a nifty system whereby each individual I add to a database automatically gets a personal directory and password. One of my users has come to me with a problem. He can add images to his directory, but cannot subsequently edit the image (i.e. open the image's manage screen) as it complains about lack of permissions. The security role he has contains all the image related options I see. He can delete it, btw. This is not an immediate issue, but I do wonder why the permissions don't seem to be working in a sensible manner. Why should he be able to add images, but not manage them? Are there extra 'image manage' permissions? If so, where do I find them?

1 0

Re: [Zope] ZServer as a windows NT service?
by Robin Dunn 09 Mar '99

09 Mar '99

I currently have ZServer running as a service on two machines using the srvany.exe tool from the NT resource kit or from MSDN. Essentially srvany is the actual service and then you tell it via registry settings what other program you want to run. It works good enough for me for the time being. The only problem is that the service stop message does a hard kill on the ZServer process so any last second updates to the Zope DB might be fragmented if it wasn't finished writing, but with the way the DB works at least the DB will still be usable. I am out of the office right now so I can't provide step by step instructions right now. There is a .doc file that comes with srvany.exe that I followed. I specified that Python was the executeable to be run by srvany, the ZServer directory is to be the CWD, and that the command-line should be start.py. Worked first try. Of course the right thing to do would be to integrate native service capabilities into ZServer itself via the win32api packages. That way ZServer could shhutdown gracefully and could send meaningful things to the event log. But srvany is good enough for alpha level, non-production servers. And I havn't had any problems to speak of dealing with running it as a service. -- Robin Dunn robin(a)AllDunn.com http://AllDunn.com/robin/ http://AllDunn.com/wxPython/ Check it out! Try http://AllDunn.com/laughworks/ for a good laugh. -----Original Message----- From: Dick Wall <dick.wall(a)mediamail.telinet.com> To: zope(a)zope.org <zope(a)zope.org> Date: Tuesday, March 09, 1999 5:09 AM Subject: [Zope] ZServer as a windows NT service? >Hi all, > >I have been using python for years, and zope for a few months now (lovely), >ZServer for weeks, but Windows NT? Not long enough to understand the >differences between services and ordinary process (give me a break, I am >heavily from a Un*x background) :-). > >I know when I installed the binary version of Zope on the windows machine >here it gave me a service in the services list which I can activate on >startup. However, I am betting that this runs the ZopeHTTPServer, not the >ZServer which I got as a separate download. I have everything working just >lovely with the ZServer now, but it needs to be run as an NT service (and >respond to start and stop signals, etc) at which point I freely admit my >own inadequacies in this area. > >Now my question. How can I do what I need to do. Is it simply a case of >redirecting a python 'shell' file used by the service to the start.py in >the ZServer module, or is there more to it? If it is this simple, which >python 'shell' file do I use? If it is not this simple, can someone send me >basic instructions on how to do it (why is NT like this - give me an >rc.local file any day - I know where I stand with that stuff). > >Thanks in advance. > >Dick > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(For developer-specific issues, use the companion list, >zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

RE: [Zope] tree doesn't work 4me linux amd win32
by Michel Pelletier 09 Mar '99

09 Mar '99

> -----Original Message----- > From: Andy Heath [mailto:A.K.Heath@shu.ac.uk] > Sent: Tuesday, March 09, 1999 12:06 PM > To: zope(a)zope.org > Subject: [Zope] tree doesn't work 4me linux amd win32 > > > I'm a zope newbie. > > I just installed on a windows 95 box and on a linux 2.0.something > but I can't get anything with tree working (other stuff seems ok). > > Hadars' second sample app doesn't work for me (the tree part > produces no output). > > Even the minimal > >  >  > > doesn't produce output (tried this with the second Habar example after > creating the "sub-folders"). > > I get the same behaviour on windows as linux. > > I must be doing something wrong. Clues please ? > I bet your using a DTML Document. Try using a DTML Method. The reason why the tree tag renders nothing for the DTML Document is because DTML Documents are not containers of other objects, they are objects to hold DTML content. DTML Methods are (and this is the suble thing) *methods* of the Folder object that contains them. They are not 'objects' in the same sense of the term used for DTML Documents (I can hear Jim saying now "*everything's* an object"). Because Folder objects *are* containers, the #tree tag used in a Folder's DTML Method will render the contents of that Folder. Hadar's example is a little outdated, it is based on 1.9, in which DTML Documents didn't exist, and all Documents were DTML methods. -Michel > Andy > btw: Zope looks really good to me (when I can get over these > glitches). > > --------------------------- > Andy Heath, Senior Lecturer a.k.heath(a)shu.ac.uk o > Sheffield Hallam University. Phone: +44 114 2534904 /\ > Sheffield, England Fax: +44 114 2533161 () () > > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

bug with SQL methods?
by Jordan B. Baker 09 Mar '99

09 Mar '99

Hi, I'm re-posting to this list because it probably is more suited here... thanks in advance, ------- Jordan B. Baker -- jbb(a)spyderlab.com weaving the web @ http://www.spyderlab.com ---------- Forwarded message ---------- Date: Fri, 5 Mar 1999 12:11:02 -0500 (EST) From: Jordan B. Baker <jbb(a)spyderlab.com> To: zope-dev(a)zope.org Subject: [Zope-dev] SQL methods q: Hi guys: I'm trying to write a SQL method though, and its giving me an error when I try to test it.. Error, exceptions.TypeError: keyword parameter redefined SQL used: Could not render the query template! The query I was using: SELECT searches.engineID as engine, queries.param as query, MAX(searches.timestamp) AS time, searches.position AS position, MIN(lastsearch.timestamp) AS lastupdate, lastsearch.position AS lastsearch, searches.URL as URL, 'NA' as change, engines.graphic as engine_gfx FROM searches LEFT JOIN searches as lastsearch USING (queryID,engineID), engines, queries WHERE lastsearch.timestamp BETWEEN  AND  AND searches.timestamp BETWEEN  AND  AND queries.clientID =  AND queries.queryID = searches.queryID AND engines.engineID = searches.engineID AND searches.timestamp != lastsearch.timestamp GROUP BY searches.engineID, searches.queryID ORDER BY searches.engineID ASC, searches.queryID ASC, searches.timestamp ASC, lastsearch.timestamp DESC ; Any ideas what I could be doing wrong? BTW, Zope is great! I've been kinda messing around with it for a while, also checking out PHP3 and other UNIX-based scripting languages and I've very impressed. As soon as I figure out what is causing this I plan to write something 'cool' with Zope :) TIA, -jordan. _______________________________________________ Zope-Dev maillist - Zope-Dev(a)zope.org http://www.zope.org/mailman/listinfo/zope-dev

5 10

tree doesn't work 4me linux amd win32
by Andy Heath 09 Mar '99

09 Mar '99

I'm a zope newbie. I just installed on a windows 95 box and on a linux 2.0.something but I can't get anything with tree working (other stuff seems ok). Hadars' second sample app doesn't work for me (the tree part produces no output). Even the minimal   doesn't produce output (tried this with the second Habar example after creating the "sub-folders"). I get the same behaviour on windows as linux. I must be doing something wrong. Clues please ? Andy btw: Zope looks really good to me (when I can get over these glitches). --------------------------- Andy Heath, Senior Lecturer a.k.heath(a)shu.ac.uk o Sheffield Hallam University. Phone: +44 114 2534904 /\ Sheffield, England Fax: +44 114 2533161 () ()

1 0

RE: [Zope] sqltest vx. var
by Rob Page 09 Mar '99

09 Mar '99

> I'll correct myself here. I was thinking of the >  tag. I > don't know what  does that  or >  won't do... I meant to bring this up in my earlier post -- this tag too, is used to simplify what could be a terribly complicated SQL Method given an indeterminate number and list of search criteria. With this tag you can permit an arbitrary arguments to be supplied connected with your predetermined ANDs and ORs This one tag has, in the past, reduced may SQL Methods into one -- natural maintenance savings. --Rob

1 0

Re: [Zope] sqltest vx. var
by Philip Aylesworth 09 Mar '99

09 Mar '99

>Something I'm just curious about... > >where  > >VS. > >where column_name =  > >Is the only advantage of using the first (sqltest) the type checking? I >can't find any other obvious advantages. > I haven't played with it too much but I think that Zope handles undefined variables properly if you do the sqltest. ie. where  and  will work if name2 is not defined. It also handles the quoting and SQL syntax (such as doubling single quotes). Phil A ------------------------------------------ Philip Aylesworth zopelist(a)regalint.com Regal International

1 1

RE: [Zope] sqltest vx. var
by Rob Page 09 Mar '99

09 Mar '99

> >Something I'm just curious about... > > > >where  > > > >VS. > > > >where column_name =  > > > >Is the only advantage of using the first (sqltest) the type > checking? I > >can't find any other obvious advantages. > > > > I haven't played with it too much but I think that Zope > handles undefined > variables properly if you do the sqltest. > > ie. > > where  > and  > > will work if name2 is not defined. > > It also handles the quoting and SQL syntax (such as doubling > single quotes). Absolutely... we ran into some situations where the SQL was so dynamic potential security problems arose. sqltest and sqlvar are designed to reduce that exposure. Additionally, we've found a very common rhythm where a search UI might expose all of a large percentage of the available data elements in the RDBMS. Using sqltest lets the user not specify one or more parameters without a lot of messy  stuff in the SQL Method. --Rob

1 0

RE: [Zope] ZServer as a windows NT service?
by Paul Everitt 09 Mar '99

09 Mar '99

Dick wrote: > startup. However, I am betting that this runs the > ZopeHTTPServer, not the Not quite. ZopeHTTPServer is a console app just like ZServer. The service is a PCGI-like thing that runs Zope as a service, listening for named pipe connections from something that is run as a CGI by the web server. > ZServer which I got as a separate download. I have everything > working just > lovely with the ZServer now, but it needs to be run as an NT > service (and > respond to start and stop signals, etc) at which point I > freely admit my > own inadequacies in this area. ZServer is still at alpha 2 so it's premature to focus on things like how it is packaged. I *think* we have all the issues figured out and the next release, perhaps this month, will be a beta1. Until we get into beta, we'll have to hope that someone in the community packages it up as a service. > Now my question. How can I do what I need to do. Is it simply > a case of > redirecting a python 'shell' file used by the service to the > start.py in > the ZServer module, or is there more to it? If it is this > simple, which > python 'shell' file do I use? If it is not this simple, can > someone send me > basic instructions on how to do it (why is NT like this - give me an > rc.local file any day - I know where I stand with that stuff). One issue off the top of my head is integration with the NT Event Log. --Paul

1 0

Re: Why doesn't this loop over files?
by Butch Landingin 09 Mar '99

09 Mar '99

In a previous posting, Tony McDonald <tony.mcdonald(a)ncl.ac.uk> wrote: >Hi, >I've d/led the ZopeDemos folder, installed it and started learning >more about Zope, but there's something happening that I'm not sure >about. > >The 'looping' example doesn't seem to iterate correctly over new >additions to the folder. The DTML is here: <... additional text deleted ...> There's a bug in the code, something I noticed when I was playing with the examples too. this is the fixed version: 001  002  003  004 <H3>Objects of type </H3> 005 <TABLE BORDER=1> 006 <TH>Id</TH><TH>Title</TH> 007  008 <TR><TD></TD> 009 <TD></TD></TR> 010  011 </TABLE> 012  013  014  About the bug and the fix: the bug was due to the statement  looping over the current folder, not the subFolder which it should be. By moving the "with" statement to enclose it (see line 002), the statement <!--#if "objectValues(... now loops over the objects inside the folder named "subFolder". I don't know who is maintaining the ZopeDemos product (or if it's being maintained at all), but I hope he/she takes note of this and posts an update. Hope this helps. Butch Landingin butchland(a)yahoo.com PS. I'm playing around with the Confera product (making it more slashdot-like) but I know it's not "officially supported" by Zope/DC -- so who's maintaining it? I have some detailed questions about the code (but I don't know if it's off-topic for Zope/Zope-dev). _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com

4 4