February 2000 - Zope

Single quote and double quote
by Sin Hang Kin 16 Feb '00

16 Feb '00

What is the different of single quote and double quote in zope? <dtml-var 'toXML()'> does not work but <dtml-var "toXML()"> works Rgs, Kent Sin

2 1

Re: [Zope] Zope Server Performance and Scalability
by J C Lawrence 16 Feb '00

16 Feb '00

On Tue, 15 Feb 2000 19:04:43 -0700 Bill Anderson <bill.anderson(a)libc.org> wrote: > Zope is a cakewalk to backup and restore. Data.fs files gzip > nicely, and bzip2 even better ;) My complaint there is the fact that data.fs is monolithic makes it difficult to impossible to segment your data for more useful backup/redundancy strategies. -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

2 1

GenericUserFolder Question
by James W. Howe 16 Feb '00

16 Feb '00

I'm trying to work with the GenericUserFolder product. I've been following the How To and I don't seem to be getting the results I would expect. I've installed the product, created a test folder with an acl_users folder. I deleted the acl_users folder and added a GenericUserFolder. I configured the security settings on acl_users as specified in the GUF readme. I then tried to access my test folder from a different browser (to make sure I would be asked for authentication). When I tried to access the folder, I got the simple login screen. I entered the values 'jorge' for the username and 'secret' for the password. When I pressed Ok, I didn't see the index_html file for the folder, instead I got the login screen once again. Can someone help me out with some ideas on what I might have done wrong (or not done at all?) Thanks. James W. Howe mailto:jwh@allencreek.com Allen Creek Software, Inc. pgpkey: http://ic.net/~jwh/pgpkey.html Ann Arbor, MI 48103

4 4

Re: [Zope] Duplicate column name in ZSQL Method
by Tres Seaver 16 Feb '00

16 Feb '00

Martin Fahlgren <martin.fahlgren(a)salomon.at> wrote: > Hello! > > Is there any possibility to make a query like > > select * from table1, table2 > > without explicitly typing every column name. If table1 and table2 have > columns with the same names Zope raises an exception with the message > "Duplicate column names" Two problems: * The "duplicate column names" one can be solved by aliasing the table names:: select t1.*, t2.* from table1 t1, table2 t2 The syntax for doing this varies; you may need to add an 'as' or wrap the alias in quotes. * Without specifying a join condition, this query produceds a "Cartesian explosion": if table1 and table2 each have 100 records, the result set will have 10,000 records. To avoid this, join the two tables using the common fields:: select t1.*, t2.* from table1 t1, table2 t2 where t2.foreign_key = t1.primary_key -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

zodb Q
by - 16 Feb '00

16 Feb '00

hi all, i still can't make out how zodb works. i see that it increases it's sizes after a while. if i pack, it shrinks back. what is really happening? i read in previous threads, all unreferenced objects are kept until packed. will cache garbage collection do this? will frequent garbage collection (30 sec) help? the site i'm maintaining has a phenomenal zodb size increase. when i pack, it goes down from 550M to 20M. this is in one day. i wonder how zope.org tackles this? how can i do this automatically? read zope admin and content manager guide, but there's only brief rundowns. any pointers, docs, howtos apreciated. tq -- -- ------------------------------------------------------ http://www.kedai.com.my/kk Am I Evil?

2 4

Zope Server Performance and Scalability
by Guy Davis 16 Feb '00

16 Feb '00

I set up a Zope 2.12 server on a PentiumPro 200 with 64MB running RH6.1 Linux. Currently I am using Apache with pcgi to handle the initial requests and MySQL for Zope's database for bug tracking and other apps. I have been asked to defend my choice of Linux over WinNT. This server will be used by approximately 50 people who will mostly make use of the document management abilities of Zope and run occasional database queries. If we assume heavy use from all 50 people, can Zope handle the loads easily? What kind of numbers (hits/second, etc.) can others report to help me back up my claim that it can? I understand that Zope is significantly slower than MS SiteServer, but for our needs is it not more than sufficient? My next question is the same but for up to 500 users. There is a small possibility that Zope may be used corporate wide rather than just for our local business units. This would likely require more serious hardware? What level? At what point does it become necessary to move to the Zope Enterprise Option? Also, what has been your experience with Zope's reliability on Linux? Has anyone been in a backup recovery situation? Was it difficult getting Zope working again from a nightly archive? This is a lot of questions but I really appreciate anyone who takes the time to answer them. -- Guy Davis mailto:davis@arc.ab.ca (403) 210-5334 Alberta Research Council

3 3

An advice for take data
by Alessandra Pessolano 15 Feb '00

15 Feb '00

Python is installed in /usr/local/Python-1.5.2 Zope is installed in /usr/local/zope/2-1-2/ I would like to get a file.html on my browser from a Unix box I want to serve the file.html through Zope, but I don't want take it on Zope. What can I do? Is it possible? Thanks in advance for Your help

2 1

Looking for Zope ISP with FTP access to Zserver+ZODB [Europe preferred] preferred]
by Jason Cunliffe 15 Feb '00

15 Feb '00

Hello We need a Zope ISP who can provide us with FTP access to the Zserver+ZODB, preferably based in Europe. Thanks - Jason Cunliffe ________________________________________________ Jason CUNLIFFE = Nomadics.Studio(DesignDirector) Smart_Map_Systems[design.technology.application] <jasonic(a)nomadicsltd.com> tel:+33 4 94.76.98.72

1 0

no typos this time; modify property via form to dtml
by technology＠mylinuxisp.com 15 Feb '00

15 Feb '00

I want to modify a folder property via dtml. I am trying to submit a value via a form teststring is a folder property of the parent folder. <form action="act_dtml"> <input type="radio" name="qtype" value="value1" checked> <input type="radio" name="qtype" value="value2"> <input type="submit"> </form> dtml method <dtml-call "REQUEST.set('teststring','qtype')"> or <dtml-let teststring=qtype></dtml-let> how should I do this. technology(a)mylinuxisp.com cj

2 1

Improve linking strategies?
by Oliver Wrede 15 Feb '00

15 Feb '00

I think link-handling for editorial staff is rather cruel in Zope! So I was thinking about a beginner-level mechanism. If I have a table (e.g. an SQL database) with Title and URL information, I'd like to replace all listed titles in a text with an URL. Example for a table: 1, "MyText", "http://www.mylink.org", NULL 2, "YourText", "http://www.yourlink.org", "<a href=\"http://www.yourlink.org\" target=\"_blank\">Other Place</a>" Example for a text: When it comes to "MyLink" ist should go to "YourLink". Destianted output: When it comes to <a href="http://www.mylink.org">MyLink</a> it should go to <a href="http://www.yourlink.org" target="_blank">Other Place</a>. What steps does a newbie like me have to take, to get this working? I can think that far: a) I may need some kind of external script written in Python b) I will have to make a list of all phrases in "..."-pairs c) I will have to do a SQL-select on each and string.replace each occurance d) I will have to be a Zope-wizard, if I want to add this functionality to existing strcutured-text formatted output.... What I can't think of yet: 1. Is this the right approach? 2. If performance will be lousy. 3. How to I get the Python beast into Zope? 4. How would the Python beast look like? Any ideas? Oliver .. Oliver Wrede .. owrede(a)khm.de .. Academy of Media Arts, Cologne .. Peter-Welter-Platz 2 . 50676 Koeln, Germany .. http://www.khm.de .. ICQ# 6580315 .. PGP 6.0 Fingerprint: .. 922C FFA2 9A07 5B8E CB2A 10A2 C370 6A62 2232 196C

3 2