November 2001 - Zope

referencing an object elsewhere in the tree
by sirius legend 24 Nov '01

24 Nov '01

Hello, I'm new to zope, and find it the best web application environment ;) Have a little problem... Browsed thru the docs and mailing lists, but can't find any information on how can i refer to objects that are not in the acquistion path. For example i build simple a shop, and have all shopping cart related dtml methods in /cart folder. In the cart's list method i'd like to include the icon, and other details can be found for example at /products/accessories/wallet/. Is there any way to do this? Now I store string object id's in cart's session variables like '/products/bags/djbag'. It's the cart item's original path. I think I should be able to resolve the object from this id, but how? There are also relations between products, like a products can be made from a list of materials, and that materials are also products. I tried to use ZCatalog to solve this, but it indexed only the current folder ( eg. /products/bags, but not the /products/materials ). The layout: /products/ materials/ natural1/ icon.gif, etc... natural2/ coloured/ black/ orange/ ... bags/ djbag/ ( here i'd like to have a manually edited list of links to materials ) backpack/ ... /cart/ list ( here i'd like to resolve object ids like /products/bags/dj ) edit ... Your help would be appreciated, martin

2 2

tutorial script error
by Raymond Norton 24 Nov '01

24 Nov '01

I am following the tutorial. When I attempt to add this script I get a syntax error on line 1. It doesn't like the quotes. Can anyone give me advice on this? ## Script (Python) "calculateCompoundInterest" ##parameters=principal, interest_rate, periods, years ## """ Calculate compounding interest. """ i = interest_rate / periods n = periods * years return ((1 + i) ** n) * principal Raymond

2 1

You are not authorized to access ... exception has me baffled
by Brad Clements 24 Nov '01

24 Nov '01

I've broken my site, and can't figure it out. This is Zope 2.4.3 binary on Linux I have / (root) with acl_users /Strader public without an acl_users (all permissions are "acquire from above") /Strader/P not public, has an LDAPUserFolder for acl_users local roles are defined in the root /acl_users Security for /Strader/P has disabled acquisition of "access contents information" and "view", and enabled these permissions for the roles Manager, SFCustomer and SFManager Logging in as a Manager defined in root /acl_users works for management, but when I attempt to view a ZPT in /Strader/P using the Test tab, I get "you are not authorized to access title" My manager userid is also defined in the LDAP adapter as well, so I'm authenticated by the LDAPUserFolder in /Strader/P or /acl_users depending on what I'm accessing. So "view" in /Strader works okay for me -- But the real problem is -- Logging in as a user who is only defined in LDAP adapter, who has the roles SFCustomer and SFManager still gives the same error "not authorized to access title" on /Strader/P/Master (page template when viewing) I'm totally stumped, it's as if LDAPUserFolder is not returning the correct list of roles. However, if I temporarily enable acquisition of view and "access contents", I can get this output from viewing the ZPT roles are ('SFCustomer', 'SFManager', 'Anonymous', 'Authenticated') (the Master template has ) roles are <span tal:content="user/getRoles">roles</span> Anyone have any ideas how to diagnose this so I can see where to fix it? I've searched the archives, there are some grumblings about this in the past but no obvious silver bullet. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

2 1

ldap user folder authentication prob
by Jonathan Cheyne 23 Nov '01

23 Nov '01

Hi all zope 2.4 running on win98. i-planet directory release 5. the new ldap user folder product. installed the ldap user folder and can query users by uid, cn etc in the users screen however when I try to actually access a protected object i can't get in. the log shows (9) Nov 22 11:07:10: root not found (getUser) (9) Nov 22 11:07:04: jon connect returned cn=Jonathan Cheyne,ou=People,ou=Contacts,dc=foe,dc=co,dc=uk subsequent attempts show (9) Nov 22 11:22:24: root not found (getUser) (9) Nov 22 11:22:19: User jon found in cache and so on Clues and hints ... ? Cheers Jonathan

2 3

recipe-question
by Sven Hohage 23 Nov '01

23 Nov '01

I'm using a nice small python-script from zopelabs: objects = context.objectValues() #get the objects in this folder for object in objects: print "id:", object.id property_names = object.propertyIds() # list of dictionaries of property names. for property in property_names: print property + ": " + object.getProperty(property) print print return printed The things I don't get are use of the double print statement and more importantly the need for returning printed. Why isn't print enough. Thanks.

1 0

Idea: move "type to Add select box" to the top frame (logged in as..)
by H.de.Wit＠SFK.NL 23 Nov '01

23 Nov '01

Just an idea, really no idea how complicated it would be: When the "type to add" select-box would be in the top frame, we would have more space in the objects window. Met vriendelijke groeten, Hans de Wit Stichting Farmaceutische Kengetallen Postbus 30460 2500 GL DEN HAAG Tel. 070-3737448 Fax 070-3737445

2 1

Error, Missing Input: Missing input variable, member_id
by Hamzat kamal 23 Nov '01

23 Nov '01

Hi, I intend to use Login Manager for user authentication to archive folder on my website. Then I was able to lay my hands on a sample written by dlpierson : Login Manager with an SQL database; http://www.zope.org/Members/dlpierson/sqlLogin I followed this strictly but when I was about to test it, I was experiencing problem with this particular Z MySql Method SQL_add_use. The Method has 3 arguments :(member_id, password, member_email). INSERT INTO member_authorization VALUES (<dtml-sqlvar member_id type=string>, <dtml-sqlvar password type=string>, <dtml-sqlvar member_email type=string>) <dtml-var sql_delimiter> INSERT INTO member_role_map VALUES (<dtml-sqlvar member_id type=string>, 'Member') <dtml-var sql_delimiter> INSERT INTO member_statistics VALUES (<dtml-sqlvar member-id type=string>, NULL, NULL) <dtml-var sql_delimiter> INSERT INTO member_profile VALUES (<dtml-sqlvar member_id type=string>, NULL, NULL) SQL used: Could not render the query template! Traceback (innermost last): File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\WebSite\lib\python\Zope\__init__.py, line 226, in zpublisher_exception_hook (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File C:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: manage_test) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 400, in manage_test (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 378, in manage_test (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 486, in __call__ (Object: SQL_add_user) File C:\Program Files\WebSite\lib\python\DocumentTemplate\DT_String.py, line 544, in __call__ (Object: <string>) File C:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\sqlvar.py, line 171, in render (Object: member_id) Missing Input: (see above) help to look at it for any assistance you can render. Thanks. kamal

1 0

Urgent help needed: Zope falls over under moderate load
by Michael Fraase 23 Nov '01

23 Nov '01

So yesterday my site got slashdotted. Zope fell over within minutes. A day later it's still falling over within an hour or so. I have 512Kb DSL (the outbound channel is 512Kb; the inbound channel is 768Kb). I figured that bandwidth would be saturated or that Windows 2000 Pro would melt long before Zope would fail, but that has proven not to be the case. Here's the particulars of my installation: Pentium III 850MHz with 768Mb RAM MS Windows 2000 Pro with current patches and service packs Zope 2.4.3 running as a service Squishdot 1.3.0 512Kb bandwidth Here's the registry start parameters: "C:\PROGRA~1\FARCES~1\bin\python.exe" "C:\PROGRA~1\FARCES~1\z2.py" -S -w80 -W9800 I don't know what the -S is; -w80 sets the port Zope's web server listens on; and -W9800 sets the WebDAV port. Zope just shuts down and closes port 80 on what seems to be very moderate load. We're talking a peak of less than 60,000 hits, a peak of 125Mb bandwidth usage, just over 58,000 page views, and a peak of 4013 visitors. What I've been doing is to manually stop the Zope service and restart it, but that's ridiculous. At this rate, clients are going to laugh at me when I suggest using Zope for a web project. Anyone have any ideas? I'm digestified, so please cc me in any response. Thanks kindly. -- Michael Fraase ARTS & FARCES LLC mfraase(a)farces.com www.farces.com PGP Fingerprint: 3D85 F3F4 9E65 4949 176A 260C CB47 190D C864 9A96

14 35

RE: [Zope] WEBDAV
by sean.upton＠uniontrib.com 23 Nov '01

23 Nov '01

Frankly, this one good reason you should consider the use of a proxy server in front to Zope like Apache or Squid, which is the usual setup for Production Zope deployments. You use proxy ACLs to screen for certain things, and can use an authenticator for things Zope doesn't authenticate on, as long as you use the same user names and passwords, or user director service. That said, you can see object ids in folders, but nothing else using WebDAV. You can also see the method objectIds callable via URL; if this concerns you, a proxy ACL is a simple, graceful solution, to keep your object id listings more obscure, and you should be able to setup ACLs for WebDAV and for things like /objectIds. You could bind an ACL to a authenticated user for this, or bind it to a group of source addresses, or a particular interface on the proxy server. True security is almost always a proper integration issue. Zope has strong security, but comprehensive solutions in a production environment really require the smart use of a reverse-proxy server / http-accelerator as a front end. Sean -----Original Message----- From: netadmin [mailto:netadmin@technifind.com] Sent: Wednesday, November 21, 2001 5:49 PM To: zope(a)zope.org Subject: Re: [Zope] WEBDAV I was using Webfolders under Windows 98 to access my webdav folder on a linux server. I found that I could access not only the directory ( and see all the files listed ) but the actual contents without having to authenticate [ scared the ? out of me ]. Is this standard? I double checked everything. I disabled acquisition and all persons on the anonymous user and I was still able to get to the contents of a file. ----- Original Message ----- From: sean.upton(a)uniontrib.com To: netadmin(a)technifind.com ; zope(a)zope.org Sent: Wednesday, November 21, 2001 6:37 PM Subject: RE: [Zope] WEBDAV It works; you need to specify the client you are trying to use, as some clients are non-standard, or do funky things. Most clients should work without problem, AFAIK... Sean -----Original Message----- From: netadmin [mailto:netadmin@technifind.com] Sent: Wednesday, November 21, 2001 5:30 PM To: zope(a)zope.org Subject: [Zope] WEBDAV Is webdav just pre-beta or what? It just doesn't seem to be working right at all. Is there a Zope-Webdav tutorial or faq or something I can get my hands on that might help me? Thanks ahead of time for any help, Luis.

1 0

ZODB and ZSQL
by Stephan Goeldi 23 Nov '01

23 Nov '01

Let's assume I have two databases. An external connected SQL database and the ZODB. In the external DB I have a table with two columns: 'name' and 'email'. In the ZODB I have a table with the columns 'name' and 'place'. How can I extract data from both in one turn using the foreign key 'name'? e.g. I want this result: name - email - place Is this possible? _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1