- Zope - Zope lists

"Zope DB instance has no attribute 'lock'"
by Derek Simkowiak 04 Mar '02

04 Mar '02

I installed the Z MySQL Database Adaptor product and configured a connection with the simple 'database username password' connection string. Now I get the above when I try "select * from applicants" in the 'test' view of my database adaptor. I have no idea what it means, or how to troubleshoot it. Is the problem in my database? In Zope? WTF? The database connections shows itself as 'open', so I think it can talk to the database okay. What do I do next? I'd post more information but I'm not sure what information is necessary... Here is the traceback from the error message page's source HTML:  ...and some other stuff: [dereks@dev dereks]$ rpm -qa | grep MySQL MySQL-client-3.23.41-5mdk MySQL-python-0.9.1-1py2 MySQL-shared-3.23.41-5mdk MySQL-3.23.41-5mdk [dereks@dev dereks]$ rpm -qa | grep Z Zope-2.4.3-1 Zope-zserver-2.4.3-1 [dereks@dev dereks]$ cat /usr/share/zope/lib/python/Products/ZMySQLDA/VERSION.txt ZMySQLDA 2.0.9 Any help would be greatly appreciated. Thanks, Derek Simkowiak

3 9

Formulator - Database Edit form (solved)
by Lee.Marzke＠ametek.com 04 Mar '02

04 Mar '02

RE: Setting up initial values on a formulator form from the contents of the DB. ( For a DB edit form ) I've found the solution by looking though the Formulator source. The following is a slight change to the index_html method in the Formulator HOWTO ( automatic method) . This form fills in the value of the fields with the current values of the DB. A ZSQL method is assumed to have been called prior to accessing this form by using direct traversal as explained by my last message. Hope this helps someone out, as I couldn't find the answer anywhere. Lee Marzke <lee.marzke(a)ametek.com> ==== <dtml-var standard_html_header> <dtml-var "form.header()"> <dtml-let me="this()"> <table border="0" width="50%"> <dtml-in "form.get_groups()"> <dtml-let group=sequence-item> <tr><th colspan="2" bgcolor="#F8F8F8"><dtml-var group></th></tr> <tr> <dtml-in "form.get_fields_in_group(group)"> <dtml-let field=sequence-item> <tr> <td><dtml-var "field.get_value('title')"></td> <td><dtml-if "_.getattr(me, field.id)"> <dtml-var "field.render(_.getattr(me, field.id))"> <dtml-else> <dtml-var "field.render()"> </dtml-if> </td> </tr> </dtml-let> </dtml-in> </tr> </dtml-let> </dtml-in> <tr> <td><input type="submit" value=" OK "></td> </tr> </table> </dtml-let> <dtml-var "form.footer()"> <dtml-var standard_html_footer> ============================================================ I'm following the recommendations on using Formulator forms and info in the Book of Zope and not having much luck translating the Add form ( which works great ) into an Edit form that must be filled in with existing values. My list method uses direct traversal to an zsql method, and I want to add an additional path to the Formulator form which will pre-fill in the values For instance, each item is listed with a link to the edit form like [ <a href="<dtml-var URL1>/user_by_id/&dtml-userid;/forms/userEdit/"> Edit </a> Where the user_by_id is a zsql method with direct traversal enabled. I added the "field.render(field[field.getId()], REQUEST) as suggested by some archived email message but I get the error. Error Type: AttributeError Error Value: __getitem__ When clicking the edit link. Any suggestions or examples on how to get formulator ( or forms in general ) to work with zsql would be appreciated.

1 0

RE: [Zope] Barnes & Nobles Putting Zope Books in the wrong place! !!!!!
by sean.upton＠uniontrib.com 04 Mar '02

04 Mar '02

As much as it would be nice to have Zope books in both sections, I would much prefer that bookstores bundle Zope books for discounted prices with Paperback fiction bestsellers to increase the bredth of Zope's target audience. ;) Seriously, though, web apps or programming and development is where these books should be first, and if they can end up on other sections or aisle-end-tables, great... Sean -----Original Message----- From: James Johnson [mailto:james@tacomait.com] Sent: Monday, March 04, 2002 12:32 PM To: zope(a)zope.org Subject: [Zope] Barnes & Nobles Putting Zope Books in the wrong place! !!!!! I tend to agree, but sometimes mistakes work out to be blessings in disguise. As a network professional it's been nearly impossible to convince some other professionals the merits of Zope. Now as the original poster said. "The Web app section is huge" The networking professional is overwhelmed with so many choices. I'm asking the community is that not sweet marketing? I bet you more professionals will look at the book if it's the only Web app server in the networking section. Let's not get lost in the sea of "Web Application" marketing power-houses. While zope is an application server. It can also be called a networking system, because I can use it to connect people and resources together. My main point is I don't think they have enough money at DC to pay B&N for such exclusive placement. If you can't find Zope in any section you can always ask for help finding the right section. What we want are the people who never heard of Zope but maybe "Web Application". If I had a choice it would be both sections, but if I had to choose it would be the networking section.... Somebody wants it noticed! With this knowledge I think we stand an even better chance targeting the network professional on the merits and usage of Zope. Developers are important, but zope needs to make more headway with networking professionals. This might be the perfect time to illustrate the main differences between Zope and other "Web App Servers" That's why its confusing and should belong in both sections ;-) Imho, -James p.s. I know at first it seems wrong to leave an Web application product out of that section if you can't have both sections. My thoughts are that a developer will eventually find the software and tools needed to get the job done. The network pro may not ever look at the same section. but if each and every network pro is exposed to Zope when they are seeking knowledge in their profession, that is power just in being able to hear one say "I've heard of it". That's exactly some of the things I've been dreaming of to happen. > In retail, product placement is often key to whether or not something > is sold; this should interest authors and publishers. I agree that > this is a mismatch. > From: Robert Geiger [mailto:rgeiger@bellsouth.net] > Sent: Monday, March 04, 2002 7:14 AM > To: zope(a)zope.org > Subject: [Zope] Barnes & Nobles Putting Zope Books in the wrong > place!!!!!! > > > I don't know who knows anybody at B&N, but maybe the authors of the > ZOPE related books can all call the booksellers and get them to put > the Zope books in the correct section! > > Currently, B&N keeps the ZOPE books in the Networking systems section, > a hodge podge of books that have absolutely nothing to do with Web App > development. > > I brought this to the attention of the section manager, and, although > he agreed with me, he told me there are other people higher up the > food chain that decide these things, and that he could not move them. > The computer inventory system would have to tell him where to put the > books. > > There is a Web Development section, and a Languages section. Either > one would be more apropos for Zope books. > > The Python section has grown considerably, and if placed in the > language section, would be within a shelf of the well-browsed python > language books. > > The Web development section is fairly huge, and mostly related to > various ASP, PHP, and other tools, and, given it's size, would be > harder to stand out in, although it would be a more apropriate > section. On the plus side, being > > at the END of a section (Z) is a good thing. > > So, after having to browse EVERY section at B&N, and finding Zope in > the 'wrong' one, I'd like it to be easier for EVERYONE to find these > books. > > Enough said, just wanting to let somebody know. I tried, now it's the > communities turn! > _______________________________________________ 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 )

2 1

ownership_info
by Joachim Schmitz 04 Mar '02

04 Mar '02

What is the permission to read the owner_info of an object ? Apparently it is not available to anonymous. For testing I gave a manager proxy role to the requesting method, but thats standard_html_header :( Mit freundlichen Grüßen Joachim Schmitz -------------------------------------------------------------------- AixtraWare Ingenieurbüro für Internetanwendungen Hüsgenstr. 33a, D-52457 Aldenhoven Telefon: +49-2464-8851, FAX: +49-2464-905163 -------------------------------------------------------------------- Key fingerprint = DA10 CC82 62F8 1DBB 39A1 1EDC 725B 3317 A8D7 C3A6 Keyserver: http://germany.keyserver.net/en/

2 1

Users more information
by Antonio Beamud Montero 04 Mar '02

04 Mar '02

How I can register more info about the user, not only name and password...? I need to create a new product that extends acl_user?... P.D: LoginManager doesn't works with my Zope 2.5 ¿? -- Microsoft merges technologoies: Windows CE + Windows ME + Windows NT = Windows CEMENT ---- Antonio Beamud Montero Agora Systems S.A. http://www.agoratechnologies.com

5 4

ZCatalog and BTrees
by Thomas Guettler 04 Mar '02

04 Mar '02

I am storing my data in a BTreeFolder with _setOb(). I can access my objects with a URL (/myBTreeFolder/foo) but ZCatalog seems to be unable to find it. I store my data with _setOb() because _setObject() behaves like a normal folder. If I access /myBTreeFolder with a browser the content does not get displayed since it is stored in a the _tree object. Has someone seen a new version of BTreeFolder (I use version 2.0)? Could it be usefull to subclass BTreeFolder and wrap _getObject to call _getOb? thomas

2 1

Passing object name or id to DTML method
by Vinod Shrestha 04 Mar '02

04 Mar '02

I have a DTML method similar to the one below. I want to call this (from an html link) with an argument that is the name of the object xxx (eg. http://localhost/zope/test?xxx=item1_id) The idea is to use the same DTML method to render many instances of the object type. Being a newbie, I would appreciate your help--an example would be nice. Thanks. <dtml-with xxx> .... </dtml-with>

2 2

RE: [Zope] Creating a file in the filesystem?
by abg＠comco-inc.com 04 Mar '02

04 Mar '02

1) Install LocalFS (http://www.zope.org/Members/jfarr/Products/LocalFS) 2) Create the following External Method (call it addLocalFSFolder): from OFS.Folder import Folder def addLocalFSFolder(self, id): ob = Folder() ob.id = id self._setObject(id, ob) 3) Call it from DTML like so: <dtml-call "addLocalFSFolder(myLocalFS, myFolderName)"> This works for creating folders. Should be easy enough to modify to create files. Aaron > -----Original Message----- > From: j2 [mailto:spamfilter2@mupp.net] > Sent: Monday, March 04, 2002 12:06 PM > To: zope(a)zope.org > Subject: [Zope] Creating a file in the filesystem? > > > I would like to create a semaphore file in the filesystem > (/tmp/restart > maybe?) and then poll that file from a cron job to see if a > certain daemon > should be restarted. But, how on earth do one create such an object? > > > _______________________________________________ > 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

zope-client.py: XML-RPC && WxPython
by Thomas Guettler 04 Mar '02

04 Mar '02

Hi! I patched ZopeClient.py from Amos Latteier. You can now edit Python-Scripts, too. zope-client.py lets you access zope with a native GUI (wxPython) via XML-RPC. It is more an example than an useful programm. If your interested you can get it from http://guettli.sf.net thomas -- Thomas Guettler <guettli(a)thomas-guettler.de> http://www.thomas-guettler.de

1 0

RE: [Zope] The Principles of Designing a Heavy Load Site with Zop e
by sean.upton＠uniontrib.com 04 Mar '02

04 Mar '02

I'm chime in with some of my thoughts and questions... Storage: why not something like logical volume management and a LV group over a handful of DAS devices; seems cheaper than one big array? I would think 5 TB is doable on a 2-box cluster with 4-6 midrange DAS units connected on dual-bus SCSI or Fibre per box, at likely less than $250,000 if you shop for some bargains... Then again, size may not be as much of an issue as load? Load balancing: L4 switch (or LVS?) in front of a group of Squid boxes in front of a decent sized ZEO cluster. Most L4 switches will do DSR/OPR (direct-send or out-of-path return) instead of proxy mode, sending packets directly from the balanced servers to the requesting client, but this packet rewriting technique means that load-balancer cannot detect whether or not the node its sending packets to is up, since it can't get a response, so you usually have to use IP-takeover based clustering (Linux FailSafe or Heartbeat) to takeover a dead proxy/caching server. In theory, this approach would eliminate a single load-balancer as a bottleneck because it becomes a packet pusher and not a brokering proxy, which would make something like this ideal for directing traffic to multiple proxy servers under a high load... Price tag: 20,000 for 2x L4 switches, 20,000 for 4 decent Proxy boxes to run Squid. Caching/Proxying: in response to the original post, I would think it would make more sense to bypass Apache altogether and proxy to ZServer (with ICP patches) directly from a competent load-balancing, ICP-capable, caching proxy like Squid. If nothing else, have Squid cache the page elements (all static pages, images, client-loaded javascript source files) that can be cached to alleviate some stress on your Zope server and allow you to still keep things relatively simple. Then again, I've never tried Apache+PCGI with Zope... Rendering: my question is when does a ZEO connection, for ODB-stored content become the bottleneck? I realize using a replicated RDB solves this problem to some extent for those using ONLY relational data for content in their apps, but I'm personally more curious about intensive use of ZODB. There are issues of bandwidth to and processing power of a ZSS. Can ZEO (yet) support using ClientStorage on an intermediary ZSS to use client caching in a hierarchy of ZSS boxes? I know that this wasn't technically possible a while back, at least from what I remember reading on the ZODB-dev list, and I wonder if it would actually yield better performance in most real world scenarios? Page Impressions & Rendering: I'm looking for an example of how Zope would handle under extreme dynamic loads with a fairly straightforward example...For a single Zope server (direct to ZServer), what kind of numbers (Req/sec) would it be reasonable to assume that you could serve for a otherwise static page that used a dtml-method that rendered results from a Catalog query returning a dozen results (assuming direct reads from metadata tables - no getObject() calls) on new-fast hardware (say, an Athlon 1.6GHz + lots of DDR using FileStorage on a striped volume on fast disks)? Could a single box like this sustain 25-30Rec/sec in ideal conditions, assuming a very aggressive use of aggregated HTTP keepalive connections was put in front of it via proxy? Personally, what I would like to be able to do is eventually be able to serve 100 simple and uncached Req/Sec along these lines from a 4-5 node cluster of ZEO Clients on 2CPU Athlon MP boxes running 2 Zope+ClientStorage instances each, with load distributed via Squid+ICP (assuming that these requests were always a cache MISS in Squid)... Sean -----Original Message----- From: Matthew T. Kromer [mailto:matt@zope.com] Sent: Monday, March 04, 2002 7:49 AM To: zope(a)zope.org Cc: iap(a)y2fun.com Subject: Re: [Zope] The Principles of Designing a Heavy Load Site with Zope I think there are some fundamental misunderstandings going on here, but I thought it would be interesting to try to respond anyway. iap(a)y2fun.com wrote: > Hi, > > This issue has been discussed again and again, > > I would like to clarify my idea and your comments will be very > appreciated. > > Suppose we want to provide a server which is: > > 1) Hosting 1,000,000 members' profile. Each member's disk quota is 5MB. > > Which means we need at least 5,000GB (5 TeraGB) disk space. > > 2) Assume the concurrent accessing to a URL is 1000 request/per second > > 3) Assume all the requests retrieve dynamic content. > > 4) We want to leverage the power of Zope which means all the pages > should be > > rendered by zope. > Having 5 TB of disk space usually means some very high-powered RAID gear; my personal favorite is the EMC Symmetrix units; I think you would probably want at least two of those to provide your coverage. Estimated cost for this is about $5,000,000 (but *very* dependant on EMC's pricing strategies). You could get by for less, by distributing each disk with each CPU (the breadrack approach.) 1000 requests/second isnt terribly high; Zope installations have done 400/sec with no problem. However, these are in situations where Zope is being heavily cached; less than 10% of the requests are actually being rendered by Zope. So, if you wanted no caching (ala everything is completely dynamic content), my estimate is you would need something like 100 1Ghz Intel Pentium III class machines to perform that amount of dynamic rendering. If each of those machines had a 50 GB disk drive, you'd theoretically have your 5TB of disk space. At a rough commercial cost of $4,000 per unit (probably a bit high), that's only $400,000. As a practical matter, you'd then need some pretty hefty load balancing servers; at least two, possibly more. However, that begs the question of how you organize that much disk space. It's not an easy task. Whether or not you use an RDBMS is irrelevant until you can work out a strategy for using the disk space scattered amongst all of those machines. * * * Now, if you forget for a moment about requiring each page to be dynamically rendered each time it is viewed, and you set aside the storage questions, you could estimate that, with a 90% caching rate, you could serve 1000 requests/sec with only about 14 machines (10 renderers, 2 cache servers, and two load balancers). Estimated cost for that is $56,000. What is most unrealistic about this scenario is your assumptions about the member base, and its ratio to expected activity. One million users may only generate 1,000 requests/sec, but they certainly could generate a lot more. In fact, a critical strategy for large systems like this is anticipating for "peak demand" events. Lets say you send an e-mail out to all million people, telling them to log in and check out a particular URL. That timed event will generate a demand curve that is not evenly distributed over time; in fact, it is usually very front-loaded. Within about 5 minutes, more than 10% of the user base will respond. This is a raw rate of about 333 requests/sec, but that prprobably esumes that the single URL is the only thing they load; usually, a page contains images and other content (style sheets etc) which also much be fetched. Pages with a high art content can have 25 elements or more on them. That pushes the request rate up to 8333 requests/sec; way out of the 1000 request/sec bound. > The priciples I would like to verify are: > > 1) Some database (RDBMS) should be used instead of FileStorage for ZODB. > > 2) The ZEO should be used for constructing a cluster computing. > > 3) The Apache should be the front end instead of ZServer. > > 4) The PCGI should be the connection between Apache and Zope. > > 5) I shouldn't create static instance into the ZODB but query the > > external database. > > 6) The "Cache" of zope is useless since all the responses are dynamic > rendered. > > By the way, how much will this kind of system costs, regardless the > hardware? > > Iap, Singuan > -- Matt Kromer Zope Corporation http://www.zope.com/ _______________________________________________ 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