- Zope - Zope lists

does zope play nice with the windows xp operating system??
by Masson, Christy 13 Mar '02

13 Mar '02

Has anyone had any difficulties running zope under the windows xp operating system? and if so, what type of problems have you run into? Chris Masson

2 1

Re: [Zope] Zope server cant bind port 80
by Bak ＠ kedai 13 Mar '02

13 Mar '02

>On 13/3/02 1:24 pm, "Stanislav Marszalek" <smarszalek(a)digi-trade.cz> wrote: > >> Hi, >> When starting Zope server on port 80 under user "zope", sever fails with >> message "fail to bind port 80 - dont have permissions." When running under >> user "root", it is ok. When trying start zope server on port 8080, >> everything is ok. So just cant run on port 80 because of permissions but >> why? > >Generally only root can bind to ports lower than 1024. If you want user zope >to be able to, you will need to set the suid bit on the binary and make it >owned by root. > or use the -u, as in z2.py -u zope -w80 but you still have to start as root, and z2.py will then change to user zope when done hth > >-- >Wayne Pascoe <wayne.pascoe(a)ehsrealtime.com> > >The price of freedom is eternal vigilance > - Thomas Jefferson > > >_______________________________________________ >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 ) >

1 0

Datefields (problem with ZPsycopg and "/"s in dates)
by Joel Burton 13 Mar '02

13 Mar '02

[ Tim -- Email to you bounces--might want to check your address. ] Not seeing the problem. Here's a small test case to make sure this isn't a version difference between us. Can you see if this works? # In psql: CREATE TABLE datetest(id SERIAL PRIMARY KEY, thedate timestamp); [using date rather than timestamp works fine, too] INSERT INTO datetest (thedate) VALUES ('2001-04-01'); # ZSQL Statement "select" # no arguments or parameters SELECT id, thedate FROM datetest # Pyscript "pyscript" # one parameter: "thedate" m = thedate.Month() return "%s is the cruellest month" % m # dtml method "dtml" <dtml-var standard_html_header> <dtml-in select> <dtml-var "pyscript(thedate)"> </dtml-in> <dtml-var standard_html_footer> View "dtml" and I get "April is the cruellest month" If this works, can you send me a .zexp of your ZSQLMethod, Python Script, and DTML Method, plus SQL DDL to create a table like yours? Joel BURTON | joel(a)joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant > -----Original Message----- > From: thawes(a)ncmail.net [mailto:thawes@ncmail.net]On Behalf Of Tim Hawes > Sent: Tuesday, March 12, 2002 9:11 AM > To: Joel Burton; zope(a)zope.org > Subject: Re: [Zope] Datefields > > > Joel Burton wrote: > > > On Mon, 11 Mar 2002, Tim Hawes wrote: > > > > > ZPsycoPG returns datefields from postgress in yyyy/mm/dd format, while > > > postgres' default is yyyy-mm-dd. I need to pass a date to > python script > > > for comparison w/ other datefields, but Zope apparently will not allow > > > values to be passed with '/'s in them. Can I change the way > ZPsycoPG is > > > returning the date fields in the database? How? > > > > Zope has no problem with passing a string like "2001/01/01" to a Python > > Script. Why do you think that Zope will apparently not allow > values to be > > passed with "/" in them? > > > > > > Zope Error > > Zope has encountered an error while > publishing this > resource. > > Error Type: TypeError > Error Value: unsupported operand type(s) for / > > Traceback (innermost last): > File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, > line 150, in > publish_module > File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, > line 114, in > publish > File /usr/local/zope/2.5.0/lib/python/Zope/__init__.py, line 158, in > zpublisher_exception_hook > (Object: Projects) > File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 98, in > publish > File /usr/local/zope/2.5.0/lib/python/ZPublisher/mapply.py, line 88, in > mapply > (Object: ChangeProject) > File /usr/local/zope/2.5.0/lib/python/ZPublisher/Publish.py, line 39, in > call_object > (Object: ChangeProject) > File /usr/local/zope/2.5.0/lib/python/OFS/DTMLMethod.py, line 127, in > __call__ > (Object: ChangeProject) > File > /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_String.py, line > 473, in __call__ > (Object: ChangeProject) > File > /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_In.py, line 695, > in renderwob > (Object: ProjectsUpdateResultMethod) > File > /usr/local/zope/2.5.0/lib/python/DocumentTemplate/DT_Util.py, line 159, > in eval > (Object: compare_datefield('start_',proj_start)) > (Info: compare_datefield) > File <string>, line 2, in f > File > /usr/local/zope/2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line > 252, in __call__ > (Object: compare_datefield) > File > /usr/local/zope/2.5.0/lib/python/Shared/DC/Scripts/Bindings.py, line > 283, in _bindAndExec > (Object: compare_datefield) > File > /usr/local/zope/2.5.0/lib/python/Products/PythonScripts/PythonScri > pt.py, line > 291, in _exec > (Object: compare_datefield) > (Info: ({'script': <PythonScript instance at 1235610>, 'context': <r > instance at 1383f28>, 'container': <Application instance at dd8220>, > 'traverse_subpath': []}, ('start_', DateTime('2002/02/25')), {}, None)) > File Script (Python), line 50, in compare_datefield > File Script (Python), line 12, in cdate > File /usr/local/zope/2.5.0/lib/python/DateTime/DateTime.py, line 668, in > __init__ > File /usr/local/zope/2.5.0/lib/python/DateTime/DateTime.py, line 276, in > _calcSD > TypeError: (see above) > > > When I try to put this value in when I test the python script > 'compare_date', > it has no problems. I pass the value in dtml, I get this error. > This is what > has led me to believe that the problem is in how Zope handles it. > > Now, looking at it, perhaps the problem is in how I am calling it in dtml? > Here is the dtml code that I use inside a database query sequence: > <dtml-var expr="compare_datefield('start_',proj_start)"> > The first parameter is for an input tag variable name that is > prepended to the > default, the second (proj_start) is a dtml var containing a > datefield for the > script to compare. The end result is html code containing > individual selection > boxes for day, month and year, w/ the default selection at what > is already in > the database. I have another version of this script working that > compares the > DateTime() value with all date > ranges to produce defaults for the current day, month, and year, and > compare_date() does the same thing > except that it creates a new DateTime() object from the second > parameter that > is passed to it.

2 3

RE: [Zope] Inserting values into db - problems
by Joel Burton 13 Mar '02

13 Mar '02

Wayne -- Please cc the zope(a)zope.org when you respond to me; other people may find this help useful. > <dtml-raise type="client"> > </dtml-raise> > insert into y8 values( > now(), > now(), > <dtml-sqlvar client type="string">, > <dtml-sqlvar product type="string">, > nextval('y8_number'), > <dtml-sqlvar description type="string">, > <dtml-sqlvar clientJobNumber type="string">, > <dtml-sqlvar clientPoNumber type="string">, > <dtml-sqlvar clientContact type="string">, > <dtml-sqlvar techContact type="string">, > <dtml-sqlvar jobCloseDate type="string"> > ) make that <dtml-raise type="client"> <dtml-var client> </dtml-raise> So that we see the actual output of the client variable. One small idea: it's possible that "client" is a meaningful word to Zope. Might want to change the parameter & dtml-sqlvar to "theclient" or somesuch and see what happens. > > Don't understand the question about an if block? What are you > talking about? > > On the zope site, the example I saw is as follows : > > <dtml-if "balance >= debit_amount"> > <dtml-call "debitAccount(account)"> > Your account, <dtml-var account>, has been debited. > <dtml-else> > <dtml-raise type="Insufficient funds"> > There is not enough money in account <dtml-account> > to cover the requested debit amount.<p> > </dtml-raise> > </dtml-if> > > So I am trying to work out if I have to test the value and then do a > dtml-raise if it fails, inside a dtml-if block as the example does... Normally, dtml-raise would be used to raise an error manually if something bad happens, so, yes, it would often be used with dtml-if. However, you can use it yourself for debugging purposes, and it's quite useful like this.

2 1

Re: [Zope-Packagers] Re: Zope 2.5.0 RPMS was Re: [Zope] What causes the community to stall so often?
by Matt Behrens 13 Mar '02

13 Mar '02

Hi guys, wasn't aware anyone was listening on this list, judging from the archives :-) Sorry I missed the zope@ thread, I don't subscribe anymore because the traffic level is (used to be?) a recipe for insanity. As Paul hinted at, I'm currently working on revamping the build, installation, and instance management processes for Zope 2.6, based on existing work. I have a vested interest in this because I build the OpenBSD package, which currently installs the software home into $PREFIX/lib/zope and includes a script to build an instance home for you. I want to expand on this. I don't know what your timetables are, but if you're in the process of rethinking this, wait till the weekend is past, I should have something by then. What I do come up with will most likely be able to be used with 2.4 and 2.5. and it'll mean you don't have to do it again for 2.6. :-)

1 0

Re: [Zope] What causes the community to stall so often?
by BZ 13 Mar '02

13 Mar '02

I am not sure if it is the community stalling so much as hitting the peaks and valleys of the development cycle. Besides, the Zope Corp people I am sure that most of us have full time (or at least part time) jobs that are non Zope. I have had mostly-full time Zope jobs and when I was doing that I was more involved in writing tips, how-tos, products, etc. I think Zope documentation (not the Zope product) suffers from the critical mass. There has to be enough people in the pot to be able to both develop and document. Right now, most of us are focusing on developing products, applications, websites and not on documentation. It is also clear that documentation itself does not provide income. If I build out another website in Zope, I can build a community and another revenue source. If I write a how-to, well, I get a gold star in the community (maybe) and it that good open source "warm feeling." So, it comes down to economics. That being said, there are now 3 (maybe 4) books out there on Zope and I can easily remember the day when there was a total of 0. There are more and more products being developed and not just stupid discussion boards :) but real, meaty products that people can make money with. That trend is a good trend. As the economy picks back up, there will be more work for consultants, more consulting and more demand and production of documentation. Do we need more books, websites, help areas, FAQ's, etc? Yes. Will they come? Yes. I have at least two of those in (not telling which ones) in the works. But time is money and money is the key. BZ

22 55

RE: [Zope] Inserting values into db - problems
by Joel Burton 13 Mar '02

13 Mar '02

Put it in the ZSQL Method; that way we can see *exactly* what it gets. Then: * can you test the ZSQLMethod (with the test tab) and have it work? * can you call the ZSQLMethod w/a hand-crafted URL and does it work? Don't understand the question about an if block? What are you talking about? Joel BURTON | joel(a)joelburton.com | joelburton.com | aim: wjoelburton Knowledge Management & Technology Consultant > -----Original Message----- > From: Wayne Pascoe [mailto:wayne.pascoe@ehsrealtime.com] > Sent: Wednesday, March 13, 2002 8:42 AM > To: Joel Burton > Subject: Re: [Zope] Inserting values into db - problems > > > On 13/3/02 1:26 pm, "Joel Burton" <joel(a)joelburton.com> wrote: > > > Hmm. I don't see anything wrong. > > > > Try putting a <dtml-raise> in your method with that will show > you the value > > of "client". It might be obvious once you see what it thinks client is. > > > > BTW, small point: now() is deprecated syntax in PostgreSQL. In > the future, > > you want to use CURRENT_TIMESTAMP (not a function, no parens), > which is the > > SQL standard compliant. > > Stupid question - Where would I put the dtml-raise ? Does it go in the > dtml-document that calls the Z SQL method or does it go in the Z > SQL method > ? > > Also, do I have to use an if block like in the example at Zope ? > > Thanks, > > -- > Wayne Pascoe <wayne.pascoe(a)ehsrealtime.com> > > The price of freedom is eternal vigilance > - Thomas Jefferson >

1 0

Redirecting
by Antonio Beamud Montero 13 Mar '02

13 Mar '02

Hello again: I have a form, and the action of this form is used by some forms in diferent parts of my site, I want to redirect te return of this action to the proper site... I have done something like this: def process(self, name, REQUEST=None): ... (blah, blah, blah...) if REQUEST is not None: return REQUEST.RESPONSE.redirect(REQUEST.get('HTTP_REFERER')) Is the correct form? Thanks. -- Microsoft merges technologoies: Windows CE + Windows ME + Windows NT = Windows CEMENT ---- Antonio Beamud Montero Agora Systems S.A. http://www.agoratechnologies.com

1 0

Inserting values into db - problems
by Wayne Pascoe 13 Mar '02

13 Mar '02

Hi all, Part of a site I'm working on needs to be able to insert job numbers into a database. I'm using PostgreSQL as the backend and psycopg as the connecter. I am able to select values from the database without problems. However, I can insert anything. I have a dtml document that prompts for values called addJobNumber. This has an action of another dtml document named commitJob. commitJob has a dtml-call to insert_job which is a Z SQL method. The Z SQL method is as follows: insert into y8 values( now(), now(), <dtml-sqlvar client type="string"> <dtml-sqlvar description type="string">, <dtml-sqlvar product type="string">, nextval('y8_number'), <dtml-sqlvar description type="string">, <dtml-sqlvar client_job_number type="string">, <dtml-sqlvar client_po_number type="string">, <dtml-sqlvar client_contact type="string">, <dtml-sqlvar tech_contact type="string">, <dtml-sqlvar job_close_date type="string"> ) When I try this, I get an error saying : Missing input variable, client Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 114, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 158, in zpublisher_exception_hook (Object: localhost) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 98, in publish File /usr/local/zope/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: commitJob) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: commitJob) File /usr/local/zope/lib/python/OFS/DTMLDocument.py, line 127, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: commitJob) File /usr/local/zope/lib/python/Shared/DC/ZRDB/DA.py, line 414, in __call__ (Object: insert_job) File /usr/local/zope/lib/python/DocumentTemplate/DT_String.py, line 473, in __call__ (Object: <string>) File /usr/local/zope/lib/python/Shared/DC/ZRDB/sqlvar.py, line 99, in render (Object: client) Missing Input: (see above) If I remove the dtml-call in the commitJob document and just print each value using <dtml-var client><br><br> All values print as expected (as entered on the previous form) Is there anything obvious that I'm missing here that could be causing this problem ? TIA, -- Wayne Pascoe <wayne.pascoe(a)ehsrealtime.com> The price of freedom is eternal vigilance - Thomas Jefferson

2 2

STATISTIC] Is there a way to have statistic of a Zope site use ?
by Fr�d�ric Lemaitre 13 Mar '02

13 Mar '02

Hello, A have my Intranet Zope production site since few days (GREAT !!!). I would like to know if there is a way (without manualy analyse the access log) to know : - How many users have been authentified since the site is on-line ? - How many times a page has been seen ? - The top visited pages ? - Statistic of when, how much, etc.. users use the site ? In fact, is there a Zope functionnality to do something like that whithout using an other software (like Webtrend) ? Thanks in advance. Fred.

4 3