- Zope - Zope lists

Advanced search with ZCatalog
by Markus Strickler 10 Jan '00

10 Jan '00

Hi! I have a ZClass with several properties defined and indexed. Now I want to perform a search where the search term is matched against any of the properties. (So if I have say a title, summary and body property and my query term is "Test" any ZClass with Test in either title, summary ord body should be returned.) I've found some hints on this in the advanced search howto, that suggests performing multiple searches (one on each property) and concatenating the results. This seems rather clumsy and I wonder if there is any other possibility? Is there any documentation of the Catalog object? Can Catalog.searchResults() be of any use in this, and if so what's the meaning of its parameters? Regards, Markus

1 0

Upgrading (sort of)
by Steve Froggatt 09 Jan '00

09 Jan '00

Hello all I have two servers one with 2.1.1 on and one with 2.1.2, all my content is on the 2.1.1 server. How do I get it on to the 2.1.2 server I have exported the file, but cannot import it.

2 2

Re: [Zope] Unable to pack - permission denied error
by Steen Suder 09 Jan '00

09 Jan '00

Steve Froggatt wrote: > > Thanks for your help.... here goes > > Zope Directory > > total 462 > drwxr-xr-x 13 506 users 1024 Jan 7 22:53 . > drwxrwsr-x 5 httpd site2 1024 Jan 3 09:47 .. > -rw-r--r-- 1 506 users 28 Nov 9 16:47 .cvsignore > drwxr-xr-x 2 223 site2 1024 Oct 19 01:58 Extensions > -rw-rw-r-- 1 223 site2 13731 Dec 20 10:03 > KnowledgeKit-1.6.7.tar > -rw-r--r-- 1 506 users 3479 Mar 10 1999 LICENSE.txt > drwxrwxr-x 2 223 site2 1024 Dec 28 12:48 MySQLdb-0.1.0 > -rw-rw-r-- 1 223 site2 35534 Dec 20 10:03 MySQLdb-0.1.0.tar.tar > -rw-r--r-- 1 506 users 2074 Jul 23 20:51 README.txt > -rw-rw-r-- 1 223 site2 5337 Dec 20 10:04 > SessionManager-0.1.tar.tar > -rw-rw-r-- 1 223 site2 246231 Dec 20 10:46 Squishdot-0-3-2.tar > drwxr-xr-x 4 506 users 1024 Dec 14 15:38 ZServer > -rwxr-xr-x 1 223 site2 656 Dec 31 15:38 Zope.cgi > -rw-rw-r-- 1 223 site2 12288 Dec 20 10:04 ZpdfDocument.tar > -rw------- 1 223 site2 38 Dec 20 09:45 access > drwxr-xr-x 3 506 users 1024 Dec 14 15:38 doc > drwxr-xr-x 3 223 site2 1024 Dec 28 12:48 import > drwxr-xr-x 2 506 users 1024 Dec 14 15:38 inst > -rw-rw-r-- 1 223 site2 19802 Dec 21 07:36 kmnn-1-0-0.tgz > drwxr-xr-x 4 506 users 1024 Dec 14 15:38 lib > drwxr-xr-x 7 506 users 1024 Dec 31 15:38 pcgi > -rw-rw-r-- 1 223 site2 18075 Dec 20 10:04 psqlinputwiz1-0-3.tar > -rwx--x--x 1 223 site2 141 Dec 31 10:55 start > -rwx--x--x 1 root users 145 Dec 20 09:44 start~ > -rwx--x--x 1 223 site2 77 Dec 20 09:44 stop > drwxrwxr-x 2 223 site2 1024 Dec 20 10:13 stuff > -rw-rw-r-- 1 223 site2 6154 Dec 20 10:22 tar.help > drwxr-xr-x 2 506 users 1024 Dec 14 15:38 utilities > drwxrwx--x 3 506 users 1024 Jan 9 18:22 var > -rw-r--r-- 1 506 users 4492 Jul 22 23:00 w_pcgi.py > -rw-rw-r-- 1 223 site2 1359 Dec 20 09:40 w_pcgi.pyc > -rw-r--r-- 1 506 users 4578 Oct 14 15:54 wo_pcgi.py > -rw-rw-r-- 1 223 site2 1506 Dec 20 09:39 wo_pcgi.pyc > -rw-r--r-- 1 506 users 17936 Jan 7 22:53 z2.py > -rw-rw-r-- 1 223 site2 10763 Dec 20 09:40 z2.pyc > -rw-r--r-- 1 root users 17927 Jan 1 18:44 z2.py~ > -rw-r--r-- 1 506 users 8806 Oct 28 18:54 zpasswd.py > -rw-rw-r-- 1 223 site2 5425 Dec 20 09:40 zpasswd.pyc > > var directory > -rw-rw-r-- 1 root users 24737 Jan 9 18:12 #Z2.log# > drwxrwx--x 3 506 users 1024 Jan 9 18:22 . > drwxr-xr-x 13 506 users 1024 Jan 7 22:53 .. > -rw-r--r-- 1 506 users 105 Nov 9 16:46 .cvsignore > -rw-rw---- 1 223 site2 4306930 Jan 9 17:46 Data.fs > -rw-r--r-- 1 506 users 76750 Jun 24 1999 Data.fs.in > -rw-rw-r-- 1 nobody site2 65007 Dec 27 13:30 Data.fs.index > -rw-rw-r-- 1 223 site2 5 Jan 9 18:22 Data.fs.lock > -rw-rw-r-- 1 223 site2 0 Jan 9 18:22 Data.fs.tmp > -rw-rw-r-- 1 root site2 7779 Dec 28 11:00 Data.fs.tr0 > -rw-rw-r-- 1 root users 34073 Jan 9 19:12 Z2.log > -rw-rw-r-- 1 nobody users 9 Jan 9 18:22 Z2.pid > drwxrwxr-x 4 223 site2 1024 Dec 22 12:28 gadfly > -rw-rw-r-- 1 223 site2 4 Jan 9 18:22 pcgi.pid > srwxrwxrwx 1 root users 0 Jan 9 18:22 pcgi.soc > -rw-rw-r-- 1 223 site2 4 Jan 9 18:22 zProcessManager.pid > > Zope is set for user nobody > > This is the start file > > #! /bin/sh > reldir=`dirname $0` > PYTHONHOME=`cd $reldir; pwd` > export PYTHONHOME > exec /usr/local/bin/python \ > $PYTHONHOME/z2.py \ > "$@" > > Steve Quite a mess! If you have a Linux box handy, try and do a fresh install on that and see what permissions the files are installed with. Follow the instructions in the install file in the package!!! I'm busy right now, thus the short answer. I might get back. Please cc mails to list also; that's how everyone learns. -- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/

7 10

mysqlUserFOlder question
by Elijah Wright 09 Jan '00

09 Jan '00

from teh mysqluserfolder docs: ". Also, it is not possible to create/delete roles. That needs to be done using sql client." So this means that i need to add a role to the database manually, rather than through the interface. OK. is this an arbitrarily named role, or is it the 'mysqlUser' role that the product says it knows about internally?? (BTW, the .sql file distributed with mysqlUserFolder is missing a field- the EMail field doesn't get created, and so the product doesn't work until you fix it- easily done by editing the script, dropping the database, and readding it.) can someone give me a brief pointer? i'm plugging mysqluserfolder into squishdot, if that helps :) elijah

1 0

special user can't add ZClass
by Timothy Wilson 09 Jan '00

09 Jan '00

Hi everyone, Yesterday I finally unveiled the first semi-cool version of the Zope-powered site at my school district. Everyone is invited to check it out at at http://www.isd197.k12.mn.us/. At this point there are three major features that really use Zope. 1. A ZClass that we use to create news articles (a la Slashdot) for display on the homepage. (We decided not to use Squishdot for a couple reasons.) 2. The PostgreSQL-driven alumni database. 3. Dynamic news headlines using Site Summary. My student and I learned a ton working on it and we hope to really expand the features of the site over the next few months. The question: We have created a role called 'NewsPoster' that should be able to post news articles for publication and basically have no other privileges. I'm having a terrible time trying to tweak the permissions so this person can log in, let alone post articles. What should be checked on the security page? Obviously the person needs 'Add News Articles' (our ZClass), but anything else beyone what 'Anonymous' has? If you visit the site, you'll see the 'Submit news' link on the left. Maybe I'm using the wrong URL to add the article. I've got: <a href="/school_news/articles/manage_addProduct/NewsProduct/NewsArticle_factory/">Submit news</a> The /school_news/articles/ directory is where all the instances are stored. The default behavior of NewsArticle_factory is to add an instance. I'm stumped. Any ideas? -Tim -- Timothy Wilson | "The faster you | Check out: Henry Sibley H.S. | go, the shorter | http://slashdot.org/ W. St. Paul, MN, USA | you are." | http://linux.com/ wilson(a)visi.com | -Einstein | http://www.mn-linux.org/

1 0

Using MySQL DA
by Tom 09 Jan '00

09 Jan '00

Everyone, i have downloaded ZMySQLDA, and MySQLdb-0.1.0. MySQLdb-0.1.0 has compiled and installed fine ( or seems to have, the _mysqlmodule.so being copied to the python/site-packages dir etc ). Then i tried to install ZMySQLDA. untarred in the correct place etc. Ran the make -f Makefile.pre.in boot, which seemed ok. But when i then try and run make i get the following errors, any one any ideas ? This is with SuSE6.3 gcc -fpic -I/usr/include/mysql -O2 -m486 -fno-strength-reduce -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning:assignment from incompatible pointer type ./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1 i am new to python and zope, any help appreciated regards Tom Wright thomas.wright1(a)btinternet.com

2 1

Unpack sequence of wrong size
by Roland Reumerman 09 Jan '00

09 Jan '00

Hi, I'm new on the Zope list and I have my first question. Why is it I always get the above in the subject line mentioned ValueError message and the below Python trace whenever I try to Test my ZODBC connection on Windows98 or NT with some SELECT SQL query, against many different database backends? ------ Roland Traceback (innermost last): File D:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\Program Files\WebSite\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: RoleManager) File D:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 165, in publish File D:\Program Files\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_test) File D:\Program Files\WebSite\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_test) File D:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\Connection.py, line 177, in manage_test (Object: RoleManager) File D:\Program Files\WebSite\lib\python\Shared\DC\ZRDB\Results.py, line 104, in __init__ ValueError: (see above) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

1 0

Hallelujah (was re: Security)
by Gregor 09 Jan '00

09 Jan '00

Lo and behold, I found the answer, which is that I'm dealing with a bug here. Of all places, it was in the How-Tos (yes, I've looked there before) http://www.zope.org/Members/gtk/containers Given the number of replies, I have to assume that few knew (or at least remembered) this. So I'm posting this info in case anyone is suffering the same problem. ^_^ - Gregor

1 0

is it possible to add numerical comparison test to dtml-in statement ? statement ?
by chas 09 Jan '00

09 Jan '00

When looping over ZClass instances in a dtml-in statement, I have constantly wanted to add a numerical test condition (eg. "where X > 12" where X is a property of the instance) This applies either using objectValues() to loop over the ZClass instances, or using the ZCatalog. Either way, I end up using something a little retarded like this : <dtml-in "objectValues(['MyClass'])" sort=Points> <dtml-if "Points > 12"> ...... </dtml-if> </dtml-in> or <dtml-in "Catalog({'meta_type': 'MyClass'})" sort=Points> <dtml-if "Points > 12"> ...... </dtml-if> </dtml-in> Either way, it's not ideal b/c it means looping unnecessarily and also, it means that I can't use the very convenient Zope "next/previous" (with a query_start) for long listings. There must be an easy way of incorporating this into the dtml-in statement and I'm ready to eat some humble pie on this one : is it possible ? Mouth wide open, chas

3 4

Upgrading to 2.1.2
by Tom 09 Jan '00

09 Jan '00

Hello All, having seen the security problem with 2.1.1 i have got 2.1.2, but no where can i find any information about upgrading from my 2.11 to 2.1.2 with out doing a fresh install. Is there a way to simply upgrade to 2.1.2 with out reinstalling everything ?? Or am i blind as a rivetted bulk head and missed the obvious documentation ? Regards Tom Wright thomas.wright1(a)btinternet.com

2 1