- Zope - Zope lists

Re: [Zope] Promplems with TinyTablePlus
by Dieter Maurer 04 Mar '01

04 Mar '01

Bodo Bauer writes: > I try to use TiniyTablePlus in my product, however I can't create a TinyTable > as subobject in any of my classes. Whenever I try to create an instance of > a TinyTablePlus, either from a DTML method, or manually in the manage screens, > the created table ends up being in the first folder (counting from innermost > upwards) that is not an instance from a Zclass I created, but a regular folder. > > All my Zclasses are derived from ZObjectManager, so it should work, right? Apparently not. It seems, you are using "manage_addTinyTable". Your Z instances lack such a method. Thus, acquisition jumps in and you get the method of the folder above. This method, of course, adds in the folder not in you Z instance. You can try "manage_addProduct['TinyTable'].... (you must replace the last three periods with the constructor name). Dieter

2 2

Using "external" components such as MySQL (was: [Zope] dd)
by Dieter Maurer 04 Mar '01

04 Mar '01

Patrick Miller writes: > how do I tell zope which python to use. and add the zmysqlda to it? The script "start" controls which Python is used. The environment variable "PYTHONHOME" (defined in "start") controls where the Python infrastructure is searched for. You can use the environment variable "PYTHONPATH" to let Python look at additional places for modules and packages. PYTHONPATH is a colon separated list of directories. Alternatively, you can make appropriate symbolic links to the external components (usually in "<zope_dir>/lib/python". Dieter

1 0

Re: [Zope] Problem with manage_ChangeProperties
by Dieter Maurer 04 Mar '01

04 Mar '01

Gregg Hartling writes: > 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 This is a weakness in "manage_changeProperties". Put it into the Collector: after "manage_changeProperties" almost completely did its work, it wants to return "manage_propertiedForm". This objects wants to use "manage_page_header". However, apparently, this object is not accessible via your "doc". As a workaround, you have two options: 1. pass the properties as keyword arguments: doc.manage_changeProperties(foo=bar) 2. catch ("dtml-try ... dtml-except") the exception and ignore it. Dieter

1 0

MySQL, ZMYSQLDA and date fields
by Salvatore Sciacco 04 Mar '01

04 Mar '01

Hello, I've a MySQL table with some datetime fields (not null). By default MYSQL put '0000-00-00 00:00:00' (a zero date) in these field. When this happen I can't select these fields anymore because Zope raise an invalid date format exception. Do you know a workaround for this problem? Thank you. -- Best regards, Salvatore Sciacco mailto:sas@prometeus.net

2 2

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