- Zope - Zope lists

RE: [Zope] MSAccess
by Schmidt, Allen J. 02 Jul '01

02 Jul '01

...and still.... I have been trying to find a way (should work, but doesn't) to have an Access on one Windows2000 server and access it with Zope on another server. Lost of suggestions ... nothing works. Waiting patiently in the wings... Allen -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Monday, July 02, 2001 12:08 PM To: Loren Stafford Cc: Montagne, Michael; zope(a)zope.org Subject: Re: [Zope] MSAccess Loren Stafford wrote: > > While I've read on this mailing list that there are some Linux ODBC drivers, > I have no experience with them. What I do is run a Zope installation on one > of the Windows machines, which can access the MSAccess DB with the Windows > ODBC. Then the Linux Zope gets the data from the Windows Zope using some > form of RPC, such as Client.py > (http://www.zope.org/Members/lstaffor/ZClientMethod) or XML-RPC (which I > have not tried). We need something similar, so we're going with a ZEO setup with the storage server and the web-serving client on a Linux box and another ZEO client running on a Windoze box doing what it needs to... cheers, Chris _______________________________________________ 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 )

2 1

Testing the performance of SQL Methods
by Peter Bengtsson 02 Jul '01

02 Jul '01

I want to find the perfect caching settings on our Z SQL Methods in the Advanced tab, and to do this I have prepared a little script that loops through a bunch different setting combinations and calls different little methods that does the processing. Let's not worry about the settings or the data analysis for the moment. What I want is a stupid little function that uses a SQL method and is very process heavy and should use the internal caching. So far I have tested a few different little functions: - One that reads lines from a file, checks if the line exists, adds the line. (about 10 000 selects and about 10 000 insert statements) - One that reads 5 lines from a file, check if one of them, adds the new of the five. More or less like the above but it waits a little bit - One that selects all records from a table 10 times per setting (10*5000 records selected per setting) None of these methods have produced any useful results, except from one: No correlation. The only deviations I see in process performance is depending on the activity of my Windows 2000. If Outlook decides to go and check for new mail, the particular test during that time takes a few milliseconds longer. Say something that I can code that will surely use the internal caching of Z SQL Methods. Is there a way of safely prove that Z SQL Method result caching is actually being done. Not a mathematician, yet Peter

2 1

debugging help needed
by Irene Barg 02 Jul '01

02 Jul '01

Hello all, I'm trying to parse input from a form to convert all string input to upper-case, before passing it on to a SQL method. So I created a DTML method to do this. In this 2nd DTML method, I call a ZSQL method to obtain the table's column names, then use the column names to access the corresponding values in the REQUEST. I must not be implementing indirect variable lookup correctly, because the script below produces the following error. How do I debug this? Thanks. Zope Error Zope has encountered an error while publishing this resource. Error Type: TypeError Error Value: read-only character buffer, instance My DTML method looks like this: <dtml-var standard_html_header> <dtml-comment> Loop over fieldnames in the family table, to lookup corresponding values in the REQUEST, then convert all lower-case values to upper-case. </dtml-comment> Before: firstmiddle=<dtml-var firstmiddle> <dtml-with get_one_family> <dtml-in names> <dtml-call "REQUEST.set(_['sequence-item'],_.string.upper(REQUEST[_['sequence-item']]))"> </dtml-in> </dtml-with> After: firstmiddle=<dtml-var firstmiddle> <dtml-comment><dtml-call update_family></dtml-comment> <dtml-var standard_html_footer> #####end#### -- irene barg ---------------------------------------------------------------- Irene Barg Email: ibarg(a)as.arizona.edu Steward Observatory Phone: 520-621-2602 933 N. Cherry Ave. University of Arizona FAX: 520-621-1891 Tucson, AZ 85721 http://nickel.as.arizona.edu/~barg ----------------------------------------------------------------

1 0

External Methods and ZSQL
by tom＠othermedia.com 02 Jul '01

02 Jul '01

A few days ago someone posted something about using the ZSQL stuff from an extenal method, not calling existing methods but building it on the fly. It went kinda like this... >From Products import SQL myconn = ZSQL.connect() mycursor = myconn.cursor myresults - mycursor.execute("select * from food") myconn.close() return myresults ...can anyone poin me to the code (or did I just imagine it?) thanks tom

1 0

RE: [Zope] Topic Security in DocumentLibrary
by Sedat Yilmazer 02 Jul '01

02 Jul '01

Hi Casey and all Zopers, Great ! Now I have some limited security in DocumentLibrary... Documents are not protected! It seems that we need a check that will control if the user has access to any of the topics that document has, or maybe a more restricted option : that the user has access to all of the topics that document has. What I like the most in DocumentLibrary is the file name attached at the end of the file object. That makes the life alot easier in the M$ world. I have tried the CMF but got tried of Open/save dialogs ( and sometimes twice! probably an IE bug) Secondly to post a document to CMF you have to go three pages. I can understand the first one ( that can be a dropdown box with the type info ("File", "Folder" etc) ) but I see no reason to have one page for metadata and one for the file upload. Is there a reason that I miss for that complication? Sedat Yilmazer -----Original Message----- From: cduncan(a)kaivo.com [mailto:cduncan@kaivo.com] Sent: Monday, July 02, 2001 5:40 PM To: Sedat Yilmazer Subject: Re: [Zope] Topic Security in DocumentLibrary Sedat Yilmazer wrote: > > Hi Zopers > > I am working on a M$ Office Client for DocumentLibrary project. It seems to be no topics security buit in! ( I mean restrict access to some topics based on user role) > If I try to restrict access to a topic ( disable 'access conetent information' on the security tab of the topic) then the user is banned fron the system totally ( system ties to access the restricted topic and fails, It comes back with auth. prompt. As the user do not have access to that topic system returns with noaccess error screen) > > Is there a way to restrict acces to some topics in DocumentLibrary? If not I think I will drop the project untill the topic/Document security is somehow provided > > Sedat Yilmazer > I haven't really addressed this, but I think it would be easy to fix by making two changes to the DTML code. I will include these changes in the next release, but here they are: In the document_browse and the index_chooser methods change the line: <dtml-in expr="objectValues('Topic Index')"> to read: <dtml-in expr="objectValues('Topic Index')" skip_unauthorized> That should help. Let me know if you still run into any problems. -- | Casey Duncan | Kaivo, Inc. | cduncan(a)kaivo.com `------------------>

1 0

RE: [Zope] OT Perl daemon to restart hung Zope on RedHat
by Dunigan, Craig 02 Jul '01

02 Jul '01

Well, Jerome, I warned you that I was talking from half-recalled knowledge! I'd forgotten about nohup. I believe that might work fine. I'll give it a try and let you know. Craig > -----Original Message----- > From: Jerome Alet [mailto:alet@unice.fr] > Sent: Monday, July 02, 2001 9:50 AM > To: Dunigan, Craig > Cc: zope(a)zope.org > Subject: RE: [Zope] OT Perl daemon to restart hung Zope on RedHat > > > On Mon, 2 Jul 2001, Dunigan, Craig wrote: > > > An "open console" means that somebody has to be logged into > the machine for > > the script to run. Exit the logged in session, and all > running jobs, > > background and foreground, get killed. That means that, > since I have remote > > What about the nohup unix command ? > > bye, > > Jerome Alet >

1 0

RE: [Zope] OT Perl daemon to restart hung Zope on RedHat
by Dunigan, Craig 02 Jul '01

02 Jul '01

An "open console" means that somebody has to be logged into the machine for the script to run. Exit the logged in session, and all running jobs, background and foreground, get killed. That means that, since I have remote servers, I'd have to leave one xterm window running on my Linux workstation for each remote server, logged into the server via ssh or whatever. If my workstation has a power outage, that process on the remote server dies. No problem if I'm here every day, but if I go on vacation, there's no one else here who knows anything at all about Linux or Zope, and our servers go unprotected, and the people in California complain that they can't get to the intranet, and my boss complains to me. Or that's roughly how it happens. Perhaps a better way to think of 'an open console' is that the process (our script) expects to find a STDIN, a STDOUT, and a STDERR, which are normally attached to a display, also called a console. A daemon forks a child, which creates its own set of these, as well as sets up its own signal handler separate from the parent. This effectively disconnects the child from a display, so that when we close STDx (on the parent) and kill the parent, the child won't catch the signal to close that comes when we close the display by logging out. More or less, since I'm speaking largely from half-recalled theory, that's why just backgrounding, as well as simply starting a non-daemon script from an rc init script, as someone else suggested, won't work. However, I'm sure someone with more knowledge and experience could explain it in greater (and more exact!) detail. Craig Dunigan Web Programmer Esker Software - Extending the Reach of Information mailto:craig.dunigan@esker.com Ph. 608.273.6000 Fax 608.273.8227 http://www.esker.com > -----Original Message----- > From: Jerome Alet [mailto:alet@unice.fr] > Sent: Monday, July 02, 2001 2:27 AM > To: Dunigan, Craig > Cc: zope(a)zope.org > Subject: RE: [Zope] Perl daemon to restart hung Zope on RedHat > > > On Fri, 29 Jun 2001, Dunigan, Craig wrote: > > > > I don't use it since Zope 2.1.6, because I've not > experienced any hang > > > since this date. However I've just looked at the code and I can't > > > see anything which would prevent it from being run in the > background: > > > > > > isdazope.py [options] & > > > > > > I don't know how to really daemonize it, though. > > > > As I'm sure you know, > > No ! I don't. > > > but for the benefit of others who might not, > > backgrounding it still needs an open console to run, and > that is what I > > wanted to avoid. Oh well, maybe someone who knows about > making a Python > > daemon could step in at this point and save us? > > What do you mean by: "needs an open console to run" ? > > Thanks in advance. > > Jerome Alet >

2 1

RE: [Support] [ZOPE Collector] Zope Bug entry: ImportError: cannot import name ZopeSplitter
by Brian Lloyd 02 Jul '01

02 Jul '01

> Title: ImportError: cannot import name ZopeSplitter > > Description: Zope won't start due to following error: > > D:\PROGRA~1\Snafu\lib\python\Products\PluginIndexes\__init__.py, line 99, > in ? > (Object: Products.PluginIndexes.KeywordIndex) > ImportError: cannot import name ZopeSplitter It turns out that this was due to an old version of Winzip we were using in the build process that seems to have had trouble with some of the deep directory structures in 2.4, leaving some incomplete files in the win32 (binary) installer that was originally posted. We've rebuilt and tested the win32 binary installer using a newer version. If you've previously downloaded the win32 binary, you should use the updated version instead: http://www.zope.org/Products/Zope/2.4.0b2/Zope-2.4.0b2-win32-x86.exe/view Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

can i create Zope Obj with other applications?
by Mate' Sztipanovits 02 Jul '01

02 Jul '01

my email is msztipan(a)bellsouth.net thanks

2 1

xml-rpc authentication
by Tim Hicks 02 Jul '01

02 Jul '01

I am trying to use xml-rpc to get hold of some files uploaded to one Zope server, send them to another for some processing, and then have them returned to the first server. My difficulty is in the authentication part. I have read Amos' tutorial (http://www.zope.org/Members/Amos/XML-RPC) and understand that xmlrpclib.py in its standard form does not handle http authentication. My problem is that I'm not really that hot on python, so I don't totally understand how to implement Amos' BasicAuthTransport class. Where should I put this code? Do I need to make any more alterations (other than subclassing 'transport' as opposed to 'xmlrpclib.transport')? I had a go at getting things to work; here's what I did: 1) Made a copy of xmlrpclib.py named xmlrpclibx.py to play with 2) Pasted in Amos' BasicAuthTransport class code. 3) Changed the line in the 'Server' class so that it set 'transport' to 'BasicAuthTransport()' ... but I simply got a syntax error when I tried to 'import xmlrpclibx' in my external method. Can anyone help me out? thanks tim

2 4