November 2001 - Zope

Re: [Zope] Howto convert ZSQL results
by Julián Muñoz Domínguez 02 Nov '01

02 Nov '01

Thanks a lot !!! The query I am doing is: select MAX(CliCodigo) from ClientesTabla And the column that is returned by zope is named 'Expr1000' (a bit strange :-)), and doing: I=int(container.last_customer()[0].Expr1000) Works !!! Thank you, I was becoming fool :-) On Fri, 2 Nov 2001, Casey Duncan wrote: > On Friday 02 November 2001 11:21 am, Julián Muñoz Domínguez allegedly wrote: > > How to convert to integer the the result of a ZSLQ method ?? > > > > > > > > > > I call a ZSQL method with: > > l=int(container.last_customer()) > > > > > > The field I query is has the type "VARCHAR(10) with Null" > > I am doing this query through ZODBC DA, to an Access .mdb file. > > > > I am digging many hours in the Documentation, and doesn't find the answer. > > > > > > I get this error: > > > > > > Zope Error > > > > Zope has encountered an error while publishing this resource. > > > > Error Type: AttributeError > > Error Value: DatabaseResults instance has no attribute > > '__int__' > > > > It sounds like you are trying to convert the whole row or recordset to an > int, which obviously won't work. You need to return just the field by itself > like: > > I=int(container.last_customer().name_of_field) > > or possibly: > > I=int(container.last_customer()[0].name_of_field) > > hth, > /---------------------------------------------------\ > Casey Duncan, Sr. Web Developer > National Legal Aid and Defender Association > c.duncan(a)nlada.org > \---------------------------------------------------/ > -- __o _ \<_ (_)/(_) Saludos de Julián EA4ACL -.-

2 1

Re: Threading, dtml and performance?!
by Oliver Erlewein 02 Nov '01

02 Nov '01

Well I've tested your script with an old backup of Zope 2.3.2 on an Win NT SP 5 machiene. There are no problems. The script runs in one window and in the other I can surf the management screen. My Solaris can't do that. On Solaris and on NT I could see your second problem. When I press cancel on the Browser the process/thread doesn't stop. Thats really a problem. I started your script twice and the machiene (NT) is nearly not usable anymore. But thats better than Solaris - there I can't start the process twice! For me I've prooven that there is something VERY WEIRD with the Solaris Zope. OK it might not be Zope but Python. As for me I need an answer / solution desperately! Any ideas anybody? My primary guess is, that Solaris doesn't relese the threads after using them. I've tried a threaded Python script on my Solaris machiene and that had no problems. But I must confess I have no clue on how Zope Threading works. Therefore my test doesn't proove anything really. By the way...it also shows how fast Zope really is because if I run "singlethreaded" and Zope can still serve a few thousand requests a day thats really not bad. Oliver Erlewein -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net

9 17

problems with security with file objects
by Robert Rottermann 02 Nov '01

02 Nov '01

Hi there, I have word documents on my site. When the user wants to download them she is presented with a authentication dialog. It is enough just to cancel it. However this is very distracting, and a user normally assumes she has hot the appropriate rights. This even happens when I am logged in into the ZMI and want to download the document. Help will be very much appreciated! thanks Robert

1 0

Xron 0.0.9 / Zope 2.4.1 / Python 2.1 win32-x86 install problems.
by Jos Yule 02 Nov '01

02 Nov '01

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello all! I've gone through all the zope and zope-dev archives (via asdn) looking for references to Xron and my problem. Lots of posts (181), but none that seemed to deal with this issue. I patched XronDTMLMethod.py and Dispatcher.py with the import DateTime fix, so the product now does not appear broken in the Products folder (as it did before i patched these files). However, it does not appear in the 'Select type to add...' drop down menu. I've re-compiled the files, to make sure they were importing correctly (by removing Xron from the product dir, del'ing the .prc files and restarting the server). I've restarted the server multiple times. I'm sure its a Zope 2.4.x vs. Xron 0.0.9 issue... Oh ya, i've also set the STUPID_LOG_FILE (or whatever its called) env variable, and there is no file in the var directory (which is where i set it to point to)... so i cant give you any info about that. Any suggestions? Any more info i could provide? Thanks jos -----BEGIN PGP SIGNATURE----- Version: PGP 6.5.8 iQA/AwUBO+LMXd4WdA43RP/AEQIATACfX7Vo72Zrk8YCnX7S5bP+BS1Z/60Anjej xGKGU+/83OBD8vb307ijLCET =dU+h -----END PGP SIGNATURE-----

1 0

Calling DTML from a python script
by Chris Meyers 02 Nov '01

02 Nov '01

My situation is this: I have a form that users fill in any or all textboxes. They then click the submit button which calls a python script which gets the information from context.REQUEST and builds an XML statement along with some other stuff. The script then calls a ZSQL method which inserts this XML and other stuff into a requests storage database table. I would then like my python script to call a DTML Document which will display the results of a query of a different table based on the info the user had input, which is where I am running into problems. My calls to the DTML Document are failing. I have tried the method suggested on this list a couple of days ago: return context.zopeObject(REQUEST=context.REQUEST) but that isn't working for me because the DTML document I am calling is one folder down from my python script so the document gets lost when it tries to get some of its necessary information in the parent folder. I have also tried using setVirtualRoot, but that isn't working either. So now I have to ask for help. How do I call a DTML Document from a python script when the Document is in a subfolder of the folder holding the script? Thanks in advance for the help Chris Nobody will ever go campin' with a Nitro Burnin' Funny Car -- Dead Milkmen

1 1

Strangeness with Zope and Postgres
by Chris Kratz 02 Nov '01

02 Nov '01

For months now, we have been noticing that every once in awhile zope just appears to freeze up. I go and look at the zope processes and they are all sleeping. The only way to fix the problem was to restart zope, hence I didn't think about the fact that it might be the database. I have been monitoring it and assumed it was something funny in Zope, but something that was mentioned on this list made me start thinking that it could be something funny happening with the database. We use postgres as our dbms and our site is heavily database instensive. Sure enough, when ever the site appears to freeze, I go and look at the database threads and one thread has a status of "UPDATE WAITING" and the the others are sitting in the normal idle in transaction status. The server is idle (2% or less cpu) and the drives are as normal, silent. The server is doing absolutely nothing. I also found out how to lock it up every time. I have a specific page that does some intensive database work including some updates to some preference tables as well as some reads of some large tables, etc. If I go to that page and then hit F5 twice in succession, it locks up the system every time requiring a zope restart. Now I am starting to think that we are running into a concurrency issue with postgres and transactions. I was wondering if anyone with a bit more experience might be able to shed some more light on the situation and/or where I might look to further debug the situation. My hunch is that the following happens: 1. First request comes in. 2. User presses F5 before the first transaction finished. 3. Browser drops first connection and reconnects. 4. Zope starts to write to the socket, notices that the browser is no longer connected. 5. Zope aborts the transaction. 6. BUT, the database never get's a rollback and simply waits in the transaction for ever. 7. Unfortunately, this must also cause some locks that don't allow any other thread to do any work. 8. Restarting Zope closes those db connections and postgres roles the transaction back. Does anyone have any further suggestions on how to debug this further or to stop the problem? -Chris RH 7.2 Zope 2.4.1 ZPoPyDA Postgres 7.1.3 ------------------------------ Chris Kratz chris.kratz(a)vistashare.com

4 4

RE: [Zope] FW: Security question - precision
by Bocquillon Philippe 02 Nov '01

02 Nov '01

Dieter, Thanks for your answer. You are right: it seems there is a problem in traversing back to the root (looking at the trace). However, my classes are already inheriting from Acquisition.Implicit. So, this is not sufficient to solve the problem. Philippe > -----Original Message----- > From: Dieter Maurer [mailto:dieter@handshake.de] > Sent: dimanche 28 octobre 2001 19:04 > To: Bocquillon Philippe > Cc: 'zope(a)zope.org' > Subject: Re: [Zope] FW: Security question - precision > > > Bocquillon Philippe writes: > > Zope refuses "add object" permission to any user having a > role other than > > Manager, i.e. Zope refuses to add objects in containers > whose classes are my > > proper classes (inheriting ObjectManager), even if I give > all permissions to > > these other roles, at root level and acquiring them. > > When a role adds these objects in _standard_ Zope Folders, > no problem, Zope > > permits it. > Looks as if your classes do not inherit from > "Acquisition.Implicit" (probably "Acquisition.Explicit" will > work, too). > > In such a case, the Zope security machinery is no longer able > to traverse back to the root. Consequently, it rejects the > request (more precisely, it uses its default role assignment, > "Manager"). > > > Dieter >

1 0

a metric for killing DTML.
by Anthony Baxter 02 Nov '01

02 Nov '01

Like any site that's been around for a while, we've got a lot of DTML that shouldn't be DTML. We're gradually killing it, but we're looking at detecting stuff that _shouldn't_ be in DTML. One metric that's come up is "any DTML method that has 3 or more calls to REQUEST.set() is probably up to no good." Have other people found other useful rules of thumb about when to avoid DTML? Anthony

11 12

Re: Zope digest, Vol 1 #1748 - 43 msgs
by Frederic Faure 02 Nov '01

02 Nov '01

At 10:13 01/11/2001 -0500, you wrote: >From: Oleg Broytmann <phd(a)phd.pp.ru> > >On Thu, Nov 01, 2001 at 10:50:40AM +0100, Frederic Faure wrote: > > In the mean time, is there a way to just use Zope as a personal and > > convenient repository, and tell it to extract an entire site into HTML so > > wget, pavuk or any other websucker will do. Thx. Does Zope provide an internal tool for this? FF.

2 1

Any way to know if in ZMI?
by Sidnei da Silva 02 Nov '01

02 Nov '01

There is any way or property that I can test to know if im inside the ZMI or not? Thanx. -- Sidnei da Silva X3ng Consultoria e Desenvolvimento Ltda. sidnei(a)x3ng.com.br

2 1