May 1999 - Zope - Zope lists

where's the latest MySQL adaptor?
by Tony McDonald 10 May '99

10 May '99

Hi all, The main site says that along with Zope 1.11 there is a new MySQL adaptor available. The one at http://www.zope.org/Download/ZMySQLDA is the following; ZMySQLDA-1.1.3-nonbin.tar.gz 31,641 bytes 1999/01/25 which I'm pretty sure is the original adaptor. Anyone know where this new adaptor is? I'm hoping it might cure some MySQL timeouts we're getting... TIA 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

Batch Processing Problem
by Alexander Schad 10 May '99

10 May '99

Hi! I want to iterate over a big data set (about 1400 entries) using the in tag and i want to provide a link to the last batch. I wanna do something like:  <a href="query_start= " >last  Entries</a>  Anyone any ideas?? Alex

1 0

(no subject)
by Jay, Dylan 10 May '99

10 May '99

I'm having extreme trouble getting the rules to work under NT4.0 with Apache 1.3.6. I've used all of this below and can't even get the first page up let alone authentication working. I believe my rewrite rules are working but something else is not as my error.log keeps reporting. [Mon May 10 18:50:46 1999] [error] [client 135.254.74.181] Options ExecCGI is off in this directory: /apache/cgi-bin/provision.exe I used the debugging info on rewrite module to get the following 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (2) init rewrite engine with requested uri /Zope/ 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (3) applying pattern '^/Zope/(.*)' to uri '/Zope/' 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (4) RewriteCond: input='' pattern='^(.*)' => matched 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (2) rewrite /Zope/ -> /Apache/cgi-bin/Provision.exe 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (5) setting env variable 'HTTP_CGI_AUTHORIZATION' to '' 135.254.74.181 - - [10/May/1999:18:21:51 +1000] [provision.auslabs.lucent.com/sid#7c6db8][rid#97b9f8/initial] (2) remember /Apache/cgi-bin/Provision.exe to have MIME-type 'application/x-httpd-cgi' My http.conf has the following. <Directory /> Options FollowSymLinks AllowOverride None </Directory> <Directory "C:/Apache/htdocs"> # # This may also be "None", "All", or any combination of "Indexes", # "Includes", "FollowSymLinks", "ExecCGI", or "MultiViews". # # Note that "MultiViews" must be named *explicitly* --- "Options All" # doesn't give it to you. # Options Indexes FollowSymLinks ExecCGI # # This controls which options the .htaccess files in directories can # override. Can also be "All", or any combination of "Options", "FileInfo", # "AuthConfig", and "Limit" # AllowOverride None # # Controls who can get stuff from this server. # Order allow,deny Allow from all </Directory> # # UserDir: The name of the directory which is appended onto a user's home # directory if a ~user request is received. # # Under Win32, we do not currently try to determine the home directory of # a Windows login, so a format such as that below needs to be used. See # the UserDir documentation for details. # UserDir "C:/Apache/users/" ScriptAlias /cgi-bin "C:/Apache/cgi-bin" # # "C:/Apache/cgi-bin" should be changed to whatever your ScriptAliased # CGI directory exists, if you have that configured. # <Directory "C:/Apache/cgi-bin"> AllowOverride None Options All </Directory> LoadModule rewrite_module modules/ApacheModuleRewrite.dll RewriteEngine on RewriteLog logs/rewrite.log RewriteLogLevel 9 RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^/Zope(/.*) /Apache/cgi-bin$1 [E=HTTP_CGI_AUTHORIZATION:%1,T=application/x-httpd-cgi,L] <Directory /Zope> Options All AllowOverride None </Directory> <Directory /apache/cgi-bin/provision.exe> Options All AllowOverride None </Directory> Amoung other things. I'm at the end of my teather. I've tried everything I can think of and always I get a 403 error. What am I doing wrong? >I don' t know if this will help much but I have version 1.3.4 working. The Zope install is named >George so, > > >RewriteEngine on >RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^/Zope/(.*) /Apache/cgi-bin/George.exe/$1 [E=HTTP_CGI_AUTHORIZATION:%1,T=application/x-httpd-cgi,L] > > >This doesn't seem much different from yours but I also had to append: > > ><Directory /Zope> > > Options All > AllowOverride None </Directory> ><Directory /apache/cgi-bin/george.exe> > Options All > AllowOverride None </Directory> > > > >before I could get it to work. Only adding ExecCGI option still gave me 403 and authorization >errors. Options All seems a bit extreme, but I didn't feel like messing with it a whole lot at >the time... > > >BTW this is on NTWS 4.0. >[My other machine runs Linux :^) ] > > >HTH, >John Jarvis > > > > -----Original Message----- > From: Rob Page [SMTP:rob.pag-@digicool.com] > Sent: Wednesday, April 14, 1999 8:21 AM > To: 'zop-(a)zope.org' > Subject: [Zope] Zope with Apache on NT > > Has anyone gotten Zope 1.10.2 to work with the windows version of Apache > (1.3.6)? I've checked, double-checked and triple-checked the notorious > rewrite rule: > > <httpd.conf snippet> > LoadModule rewrite_module modules/ApacheModuleRewrite.dll > # > # > RewriteEngine On > RewriteCond %{HTTP:Authorization} ^(.*) > RewriteRule ^/Zope/(.*) /PROGRA~1/APACHE~1/cgi-bin/Zope1-10-2.exe/$1 > [last,e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] > </httpd.conf snippet> > > so on: > > http://localhost/Zope/manage or > http://localhost/Zope/anything-else-for-that-matter > > I just get Error 403 Forbidden messages. > > waaaaahhh... it's late and I'm getting cranky... snivel... > > :^) > > --Rob > > -- > Rob Page V: 540 371 6909 > Digital Creations > http://www.digicool.com > > _______________________________________________ > Zope maillist - zop-(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-de-(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) _______________________________________________

1 0

Bug or my fault?
by Tom Deprez 10 May '99

10 May '99

Hi, I'm using Zope1.11, Medusa, and IE4.0 for testing purpose I was working with structured text and I've stumbled onto two strange thingies : 1. Solved at ZDP! But this 2nd made it very difficult to find the problem! ---------- Another strange? behavior : If I have added a DTML document with struct. text. View it -> Go back -> change it -> view it again, the text shown is the old text (even if I refresh my page). BUT! If change my DTML-document which calls the struct text (see above), like this : assume I've changed page with id fifth :  (So I change it to view page first) then change it back to  (To view page fifth) Then I do get my correct page (changed page) after refreshing it... huh??? Why do I've to change one page, to see the changes of another page??? Tom.

2 1

What method do I use to check access?
by Jay, Dylan 10 May '99

10 May '99

I want to do a conditional dtml statement based on whether the user has access to a particular object. What method do I use?

1 0

RE: [Zope] Zope 1.11 timeouts with IE 5.0
by Alexander Staubo 10 May '99

10 May '99

That's true -- I'm using ZServer now and so far it's been behaving well. There's no particular reason to use the ZopeHTTPServer, anyway. Alexander Staubo http://www.mop.no/~alex/ mailto:redhand@mop.no >-----Original Message----- >From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Tom >Deprez >Sent: 9. mai 1999 01:21 >To: Alexander Staubo >Cc: zope(a)zope.org >Subject: Re: [Zope] Zope 1.11 timeouts with IE 5.0 > > >Hi Alexander, > >Yes, others and I experienced this too. However, when I >installed Medusa >(delivered with Zope 1.11) everything works just fine. > >Tom. > >-----Original Message----- >From: Alexander Staubo <alex(a)mop.no> >To: zope(a)zope.org <zope(a)zope.org> >Date: zaterdag 8 mei 1999 23:00 >Subject: [Zope] Zope 1.11 timeouts with IE 5.0 > > >:I'm having some problems on Zope 1.11 (running ZopeHTTPServer) with IE >:5.0 (this is NT, SP4). >: >:Pages in the management interface usually load fine, but IE will never >:load images on first attempt -- they time out. A simple refresh on the >:individual frame will usually bring up the images. Occasionally single >:pages time out, as well, or the server gives a "connection refused". I >:experienced the latter problem with Zope 1.10.2 to a certain extent; >:with 1.11 it seems to have worsened. >: >:Alexander Staubo >:http://www.mop.no/~alex/ >:mailto:redhand@mop.no >: >: >:_______________________________________________ >:Zope maillist - Zope(a)zope.org >:http://www.zope.org/mailman/listinfo/zope >: >:(For developer-specific issues, use the companion list, >:zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >: > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://www.zope.org/mailman/listinfo/zope > >(For developer-specific issues, use the companion list, >zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev ) >

1 0

Zope with MSSQL under Linux?
by Alexander Staubo 10 May '99

10 May '99

Has anybody used Zope with MS SQL Server under Linux? I was hoping that perhaps the ZSybaseDA thing would work (MSSQL, being based on Sybase, is generally compatible on protocol level), but it requires an OpenLink ODBC driver, which as far as I know is a commercial product. Could the ODBC DA theoretically support ODBC drivers under Linux? There are several open-source ODBC projects underway (such as unixODBC), albeit none -- that I know -- with MSSQL support. ODBC is not as widely supported on UNIX as on Windows, and the idea that you actually have to go buy an ODBC driver for your database product is ridiculous at best. Oracle only provides ODBC drivers for Windows, for example, which is just sad. So far I'm very happy with Zope and MSSQL/ODBC on Win32, but if installing Zope on a Linux box means I must be content with using MySQL or mSQL, or buying several pieces of commercial software, I'm not doing it. Alexander Staubo http://www.mop.no/~alex/ mailto:redhand@mop.no

1 0

zope: accessing zsql methods from external methods (1.10.2 and 1.11pr1)
by Dr. Ross Lazarus 10 May '99

10 May '99

I'm stumped. I need a simple example of how to get an external python method to grok a working zsql query. I have a zsql query which works fine, called showcont, returning the entire contents of a small table. I have a simple external method based on the hint on page 11 of the zsql methods user's guide which implies that an external method should get something useful back from showcont() - I've stripped it to the basics so I expect to get some horrible but familiar text back without adding any python complications - I just want this to work !!! ===========testzsql.py in Extensions directory # testing external methods def test(self): s = '' for cont in showcont(): for contitem in cont: s = s + contitem + '<BR>' return s ========= The external method is loaded into the same folder as the zsql method and function test is called as testzsql. I put a  into a dtml method and get...tracebacks. Basically, they all point to the fourth line - the showcont() call seems to break. This doesn't seem to work for 1.10.2 or 1.11pr1 - both running under nt4/sp4 using the simple server. At least I get better error messages from the fixed externalmethods in 1.11... Any advice appreciated ! -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, Room 126A, A27, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au http://www.health.usyd.edu.au/people/rossl.htm

1 0

Re: [Zope] Why doesn't this work?
by Craig Allen 09 May '99

09 May '99

Thanks for the tip, I'll do that. Do you know of any zopish way to render the URL of the top level directory (without knowing where you are in the folder hierarchy)? This would be more elegant as a generic solution. The plus side of not using the absolute URL is that I could have a local version of 'folderimg' if I wanted, without having a local version of the method. Kent Polk wrote: > You might want to provide your images with an absolute URL if > applicable because browsers will reload the images with each document > instead of caching them.

2 1

Re: Re: Adding a new data source to Zope
by Andrey V Khavryutchenko 09 May '99

09 May '99

Hi, Michel! >>>>> "MP" == Michel Pelletier writes: From> Andrey V Khavryutchenko [mailto:akhavr@compchem.kiev.ua] [other datasource] >> If you're adventurous, you may try my module for storing/retrieving >> data from any data source. Available at >> http://www.kbi.kiev.ua/projects/python-oordb.shtml >> Though, it was first created to interface mysql database, it is >> designed to use user-defined store/retrieve functions, so it might be >> used with any datasource. MP> This reminds me to get on the ball, I haven't rad this oordb document MP> yet, just glanced at it, it looks interesting. Thanks. I have to say, that I've not used it with Zope, but with the previous version, bobo. It should plug without any problems ;) but it may lack some reader/writer functions for internal Zope classes. MP> In either case, you might want to wait for ZODB3, which is probably MP> going to be much easier for you to extend in this way. See: MP> http://www.zope.org/pipermail/zope/1999-April/006175.html MP> For the ZODB3 UML documentation. Yes, I've read this document, but my module is the offspring of commercial project and, at the end of 1998, when I was starting to design it, ZODB3 wasn't still usuable in any, but test environment. -- SY, Andrey V Khavryutchenko http://www.kbi.kiev.ua/~akhavr Freelance Software Engineer Visit my site Shick's Law: There is no problem a good miracle can't solve.

1 0