- Zope - Zope lists

Date Problem of ODBC DA
by T. C. Huang 02 Jun '99

02 Jun '99

Hi, I access the data in Oracle 7.3(AIX server) through ODBC DA on NT platform. Things work well unitl the table has column with DATE type. When my SQL method is "select start_date from project_table", and test it in Zope 1.10.2, I get only "Sorry, an error occurred.". Is it a problem of Zope or ODBC DA? How to fix it? T. C. Huang

2 1

Article in Computing Canada
by Rob Page 02 Jun '99

02 Jun '99

A special thanks to community-member Jordan Baker from Spyderlab (http://www.spyderlab.com) who was recently interviewed by Computing Canada for an article on Open Source Software. Turns out that Computing Canada followed his suggestion to call Digital Creations to get it straight from the horse's, erm, mouth! :^) Jordan was also kind enough to provide a link the newly avaiilable article: http://www.plesman.com/cc/news/cc252127a.html Thanks again, Jordan! --Rob -- Rob Page Phone: +1 540 371 6909 Digital Creations Fax: +1 540 371 1201

1 0

Running ZopeHTTPServer and PCGI together = a bad thing?
by Tony McDonald 02 Jun '99

02 Jun '99

Hi, I'm running a ZopeServer on port 9673 of a machine and have set up a virtual host using the Apache redirect rules to start up the PCGI process when someone enters the site via the virtual host route. My problem is that the information shown to the user is *different*, depending on what route they choose. If I look at the database information for the PCGI Zope I get Database Size :: 11.3M Database Location :: /home/nnle/zope/Zope-1.10.2-solaris-2.5.1-sparc/var/Data.bbb You are running Zope version: Zope 1.10.2 (binary release, python 1.5.1, solaris-2.5.1-sparc), on Python 1.5.1 (#1, Feb 16 1999, 18:37:21) [GCC 2.7.2] on sunos5. Zope has been running (with a process ID of 24082) for 19 days 15 hours 49 min16 sec. (on this server I can only 'undo' two or three transactions) The same data for the port :9673 Zope is Database Size :: 11.3M Database Location :: /home/nnle/zope/Zope-1.10.2-solaris-2.5.1-sparc/var/Data.bbb You are running Zope version: Zope 1.10.2 (binary release, python 1.5.1, solaris-2.5.1-sparc), on Python 1.5.1 (#1, Feb 16 1999, 18:37:21) [GCC 2.7.2] on sunos5. Zope has been running (with a process ID of 3895) for 22 days 43 min 40 sec. (on this server I can 'undo' literally hundreds of transactions). In addition, the Zope server is much faster than the PCGI. I have been working on the 9673 server for a long time, and usually start up the PCGI to demo the site without using port numbers. Eventually however, I must get rid of port numbers and (presumably) use the PCGI method. I'm really concerned that there is the discrepancy in the server and would like to get it sorted out. Does anyone have *any* clues as to what is happening? cheers tone. ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2

1 0

RE: Trouble with Zope 2.0.0a1
by webman 02 Jun '99

02 Jun '99

hallo christopher, i wouldn't recommend using Zope 2.0.0a1 other than for experimental purposes. it is definitely alpha code. use zope 10.2 or higher but stay away from the 2.0 alpha or future beta releases if you want to have a stable zope platform to work with. regards, webman --------------------------------------------------------------------------- webman | _ beehive GmbH | ASCII ribbon campaign ( ) berlin, Germany | - against HTML email X http://www.beehive.de | & vcards / \

1 0

cookies
by Graham Chiu 02 Jun '99

02 Jun '99

I presume that there are in built functions for handling cookies etc, but I can't find the documentation. Anyone have a very simple example? Thanks, ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz

2 2

RE: [Zope] Zope on Mac OS X Server
by Jeffrey Shell 02 Jun '99

02 Jun '99

It seems I had to do something with ZServer too (something about FCNTL not happening properly), but after I made my modification (which is still locked away on an unaccesible UFS volume at the moment), Zope was bloody fast on my 233/G3. :)

2 1

Re: [Zope-dev] Re: external product writing to a file system ?
by rossl＠med.usyd.edu.au 02 Jun '99

02 Jun '99

One of us is probably really missing something here. I also have no trouble taking files from the file system and stuffing them into zope as dtml from external methods. The problem I'm wrestling with is the opposite - I can grab zope dtml objects in external methods, but I can't figure out how to call some mythical function render(foo) the way zope does - converting all the zope bits (such as ) into the same html that the zope ORB would. Any advice appreciated... <928251944.57469-(a)fezzik.endicor.com> wrote: Original Article: http://www.egroups.com/group/zope/?start=5647 > This is almost trivial to implement. My filesystemed database app > looks for *.dtml files as it's walking the fs and loads them as > dtml methods of the SubDir (folderish) object in which they reside. > You can use DTMLMethod.add() or handle it directly with the DTMLMethod > class. Just send the file contents as the "file=" argument. > Acquisition works just like with zope dtml methods, though you may > well need to futz with the object __roles__ when you add it. You > also would need to add an 'update' method for the dtml file, which > I haven't gotten around to yet. I just restart the server right > now if I need to edit one. :^) > > Since you can read the dtml source in before creating the method, > you have the opportunity to handle any potential metadata that you > may want to store in the dtml source... > > Kent > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://www.zope.org/mailman/listinfo/zope-dev > > (For non-developer, user-level issues, use the companion list, > zope(a)zope.org, http://www.zope.org/mailman/listinfo/zope )

1 0

trouble with Zope 2.0.0a1, manage_addZGadflyMethod
by Christopher Lange 02 Jun '99

02 Jun '99

Hi, I am new to Zope and can´t get a database connection up and running. I downloaded Zope 2.0.0a1 and starting it using /home/chl/Python-1.5.2/bin/python z2.py -2 -d 192.168.10.1. its running fine on my Linux system (2.2.5 kernel, SuSE 6.1). When trying parts of your HowTo http://www.zope.org/Documentation/HowTo/SampleGadfly I always get an error when running    in the last line: Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: manage_addZGadflyMethod --------------------- When I try to create a ZSQL-Method, for example create table zopista (col_a integer, col_b integer) I get, when adding, testing and submitting the error: Zope Error Zope has encountered an error while publishing this resource. exceptions.AttributeError Sorry, a Zope error occurred. ---------------------- whats wrong? Where can I get working database demos? In detail, how can I create a table to play with? Chris

1 0

RE: [Zope] Object creation time
by Jay, Dylan 02 Jun '99

02 Jun '99

> -----Original Message----- > From: Alex Rice [mailto:alrice@swcp.com] > Sent: Wednesday, June 02, 1999 10:19 > To: djay(a)lucent.com > Cc: jim(a)digicool.com; zope(a)zope.org > Subject: Re: [Zope] Object creation time > > > > On Wed, 2 Jun 1999 09:09:07 +1000, > "Jay, Dylan" <djay(a)lucent.com> said: > > Jay> yes. I think anything an os fs does is at least a minimum for > Jay> bobopos. > > Depending what OS you mean, that would be overkill ( user/group > permissions, suid bit, symlinks, journaling, etc. ) :-) Zope has user/group permissions, suid bit. People have experimented with symlinks and I for one would like to see them there as well. Not sure what journaling is. You also miss locking and ownership which I believe is in Zope 2.0. > Maybe a filesystem isn't the right metaphor? I agree that having a > creation time stamp would be nice in some cases. > > Alex Rice | alrice(a)swcp.com | http://www.swcp.com/~alrice > Current Location: N. Rio Grande Bioregion, Southwestern USA >

2 1

MySQL & lost server connections
by John Eikenberry 01 Jun '99

01 Jun '99

I seem to remember this being asked before, but I couldn't find anything in the archives... :P Basically, it looks like I'm losing my connection from Zope to the MySQL database. While the site remains busy, it stays connected, but if there's a long dead period the connection goes away. Both Zope and MySQL are running on the same BSDI 3.1 machine. Its Zope-1.10.2 and MySQL-3.21.33b. Is there anything I can do to fix this? Here's the traceback and error: ------------------------------------------------------------------ Error type: Error value: Lost connection to MySQL server during query Traceback (innermost last): File /usr/local/lib/Zope-1.10.2/lib/python/ZPublisher/Publish.py, line 877, in publish_module File /usr/local/lib/Zope-1.10.2/lib/python/ZPublisher/Publish.py, line 590, in publish (Info: /members/index2) File /usr/local/lib/Zope-1.10.2/lib/python/OFS/DTMLMethod.py, line 155, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/OFS/DTMLMethod.py, line 151, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_String.py, line 513, in __call__ (Object: index2) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_With.py, line 138, in render (Object: db) File /usr/local/lib/Zope-1.10.2/lib/python/DocumentTemplate/DT_In.py, line 617, in renderwob (Object: userid) File /usr/local/lib/Zope-1.10.2/lib/python/Shared/DC/ZRDB/DA.py, line 390, in __call__ (Object: CopySource) File /usr/local/lib/Zope-1.10.2/lib/python/Products/ZMySQLDA/db.py, line 171, in query error: (see above) --- John Eikenberry [jae(a)kavi.com - http://taos.kavi.com/~jae/] ______________________________________________________________ "A society that will trade a little liberty for a little order will deserve neither and lose both." --B. Franklin

3 2