- Zope - Zope lists

Problem with ZODBCDA
by Matthew Wilbert 16 Mar '00

16 Mar '00

I just installed ZODBCDA on a new Windows install of Zope 2.1.4 using ZServer running as an NT service. After editing db.py to fix the THUNK typo (I've submitted that to the collector) it sees the System ODBC DSNs that exist, and it lets me pick one. But when I try to open the connection, it tells me I have an invalid connect string. The weird thing is that I turned on Windows ODBC tracing, and NOTHING is being logged from the Zope connection. So I don't think it is actually passing anything to ODBC. If I do the same thing from some other ODBC client, the connect string works and the session gets logged by the ODBS tracer. There was a very similar problem in the list archives several months ago, and it seemed that running the service as a user, instead of the system, fixed the problem. Didn't work for me. Any suggestions on how to track this down further, or better yet to fix it, would be appreciated. Matt Wilbert mwilbert(a)alum.mit.edu ______________________________________________________________________ Get Visto.com! Private groups, event calendars, email, and much more. Visto.com. Life on the Dot. Check it out @ http://www.visto.com/info

1 0

ZDiscussions
by Pearson, Brian Edward (GEA, 056278) 16 Mar '00

16 Mar '00

All, Have been trying to add File Attachment functionality to the ZDiscussions Product. Thus far, I have modded the ZDiscussions.py file, specifically the ZDItem class's __init__ method, to accept one extra parameter called file. The corresponding DTML-Method (postForm) within the ZDiscussion object has been modded to include a FILE input field. To facilitate the file handling, I am using the Squishfile.py module. All is working well, and via a new def attachment(self) method that was added to the ZDiscussion.py module, I am able to return the file to the browser. Herein lies the problem. How can I reference the file via an HREF? With the following DTML: <dtml-if attachment> <b>Hello there</B> <tr><th bgcolor="#d0d0f0" align=left>Attachment:</th><td> <dtml-in attachment> <A HREF="./<dtml-var file_name url_quote>"> <IMG SRC="<dtml-var SCRIPT_NAME >/<dtml-var icon >" HEIGHT=16 WIDTH=16 BORDER="0" ALT="Click to download attachment"></A> <A HREF="./<dtml-var file_name url_quote>"> <dtml-var file_name></A> <dtml-var file_kbytes>KB (<dtml-var file_bytes> bytes)<BR> </dtml-in attachment></td> </dtml-if> This of course references the file object as absolute_url/ZDItem_id/file_name. This same reference url is used in the Squishdot product when displaying a link the user may click on to download the file. However, in my implementation it is not referencing the file. The only way to reference the file is to use <dtml-var attachment>, which means that the file will be streamed to the user as soon as they click on the message thread, obviously not the way I would like to handle the situation. Do I need to include the file object as a property of the message? I thought by including the file object during the creation (__init__) method of ZDItem this would be handled. Any/all assistance would be greatly appreciated. Also, if I am crazy for doing this please let me know. Perhaps a new ZDiscussion already exists that supports attachments? Thanks again, -Brian

1 0

Getting Zope to dump core...
by Michel Pelletier 16 Mar '00

16 Mar '00

Jon Prettyman wrote: > > Well, I'm having no luck getting a core file from my Zope on this > production linux box. I'm still getting the Aiieeee! But can't get a > core for the life of me. > > Have you guys been able to reproduce anything similar? I'm able to get Zope to dump a core file if run in debug mode ('-D'). I haven't proved this, but I suspect that when a fork()ed child dies it does not dump a core file. Since debug mode does not cause Zope to fork off Zope as a child from the parent watchdog, a core file is produced. None of this is mentioned on the fork() man page, or the clone() man page, or whatever. I probably need a good UNIX programming reference to verify it. Give it a try, fire up Zope in debug mode and run your load scripts against it to reproduce your segfault. -Michel

1 0

Subclassing ZObjectManager in ZClasses
by Alexandre Ratti 16 Mar '00

16 Mar '00

Hello, I've been playing with ZClasses and I ran into an issue with ZObjectManager. Summary: (when creating a folderish ZClass and cascading base classes) if ZObjectManager isn't subclassed at 1st level, objects can be added to the folderish ZClass instances but they don't show in the manage_main object list. [Zope 2.1.4 on Win32, pure ZClasses, no Python around] More details: 1) I first tried this simple setup. It worked fine:

1 0

InterScan eManager Content Management Notification! (Sexual Discrimination)
by viruswall＠bam.com 16 Mar '00

16 Mar '00

******Message from InterScan E-Mail VirusWall NT****** The following mail was blocked by InterScan eManager Content Management. Source mailbox: <zope(a)zope.org> Destination mailbox(es): <zope(a)zope.org> Policy: Sexual Discrimination Action: Quarantine Recipient, Content filter has detected a sensitive e-mail. ******************* End of message ******************* Received: from www2 (localhost [127.0.0.1]) by zope.codeit.com (8.9.2/8.8.7) with ESMTP id KAA26958; Thu, 16 Mar 2000 10:39:39 -0800 (PST) Date: Thu, 16 Mar 2000 10:39:39 -0800 (PST) Message-Id: <200003161839.KAA26958(a)zope.codeit.com> From: zope-admin(a)zope.org Subject: Zope digest, Vol 1 #685 - 60 msgs Reply-to: zope(a)zope.org X-mailer: Mailman v1.0b8 Mime-version: 1.0 Content-type: multipart/mixed; boundary="209.67.167.110.8.26936.953231977.598.12607" To: zope(a)zope.org Sender: zope-admin(a)zope.org Errors-To: zope-admin(a)zope.org X-Mailman-Version: 1.0b8 Precedence: bulk List-Id: Users of the Z Object Publishing Environment <zope.zope.org> X-BeenThere: zope(a)zope.org

1 0

XML-RPC Woes
by Kapil V. Thangavelu 16 Mar '00

16 Mar '00

Hi i've spent the day trying to make this work so i thought i'd see if brighter minds could illuminate the darkness of my night. I'm trying to setup an email archiving system in Zope. I've got the email retrieval setup in an separate python script and a couple of ZClasses setup in Zope to archive/catalog the emails. My problem is getting the parsed email info(to, from, body, etc) from the external script into my Zclasses. i've tried xml-rpc but i keep getting server errors. i connect to the server and try zope.project.archive.addEmail(id) but i keep getting a 500 Internal server error message. addEmail is just a wrapper around the constructor which expects only one parameter the id of the email Zclass object to create( just something to debug before i pass in all the params). So what gives? i can call the method from the web with http://localhost/project/archive/addEmail?id=xx but how do you call a dtml method with args from xml-rpc. fyi i'm using amos's patched xmlrpclib for authentication (i fixed the import errors) i've trying to reimplement this as a xmlrpc call to an external method but i would really like to know how to do it with xml-rpc and dtml. Thanks Kapil

1 1

Re: [Zope] GUF: Generic User Folder
by Hung Jung Lu 16 Mar '00

16 Mar '00

OK, I went to the website http://cvs.zope.org/cgi-bin/cvsweb.cgi/ZopePTK/PTKDemo/DemoPortal.zexp and downloaded DemoPortal.zexp, but it does not work on my Zope 2.1.4. Do I need the latest version of Zope in CVS? The error message is: Error Type: ImportError Error Value: No module named PTKDemo regards, Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

3 2

ZClasses and scope...
by jiva＠devware.com 16 Mar '00

16 Mar '00

Okay, I *think* I am beginning to grok zclasses, but I have a couple of questions: What is the scope/namespace of a ZClass' methods? In my tests, I cannot access other methods of the same ZClass. I *can* access methods in parent folders of my ZClass, but not the current folder. Ie: Create ZClass called zcTest. Create two methods in this ZClass, called index_html and test. Neither can see the other. Secondly, when I try to access anything off of instances of my zclass except for property sheets, I get access denied. Where do I set up the permissions to allow my methods to be viewable? -- "There was no difference between the behavior of a god and the operations of pure chance..." -- Thomas Pynchon, _Gravity's Rainbow_

1 0

Re: [Zope] How does one refer to the root folder?
by Andres Corrada-Emmanuel 16 Mar '00

16 Mar '00

Hi Zopistas, Thank you for the answers. My problem arose because I was passing a DTML Method a list of strings: [ 'PARENTS[-1]', 'FolderA', ...]. And while I could do: <dtml-with "_( folderObject=_.getitem('FolderA'))"> I could not do the same with 'PARENTS[-1]'. The simple solution suggested by your answers is to just pass the objects themselves (duh!): [ PARENTS[-1], FolderA, ...]. But out of curiosity I'm still wondering if there is a way to refer to the root folder by name so one could write _.getitem( 'rootFolderName' ) Andres Corrada

1 0

Re: [Zope] A Suitable RDBMS?
by Hung Jung Lu 16 Mar '00

16 Mar '00

bill anderson <bil-(a)libc.org> wrote: original article:http://www.egroups.com/group/zope/?start=26253 >Hung Jung Lu wrote: > > My experience with SyBase is that the adapter development is > > kind of slow, and only Linux platform is supported. And > > currently it has some glitches with some data types (decimal > > with 10 or more digits), it does not support stored procedures, > > and the implementation in Zope 2.1.4 crashes when you have > > date fields ending between 59 and 60 seconds (e.g: 59.23 sec). > > Also, when there is database problem, the adapter very often > > just hangs and lock the database out, requiring a Zope reboot. > >Can you provide more specific detials? I am running two seperate systems >with Sybase, one of which is pounded on pretty hard, with zero problems. Sure, you just need to trace my previous postings. :) SyBase adapter has two specific problems that I have ran into. They are both 100% reproduceable and both have been reported to the Collector. One of them is now fixed for Zope 2.1.5 (the _validTime thing.) The other one still sits still waiting for Digicool to fix it. If I say the development of the adapter has been slow, it's because it's been slow. If I alone have been able to find (and fix) two problems and one limitation, somehow I don't think they are the only problems and limitation. :) Some of the bugs are later found independently by other people, too. (See below.) Many people also say that they have zero problems with Microsoft Windows. I guess they just have been lucky. Ha ha. But just because one person is lucky, it doesn't mean the rest of the world is equally lucky. :) Let me teach you how to para-phrase your question: "Can you provide more specific details? I am running two separate system with Sybase, and I would like to know more about these problems." Very nice. The following are three articles in chronological order. regards, Hung Jung ============================================================================== "hung jung lu" <hungjungl-(a)hotmail.com> wrote: original article:http://www.egroups.com/group/zope/?start=22495 > >From: Christopher Petrilli <petrilli(a)digicool.com> > > > >Can you please specify what the exact behaviour problem IS? We treat any > >NUMBER data type with DECIMAL(10,0) or greater as a python long because >it > >can not be represented accurately in a 32-bit integer. The option (as >was > >treated before) is to return a float, but this is losing accuracy. > >---------------------------------------------------------------- > >:) Sure enough, the DECIMAL data type problem persists in >SybaseDA-2.0b2. > >---------------------------------------------------------------- > >:) I nagged quite a bit in the zope mailing list about the >SybaseDA DECIMAL data type problem, even posted a patch for it. >Chris McDonough was kind enough to send everything to the >Collector, too. The relevant threads can be views at >Egroups.com under > >http://www.egroups.com/group/zope/showthread.html?start=21025 >http://www.egroups.com/group/zope/showthread.html?start=21108 > >---------------------------------------------------------------- > >It is very easy to cause the crash. Install your SybaseDAv2, >restart Zope, create (add) an instance of "Sybase DataBase >Connection", click on it, make sure that is it connected. >Now, go to the "Test" tab, issue the SQL command: > > create table test (id decimal(10)) > >Hit "Submit Query". Good. The table is created. Now, go >to the "Test" tab again, issue the SQL command: > > select * from test > >Voila, crash. > > Error Type: sy_occ.error > Error Value: Invalid buffer element type > ... > File /usr/local/bs_zope/lib/python/Products/SybaseDAv2/db.py, line >239, in query > sy_occ.error: (see above) > >The error does not happen when you have 9 or fewer digits >in your DECIMAL data type declaration. > ============================================================================== "hung jung lu" <hungjungl-(a)hotmail.com> wrote: original article:http://www.egroups.com/group/zope/?start=22504 >Hi, > >There is a bug in \lib\DateTime\DateTime.py, this particularly concerns >Sybase database users. In the lines: > > def _validTime(self,h,m,s): > return h>=0 and h<=23 and m>=0 and m<=59 and s>=0 and s<=59 > >Please change s<=59 to s<60. > >This bug is causing Sybase to crash whenever a table contains a date value >with s>59, e.g: s=59.23 > >regards, > >Hung Jung >(I have submitted to the Zope bug collector) > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://lists.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > ============================================================================== brian takashi hooper <bria-(a)garage.co.jp> wrote: original article:http://www.egroups.com/group/zope/?start=23843 >Hi there - > >(I've taken the liberty of also submitting these bugs to the Collector...) > >I think I found a bug with ZSybaseDA (the newest version) - here's the >deal: > >I have a table in Sybase with a DateTime field. >When I get a time back from it, the value of the field gets set in >sy_occbf.c to something like: > >(2000, 2, 21, 22, 31, 59.63) > >The second value is being set to double (on purpose, looking at the >sy_occbf.c code). > >The problem with this is that DateTime doesn't correctly validate >floating point hour/min/seconds. The documentation string seems to say >that DateTime can take (from the DateTime 1.43 doc string) > >"floating point, positive or negative offsets in units of hours, minutes, >and days," > >for the fourth, fifth and sixth arguments - should this instead be > >"positive integer values for hours, minutes, and positive floating point >values for seconds"? > >I think the latter might be simpler and easier to understand... >Anyways, right now what DateTime is closer to this anyway - it validates >times by calling self._validTime(h, m, s), which is defined: > > def _validTime(self,h,m,s): > return h>=0 and h<=23 and m>=0 and m<=59 and s>=0 and s<=59 > >I was lucky enough to stumble on the case where 59 < s < 60; this could >be taken care of by: > > def _validTime(self,h,m,s): > return h>=0 and h<=23 and m>=0 and m<=59 and s>=0 and s<60.0 > >Of course, it's obvious that negative hour or minute offsets are also >not going to work... > >The Sybase DA end of the thing - as I started out by saying, I noticed >all this because the results that Sybase returned didn't convert >correctly. Specifically, an exception was raised where SybaseDA was in >the middle of handling a fetched result set: > >(in db.py, DA.query()...) > >if type(v) is TupleType: > v=apply(converters[t], v) > >Because an exception is raised in the middle of fetching a result set, >the command structure still has results left to fetch - this makes the >next call to cm.ct_command() fail - Sybase says, on the next query: > >ct_command(): user api layer: external error: This routine cannot >be called while results are pending for a command that has been sent to >the server. > >Which happens because we never got to cancel the previous result set. > >How about running the conversions in a try/except, for safety, like: > >try: > if type(v) is TupleType: > v=apply(converters[t], v) >except: > cm.ct_cancel(sy_occ.CS_CANCEL_ALL) > raise Error("Results field conversion error: converter=%s, v=%s" % \ > (str(converters[t]), str(v))) > >I don't think there is anything else, but anything that might throw an >exception in the error processing loop should also probably be wrapped >to call ct_cancel so that the command structure is ready to go on the >next call. > >Well, that's all. This'll be in the Collector as soon as I can write it, >too. > >-Brian Hooper > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://lists.zope.org/mailman/listinfo/zope >** No cross posts or HTML encoding! ** >(Related lists - http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0