August 2000 - Zope - Zope lists

need some basic help
by Dan Huston 11 Aug '00

11 Aug '00

Hello Folks, So I downloaded Zope and installed it on my sun box and on my nt box. I can go to the manage page as the admin and it all looks like it installed fine. So I tried to create a folder but the superuser cannot own a folder it says. So I figure I can create a folder in the zope dir as one of the users I have defined, but then how do I add objects to that folder? The only login that works at the manage page is the admin password. Is there a different page for users to go to that is similar to the manage page? I can believe that the admin would have to add all of the objects as that would seem un-Zope-ish. I have looked at a lot of docs but they were either so basic as not to address hands on stuff (devshed) or advanced enough that it was assumed that you could do this simple task. Can someone straighten me out? Thanks, Dan

3 2

Python + COM (from external method)
by Steinar Rune Eriksen 11 Aug '00

11 Aug '00

How come this fails... ------------------------------------------ import win32com.client oOleObj = win32com.client.Dispatch("DSOleFile.PropertyReader") -------------------------------------------------- when run from Zope (within and External Method) when it works from Python standalone on the same machine ? SRE ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Admin Orion System AS **********************************************************************

3 2

RE: [Zope] zope2.2.0 and what is high load
by Chris McDonough 11 Aug '00

11 Aug '00

> On Fri, 11 Aug 2000, Chris McDonough wrote: > > > i went to each Zeo client control_panel, and see that there's > > > a mzximum of > > > four connections open at any given time. > > > comments to the above. i saw only four threads because i > started that > particular box with the default. on the box with -t25, i see 7 open > connections at any given time. sorry, my mistake. Oh, ok... that makes more sense. > > You may want to ramp your number of threads down to 5 > (-t5). 25 doesn't > > do much for you because only 7 threads can be using > database connections > > at any given time. The high number of threads you're > servicing might > > actually be slowing things down as they contend for > available database > > connections. > > > will do. and hope to see that it does something. Based on your findings that all 7 DB connections are being used, I'd revise the number of threads to 8. > > It doesn't seem as if bumping your number of database > connections will > > do us any good here, because it doesn't seem you're using > all 7. I'm > > not sure *why* you're not using all 7, because you've got > at least 15 > > processes waiting around just on your top screen for DB connections. > > i did some grepping and saw the magical number 7 in > ZODB/DB.py. is that the > number to turn up if i wanted to try increasing the db pool > connection? i do > have postgresql with ZPygreSQL. will that have anything to > do with what i'm > facing? Yes, it's the pool_size parameter. You can increment this value *carefully* if you see that you have more threads hanging around than DB connections, like you're seeing now. I have no idea what this will do to your relational stuff. The "right thing to do" is to test this outside of production. I don't want to tell you to go ahead and muck around on a production server. But if it were *me*, I might be tempted to: - First, lower the number of threads via -t8 and see what effect that has on speed. - If that doesn't solve anything, bump up both the NUMBER_OF_THREADS and the pool_size up to 10 or 12, then do some checking, and see if you still have threads waiting for a DB. Continue doing this in increments of 2 or 4, making notes as you go. Note that if it breaks your site, I'll deny I ever gave you this advice. :-) Proceed at your own risk. > i love zope, and open source in general, and i can't bear > having to switch to > using something i don't really like. Geez, I hope not. This is an eminently solveable problem.

2 1

RE: [Zope] Defining High Load in Heavily DB Driven site (was: [Z ope] zope2.2.0 and what is high load)
by Jens Vagelpohl 11 Aug '00

11 Aug '00

hi dario, to clear up some possible misunderstandings and naming issues: we have two different beasts here. one is the number of threads that zope uses while it runs. this can be tweaked by invoking the start script with an argument like "t <number_of_threads>" or by editing z2.py and changing the default number of 4 threads. again, these are application threads. the database connections that were talked about are a different issue. these refer to the number of connections zope creates to its underlying ZODB object store. you can see them if you go to <myzope>/Control_Panel/manage_debug in Zope < 2.2.0 or by using the link in the control panel in Zope > 2.2.0. the number of these connections is set in <zope>/lib/python/ZODB/DB.py and the default is 7. in general, when a thread attempts to do anything with zope it needs to get hold of a ZODB connection so it can read or otherwise manipulate objects in the ZODB. this is why the number of application threads should be smaller than the number of ZODB connections. tweaking these numbers is possible, but mileage may vary depending on your specific site and usage. jens ---- Jens Vagelpohl jens(a)digicool.com Software Engineer www.digicool.com Digital Creations (888) 344-4332 Got Zope? ---- > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On > Behalf Of Dario > Lopez-Kästen > Sent: Friday, August 11, 2000 07:10 > To: zope(a)zope.org > Subject: [Zope] Defining High Load in Heavily DB Driven site (was: > [Zope] zope2.2.0 and what is high load) > > > Hello! > > I need to find more info on how Zope handles threading with > relation to > database connections. > > I am currently considering and evaluating Zope as one of the > options we have > to build a really large, completely databasedriven "enterprise scale" > web-platform. I am a bit worried about this "maximum of 7 > threads per db > connection" limitation mentioned previously, and I need to > know a) what does > this mean in terms of accesibility, b) how does it affect > performace, and c) > how does Zope work (in detail) with external database connections. > > We are going to be using Oracle as our DB backend, all our > served data will > be database *only* (some of it will be fairly large), and > efficient database > connections is *crucial* to what we intend to do. > > We are going to have between 10-20k users at most and I > expect the maximun > of simultaneous connections to be beween 400 - 900 under > heavy load; "normal > load" will probably oscillate around 25-200 simultaneous > connections (these > numbers are crude guesses, but take into account increased > usage over time > as more services are provided in the future). > > Bandwith problems are not an issue, nor is computing power. > > I would appreciate any pointers to documentation or people to ask. > > Sincerely, > > /dario >

2 1

Speeding up Zope by disabling logging of hits
by David Trudgett 11 Aug '00

11 Aug '00

I'm using zope behind a front-end server and don't require any logging of hits. Is there a way to disable Zserver hit logging to increase speed and decrease disk utilisation? (I suppose I can send output to /dev/null, but that doesn't stop the logging code from being executed, and I would also lose error logging.) Even better would be the ability to disable logging based on IP address of the requester. Thanks. David Trudgett

2 1

RE: [Zope] Python + COM (from external method)
by Steinar Rune Eriksen 11 Aug '00

11 Aug '00

That worked. Thanks > -----Original Message----- > From: Phil Harris [SMTP:phil.harris@zope.co.uk] > Sent: Freitag, 11. August 2000 14:06 > To: Steinar Rune Eriksen; zope(a)zope.org > Subject: Re: [Zope] Python + COM (from external method) > > Steinar, > > Did you call pythoncom.CoInitialize()? > > If not you need to. > > hth > > Phil > phil.harris(a)zope.co.uk > > > ----- Original Message ----- > From: "Steinar Rune Eriksen" <steinar(a)orion.no> > To: <zope(a)zope.org> > Sent: Friday, August 11, 2000 12:49 PM > Subject: [Zope] Python + COM (from external method) > > > > How come this fails... > > ------------------------------------------ > > import win32com.client > > oOleObj = win32com.client.Dispatch("DSOleFile.PropertyReader") > > -------------------------------------------------- > > > > when run from Zope (within and External Method) when it works from > Python > > standalone on the same machine ? > > > > > > SRE > > > > > > > > > > > > ********************************************************************** > > This email and any files transmitted with it are confidential and > > intended solely for the use of the individual or entity to whom they > > are addressed. If you have received this email in error please notify > > the system manager. > > > > This footnote also confirms that this email message has been swept by > > MIMEsweeper for the presence of computer viruses. > > > > Admin > > Orion System AS > > ********************************************************************** > > > > _______________________________________________ > > 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 ) > > > _______________________________________________ > 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 ) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Admin Orion System AS **********************************************************************

2 1

Difference between manage_changeProperties and manage_editProperties?
by Peter Arvidsson 11 Aug '00

11 Aug '00

What is the difference? Somewhere I read that one of them erased all properties and changed those that are sent to the method (causing properties that is not sent to the method to be empty) but I dont remeber where I read it or which one it was? Are there any other differences?

2 1

PB with zodbca object, very Important !!!!!!!!!!!!!!!!
by kguesnet＠imexpert.com 11 Aug '00

11 Aug '00

When I create or use an object with a zodbc connection, and when I try to see a dtml page using it, zope open a login window (login with password) , but I don't know what it is, because I try lot of password (zope manager password, zope simple user password, Pc user password ....) no one can give me the access to the view of the dtml page. has anyone this sort of problem, and does anyone have a solution ???? thks a lot for your answer .... david sergent

1 0

RE: [Zope] Defining High Load in Heavily DB Driven site (was: [Z ope] zope2.2.0 and what is high load)
by Chris McDonough 11 Aug '00

11 Aug '00

Here's my understanding of how it works: - The number of threads is decided by NUMBER_OF_THREADS in z2.py or the command line argument -t[whatever]. - You can give ZServer/Zope a hundred threads if you want to, but if you want more DB connections to service those threads with, you need to change the pool_size in DB.py. Because Dario's site is hypothetical at the moment, it's probably not a good idea to start out by changing these parameters. He should probably just try it out at default, knowing that he can (carefully) bump these values up as necessary if he notices problems. It's sort of pointless to guess about how to increase speed until you know you need it to be increased. Zope can handle this kind of load, it's just a matter of hitting the sweet spot. In order to do that, you need to do some profiling work, unfortunately. > -----Original Message----- > From: Paul Everitt [mailto:paul@digicool.com] > Sent: Friday, August 11, 2000 9:03 AM > To: Dario Lopez-Kästen > Cc: zope(a)zope.org > Subject: Re: [Zope] Defining High Load in Heavily DB Driven site (was: > [Zope] zope2.2.0 and what is high load) > > > "Dario Lopez-Kästen" wrote: > > > > Hello! > > Hello Dario! > > > I need to find more info on how Zope handles threading with > relation to > > database connections. > > How about: > > http://www.zope.org/Documentation/Developer/Models/ZODB > > The jargon of threads and connections (and then threads again) can be > pretty confusing in Zope. > > First, ZServer is the thing in front listening for socket > requests. It > has a connection pool (select based) which maps into Python threads in > the Zope application. (ZServer is part of the Zope process, I'm > discussing logical partitioning.) > > Each concept of a "thread" in Zope is actually a "database connection" > to the ZODB. Threads get a private copy of the transaction > space, thus > greatly simplifying (to the point of removal) the need for programmers > to think about thread safety. > > If you're talking about the thread concurrency a connection to Oracle, > then that's a bit different. I _think_ that ultimately this > maps to the > number of Zope database connections. > > This conversation is probably better in the zope-dev list. > > > I am currently considering and evaluating Zope as one of > the options we have > > to build a really large, completely databasedriven > "enterprise scale" > > web-platform. I am a bit worried about this "maximum of 7 > threads per db > > This isn't a maximum. It's just the default. It's easy to > increase the > number of connections. > > > connection" limitation mentioned previously, and I need to > know a) what does > > this mean in terms of accesibility, b) how does it affect > performace, and c) > > how does Zope work (in detail) with external database connections. > > > > We are going to be using Oracle as our DB backend, all our > served data will > > be database *only* (some of it will be fairly large), and > efficient database > > connections is *crucial* to what we intend to do. > > Since you're not using any persistent objects in Zope (unless you do > caching of the SQL data, which you probably should), then you > don't have > to worry about process growth from having more database > connections for > Zope. Jack it up to 25. > > Since much of the time in a Zope hit is taken by rendering to HTML, a > number like 25 probably means you can process a hundred simultaneous > Oracle requests. That works out to be an average of around > ten million > hits per day. If you want more, increase the number. > > > We are going to have between 10-20k users at most and I > expect the maximun > > of simultaneous connections to be beween 400 - 900 under > heavy load; "normal > > load" will probably oscillate around 25-200 simultaneous > connections (these > > numbers are crude guesses, but take into account increased > usage over time > > as more services are provided in the future). > > > > Bandwith problems are not an issue, nor is computing power. > > > > I would appreciate any pointers to documentation or people to ask. > > Is this an intranet or a public site? > > --Paul > > _______________________________________________ > 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 ) >

1 0

RE: [Zope] No file in INPUT TYPE='file' field
by Mabe, Brad 11 Aug '00

11 Aug '00

I love this list! I am designing a file upload form and just started thinking about how I am going to handle invalid filenames, no filename, etc. Of course, rather than doing "real work" I decided to take some time and catch up with my e-mail and viola! Here is this thread. Thanks Peter! -=Brad=- -----Original Message----- From: Peter Arvidsson [mailto:peter@innodev.com] Sent: Thursday, August 10, 2000 4:07 AM To: Alexander Chelnokov Cc: zope Subject: Re: [Zope] No file in INPUT TYPE='file' field Hi I use this code to check if the input is empty: <dtml-if "name_of_file_input.filename"> Exists... To check if the input is a valid file you can store it as a temporary variable and then make a check if the size of the object is more than 0 bytes like this: <dtml-if "_.getitem(temp_object_id,0).getSize() > 0"> Valid file... I hope this helps you :) Peter Alexander Chelnokov skrev: > > Hello All, > > How to define in DTML that user put nothing into the > field <INPUT TYPE="file"...>? > Give pls an example of code. > > Best regards, > Alexander N. Chelnokov > Ural Scientific Institute of Traumatology and Orthopaedics > str.Bankovsky, 7. Ekaterinburg 620014 Russia > ICQ: 25640913 > > _______________________________________________ > 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 ) _______________________________________________ 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 )

1 0