March 2001 - Zope - Zope lists

ZClass with property linking to another object
by Ronald L. Chichester 04 Mar '01

04 Mar '01

Is there a way to have a ZClass with a property that, upon instantiation, can link the newly instantiated object to another object that already exists within the database? In other words, is there a way to establish a relationship between two objects in the database so that a search for related objects in one instance will bring up the other objects (be they the same class or not)? I have some "people" objects and I want to 'link' things about those people (i.e., things that they are responsible for or have created) in a way that I can hyperlink form the created object. Any ideas? Thanks in advance, Ron

1 0

RE: ZODBC problem (was: Preventing WebDAV locks)
by Capesius, Alan 04 Mar '01

04 Mar '01

Thanks Jeffrey, Where are these WebDAV.resource.lock() permissions? I am running both 2.2 and 2.3 Zope and cannot find this anywhere. The locks seem to be coincidental to the problem, with further testing I have determined that the Zope server itself is not locking up, but rather requests to the database (MS SQL7 via ZODBCDA) seem to be queueing up. I have several long running report queries that were recently added to the server. They do totalling within DTML to provide accounting reports. If two clients request these reports at the same time, all other SQL based access is halted until one of the queries finishes. Any query is unresponsive while the server is processing these long running queries (30 secs +). Even very short queries will not respond until the client processing the long queries frees up. I've tried increasing ZODB pool_size, but this does not help. The SQL Client is set up for TCP/IP connection to the SQL server on another box. Is there a limitation here. A fix? Or perhaps another way to connect to the SQL server than ZODBCDA? In addition, I've loaded two instances of Zope on the same server running identical configurations. One instance will stop the other instance from accessing the database. This leads me to believe it may be a bottleneck in the SQL ODBC driver. Alan Capesius Technical Support Engineer Sysmex Corp of America >>>-----Original Message----- >>>From: Jeffrey P Shell [mailto:jeffrey@Digicool.com] >>>Sent: Wednesday, February 28, 2001 8:20 AM >>>To: zope(a)zope.org >>>Cc: Capesius, Alan >>>Subject: re: Preventing WebDAV locks. >>> >>> >>>> ----- Forwarded message from "Capesius, Alan" >>><CapesiusA(a)Sysmex.com> ----- >>>> >>>> Subject: [Zope] Preventing WebDAV locks? >>>> From: "Capesius, Alan" <CapesiusA(a)Sysmex.com> >>>> To: zope(a)zope.org >>>> Delivery-date: Tue, 27 Feb 2001 22:48:38 +0100 >>>> X-BeenThere: zope(a)zope.org >>>> >>>> I have some pages configured to return Excel format to the >>>user using the >>>> technique detailed at: http://twsite.bizland.com/twzop0014.htm >>>> >>>> When executed from Netscape everything works fine, when >>>executed from IE >>>> 5.5, if the user opens the file directly into Excel via >>>embedded OLE (clicks >>>> open or has the XLS associated), the client is locking the >>>file on the >>>> server, preventing other users from accessing the data. >>>> >>>> Another client attempting to access the same file will not >>>receive a >>>> response until the first user times out (3 minutes). >>>> >>>> Zope is unresponsive until the lock is released. >>>> >>>> Is it possible to prevent these client locks from the >>>server? or to force >>>> read-only in Excel? >>>> The user is anonymous. >>> >>>If the user is Anonymous, they shouldn't even be actually >>>getting locks, as >>>they're protected by the "WebDAV Lock items" permission. >>>This permission >>>protects the webdav.Resource.LOCK() method itself, so the >>>client should be >>>getting an unauthorized exception on the LOCK command >>>(unless you've granted >>>the permission to Anonymous users). >>> >>>I set up a situation in GoLive 5 where the user had access to every >>>permission *except* "WebDAV Lock items" and "WebDAV Unlock >>>items". When I >>>opened documents to edit, it would warn me about being >>>unauthorized to lock >>>items, but open the document anyways. While the document >>>was open, Zope was >>>still responsive. Even after I granted access to Locks, >>>Zope was still >>>responsive while the Lock was in place. >>> >>>There seem to be some issues with IE 5.5 and >>>"Content-Disposition" or some >>>other header or setting that seems to cause it not to close >>>connections >>>properly on certain requests. >>> >>>> [27/Feb/2001:21:31:57 -0500] "LOCK >>>/IOTA/report_ordersmtd?format=xls >>>> HTTP/1.1" 200 817 "" "Microsoft Data Access Internet >>>Publishing Provider >>>> DAV" >>>> [27/Feb/2001:21:32:21 -0500] "GET /IOTA/report_ordersmtd?format=xls >>>> HTTP/1.1" 200 71207 "" "Microsoft Data Access Internet >>>Publishing Provider >>>> DAV" >>>> [27/Feb/2001:21:32:21 -0500] "UNLOCK >>>/IOTA/report_ordersmtd?format=xls >>>> HTTP/1.1" 204 240 "" "Microsoft Data Access Internet >>>Publishing Provider >>>> DAV" >>> >>>Jeffrey P Shell, jeffrey(a)Digicool.com >>>http://www.digicool.com/ | http://www.zope.org >>> >>>

1 0

Re: [Zope] ZMySQLDa and Win32
by David Parker 04 Mar '01

04 Mar '01

Hey Robert, I managed to get it all going yesterday evening. It turns out it is not too difficult doing it this way (figuring it out was the hard part) (assumes Zope 2.3 and MySQL 3.23.33 are currently installed on Windows 2000): 1) Install Python 1.5.2 but use the bin directory in your Zope base directory as the destination path. (Where python.exe resides). This essentially adds the python components that are needed by Distutils that are not distributed as part of Zope 2.3. 2) Install ZMySQLDA-2.0.4 using standard Zope product install procedure. 3) Install Python Distutils (Distutils-1.0.1.win32.exe) http://www.python.org/sigs/distutils-sig/download.html . (Launch the Distutils exe rather than extractng 1st.) This is required for step 4. This is also why I did step 1, to allow Distutils to install properly. 4) Install MySQLdb 0.3.3 using the Windows Installer package at http://highqualdev.com/ (link from page http://dustman.net/andy/python/MySQLdb) 5) From a Python cmdline type "import _mysql". 6) Restart Zope. So far everything sems to work very well. Much faster and secure than using Access as a backend database. (MS SQL Server not an option due to price constraints). Thanks, David ----- Original Message ----- From: Robert Rottermann To: David Parker Sent: Sunday, March 04, 2001 12:02 AM Subject: Re: [Zope] ZMySQLDa and Win32 Hi David, I did install mysql for zope on an nt 2000 box. It's a coupple of weeks ago and I did not keep any notes so what I tell you is wat my stak overflow riddlel brain remembers.

1 0

Using Python Script as module?
by Janko Hauser 04 Mar '01

04 Mar '01

Hello, I try to define some helper functions inside of a `Python Script` (PS). Simplified example: # def fa(): print 'fa executed' def fb(): fa() fb() return printed # This does not work, as the PS itself is apparently not a module level namespace. I can call fa() directly, although. Is there some way to call a function defined in the PS inside another function? Is there something like the PS namespace? TIA, __Janko

2 2

dd
by Patrick Miller 04 Mar '01

04 Mar '01

how do I tell zope which python to use. and add the zmysqlda to it? mysql module wanted something newer than 1.5 -- as currently setup 1.5 is in the zope seen at the bottom -- I added python 2.x to the system from the TAR ball, and made sure the mysql module was upto date (as seen in the top half below). MySQL-python-0.3.3# python setup.py install running install running build running build_py not copying MySQLdb.py (output up-to-date) not copying CompatMysqldb.py (output up-to-date) running build_ext skipping '_mysql' extension (up-to-date) running install_lib copying build/lib.linux-i486-2.0/MySQLdb.py -> /usr/local/lib/python2.0/site-packages copying build/lib.linux-i486-2.0/CompatMysqldb.py -> /usr/local/lib/python2.0/site-packages copying build/lib.linux-i486-2.0/_mysql.so -> /usr/local/lib/python2.0/site-packages byte-compiling /usr/local/lib/python2.0/site-packages/MySQLdb.py to MySQLdb.pyc byte-compiling /usr/local/lib/python2.0/site-packages/CompatMysqldb.py to CompatMysqldb.pyc tas:/tmp/MySQL-python-0.3.3# cd /usr/local/zope/2.3.0/ tas:/usr/local/zope/2.3.0# ls Extensions README.txt ZServer bin import install install.txt~ pcgi stop var z2.pyc zpasswd.pyc LICENSE.txt ZMySQLDA-2.0.4.tar Zope.cgi doc inst install.txt lib start utilities z2.py zpasswd.py tas:/usr/local/zope/2.3.0# ./stop [1]- Terminated ./start tas:/usr/local/zope/2.3.0# ./start & [3] 9932 tas:/usr/local/zope/2.3.0# ------ 2001-03-04T12:16:12 ERROR(200) Zope Couldn't import Products.ZMySQLDA Traceback (innermost last): File /usr/local/zope/2.3.0/lib/python/OFS/Application.py, line 530, in import_products (Object: string) File /usr/local/zope/2.3.0/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/zope/2.3.0/lib/python/Products/ZMySQLDA/DA.py, line 91, in ? File /usr/local/zope/2.3.0/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql

1 0

��ϴ� �� "�ݿ��"�� ϼ��!!(��)
by �� 04 Mar '01

04 Mar '01

1 0

ZMySQLDa and Win32
by David Parker 03 Mar '01

03 Mar '01

I'm attempting to use MySQL with Zope on Windows 2000. Here is a summary of products used. Zope 2.3 MySQL 3.23.33 ZMySQLDA-2.0.4 MySQL-python-0.3.3 I followed the howto laid out at http://www.zope.org/Members/philh/mysql . (I cannot find the file libmySQL.dll). After all is said and done ZMySQLDa is installed as a broken product. Below is a Traceback. Has anyone gotten this to work or know of a more current howto? Traceback (innermost last): File "C:\Zope\DavWeb\lib\python\OFS\Application.py", line 530, in import_products product=__import__(pname, global_dict, global_dict, silly) File "C:\Zope\DavWeb\lib\python\Products\ZMySQLDA\__init__.py", line 91, in ? import DA File "C:\Zope\DavWeb\lib\python\Products\ZMySQLDA\DA.py", line 91, in ? from db import DB File "C:\Zope\DavWeb\lib\python\Products\ZMySQLDA\db.py", line 89, in ? import _mysql ImportError: No module named _mysql Thanks, David

1 0

Re: [Zope] SiteAccess, Set Access Rule, Proxy, ReWrite or Virtual Host Monster
by Dieter Maurer 03 Mar '01

03 Mar '01

Peter Bengtsson writes: > There seems to be many ways to connect a domain name to a folder in Zope > without :8080 in the URL. > All I care about is being able to have access to REMOTE_ADDR in my > application and the hiding of "ugly URLs". > > I've got a structure like this: > /app/members/ > /member1 > /member2 > > Both member1 and member2 deserve a SiteAccess object there. > If I use Apache:80 to ProxyPass to 127.0.0.1:8080/app/members/member1 > Everything looks nice and as it should, but I loose the very important > REMOTE_ADDR Someone from NIP wrote a HowTo (how to patch Apache such that it forwards the information). Search zope.org (or the mailing list archive). Dieter

1 0

Re: [Zope] Deleting objectreferences
by Dieter Maurer 03 Mar '01

03 Mar '01

Torsten Gallmeister writes: > After /Control_Panel/manage_debug I have many thousend objectreferences > to instances of this object. Apparently, your instances contain a cyclic reference. Python before version 2.0 can not collect cyclic garbage. Look on http://www.python.org for tools to detect cycles. If you can not think any there, look in the archive of comp.lang.python. Dieter

1 0

Problem with manage_ChangeProperties
by Gregg Hartling 03 Mar '01

03 Mar '01

Hopefully this is one of those dumb newbie questions that someone will be able to answer quite easily: I'm in Zope 2.3.0, and using a Python script to try to change a property of a DTML document, using a call like this: doc.manage_changeProperties({"foo":bar}) # doc, "foo" and bar are just examples I receive the following error: Error Type: KeyError Error Value: manage_page_header I get the same error trying to do a dtml-call to the method within the document. However, I'm able to execute manage_addProperty() successfully in both situations. Am I missing something? Big thanks to anyone who can point me in the right direction. I'm just starting up the learning curve here. :-) Gregg. -- Gregg Hartling hartling(a)earthlink.net

1 0