February 2002 - Zope

iplanet enterprise web server 6.0 on Solaris 5.8
by jbr＠FIZ-Karlsruhe.DE 20 Feb '02

20 Feb '02

Hello, I have searched for information how to connect zope to iplanet server but found only documents related to apache. Here at our site we are running iplanet enterprise web server 6.0 on SUN Solaris 5.8 Does anybody know how to connect this webserver to the zope server ? Is it done by URL Forwarding ? Thanks in advance. With kind regards, Juergen Berger

2 1

ZSQL and last_insert_id
by Chad Nantais 20 Feb '02

20 Feb '02

What is the right syntax for getting the id of the last recorded inserted with ZSQL methods? I tried this: SELECT LAST_INSERT_ID() AS last_insert_id The resulting error is: Traceback (innermost last): File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 223, in publish_module File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/2.4.4b1/lib/python/Zope/__init__.py, line 226, in zpublisher_exception_hook (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 171, in publish File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_test) File /usr/local/zope/2.4.4b1/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_test) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 400, in manage_test (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 378, in manage_test (Object: last_insert_id) File /usr/local/zope/2.4.4b1/lib/python/Shared/DC/ZRDB/DA.py, line 493, in __call__ (Object: last_insert_id) File /usr/local/zope/instance/Products/ZMySQLDA/db.py, line 252, in query OperationalError: (1064, "You have an error in your SQL syntax near 'last_insert_id LIMIT 1000' at line 1"

4 3

Error(200): python exceptions
by Cornelis J. de Brabander 20 Feb '02

20 Feb '02

I have a Zope server serving several applications. Some applications are still in use, though their authors have left the scene. I am plagued regularly by python exceptions of which below is an example. I simply do not know where to start looking. Can anybody give me a hint? Current setup: Windows NT Zope 2.4.3 2002-02-19T16:14:42 ERROR(200) ZServer uncaptured python exception, closing channel <zhttp_channel connected 62.234.42.8:1113 at 2bbb72c channel#: 6080 requests:> (exceptions.ValueError:unpack list of wrong size [E:\zope\243\bin\lib\asyncore.py|poll|95] [E:\zope\243\bin\lib\asyncore.py|handle_read_event|383] [E:\zope\243\ZServer\medusa\asynchat.py|handle_read|113] [E:\zope\243\ZServer\medusa\http_server.py|found_terminator|456] [E:\zope\243\ZServer\medusa\http_server.py|found_terminator|152] [E:\zope\243\ZServer\HTTPServer.py|found_terminator|174] [E:\zope\243\ZServer\HTTPServer.py|continue_request|309] [E:\zope\243\ZServer\HTTPServer.py|get_environment|287]) This was the last exception I caught. I remember that before I upgraded from Zope 2.1.6 the exception was not a value error but an attribute error: exceptions.AttributeError:'int' object has no attribute 'send' TIA Cornelis J. de Brabander ========================================== Department of Education, Leiden University P.O.Box 9555, NL-2300 RB Leiden +31 71 527 3422/3401 brabander(a)fsw.leidenuniv.nl ==========================================

2 2

Re: Anyone know of a product that can...
by Tim Owen 20 Feb '02

20 Feb '02

Sorry about the @#%$^* previous non-text email. Got to figure out a way to turn the formatted email off by default... Regards. ----- Original Message ----- From: Tim Owen To: zope(a)zope.org Sent: Wednesday, February 20, 2002 10:00 AM Subject: Anyone know of a product that can... manage a directory of businesses for a local chamber of commerce (read this as very little $$$ to spend). Want it to be somewhat self managing (create a listing and manage a listing by the businesses themselves using a predefined format) but retaining the review and publish rights for manager of the site. Basic listing is no cost, but upgraded listings (extended information, link to another web site, inclusion of logos, etc.) would have a cost. Other functions required: category, location, and other criteria based searches, potentially include banner ads, email integration for information requests. Site could just use ZODB since the number of listings should be under 1000, but might grow to 5000. I suppose Gadfly or MySQL could be used if this seems large for ZODB. I was thinking about Formulator, Metapublisher, CMF, etc. but was not sure the best route to go. Thoughts? Thanks in advance, Tim Owen This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.

1 0

Anyone know of a product that can...
by Tim Owen 20 Feb '02

20 Feb '02

manage a directory of businesses for a local chamber of commerce (read this as very little $$$ to spend). Want it to be somewhat self managing (create a listing and manage a listing by the businesses themselves using a predefined format) but retaining the review and publish rights for manager of the site. Basic listing is no cost, but upgraded listings (extended information, link to another web site, inclusion of logos, etc.) would have a cost. Other functions required: category, location, and other criteria based searches, potentially include banner ads, email integration for information requests. Site could just use ZODB since the number of listings should be under 1000, but might grow to 5000. I suppose Gadfly or MySQL could be used if this seems large for ZODB. I was thinking about Formulator, Metapublisher, CMF, etc. but was not sure the best route to go. Thoughts? Thanks in advance, Tim Owen This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies.

1 0

login manager on 2.5.0
by honey bee 20 Feb '02

20 Feb '02

1 0

BUG? Non-manager can't edit ZPT with WebDAV or FTP; can with ZMI (fwd)
by Joel Burton 20 Feb '02

20 Feb '02

(Apologies if you're seeing this message twice; after 24 hours, I haven't seen it appear on the list, so I'm re-sending.) Synopsis: A highly-privileged non-manager user can edit all content types through WebDAV or FTP *except* PageTemplates. If user is changed to a manager, they can now edit PageTemplates through WebDAV/FTP. Demonstration/Walkthrough: 1) in folder "/foo", create local role "test" 2) in "/foo", give role "test" *all* permissions (in theory, this person would only need a few privileges; to remove any possibility that we're guessing the wrong privileges, select them all) 3) add user "bob" w/role=test 4) create a ZPT document "test.pt" in "/foo" 5) create a DTML DOcument "test.dtml" in "/foo" 5) see that bob can edit both documents using ZMI w/o problem. (therefore, it's not privileges per se that's causing the problem) 6) see that using WebDAV/FTP, bob can edit "test.dtml" (therefore, it's not WebDAV setup per se that's causing the problem) 7) see that using WebDAV/FTP, bob *cannot* edit "test.pt" (!) 8) add manager role to bob 9) now bob can edit "test.pt" through WebDAV/FTP (therefore, it's not simply ZPT+WebDAV that's causing the problem) Notes: I've tried FTP and 3 WebDAV clients (cadaver, WebDrive, Dreamweaver); all return an unauthorized message. This isn't a firewall, client, or locking problem: I can't do it from the server using cadaver; I've tried different client machines; using cadaver, I can't even GET the file (which makes no attempt to lock it.) WebDAV editing of ZPT is a critical feature for my clients. I can't give the editors "manager" role w/o opening huge security holes. Using cadaver w/debug settings, I can get detail on the requests and responses: the forbidden edit request (step #7 above) just re-requests authentication twice and fails. Happy to send the cadaver log to anyone who might find it helpful. Can anyone edit ZPT through WebDAV or FTP with non-managers? Can anyone shed any light on this problem? I do read zpt(a)zope.org, but a cc to me directly would be appreciated. Thanks in advance! -- Joel BURTON | joel(a)joelburton.com | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant

1 0

AW: [Zope] Priority of processes in Zope
by oliver.erlewein＠sqs.de 20 Feb '02

20 Feb '02

Hi all It seems that Problems with Solaris threading should be solved after installing Python 2.1.2 or Python 2.2. The thread to read up on this can be found at: http://groups.google.de/groups?hl=de&threadm=slrn9phonu.vq6.bbrox%40bbland.b brox.com&rnum=2&prev=/groups%3Fq%3Dsolaris%2Bthreading%2Bpython%26hl%3Dde%26 selm%3Dslrn9phonu.vq6.bbrox%2540bbland.bbrox.com%26rnum%3D2 The corresponding Python patchnumber is #460269. I'll try this on my Sun Solaris 2.8 and on my Intel Solaris 2.7 next week (my administrator's on holliday - !!!Grrrrrr!!! ;-) I'll post my results. Thanx to all who have helped solve the problem and burned a few calories thinking about the solutions! If anybody has more questions or can confirm the successful use of Python 2.1.2 (see problems in thread "threading, dtml and performance"), then please respond to the list. Oliver Erlewein

1 0

Python 2.2 RPMs OK for Zope 2.5.x on RH 7.2?
by Jeff Kowalczyk 20 Feb '02

20 Feb '02

My Zope experimenting has been done on Windows machines to date. I'd like to start using Python and Zope on my Linux boxes, but wondered if unlike Windows, I need to have an externally installed Python version synchronized with Zope's expected v2.1. Does anyone have any feedback on whether the Zope 2.5.x series will coexist nicely with the Python 2.2 RH7.2 RPMs at http://www.python.org/2.2/rpms.html ? I'd probably wait to use the Zope RPMs at TauPro when the 2.5.x version becomes available.

3 2

dtml-var weirdness
by Joseph A Knapka 20 Feb '02

20 Feb '02

Hi everyone, Stupid question of the day: Why might the following code result in a KeyError? It does in some contexts under Zope 2.5.0. <dtml-if expr="REQUEST.has_key('xyz')"> <dtml-else> <dtml-call expr="REQUEST.set('xyz','Hello world')"> </dtml-if> Sometimes the next line results in a KeyError, value 'xyz': <dtml-var name="xyz"> In such cases, this works fine: <dtml-with REQUEST only> <dtml-var name="xyz"> </dtml-with> Huh? TIA, -- Joe "I should like to close this book by sticking out any part of my neck which is not yet exposed, and making a few predictions about how the problem of quantum gravity will in the end be solved." --- Physicist Lee Smolin, "Three Roads to Quantum Gravity"

7 14