December 1999 - Zope

RE: [Zope] Zope woes continue - server going down regularly. (pos sible solution)
by Cayce Ullman 09 Dec '99

09 Dec '99

Well, I'm not suprised to find out that it was something I was doing wrong. However, the symptons still sound fairly similar and I wouldn't be suprised it someone his site is doing something similar. Also, I tried : x = Zope.app() x.close() And it complains that x has no attribute close. any ideas? Thanks, Cayce --- Michel Pelletier <michel(a)digicool.com> wrote: > > -----Original Message----- > > From: Tres Seaver [mailto:tseaver@palladion.com] > > > Michel Pelletier <michel(a)digicool.com> wrote: > > > > -----Original Message----- > > > > From: Cayce Ullman [mailto:c_ullman@yahoo.com] > > > > There is stuff in ZODB.ZApplication.py which looks > as though > > it should not be > > necessary to close a ZODB connection manually:> > > > Am I misreading this? Or do we have a refcount > cycle in here > > somewhere? > > That code closes the database connection associated > with the REQUEST. > The original poster had an external method that > created a *new* > connection object, *in addition to* the one opened > by the REQUEST. The > Zope Application code knows to clean up the REQUEST > connection, but has > no information about any other connections you open, > including those in > an external method. You must explicitly close() > them. > > -Michel > __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one place. Yahoo! Shopping: http://shopping.yahoo.com

1 0

Reverse sort w/ dtml-in
by Chuck Burdick (TT) 09 Dec '99

09 Dec '99

I'm trying to implement some database interaction in Zope. I'm using ZSQL and <dtml-in> tags to display the data on the web page. The data has a date in it, and I would like to sort so that most recent is first. However, I see no mention of a "reverse" option with the sorting capability of the <dtml-in> tag. Is there a way to script the reverse sorting in DTML, or do I have to do all my sorting inside the database query (ZSQL method)? Thanks, Chuck Burdick Web Administrator / Developer Trading Technologies, Inc. chuck.burdick(a)tradingtechnologies.com (847) 424-8844

2 1

form question
by Dennis Moore 09 Dec '99

09 Dec '99

I have a form that gathers a information in a dtml document. The form action is a dtml method which shows this information for the user to verify in a new form. The problem is that somewhere along the way, letter is no longer a list. I've tried making NAME="letter:list" in the first document, but that doesn't help. I think the solution is in the hidden input in the first method. When i make letter = <dtml-var letter> it's just a string and not a list. How do I make it a list? On a related note, if I only select one of the checkboxes, it doesn't get passed as a list (single element), but just as a bare string when it gets to the sql method. Then dtml-in doesn't work on the variable. How do I test to see if the variable is a list, or cast it to one in dtml-in? Also, is there a better way of propagating the namespace? This is just an oversimplified version of what I'm actually trying to do. I would rather not have to make a 'hidden' line for every variable I want to pass. I hope a comprehensive, up to date, DTML reference appears soon. Thanks in advance.. ### dtml document cb_test:  <h2></h2> <p> This is the  Document. <form action=PerformCbVerify method=POST> <INPUT TYPE="checkbox" NAME="letter" VALUE="a"> A<BR> <INPUT TYPE="checkbox" NAME="letter" VALUE="b"> B<BR> <INPUT TYPE="checkbox" NAME="letter" VALUE="c"> C<BR> <INPUT TYPE="checkbox" NAME="letter" VALUE="d"> D<BR> <p> <INPUT TYPE =submit NAME=submit VALUE=Submit> <INPUT TYPE=reset> </form> </p>  ### dtml method PerformCbVerify:  <H2> </H2> <P>This is the  Document in the  Folder.</P> You picked: <form action=PerformCbTest> <dtml-in letter> "<dtml-var sequence-item>" <dtml-if sequence-end>. <dtml-else>and </dtml-if> <dtml-else>null </dtml-in> <p> <INPUT TYPE=hidden NAME=letter VALUE="<dtml-var letter>"> <INPUT TYPE =submit NAME=submit VALUE=Submit> </form>  ### dtml method PerformCbTest:  <H2> </H2> <P>This is the  Document in the  Folder.</P> <dtml-call sqlCbInsert>  ### sql method sqlCbInsert: insert into mytable (letter) values ( <dtml-in letter> <dtml-if sequence-start>'{ </dtml-if> "<dtml-var sequence-item>" <dtml-if sequence-end>}' <dtml-else>, </dtml-if> <dtml-else>null </dtml-in>) -- pity this busy monster, manunkind, | Dennis Moore | Sarah not. Progress is a comfortable disease. | rainking(a)frenzy.com | McLachlan -e.e. cummings: One Times One | archon on the irc | "Black" If I cried me a river of all my confessions would I drown in my shallow regret?

1 0

MySQL HELP !!!
by Gabriel dos Santos 09 Dec '99

09 Dec '99

Hello guys, I have trouble to compile the ZMySQLDA. Is there anything that I dont know ? When I execute the [make -f Makefile.pre.in boot], it issue to me: [...make[1]: *** No rule to make target /usr/lib/python1.5/config/Makefile, needed by sedscript. Stop. ...] I dont found the directory [/usr/lib/python/config] in any python version! Can you help me ? _____________________________________________________________ Aquilo que você sempre quis ter está sendo vendido agora. www.gibraltar.com.br _____________________________________________________________

2 1

RE: [Zope] New site using Zope technology
by Rob Page 09 Dec '99

09 Dec '99

Hi Bruno: Bruno Mattarollo wrote: > I am glad to announce our first public beta of the site > we have been developing for the last month. It's all done in Zope served > through Apache. What is the URL? Love to take a look -- even though it's likely I won't be able to read it! :^( --Rob

1 0

Trapping external database errors
by Henny van der Linde 08 Dec '99

08 Dec '99

Hi, I have a Zope site connected to a SQL-server 7 database. It's nescesary to update, add information through the Zope site. Is there a elegant way to trap errors generated by the external database server. Now, when an user enters a invalid date for example, Zope simply returns a standard error page, with some information generated (i guess) from the ODBC adapter. I know the right thing to do is validating the fields before submitting the form (I have a question on this matter wich I posted earlier). But that said: it must be possible evaluate/trap the outcome of a external database transaction in an elegant way. thanks Henny van der Linde

1 0

Zope Weekly News
by Mike Pelletier 08 Dec '99

08 Dec '99

G'day, Zope Weekly News is a digest of some of the useful and interesting events which have occurred in the Zope universe. It is published each Wednesday evening. Any opinions contained in the Zope Weekly News are those of the chronicler exclusively. New Products * "faassen" released ZFormulator 0.1: "ZFormulator is a product that can assist with the creation of HTML forms, their validation and processing. The Zope user can construct forms from within the Zope management interface." "Neat feature: eats its own dogfood (ZFormulator is built with ZFormulator!)" http://www.zope.org/Members/faassen/ZFormulator * "vladap" released MySQL User Folder. It allows you to store user information in a MySQL database. http://www.zope.org/Members/vladap/mysqlUserFolder * "phd" has submitted an early development release of mod_pcgi2(0.0.1). Presumably, this moves the wafer-thin C stub PCGI employs into Apache's process, eliminating the so-called fork tax. http://www.zope.org/Members/phd/mod_pcgi2/mod_pcgi2_v0.0.1 Announcements * Digital Creations has partnered with Fast Engines to add support for their FastServ product. FastServ provides advanced load-balancing (even within a heterogenous server environment) and works with industry standard web servers. http://www.digicool.com/News/FastEngines * Digital Creations has announced that an early 2000 Zope release will include support for two open protocols heavily supported by Microsoft: the Simple Object Access Protocol (SOAP) and Web Distributed Authoring and Versioning (WebDAV) protocol. http://www.digicool.com/News/integrate * Another press release from DC: Jon Udell will be delivering a keynote at the Zope Track of the 8th International Python Convention. http://www.digicool.com/News/Udell * "TWilson" announced a special interest group on the subject of Zope and educators. The group is still in it's formative period, so get involved now to help plan it's future. http://www.zope.org/Members/TWilson/Zope-edu * Tom Deprez <tom.deprez(a)uz.kuleuven.ac.be> reported on the state of the Zope Documentation Project. http://lists.zope.org/pipermail/zope-dev/1999-December/002524.html * Eduardo Fernandez Corrales <efernandez(a)sistelnet.es> has a Spanish Zope portal and mailing list. http://zope.sistelnet.es/ http://zope.sistelnet.es/cgi-bin/mailman/listinfo/hispazope * Paul Everitt sent out a reminder that it's time to register for the Zope Track at the 8th International Python Conference. http://lists.zope.org/pipermail/zope/1999-December/015052.html Updates * Zope 2.1.0 final has been released! This release includes many bug fixes, speed improvements and new features. http://www.zope.org/Products/Zope/2.1.0/ A log of everything that has changed is also available. http://www.zope.org/Products/Zope/2.1.0/CHANGES.txt Zope.org items * Zope Resources is changing slightly. Zope Hosting Providers is being replaced with a more general page, Zope Solution Providers. http://www.zope.org/Resources * "Zen" submitted a pair of tips about Zope's little-known 'manage_debug' method, which can provide profiling information and information useful for debugging connection problems. http://www.zope.org/Members/Zen/tips/profiling http://www.zope.org/Members/Zen/tips/manage_debug * "tseaver" reported a LinuxPlanet review of Zope. Kevin Reichard (the reviewer) brings with him a fresh perspective as someone coming from outside the "Zope community". He gives Zope an overall 4/5 rating and raises a number of concerns, some valid, some perhaps less so. Kevin represents a demographic destined to become the majority of Zope users (namely, those who view Zope as a tool rather than as a way of life. ;-) ) and so his review deserves careful consideration. http://www.linuxplanet.com/linuxplanet/reviews/1319/1/ Notable Discussions * Rodrigo <rdeleonp(a)yahoo.com> posted a query about using Zope with SSL. The common solution is to use Zope with Apache, IIS or Netscape Server to provide a secure connection. David Kankiewicz <kankie(a)thegrid.net> cited an old post about a product which gives ZServer the ability to establish SSL connections! http://lists.zope.org/pipermail/zope/1999-December/015061.html http://lists.zope.org/pipermail/zope/1999-December/015063.html http://lists.zope.org/pipermail/zope/1999-December/015065.html -- Mike Pelletier.

1 0

RE: [Zope] AtributeError
by Rob Page 08 Dec '99

08 Dec '99

Henny: Hmm.. you mention below that you are using the latest ODBC driver. The error strongly implies that it's not the current one. Are you using Z ODBC DA 3.0.1? --Rob > When our site tries to access a SQL-server 7 database we get > often (not > always, it's a bit random) the following error: > > > Error type: AttributeError > Error value: tpc_begin > --> > </BODY></HTML> >  > > When we click on refresh in the browser the page is correctly > loaded. We > use: > > NT-server, > IIS4, > SQL server 7 > Zope 2.01 with the latest ODBC adapter. > > By the way, this problem didn't occur under Zope 1.10 with > the old ODBC > adapter. > > Please help, > It's verry urgent. > > Thanks > > Henny van der Linde > > > _______________________________________________ > 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 ) >

3 4

RE: [Zope] Zope woes continue - server going down regularly. (pos sible solution)
by Michel Pelletier 08 Dec '99

08 Dec '99

> -----Original Message----- > From: Tres Seaver [mailto:tseaver@palladion.com] > Michel Pelletier <michel(a)digicool.com> wrote: > > > -----Original Message----- > > > From: Cayce Ullman [mailto:c_ullman@yahoo.com] > > There is stuff in ZODB.ZApplication.py which looks as though > it should not be > necessary to close a ZODB connection manually:> > Am I misreading this? Or do we have a refcount cycle in here > somewhere? That code closes the database connection associated with the REQUEST. The original poster had an external method that created a *new* connection object, *in addition to* the one opened by the REQUEST. The Zope Application code knows to clean up the REQUEST connection, but has no information about any other connections you open, including those in an external method. You must explicitly close() them. -Michel

2 1

Re: [Zope] Zope woes continue - server going down regularly. (possible solution)
by Tres Seaver 08 Dec '99

08 Dec '99

Michel Pelletier <michel(a)digicool.com> wrote: > > -----Original Message----- > > From: Cayce Ullman [mailto:c_ullman@yahoo.com] > > Sent: Wednesday, December 08, 1999 11:26 AM > > To: zope(a)zope.org; panda(a)skinnyhippo.com > > Subject: [Zope] Zope woes continue - server going down regularly. > > (possible solution) > > > > > > >>> Alternatively, the server just hangs and doesn't > > respond > > >>> (but ps -aux shows the process is running). > > >> > > >>Is it spinning? (consuming 100% CPU resources?) or > > hung? (consuming > > >>none..) > > > > I noticed a couple of weeks ago that my Zope, > > started spinning when I hit a certain page 5 or > > 6 times. I noticed that this page was different > > from the others as it tried to do a Zope.app(). > > This was interesting cause the actual Zope.app() > > call worked, except it would eventually hose the > > server. I figured I was just doing something wrong > > and figured out another way to do it. Anyway, > > here's how to reproduce the problem : > > > > Create a external method that looks like this : > > > > import Zope > > > > def helloworld(self): > > x = Zope.app() > > return "Hello World" > > This is because the connection gets opened, but never closed. Zope 2.x > is hardwired to have only 7 available database connections. We'll > probably add a knob in 2.2 that lets you configure the number of db > connections. In either case, the problem is not the hardwiring, the > problem is that your code has a bug in it, because you do not free the > resource you are consuming. Do an: > > x.close() > > at the end of your method and you won't run out of connections. There is stuff in ZODB.ZApplication.py which looks as though it should not be necessary to close a ZODB connection manually: conn=db.open(version) # arrange for the connection to be closed when the request goes away cleanup=Cleanup() cleanup.__del__=conn.close REQUEST._hold(cleanup) Am I misreading this? Or do we have a refcount cycle in here somewhere? -- ================================================================================ Tres Seaver tseaver(a)palladion.com http://www.palladion.com Palladion Software Houston, Texas, USA 713-523-6582

1 0