- Zope - Zope lists

RE: [Zope] sql varchar truncated?
by Alexander Staubo 17 Jun '99

17 Jun '99

False -- Microsoft SQL Server 7.0 supports char and varchar fields up to 8000 characters in size. Anything above that you use text, ntext, or image. To answer the poster's question, Zope/Python strings are _not_ limited to ~256 characters. I have successfully inserted large amounts of data in MSSQL image fields (which is a pain but works), although I don't recall if I ever pushed anything about 256 into a varchar field. If you have access to isql[w], I recommend that you run the query manually and see what happens. -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_ >-----Original Message----- >From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On >Behalf Of Larry >Luther >Sent: 16. juni 1999 16:12 >To: Scott Lewis >Cc: zope(a)zope.org >Subject: Re: [Zope] sql varchar truncated? > > >If I recall the varchar type is limited in size (256 chars?) and the >"text" (MsSQL?) or "memo" (Access?) type is what is used for large text >lengths. > >_______________________________________________ >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] undeletable objects
by Michel Pelletier 17 Jun '99

17 Jun '99

> -----Original Message----- > From: Thilo Mezger [mailto:thilo@eevolute.com] > Sent: Thursday, June 17, 1999 3:12 PM > To: zope(a)zope.org > Subject: [Zope] undeletable objects > > > hi! > > when i read about an undeletable top-level "acl_users" in a > recent post a > question came to my mind again: > > why isn't it possible to delete the top-level dtml-methods > standard_error_message, standard_html_footer and > standard_html_header in > zope 1.10? > > i get the message "standard_html_header cannot be deleted" ... > Zope is generaly displeased when you try to delete these top level objects. The protection against deleting them is hardwired into Zope. This is unlikely to change. The top level user folder however, can be deleted (in 2.0 and the latest CVS). This can be a Bad Thing (tm) if you don't have access to the superuser password, because due to Acquisition and the design of the authentication system, the entire site is locked out! Only the superuser, at that point, can get in to add a new user folder at the top level (and thus return the system to normality). -Michel > > thilo > > > _______________________________________________ > 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

Easily including external HTML file?
by Dan York 17 Jun '99

17 Jun '99

Greetings! I've been lurking for a bit and have appreciated the tips and ideas I've picked up on the list. But now I have a question. In one of my pages, I would like to pull in the latest stories from Linux Today. They explain what to do at: http://linuxtoday.com/linkus.html All I would like to do is pull the following file into the middle of a DTML document: http://linuxtoday.com/backend/lthead.inc Now I frequently did this before with Apache and server-side includes, but I can't figure out exactly how to do this using DTML. In looking around zope.org, I found the contributed external method for pulling in items from Slashdot.org: http://www.zope.org/Download/Contrib/slashdot.py And while that works... and I could sit and modify the python to have it go pull in the LinuxToday info... I just find myself sitting here thinking there's got to be a better way to do this! All I want to do is pull in the LT file... no formatting or anything else. Any ideas you have will be appreciated. Thanks, Dan -- -------------------------------------------------------- Dan York, Certification Program Manager, Linuxcare, Inc. dyork(a)linuxcare.com http://www.linuxcare.com/ 415-740-4519 mobile, 603-268-0691 tel, 603-268-0103 fax Linuxcare. At the center of Linux. --------------------------------------------------------

2 1

Revoking authentication (or: logging out)?
by Jonathan Corbet 17 Jun '99

17 Jun '99

I'm working on a system to make medical records available via a web interface. It needs to make different levels of access available to different sorts of people (doctors, nurses, clerical staff) - a perfect match for Zope's roles. But I've encountered one rub: the web browser will be running on PC's sitting in various spots in the clinic's offices: the doctor's office, work areas, even examination rooms. There will be a different person sitting down at it every few minutes. But, with "Basic" authentication, once the web browser has your username/password in its clutches, it never lets go. We're dealing with medical records here, so it is a poor idea to leave a "logged in" browser sitting around in a public place. What I am looking for is a way to put in a "log out" option that stops short of killing and restarting the browser. Has anybody else figured out a way to do this? Thanks, jon Jonathan Corbet, Eklektix, Inc. corbet(a)eklektix.com

4 5

undeletable objects
by Thilo Mezger 17 Jun '99

17 Jun '99

hi! when i read about an undeletable top-level "acl_users" in a recent post a question came to my mind again: why isn't it possible to delete the top-level dtml-methods standard_error_message, standard_html_footer and standard_html_header in zope 1.10? i get the message "standard_html_header cannot be deleted" ... thilo

1 0

Forcing a user to use a session...
by Jules Allen 17 Jun '99

17 Jun '99

Is there a way to force a user into a session when they log in to resource/manage? I'd like to be able to give 'content masters' control of their own areas but without allowing them to change objects live. Then a manager/reviewer could approve the changes and commit the session. Cheers, Jules -- "There should be one-- and preferably only one --obvious way to do it. Although that way may not be obvious at first unless you're Dutch." -- Tim <0.8 wink> Peters

1 0

RE: [Zope] Zope performance too low ?
by Alexander Staubo 17 Jun '99

17 Jun '99

>> I'm not familiar enough to Linux to say this for sure, but >my guess is >> that it _would_ be using a high-resolution system timer. >> > >Nope, 'ab' uses gettimeofday(2) to return microseconds, and >then does an >internal divide by 1000 to return milliseconds. This is done all with >itegers however, I suspect there is a loss of precision. You have to wonder why they'd found the calculations of a benchmarking program on integer calculations. (Fyi I don't have the Apache sources at hand myself.) >>> Ouch. These extremely low transfer rates bother me. The theoretical >>> bandwidth on a local machine transfer should be way, way >>higher. Otoh, >>> your document was very small, so the stop/start, connect/teardown >>> margins would be relatively high. I'd like to see benchmarks >>> with longer >>> (>3KB) documents. >>> > >I redid the same benchmark between two linux boxes on my desk (the same >server as before, the client is RedHat 6.0 on a P166 w/ 10Mb Ethernet >card) with a 36K document, and got 656 KB/sec (~36 requests/sec 147ms >average response time), the effective limit on a moderately loaded >10Mb/s Ethernet lan. So, Zope can at least hose a 10 Mb >Ethernet (Note, >a 70MB FTP between the two machines yielded 800 KB/s, I think >the amount >of request/response and tcp connect/disconnect overhead could account >for the other 144 KB/s, at least to a 10% margin of error). Agreed. >When Rob buys me a 100MB card for my other machine, I'll rerun the >benchmark to see if Zope can beat the 10Mb limit. Just for fun, I sat down for five minutes and wrote a small, general-purpose benchmarking script. The configuration: * Zope server NT: NT Server, SP4, Zope 1.11.0pr1 (ZServer), PII/400, 256MB RAM, fast U2W SCSI disk, low-traffic 100mbps network. * Zope server Linux: Slackware Linux 2.2/glib-2.0.6, Zope 1.11.0pr1 (ZServer), P/133, 32MB RAM, IDE disks, medium-traffic 100mbps network. This server doubles as mail and Samba server. * Apache server Linux: Same Linux box, running Apache 1.3.4. With a small document (12215 bytes including HTTP header), the results are similar to yours. This is a DTML document, same variables as yours, just a lot of dummy text. Results Zope server NT: Total time: 203.39 Total requests: 1000 Total bytes: 12215000 Requests/sec avg: 4.92 Bytes/sec avg: 60056.44 CPU load avg: 20% Results Zope server Linux: Total time: 77.71 Total requests: 1000 Total bytes: 12228000 Requests/sec avg: 12.87 Bytes/sec avg: 157350.22 CPU load avg: 15-20% [*] Results Apache server Linux (served as static HTML page): Total time: 30.76 Total requests: 1000 Total bytes: 12601000 Requests/sec avg: 32.50 Bytes/sec avg: 409588.83 CPU load avg: 1-5% [*] [*] numbers derived from watching output of "top". :-) I intended to use xload for that, but I don't have my X Server for NT at hand. Load average for Zope climbed towards 4.0, whatever that means; load average for Apache never went above 0.04. The different "bytes transferred" numbers can be accounted for by differences in the HTTP headers between ZServer on NT, ZServer on Linux, and Apache. I'm not implying that comparing Zope with statically served pages on Apache is valid; it's interesting data, but not useful except as a meter on "how fast things can really go" when publishing static pages. Note that I tested against an Apache server that is already under some stress, as it already hosts a number of public web sites. This inevitably also affects the purity of the Zope numbers. Also, the fastest machine was running NT, not known for being an efficient web serving platform, or very efficient at all, period. ;-) Compare the results: 12.87 requests/sec on a Linux Pentium/133, 4.92 requests/sec on an NT Pentium II 400MHz. No, I wouldn't mind if Microsoft lost in a certain ongoing antitrust trial. :-) We don't throw out old desktop computers anymore: We set up them up to run Linux. As an aside, I also tested a small DTML Method (2014 bytes including HTTP header) just to see how well Zope handles more complex pages. It has a top navigation bar which iterates through its parents to build a Yahoo!-ish link list; then sets some REQUEST variables; and finally does an  loop to enumerate five documents or so in the parent folder and output their titles and a short description property. In other words, not very complex, but certainly not a "static" page, either: Results Zope server NT: Total time: 198.11 secs Total requests: 1000 Total bytes: 2014000 Requests/sec avg: 5.05 Bytes/sec avg: 10165.81 Average CPU load: 38% I did not test this on the Linux machine as I'd have to copy a large part of my Zope database (including some Z Classes) in order to emulate the same functionality. Suffice to say we can expect a lot better than this. It's interesting to note that, while the transfer rate drops drastically -- we can easily blame this on the size of the rendered document -- the request rate is more or less the same as with the very simple, larger page. What's to accepted is that the CPU load increases. I look forward to testing more -- especially with concurrent requests -- with Zope 2.0 as it grows more mature. We're setting up a brand new Linux server to run Zope, and I'll have some time to run more refined benchmarks in a clean environment (no mail, web or file daemons grabbing CPU slice). >Also not that the ~37 requests per second I got (this is the average >between all benchmarks) equates to approx *3.2 million hits per day* on >one moderately fast PII with no fancy hardware. Great, but this assumes 3.2 million hits spread across 24 hours. In the Real World, traffic is not that even, and the real test of Zope's scalability comes when you do 40+ concurrent clients. [snip] >> I'd be very interested to hear about what the CPU load was during the >> test run. If it's anything above 5-8% (average), that's not >> promising at >> all. The fact that adding more concurrent sessions did not regrade >> performance seems to indicate that CPU load was not too bad. > >Note that load average and % of time spent in the CPU are not the same >thing. Of course. I don't even know exactly what "load average" on Linux means. :-) For the above tests I clocked the average CPU load on NT by running Performance Monitor. [snip] >> I'm planning on putting together a simple httplib-built >benchmark test >> just to get some raw numbers, although I'd like to try putting the >> timing logic inside Zope. >> > >We would be interested in seeing what you come up with (code and >numbers). As I'm not known in any circle as "The Benchmarking Guru", and probably will never be, I thank you for your friendly and accommodating position on this matter. :-) This is the simple script I jotted down to do the tests. It seems to be inconsequential whether the timing includes getfile() and doc.read(), even though as far as I can see the byte stream isn't read from the socket until you actually perform the read. This may well be explained by socket buffering or NIC-level buffering happening behind the scenes. I don't know enough about the innards of the httplib, mimetools, and rfc822 modules to check this, and I don't have the time right now. import httplib import os.path import time import sys import string TotalDocs = 0 TotalTime = 0.0 TotalBytes = 0 def Request(Url): global TotalTime, TotalDocs, TotalBytes if Url[:7] == 'http://': Url = Url[7:] i = string.find(Url, "/") if i >= 0: Server = Url[:i] DocUrl = Url[i:] else: DocUrl = '' if DocUrl == '': DocUrl = '/' StartTime = time.time() HttpRequest = httplib.HTTP(Server) HttpRequest.putrequest('GET', DocUrl) HttpRequest.putheader('Host', Server) HttpRequest.putheader('Accept', 'text/html') HttpRequest.putheader('Accept', 'text/plain') HttpRequest.endheaders() httpcode, httpmsg, headers = HttpRequest.getreply() if httpcode != 200: raise "HTTP error %d getting document" % httpcode doc = HttpRequest.getfile() TotalBytes = TotalBytes + len(doc.read()) TotalTime = TotalTime + time.time() - StartTime TotalDocs = TotalDocs + 1 doc.close() class CommandLine: def __init__(self): self.Args = {} i = 1 while i < len(sys.argv) - 1: if sys.argv[i][:1] in ['-', '/']: self.Args[sys.argv[i][1:]] = sys.argv[i + 1] i = i + 2 else: i = i + 1 def __getitem__(self, i): if self.Args.has_key(i): return self.Args[i] else: return None def Main(): Args = CommandLine() Document = Args['u'] or Args['url'] if not Document: print "hb: No document specified" return RequestsToDo = string.atoi(Args['n'] or Args['number'] or '1') print "Document: %s" % Document print "Requests: %d" % RequestsToDo print "..." while RequestsToDo > 0: Request(Document) RequestsToDo = RequestsToDo - 1 print "Total time: %8.2f" % TotalTime print "Total requests: %8d" % TotalDocs print "Total bytes: %8d" % TotalBytes print "Requests/sec avg: %8.2f" % (TotalDocs / TotalTime) print "Bytes/sec avg: %8.2f" % (TotalBytes / TotalTime) if __name__ == '__main__': Main() -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

1 0

Problems: How should I run zope under windows?
by Thomas Heller 17 Jun '99

17 Jun '99

How should I run zope under windows? So far I tried 1.10.2, which is the current stable release. 1. I'm a little afraid to install (and configure) apache, so I tried the Xitami Web server. This runs fine, but I could not figure out how to configure the system so that the homepage which is in the Zope folder 'root/Company/index_html' when the user enters http://www.company.com/ Hints, anyone? 2. So, I tried using ZopeHTTPServer, without any external webserver. The above problem is easy to solve: Store the homepage in the Zope folder 'root/index_html'. Problems: a) IE 4 and 5 seem not to finish the transfer on any page (although the data is transmitted completely), finally they timeout. Netscape works fine. (This could be related to the fact that I run a proxy server for internet access on the same machine). b) I had to patch ZopeHTTPServer.py and BaseHTTPServer.py from the python1.5 lib to fix extremely long response times, which apparently have to do with reverse DNS lookups, the problem and the solution is fully described in http://www.deja.com/getdoc.xp?AN=465892270. 3. Finally, I downloaded ZServer beta together with the 'recent snapshot' of ZPublisher, but I could not get this to work at all. I'm stuck. What is the recommended way? Please note that I would like to stay away from IIS... Thomas Heller ION-TOF GmbH

1 0

RE: [Zope] Use Amaya! Even PCWeek recommends it! -- WAS: IE/Netsc ape Authoring ... ...
by Rob Page 17 Jun '99

17 Jun '99

> Rob Page <rob.page(a)digicool.com> writes: > > version -- a problem for even maintaining  type references which Amaya snarfs out. :^( > > I wonder if the new experimental syntax works better ? Humph... surprisingly, it does! I'd have thought with all the DTD checking that's supposedly going on something like: <dtml-in objectValues> would have been tossed post-haste. Specifically, (snipping out the rather annoying <HTML><HEAD><TITLE> stuff Amaya insists on providing) the following snippet survived an Open and Save in Amaya: <p>This is a paragraph...</p> <p>This is some more stuff</p> <dtml-var standard_html_header> <ul> <dtml-in objectValues> <li> <a href="&dtml-URL1;/&dtml-id;/manage_workspace"><dtml-var title></a> </li> <dtml-/in> </ul> <dtml-var standard_html_footer> Of course, it's invisible (hence uneditable) in Amaya. However, there seems to be hope... --Rob

1 0

RE: [Zope] getting at vars from <form>'s in external methods
by Alexander Staubo 17 Jun '99

17 Jun '99

Try adding REQUEST as a parameter to your method. Through this variable you should be able to get at your form data, thus: def MyMethod(REQUEST): Name = REQUEST.name Age = REQUEST.age ... -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_ >-----Original Message----- >From: rmilner(a)dev.tivoli.com [mailto:rmilner@dev.tivoli.com] >Sent: 17. juni 1999 20:07 >To: zope(a)zope.org >Subject: [Zope] getting at vars from <form>'s in external methods > > > > I'm sure this is obvious - but I can't find it anywhere. How can >my external method get the value of a variable set from a <form> >submit? > > Thanks, > ^Roman > > > >-- >If Happy Fun Ball begins to smoke, get away immediately. Seek shelter >and cover head. >--------------------------------------------------------------------- >Roman Milner rmilner(a)dev.tivoli.com > >_______________________________________________ >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