- Zope - Zope lists

RE: [Zope] zope_msg.log Message
by Jens Vagelpohl 27 Mar '00

27 Mar '00

some additional data points on those crashes: in my test setup (CVS checkout using ZOracleDA) i found the following ways to avoid crashing: - using Pavlos' cure (setting DEBUG=1 in asyncore.py) - manually closing the oracle database connection or deleting it (which renders the membership components of my site useless since all that info is in oracle) - calling the offending page directly in a python interpreter by talking to ZPublisher and circumventing ZServer my suspicion is some weird interaction between the database adapter and ZServer. jens ---- Jens Vagelpohl jens(a)digicool.com Software Engineer www.digicool.com Digital Creations (888) 344-4332 Got Zope? ----

1 0

long-time difficulties using Oracle 8i
by Andy Pahne 27 Mar '00

27 Mar '00

Hi there, I'm trying hard to make my Oracle8i (Oracle 8.1.5.0.1) for Linux on Redhat 6.0 with Python 1.52 plus python-devel installed from rpms and Zope 2.1.6 talk to each other... As I understand so far, I first have to build the extension modules used by DCOracle. And then Install the ZOracleDA Right? Well, I do not even manage to do the first: When I try make -f Makefile.pre.in boot PYTHON=/usr/bin/python I get: rm -f *.o *~ rm -f *.a tags TAGS config.c Makefile.pre python sedscript rm -f *.so *.sl so_locations VERSION=`python -c "import sys; print sys.version[:3]"`; \ installdir=`python -c "import sys; print sys.prefix"`; \ exec_installdir=`python -c "import sys; print sys.exec_prefix"`; \ make -f ./Makefile.pre.in VPATH=. srcdir=. \ VERSION=$VERSION \ installdir=$installdir \ exec_installdir=$exec_installdir \ Makefile make[1]: Entering directory `/www/Zope-2.1.2-src/lib/python/Products/DCOracle/src' sed -n \ -e '1s/.*/1i\\/p' \ -e '2s%.*%# Generated automatically from Makefile.pre.in by sedscript.%p' \ -e '/^VERSION=/s/^VERSION=[ ]*$.*$/s%@VERSION[@]%\1%/p' \ -e '/^CC=/s/^CC=[ ]*$.*$/s%@CC[@]%\1%/p' \ -e '/^CCC=/s/^CCC=[ ]*$.*$/s%#@SET_CCC[@]%CCC=\1%/p' \ -e '/^LINKCC=/s/^LINKCC=[ ]*$.*$/s%@LINKCC[@]%\1%/p' \ -e '/^OPT=/s/^OPT=[ ]*$.*$/s%@OPT[@]%\1%/p' \ -e '/^LDFLAGS=/s/^LDFLAGS=[ ]*$.*$/s%@LDFLAGS[@]%\1%/p' \ -e '/^DEFS=/s/^DEFS=[ ]*$.*$/s%@DEFS[@]%\1%/p' \ -e '/^LIBS=/s/^LIBS=[ ]*$.*$/s%@LIBS[@]%\1%/p' \ -e '/^LIBM=/s/^LIBM=[ ]*$.*$/s%@LIBM[@]%\1%/p' \ -e '/^LIBC=/s/^LIBC=[ ]*$.*$/s%@LIBC[@]%\1%/p' \ -e '/^RANLIB=/s/^RANLIB=[ ]*$.*$/s%@RANLIB[@]%\1%/p' \ -e '/^MACHDEP=/s/^MACHDEP=[ ]*$.*$/s%@MACHDEP[@]%\1%/p' \ -e '/^SO=/s/^SO=[ ]*$.*$/s%@SO[@]%\1%/p' \ -e '/^LDSHARED=/s/^LDSHARED=[ ]*$.*$/s%@LDSHARED[@]%\1%/p' \ -e '/^CCSHARED=/s/^CCSHARED=[ ]*$.*$/s%@CCSHARED[@]%\1%/p' \ -e ORSHARED=/s/^LINKFORSHARED=[ ]*$.*$/s%@LINKFORSHARED[@]%\1%/p' \ -e '/^prefix=/s/^prefix=$.*$/s%^prefix=.*%prefix=\1%/p' \ -e '/^exec_prefix=/s/^exec_prefix=$.*$/s%^exec_prefix=.*%exec_prefix=\1%/p' \ /usr/lib/python1.5/config/Makefile >sedscript echo "/^#@SET_CCC@/d" >>sedscript echo "/^installdir=/s%=.*%= /usr%" >>sedscript echo "/^exec_installdir=/s%=.*%=/usr%" >>sedscript echo "/^srcdir=/s%=.*%= .%" >>sedscript echo "/^VPATH=/s%=.*%= .%" >>sedscript echo "/^LINKPATH=/s%=.*%= %" >>sedscript echo "/^BASELIB=/s%=.*%= %" >>sedscript echo "/^BASESETUP=/s%=.*%= %" >>sedscript sed -f sedscript ./Makefile.pre.in >Makefile.pre /usr/lib/python1.5/config/makesetup \ -m Makefile.pre -c /usr/lib/python1.5/config/config.c.in Setup -n /usr/lib/python1.5/config/Setup bad word ) in ) make[1]: *** [Makefile] Error 1 make[1]: Leaving directory `/www/Zope-2.1.2-src/lib/python/Products/DCOracle/src' make: *** [boot] Error 2 [root@web src]# I tried the new Oracle8i setup-file provided on www.zope.org, I also tried both Setup-Files provided with DCOracle, but everytime the same. By the way, I suppose that there is no problem with the Oracle client-library setup, because I am already connecting to the Oracle8i with PHP. I've never had problems with Python installed from rpms? Did anybody else have? Andy Pahne ap(a)net22.net

1 0

newbie question - handling strings
by Dimitris Andrakakis 27 Mar '00

27 Mar '00

Hi there, I've got an 8-character string, say str='12345678'. With <dtml-var str> ofcourse I get 12345678. How can I display only part of it ? Say the first 4 chars (1234) or the next 2 (56) or the last two (78). In python I know this can be done with something like str[:4], str[4:6] and str[6:]. Any help ? (Hope I didn't sound too newbish !). --- Dimitris Andrakakis http://atlas.central.ntua.gr:8000/~mc94068 __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

4 3

MailHost Error Handling
by J. Atwood 27 Mar '00

27 Mar '00

I have set up a form for people to send an email to someone else from the website. They put in a from and a to email address. It will take any "to" email but if the "from" email address does not exist it returns the error "Recieved error code 501 from SMTP: 501 ... Sender domain must exist " I have used <dtml-try> but it does not work. Anyone have another way to handle this error? Thanks, J

1 0

Accessing ZSQL connection from external method
by Ragnar Beer 27 Mar '00

27 Mar '00

Howdy! I'm making heavy use of MySQLdb in my external methods. Now I just realized that ZSQL-connections are kept open permanently and it would save a lot of time if I wouldn't have to open a connection each time my external method is invoked but use the already existing ZSQL-connection instead. My question: How can I access a ZSQL-connection (ZMySQLDA) from an external method? --Ragnar P.S.: I benchmarked MySQLdb and found that opening a connection took 1.2ms on my systen whereas a very short request for authentication took only 1.1ms. So beeing able to use an existing connection would result in about 100% performance gain (at least at first glance).

3 2

Weird Security Problem
by Chris Withers 27 Mar '00

27 Mar '00

This I cannot understand, what's new ;-) I've mocked it up in the attached .zexp if anyone wants to try it out themselves. I have a site with a subfolder. This is private and so has 'view' permission only to a 'user' role and the usual 'manager' role. I have a file, index_html in the mockup, in this subfolder, which includes an image called 'black' from the root of the site. The root folder has 'view' granted to the anonymous user. I added my users with the 'user' role, user1 in the mockup - password 'user1', to the subfolder's acl_users . However, when I went to view the subfolder and logged in as user1, the page loaded fine, except for the 'black' image. I was asked to authenticate again but the only way I could get past this was to use user2, password 'user2', who has manage access to the whole site. This is really confusing as 'black' comes from the root of the site, which is viewable by even the anonymous user, and viewing the black image on its own in another browser session, even using the URL from the HTML generated for the subfolder index_html, worked fine and no authentication was requested. Obviously giving these users manager access to the whole site was unacceptable. I managed to solve the problem, see user3 - password 'user3' in the mockup, by creating the user in the root acl_users folder and giving them no roles. Then, giving them 'user' as a local role in subfolder. I've tried this with Zope 2.1.4 and 2.1.6 on Linux and NT4, Netscape 3.04, Netscape 4.7 and Explorer 5.1 all with the same result. Anyone know what's going on? Chris

1 0

Zope and Windows NT 2000
by Bruno Grampa 27 Mar '00

27 Mar '00

Hello, i'm testing Zope 2.1.6 with Windows NT 2000. Everything is running fine but... it's slow updating the internal database. Each time you press the "Change" button the wait is 30 seconds! On the same machine with Windows98SE and Linux there is no wait. All the other operations are working without any problems of speed. Is there anyone else who tried Zope with Nt2000? Thanks, Bruno

3 2

Performance Testing / Expections
by Ben Leslie 27 Mar '00

27 Mar '00

Ok, I know it has been asked a couple of times before on the list, but there hasn't really been any absolute conclusions on the type of performance to expect from zope and/or how to tweak it for the best kind of performance. Over the last two days I have been doing some testing and would like to hear on opinions if these results are similar to other peoples. Firstly the machine specs are: PIII 450Mhz 128Mb IDE Harddrive Running Debian Potato Zope is running through Apache with PCGI. All tests were run using ab. First I tested apache to see how fast it was as a benchmark. 1000 requests, 25 Concurrent. /usr/sbin/ab -c 25 -n 1000 "http://www.eminecorp.com.au/docs/testemc.html" Results: 384 requests per seconds (rps). Avg wait: 54ms. Max Wait. 83ms. Throughput: 20MB/s 1000 requests, 1 at a time. /usr/sbin/ab -c 1 -n 1000 "http://www.eminecorp.com.au/docs/testemc.html" 425 rps AvgWait: 2ms MaxWait: 3ms Throughput: 21MB/s The I tested the same document servered statically through zope. (From zope's root) /usr/sbin/ab -c 25 -n 100 "http://www.eminecorp.com.au/testemc" 42 rps Avg Wait: 514ms MaxWait: 743ms Throughput: 2MB/s /usr/sbin/ab -c 1 -n 100 "http://www.eminecorp.com.au/testemc" 45 rps AvgWait: 21ms MaxWait: 29ms Throughput 2.3MB/s Next on line was a moderately dynamic page. Dtml only, no DB or Ext. Methods. /usr/sbin/ab -c 25 -n 100 "http://www.eminecorp.com.au/eminecorp/ecom2/sesgroup?cu rrentid=0&cur_page=http%3a//www.eminecorp.com.au/eminecorp/ecom2/siteinfo/index_html?" 4.97 rps AvWait: 4.4s MaxWait: 5.6s Throughput 21kb/s /usr/sbin/ab -c 1 -n 100 "http://www.eminecorp.com.au/eminecorp/ ecom2/sesgroup?currentid=0&cur_page=http%3a//www.eminecorp.com.au/eminecorp/ecom2/ siteinfo/index_html?" 5.09 rps AvWait: 195ms MaxWait: 198ms Throughput 22kb/s Then finally testing a page with the same amount of DTML complexity but some external methods which call a database using pygresql /usr/sbin/ab -c 25 -n 100 "http://www.eminecorp.com.au/eminecorp/ecom2/products/?s tartitem=1&currentid=22" 1.3rps Avwait 16s MaxWait 20s Throughput 19.51 kb/s /usr/sbin/ab -c 1 -n 100 "http://www.eminecorp.com.au/eminecorp/ecom2/products/?s tartitem=1&currentid=22" 1.3rps Avwait 768s MacWait 789 Throughput 19.55 kb/s In summary serving straight of apache is very fast, and doesn't suffer if multiple people access the site at once. Static Zope (which you wouldn't really do anyway) was acceptable speed and didn't really suffer too badly if there were multiple accesses. Dynamic Zope was fair in speed, but proably still fast enough, at least for my site anyway. It started to suffer in a bad way with multiple accesses, up to 5 sec response time. Highly dynamic Zope was very bad in rps and hopeless more multiple access. Now I have only been in this game I a while so I don't know how critical the multiple access thing is going to be. I am expecting at most 1000 visitors each day (say a 10 hour period). So 100 visitor each hour shouldn't cuase me any problems at the moment. I guess how I would like to know if anyone out there knows how to improve this performance at all. Can I throw memory and processors at it and make it go away? Obviously there are some things in the highly dynamic bit which I will need to speed up, however how can I make just normal dtml execute faster? The prospect of ZEO has certainly helped in this area but surely I must be able to sqeeze some more performance out of this machine. Thanks in advance. Benno

6 11

Re: Indirect calling of extensions
by Glenn Rogers 27 Mar '00

27 Mar '00

I wrote: > > I want to call this in a manner similar to: > > > >  > >  > >  > >  > >  Tres Seaver wrote: > Try this (untested), assuming the name of the method you want to call > is stored somehow in the variable 'methodName':: > > <dtml-let methodToCall="_[ methodName ]"> > <dtml-in list_hrefs mapping> > <dtml-var "methodToCall( this(), href )"> > </dtml-in> > </dtml-let> > Alas! It doesn't work. It appears to fall down on the line: <dtml-let methodToCall="_[ methodName ]"> Traceback: File C:\PROGRA~1\Zope\lib\python\DocumentTemplate\DT_Let.py, line 144, in render (Object: methodToCall="_[select_method]") File C:\PROGRA~1\Zope\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: _[select_method]) (Info: select_method) File <string>, line 0, in ? File C:\PROGRA~1\Zope\lib\python\DocumentTemplate\DT_Util.py, line 161, in careful_getitem File [snip]\Products\ExternalMethod\ExternalMethod.py, line 248, in __call__ (Object: pyFetchInvTopicsForHref) (Info: ((), {}, None)) TypeError: (see above) [above= Error Type: TypeError Error Value: not enough arguments; expected 2, got 0 ] It seems evaluating this doesn't just give the string contents of the dictionary item, it evaluates the actual external method call. I think I'll have to give up at this point and take the cludgy option (unless anyone can think up another way). Thanks for your help. Glenn

1 0

zope search problems w/squishdot with latin1, locale fi_FI
by Jyrki Kuoppala 27 Mar '00

27 Mar '00

I'm using Zope 2.1.4 on Linux with environment LC_ALL set to fi_FI and Zope started with -L fi_FI, and ZCatalog indexing & searching seems to work fine. (well, there's a problem with some documents having ä etc. spelled out, but if ä is used everything works OK.) BUT, ZDConfera & Squishdot don't work right. For some reason, at some phase of the indexing characters like ö (ö, octal 366) in words are converted to their octal codes. This can be seen by looking at the raw Data.fs file. The result is that when I have a word like kökköviesti in the ZDConfera or Squishdot article, it can be found by search as 366viesti It is converted in the db storing/indexing phase to something like k\366kk\366viesti, which is then broken into words k, 366kk, 366viesti which are stored into the textindex. Any ideas on how to fix this? I've looked at Splitter.c, TextIndex.py, ZDiscussions.py and Squishdot.py, but I can't find anything which would convert characters to their octal codes. //Jyrki

1 0