- Zope - Zope lists

calling a SQL method without arguments
by Daniel M. Drucker 10 Jun '99

10 Jun '99

If I have an SQL method with one optional argument, how can I call it without using that argument: For example: SQL_method Arguments: authorid select * from authors    Theoretically, if I call this with a authorid, it'll return the proper row, and if I don't, it'll return all rows. But, given the following:  blah  I get this error:  So, what's the proper way to call a SQL method without arguments?

2 1

Searching Zope sites?
by Alexander Staubo 10 Jun '99

10 Jun '99

Let me guess. This is a fairly frequently asked question? I'm using Zope 1.11.0pr1, and I'm looking for a simple way to permit full-text search, preferably including boolean expressions, on Zope sites. Looks to me like the only objects supporting the "Z Search Interface" are SQL Methods and Confera topics. Will full search capabilities come with the Portal Toolkit? Until then, is there a simple way to search through just, say, DTML Documents and DTML Methods? -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

2 1

Zope 1.10.2, Sessions and Z SQL Methods
by Eric Kidd 10 Jun '99

10 Jun '99

Under Zope 1.10.2, Sessions and Z SQL Methods do not seem to play nicely. Querying through a Z SQL Method (using the ZPyGreSQLDA, at least) appears to modify the method somehow. This means that if somebody's working in a session while a user is browsing the site, bad things tend to happen. This makes Sessions nearly useless. Does anybody know how I can work around this problem? Cheers, Eric

2 1

RewriteRule for Zope.cgi
by Robert W. Canary 10 Jun '99

10 Jun '99

Hi, Seem to be having trouble getting my RewriteRule correct for authenticating. Cn some one take a look and see what is I am doing wrong here. This is a RHL 5.2, with Apache-1.3.3. The rewrite is the last entry in the /etc/httpd/conf/httpd.conf RewriteEngine on RewriteLog /var/log/httpd/ap_rewrite_log RewriteLogLevel 9 RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^/cgi-bin/Zope(.*) /cgi-bin/Zope$1 [e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] The Zope.cgi is located in /home/httpd/cgi-bin/Zope.cgi. This directory is recognized by appache as an cgi directory with this entry in the /etc/httpd/conf/access.conf: <Directory /home/httpd/cgi-bin> AllowOverride None Options ExecCGI </Directory> Owner nobody rwxr-xr-x /var/local/zope nobody rwxr-xr-x /var/local/zope/* nobody rwxr-xr-x When I go to /www.ohiocounty.net/cgi-bin/Zope.cgi I get an error 403 Forbidden. Here is what I get in the rewrite log: ( i cut the date and time string) (2) init rewrite engine with requested uri /cgi-bin/Zope.cgi (3) applying pattern '^/cgi-bin/Zope(.*)' to uri '/cgi-bin/Zope.cgi' (4) RewriteCond: input='' pattern='^(.*)' => matched (2) rewrite /cgi-bin/Zope.cgi -> /cgi-bin/Zope.cgi (5) setting env variable 'HTTP_CGI_AUTHORIZATION' to '' (2) remember /cgi-bin/Zope.cgi to have MIME-type 'application/x-httpd-cgi'(2) local path result: /cgi-bin/Zope.cgi (2) prefixed with document_root to /home/httpd/html/cgi-bin/Zope.cgi (1) go-ahead with /home/httpd/html/cgi-bin/Zope.cgi[OK] (1) force filename /home/httpd/html/cgi-bin to have MIME-type 'application/x-httpd-cgi' Thanks in advance :-) -- robert canary system services OhioCounty.Net rwcanary(a)ohiocounty.net (270)298-9331 Office (270)298-7449 Fax

1 0

Permission mappings, Z Classes, and acquisition
by Alexander Staubo 10 Jun '99

10 Jun '99

Let's say I create a Z Class "Document" and define some new permission types. Then for some objects in my Z Class I create permission mappings, such as "Add Documents, Images, and Files" and "Delete objects" mapping to my permission type "Manage documents". Then I create some instances of the Z Class in the folder "Documents". I define a new global role "DocumentAdmin". I want this role to manage documents in the "Documents" folder and all subfolders. But there's the rub. I'd like to use acquisition to enable these security settings for all documents in this hierarchy. Zope only allows giving this permission to this role for each and every specific Z Class instance, because my custom permissions, such as "Manage documents", are not available on the folder level -- they're only available on instances. Is this a bug? Isn't the permission list supposed to be a superset of all available permission types defined in the database? Am I missing something? Because of this design, I guess I have to create a dummy Z Class called "DocumentFolder" which defines my custom permissions, then let the root folder be an instance of this class. Which is fine, but I didn't expect having to do this. If this is by design, I'd like to know the rationale behind it. Oh, and this is Zope 1.11.0pr1. -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

1 0

University Website with Zope
by Troy Shurtleff 10 Jun '99

10 Jun '99

I a working on a more effective way to manage the website for a public university in North Carolina. Lately I have been considering Zope as a possible solution. I have spent some time using Zope and seeing what I can do with it. There are two features that are a priority in the web site... 1. We need to have a search feature where users from the web can enter a value in a search field and find documents that contain that text.....a fairly simple operation. I tried experimenting with the find feature in the Zope management interface. I was able to get close to what I want. I had to give anonymous users permision to view management screens. after some search criteria was entered a list of DTML Documents would appear that contained the text that I searched for. When I clicked on the documents it took me to the management screen for that document....from there i could view it. I would like to be able to better control the appearance of the output after a user does a search and I would like the user to be sent directly to a document listed in the search results.....without going through the management screen. 2. We would like to have a dynamically generated site map....this will probably only be avalible to administrators but possibly outside users. With the site map I would like to see what is linked to what...and if there are any broken links. I tried using the tree tag but nothing showed up.    is there something wrong with it? a tree view may be sufficient. I am currently running... Zope 1.10.2 (binary release, python 1.5.1, win32-x86), on Python 1.5.1 (#0, Nov 18 1998, 12:17:58) [MSC 32 bit (Intel)] on win32. Eventually we plan on installing Zope on our primary academic machine....unix....that is if we can implement the features we want. Any help would be greatly appreciated. Feel free to respond to this via e-mail to troy(a)mav.net Thanks Troy -- Troy Shurtleff troy(a)mav.net

1 0

RE: [Zope] O'Reilly Open Source Conf -Aug 21-24
by Paul Everitt 10 Jun '99

10 Jun '99

Bob wrote: > I just got the O'Reilly Open Source Software > Convention brochure. > > http://conferences.oreilly.com > > There is a track on Python and the > Pre-Conference Tutorial includes > > "Introduction th the Zope Web Application > Server" from 2pm to 5:30pm on Sat > Aug 21st. > > Also "Community: Funding the Perfect Beast... > Venture Capitalism, IP and Open Source" > from 2pm-4pm on Monday, Aug 23rd. > > I'm sure Paul and Digicool will have an official > announcement but this seems like a good thing > to announce now for the Zope community. Well, this looks like an official enough announcement! Thanks Bob. --Paul

1 0

Zope on a CD-ROM?
by spamfranke＠bigfoot.de 09 Jun '99

09 Jun '99

I'm trying to put my Zope app (1.10.2, Win NT) on a CD-ROM for demo purposes, using ZopeHTTPServer. I have a batch file whichs sets ZOPE_READ_ONLY before starting start.bat. It works fine when running from the harddisk. But on a CD-ROM I get the traceback below. Is the read-only mode not really read only? Stefan Traceback (innermost last): File "serve.py", line 100, in ? ZopeHTTPServer.main(args) File "D:\Programme\Zope\Koelnzope\ZopeHTTPServer\ZopeHTTPServer.py", line 500, in main start(module_file,host,port,threading,env) File "D:\Programme\Zope\Koelnzope\ZopeHTTPServer\ZopeHTTPServer.py", line 438, in start set_published_module(module_file,BoboRequestHandler,env) File "D:\Programme\Zope\Koelnzope\ZopeHTTPServer\ZopeHTTPServer.py", line 434, in set_published_module __import__(name) # to catch problem modules right away File "D:\Programme\zope\koelnzope\lib\python\Main.py", line 103, in ? Bobobase=OFS.Application.open_bobobase() File "D:\Programme\zope\koelnzope\lib\python\OFS\Application.py", line 365, in open_bobobase install_products(app) File "D:\Programme\zope\koelnzope\lib\python\OFS\Application.py", line 483, in install_products get_transaction().commit() File "D:\Programme\Zope\Koelnzope\lib\python\BoboPOS\SingleThreadedTransaction.py", line 182, in commit o.__inform_commit__(self,self.now) File "C:\temp\zope_cd\lib\python\BoboPOS\SimpleDB.py", line 348, in store if self._ro: self.write_mode_error() File "C:\temp\zope_cd\lib\python\BoboPOS\SimpleDB.py", line 341, in write_mode _error raise IOError, (ErrorFormat % IOError: <HTML><HEAD><TITLE>Database Error</TITLE></HEAD> <BODY BGCOLOR="#FFFFFF" LINK="#000099" VLINK="#555555" ALINK="#77003B"> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="10"> <TR> <TD VALIGN="TOP"> <CENTER>!</CENTER> </TD> <TD VALIGN="TOP"> <CENTER>Attempt to perform a write operation while the database is in read-only mode. </CENTER> </TD> </TR> </TABLE>

3 2

Tree tag and SQL methods?
by Alexander Staubo 09 Jun '99

09 Jun '99

I don't have a head for figuring this out today, but maybe somebody here can help me out. I'm thinking of exploiting the #tree tag in conjunction with one or more SQL method. Say I have a hierarchical-ish table with id/parent_id references, and I'd like to display this information in a nice collapsible tree. Possible? Possibly the expr= or branches_expr= arguments to #tree could evaluate the result of an SQL method, although it sounds to me like this would require one query per tree level. Possibly you could put the query results of the complete table in a temporary variable and evaluate on that? Anybody done something like this? -- Alexander Staubo http://www.mop.no/~alex/ "`Ford, you're turning into a penguin. Stop it.'" --Douglas Adams, _The Hitchhiker's Guide to the Galaxy_

3 2

Sqishdot bug and issues
by Michel Pelletier 09 Jun '99

09 Jun '99

After getting Tiny Tables to work with Zope 2.0 with ZODB2 (effectivly "1.11", it won't work with ZODB3) I installed the Squishdot product. Tres cool, as Morgan would say if she could say more than "bye bye". Only problem is I get an error if I try and use either of the two style themes that require Tiny Tables (I keep wanting to type Tyny Tables) Squishdot work with the basic layout, and tiny tables works fine by itself: Traceback (innermost last): File /home/michel/dev/Michel/lib/python/ZPublisher/Publish.py, line 255, in publish_module File /home/michel/dev/Michel/lib/python/ZPublisher/Publish.py, line 161, in publish File /home/michel/dev/Michel/lib/python/ZPublisher/mapply.py, line 154, in mapply (Object: manage_addSquishdot) File /home/michel/dev/Michel/lib/python/ZPublisher/Publish.py, line 98, in call_object (Object: manage_addSquishdot) File /home/michel/dev/Michel/lib/python/Products/Squishdot/Squishdot.py, line 1464, in manage_addSquishdot (Object: ApplicationDefaultPermissions) File /home/michel/dev/Michel/lib/python/Products/Squishdot/Squishdot.py, line 405, in __init__ (Object: bipity) File /home/michel/dev/Michel/lib/python/Products/Squishdot/Squishdot.py, line 195, in addTable (Object: bipity) File /home/michel/dev/Michel/lib/python/Products/TinyTable/TinyTable.py, line 58, in addItem (Object: bipity) File /home/michel/dev/Michel/lib/python/App/special_dtml.py, line 120, in __call__ (Object: manage_main) File /home/michel/dev/Michel/lib/python/DocumentTemplate/DT_String.py, line 514, in __call__ (Object: manage_main) File /home/michel/dev/Michel/lib/python/App/special_dtml.py, line 120, in __call__ (Object: manage_tabs) File /home/michel/dev/Michel/lib/python/DocumentTemplate/DT_String.py, line 514, in __call__ (Object: manage_tabs) File /home/michel/dev/Michel/lib/python/DocumentTemplate/DT_With.py, line 133, in render (Object: _(manage_options=filtered_manage_options())) File /home/michel/dev/Michel/lib/python/DocumentTemplate/DT_Util.py, line 309, in eval (Object: _(manage_options=filtered_manage_options())) TypeError: sequence index must be integer -Michel asking a question for once

2 1