- Zope - Zope lists

Zope, Apache/NT, Reliability issues
by Fabio Akita 09 Jun '00

09 Jun '00

Hello I am a developer and we are studying the possibility of adopting Zope as a production platform for our clients. Actually I use PHP, Perl and ASP as server-side "platforms" and I will also be testing WebObjects although I have to say that Zope interested me much more as a programmer ^_^ Until now I have read lots of documentations, DTML looks good enough and I learned a lot about Python. But there are still some doubts that no online document could solve easily. Concerning the installation I´d like to know if anyone knows (or knows some document that details about) the essencial differences between the many ways of installing Zope. I´ve used the ZServer in stand alone mode and I also have implemented the easy Proxy Reverse trick in Apache. I will try FastCGI and PCGI as soon as possible, but I have some doubts now. My test platform is a Windows NT 4 running Apache 1.3.12. The first doubt comes to the fact that I could not find the pcgi module for NT (I do not have any kind of C compiler, so I´ll be very glad if anyone know a binare version). So I´d like to know where can I find informations about installing Zope using PCGI in an NT Apache installation. The second doubt: what exactly are the differences of running it in PCGI mode or in ZServer? I do understand the concept of forking a process and interfacing a web server and a process through a CGI interface as PCGI and I also understand the fact of the multithreading feature in ZServer. Basically it would mean that each connection request will fork a new Zope connection and then maintain it in some kind of a connection pool (as databases do)? Or will there be only one process running Zope and a queue of requests to access it? What are the performance impacts, what are the hardware (memory/CPU) impacts? Personally I do not like the concept of CGI but know nothing about the Persistent CGI concept. And what about the method of "masquerading" the ZServer through Apache? I have read solutions using the Rewrite module and the Proxy module, but it actually means (roughly speaking) that if there are 10 requests made to Apache then it will make 10 requests to ZServer so, considering only the reliability issue of the server even if Apache can handle millions of requests per second, the ZServer would fall down much faster than that so I cannot see any advantage of using Apache in front of it. Of course I understand the other advantages of Apache as it´s many configuration options, robustness as a web server, etc, but can the ZServer stay up and running in pair with Apache? Maybe there´s any way to configure Apache to cache the pages -- as a Squid would -- so it can "filter" the requests and low the requests level that it will do to ZServer? And what about it´s object oriented database? I also have some doubts about it. I worked a lot with relational databases as MS SQL and MySQL but never tried to study an OO approach to DB. How fast it is? How much requests can it handle without hanging, collapsing or corrupting data? I mean, anyone tried to do some study of a database that changes everytime and have queries everytime, I mean, searches in a database where it´s data changes constantly (searching a static database is much different than searching on a mutable one). Row level locking, transaction, consistency, etc, all these concepts apply here? Can it be substituted by a traditional relational database and have it´s contentes interfaced to "looks like" object oriented? The reliability issue is important as I would´t like to have to write a cron to verify if the server is up and running and, if not, kill all of it´s processes and start all over again. It´s not professional, it´s just an ugly band-aid. Actually the PCGI module for NT is not that important as I do prefer working with Apache on Linux but some of our clients prefer working on NT as much of it´s products are already up and running on NT, so Zope on NT would be the preferred option (is Zope+NT as stable as Zope+Linux, only talking about the web server robustness). Well, these are my doubts for now. Thanks for the attention. I hope we can do some interesting discussion. []´s Fabio Akita - Developer F/Nazca S&S / Adversiting

5 5

Re: [Zope] mssql system dsn hangs causing zope to be no more
by julio dinis 09 Jun '00

09 Jun '00

I'm using 2.1.6. Regards, Julio >From: "Harald Ragger" <h.ragger(a)aon.at> >To: "julio dinis" <juliodinis(a)hotmail.com> >CC: "Zope List" <zope(a)zope.org> >Subject: Re: [Zope] mssql system dsn hangs causing zope to be no more >Date: Thu, 8 Jun 2000 18:02:33 +0200 > >Julio: >what version of zope do you run? > >harald >----- Original Message ----- >From: "julio dinis" <juliodinis(a)hotmail.com> >To: <zope(a)zope.org> >Sent: Thursday, June 08, 2000 1:49 PM >Subject: [Zope] mssql system dsn hangs causing zope to be no more > > > > Hi Zopistas! > > > > After some time of heavy use of the site the > > zserver goes zombie, and even restarting will put zope > > automatically zombie, never more. > > > > If I remove the system dsn I use with zodbc and restart zope, > > then zope runs like a ferrari. I than create again the odbc system > > dsn and everything is back again. > > > > But some time after the zombie arise from the grave :-( > > > > I'm looking at logs. > > Anyone with this problem? > > > > Júlio Dinis Silva > > ________________________________________________________________________ > > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > > > > > _______________________________________________ > > 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 ) > > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Zope.org Hidden Stats
by J. Atwood 09 Jun '00

09 Jun '00

Just making my daily visit to Zope.org and stumbled across the statistics at http://www.zope.org/About/Statistics Very nice... There is a bunch more on the about page http://www.zope.org/About/ Cheers to DC and letting us see what they are doing behind the scenes.... How are you going to spend that $1,000 when you get ZEO working? :) JMA

4 7

problem in creating portal
by P Chandra Sekhar 09 Jun '00

09 Jun '00

Hi everybody, Right now I'm trying to create Portal. I've established the ODBC database connection and ZSQL method every thing is working fine. The problem in creating portal is , in second page of wizard I've not seen any info regarding members(theme, layout, public view) as it mentioned in document, it has only design scheme. In third page I've provided all the info including portal manager.After clicking finish button I'm getting the error like this..... Zope Error Zope has encountered an error while publishing this resource. Error Type: sql.error Error Value: ('S0002', 208, "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'users'.") Troubleshooting Suggestions The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 214, in publish_module File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 179, in publish File C:\PROGRA~1\WebSite\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 165, in publish File C:\PROGRA~1\WebSite\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\OFS\DTMLMethod.py, line 150, in __call__ (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: Portal_add) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_With.py, line 148, in render (Object: Portal.createInObjectManager(REQUEST['id'], REQUEST)) File C:\PROGRA~1\WebSite\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: apply_wizard(REQUEST)) (Info: REQUEST) File <string>, line 0, in ? File C:\Program Files\WebSite\lib\python\Products\PTKDemo\Portal.py, line 248, in apply_wizard (Object: DemoPortalBase) File C:\Program Files\WebSite\lib\python\Products\PTKDemo\Portal.py, line 172, in addMember (Object: DemoPortalBase) File C:\PROGRA~1\WebSite\lib\python\AccessControl\User.py, line 501, in _addUser (Object: DemoSQLMemberFolderBase) File C:\Program Files\WebSite\lib\python\Products\PTKDemo\SQLMember.py, line 92, in getUser (Object: DemoSQLMemberFolderBase) File C:\PROGRA~1\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 430, in __call__ (Object: sqlUserQuery) File C:\Program Files\WebSite\lib\python\Products\ZODBCDA\db.py, line 198, in query sql.error: (see above) .... Can any body help me..what to do next... Thanks in advance.... Chandra Sekhar. P Version details: Zope version: Zope 2.1.6 (binary release, python 1.5.2, win32-x86) Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform: win32

1 0

Re: [Zope] Urgent Help Required- Installation
by System Administrator 09 Jun '00

09 Jun '00

Hi Daryl this did not work. it gave a conflict with the exisiting installed packages. On Fri, 9 Jun 2000, Daryl Tester wrote: > python-devel is an RPMism (which means you won't find it on python.org) > On my RedHat 6.1 box, it's python-devel-1.5.2-7.rpm . chkconfig, > according to "rpm -qf `which chkconfig`", is owned by chkconfig-1.0.7-2. > > > Regards, > Daryl Tester > Parag Mehta <admin(a)puretech.co.in> System Administrator. Puretech Internet Pvt. Ltd. http://puretech.co.in/ 77 Atlanta. Nariman Point. Mumbai - 400021. India. Tel: +91-22-2833158 ============================================================ Support is now available thru our Web Based Support System. http://support.puretech.co.in ============================================================

1 0

RE: [Zope] Q: Accessing ZSQL methods from Python
by a.wacknitz＠francotyp.com 09 Jun '00

09 Jun '00

> -----Original Message----- > From: Dieter Maurer [mailto:dieter@handshake.de] > Sent: Thursday, June 08, 2000 10:21 PM > To: a.wacknitz(a)francotyp.com > Cc: zope(a)zope.org > Subject: Re: [Zope] Q: Accessing ZSQL methods from Python > > > a.wacknitz(a)francotyp.com writes: > > my question is what type or value is returned by a ZSQL > method that is > > invoked from Python? > ZSQL methods return "Shared.DC.ZRDB.Results.Results" instances. > Such an instance essentially behaves like a sequence of > objects each describing one result row. > These objects have been set up such that a column value > can be accessed as attribute with the column name. > Thus, "results[i].column" gives the value of "column" of > the i.th row. Yes, that works fine. But I need to know of NULL values. > > How to determine, how "Null" values are recognized, > is less a Zope than a database adapter question. > I would expect, that most (if not all) database > adapters will map SQL Null to None. That was what I thought but at least ZODBC won't do this. What I have found out is, that repr(SQL NULL) == 'Missing.Value'. > > However, even some well established SQL databases do not > treat Null standards-conform but represent it as > the empty string. Then, the database adapter has > no chance to map this to None but must use '', too. ZODBC won't do this either. > > > Dieter > Andreas ********************************************************************** This email message has been swept by MIMEsweeper for the presence of computer viruses. Francotyp-Postalia AG & Co.

1 0

ANN: ZUBB 0.3.2 (Zope Ultimate Bulletin Board)
by J. Atwood 09 Jun '00

09 Jun '00

http://www.zope.org/Members/BwanaZulia/ZUBB/ A few bugs fixed. A few more features added. Almost ready for prime time. Take a look and email me with your comments. If you are using it and would like to be linked to as an "example" site please send me the url. The idea is to make sure the release works and then submit it for cataloging on Zope.org. Thanks, J

4 5

unsubscribcription
by rapha�l zamochnikoff 09 Jun '00

09 Jun '00

hello ! i would like to unsuscribe the zope mailing list as soon as possible, because the end of my training course comes near. thanks in advance ! raphael zamochnikoff ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Urgent Help Required- Installation
by System Administrator 09 Jun '00

09 Jun '00

Hi can anyone help with the following errors : error: failed dependencies: python-devel is needed by Zope-2.1.6-1 /sbin/chkconfig is needed by Zope-2.1.6-1 i'm using suse6.4 linux box wherein i have installed all the available python packages. i also tried to search python.org for python-devel package but couldn't find it. awaiting a reply at the very earliest, regards. Parag Mehta <admin(a)puretech.co.in> System Administrator. Puretech Internet Pvt. Ltd. http://puretech.co.in/ 77 Atlanta. Nariman Point. Mumbai - 400021. India. Tel: +91-22-2833158 ============================================================ Support is now available thru our Web Based Support System. http://support.puretech.co.in ============================================================

1 0

Wrong mime type sent by Zope on every page
by dillera＠isc.upenn.edu 09 Jun '00

09 Jun '00

Hello: It was just brought to my attention that Zope (using Zserver) is sending the wrong MIME type of all its pages. Here is the header from zope: (some lines have been cut) ------------------ HTTP/1.0 200 OK Server: Zope/Zope 2.1.6 (source release, python 1.5.2, linux2) ZServer/1.1b1 Date: Thu, 08 Jun 2000 15:45:23 GMT Ms-Author-Via: DAV Content-Type: application/octet-stream Last-Modified: Thu, 8 Jun 2000 15:45:07 GMT Here is one from apache: ------------------------- HTTP/1.1 400 Bad Request Date: Thu, 08 Jun 2000 15:29:59 GMT Server: Apache/1.3.6 (Unix) Content-Type: text/html I want Zope to be sending text/html, as some browsers want to download the page rather than view it. I haven't discovered anywhere to configure this. I read the Setting the MIME Type of a DTML Method http://www.zope.org/Members/anser/howto_dtml_mimetype which claims that you can set the mime type of a method by putting it at the top of the method. I did this on a test page, but still received the same header from Zope. Can someone shed some light on this? 1. how to set the mime type for all methods and documents of Zope 2. What is the Ms-Author-Via: DAV in the Zope header? WebDAV? thanks, andy diller

4 6