- Zope-Dev - Zope lists

Re: [Zope-dev] ODBC on linux
by Gabor Melis 02 Feb '00

02 Feb '00

In a possible future scenario, I may have a Zope server running on linux while having an oracle db on a vms machine. I wanted to make sure this can be easily set up without having to deal with oracle stuff. That's why I asked for ODBC first. In fact ODBC is preferable to me because there may be even (god help us all) Access dbs. Gabor On 02-Feb-00 MIME :phd@phd.russ.ru wrote: > On Wed, 2 Feb 2000, Gabor Melis wrote: >> On a slightly different note, is there a way to connect to an >> oracle db on another computer *without* having any oracle specific >> libraries? > > I am sure there is no. Why do you need it? > > Oleg. > ---- Oleg Broytmann Foundation for Effective Policies > phd(a)phd.russ.ru > Programmers don't die, they just GOSUB without RETURN. > > > _______________________________________________ > Zope-Dev maillist - Zope-Dev(a)zope.org > http://lists.zope.org/mailman/listinfo/zope-dev > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope )

2 1

Zope hanging on high loads
by Federico Di Gregorio 02 Feb '00

02 Feb '00

Hi, we are using Zope to develop some pretty complex web-sites (http://www.tradinglab.com) and we are encountering some serious problems with high loads. apparently, sometimes, zope does not answer to the pcgi-wrapper and after some minutes we have tens (60+) of pcgi-wrapper processes hanging with only a few in the "ready" state. all the others are sleeping waiting for zope to answer. that happens with every version of zope from 1.0.0 up. if there is some acrtion I can take to send you a more informative bug report, please let me know, thank you very much for your time, federico -- Federico Di Gregorio MIXAD LIVE System Programmer fog(a)mixadlive.com Debian GNU/Linux Developer & Italian Press Contact fog(a)debian.org Best friends are often failed lovers. -- Me

3 4

ZServer and SSL
by Lalo Martins 02 Feb '00

02 Feb '00

Ng Pheng Siong has released a version of ZServer that works with SSL. http://www.post1.com/home/ngps/m2 (there are python modules for SSL there too.) []s, |alo +---- -- I am Lalo of deB-org. You will be freed. Resistance is futile. http://www.webcom.com/lalo mailto:lalo@webcom.com pgp key in the web page Debian GNU/Linux --- http://www.debian.org Brazil of Darkness -- http://zope.gf.com.br/BroDar

1 0

Re: [Zope-dev] How to insert time use mysql connection!
by Victor.Zhai＠ogilvy.com 02 Feb '00

02 Feb '00

Dear: What you said is just the requirment of my project, I want to one field is an auto increment integer when user use one form to add something into my database. Should I modify my database structure.Make Null the first fields of the database? is there any other method to do that? How to realize the auto increment integer? Please give me some advice. Thanks a lot! Victor zhai. "WorldSecure Server <ogilvy.com>" made the following annotations on 01/31/00 22:49:42 ------------------------------------------------------------------------------ Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it. ==============================================================================

2 1

How to use the PropertySheets-Class
by Martin Grönemeyer 02 Feb '00

02 Feb '00

For serveral reasons I want to implement propertysheets without using explicitly a ZClass. I found the PropertySheets.py - Module and played around with it but without good results. If I define something like ' propertysheets = PropertySheets() ' in my class, I'm able to add PropertySheets in the url or in the __init__ - Method of my class (self.propertysheet.addPropertySheet(self.mysheet)) but if i want to 'manage' this sheet, I get a permission defnied. So, my question: has anybody a small and basic implementation of the PropertySheets-Class with serveral propertysheets from wich I can learn ? Thanks, Martin

1 0

Re: Per-user Oracle connections (fwd)
by Oleg Broytmann 02 Feb '00

02 Feb '00

Hi! Nobody seems able to answer, trying to repost... On Tue, 18 Jan 2000, Jim Fulton wrote: > > I have an Oracle database, and by design every user that logs into the > > site will be connected to the DB with his/her login/password (that is, > > his/her Oracle login/password is the same as for WWW). > > > > I am considering using Zope for the site, but the question is - how can > > I create one ZOracleDA connection for every user, and how can I use diferent > > connections for different users? > > You can't. However, you could create a new kind of connection > object that did this for you. This should be a reasonably > straightforward hack of ZOracleDA: > > - Take a database name through the web. Not a database name - it's fixed - but login/password. Well, I can do it, but how can I pass this information to Connection object? Well, recently I read the code for Postgres, MySQL and Oracle adapters, and a lot of code in lib/python/Shared/DC/ZRDB, so I thing I do understand what is Connection object, adapter and so on.` It seems I need to write a Connection object based on Shared.DC.ZRDB.THUNK.THUNKED_TM or Shared.DC.ZRDB.THUNK.TM, maintain a pool of actual database connections, and pass queries down to db_connection.query(). But how can I find the db_connection? It is an object from my pool of connection, but I need to know 2 things: 1) login/password; I thing the pool will be just a dictionary indexed by (login, password) tuples. Does this information available in the query() method? I can stuff login/password into a REQUEST object, but is the REQUEST object available in the query() ? 2) whether the connection is actually running a query; if the query is in the process - I need to open new connection for the same user. How do I ask the connection object "Are you running a query"? Oleg. ---- Oleg Broytmann Foundation for Effective Policies phd(a)phd.russ.ru Programmers don't die, they just GOSUB without RETURN.

2 2

Question about external method or python method!
by Victor.Zhai＠ogilvy.com 02 Feb '00

02 Feb '00

Hi.all In my project, I want to realize one function that: Verify Username and password form UserInform Database and if the input is correct,then turn to one page. Else warning the user and exit. Now I use external method can only return the result "select * from UserInfor where username=<dtml-var username> and password=<dtml-var password>" and it can return the record if exist.Or use Sql method do the same thing. But I want to know that to the correct page due to different conditions. Like this: If exist user then Page one Else Page two , warning mesages End. If use ESQL I can do it better ,But now it is Zope! And I am beginer. Can some one help me! or give me some advice. Thanks a lot! Victor zhai. "WorldSecure Server <ogilvy.com>" made the following annotations on 02/01/00 22:14:04 ------------------------------------------------------------------------------ Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the Ogilvy Group shall be understood as neither given nor endorsed by it. ==============================================================================

1 0

[ANNOUNCE] ZServerSSL and Encrypting Monitor
by Ng Pheng Siong 01 Feb '00

01 Feb '00

Hello, I am pleased to announce the release of M2Crypto 0.03. M2Crypto = Python + OpenSSL + SWIG. It makes accessible to the Python programmer DH, DSA, RSA, symmetric ciphers, message digests, HMACs and sufficient SSL functionality to implement servers and clients. Of interest to the Zope community will be the Zope 2.1.3-compatible HTTPS server and encrypting Medusa monitor, and XMLrpc-over-HTTPS. M2Crypto is available here: http://www.post1.com/home/ngps/m2 Feedback is most appreciated. -- Ng Pheng Siong <ngps(a)post1.com> * http://www.post1.com/home/ngps

1 0

'object based' Zope editing (repost)
by Rik Hoekstra 01 Feb '00

01 Feb '00

I suspect that everyone was away at IPC8 when I posted this mail, so I repost it here. (Unless, of course this is a subject no one is interested in or it's utter nonsense ;-)) Wysiwyg Zope editing possibilities has come up in the list more than once. Unless I understand the Zope Mozilla project wrongly, it seems to offer no solution, let alone a standardized one, as Johann Carlsson (the inventor of ZIE) is using XML-RPC for editing. The Zozilla and especially the ZopeStudio project offers some interesting points, though. Now I may be completely mistaken here, as I only half understand everything that has been going on. If so, flame me, and stop reading. If not, read on, and please bear with me, cause this turned out to be a lengthy analysis. The question of wysiwyg comes up on the list frequently, though. And it is certainly not solved, let alone in a portable way. The question of editing and the apparent difficulty of rendered editing vs source editing has been proposed as a fundamental objective to editing Zope html documents/objects ;-) in wysiwig editors. Let's for a second leave aside, whether wysiwyg editors are at all desirable and which. After pondering the question for some time I _think_ I may have a solution. It was triggered by an article of John Aycock and Michael Levy, "An Architecture for Easy Web Page Updating" in Crossroads <URL: http://www.acm.org/crossroads/xrds6-2/updating.html>. They state that the 'atomic document' is a myth and that 'a document is the fundamentally wrong level of abstraction for web page updating'. Then they go on to an architecture which breaks apart a document into editable regions and store these into a dbm-database. The documents are retrieved through a http like protocol (called UTTP and invented by the authors) and edited in a special client. Aycock and Levy's proposal sounded to me as if Zope has provisions for most of this already, but I would propose this could also be achieved through a web-based system. A dtml document is already composed of 'sections' (namelijk html and dtml sections). They can seen as a collection of objects (both real zope objects and section objects) that are together rendered as a html/xml/pdf/whatever document. The dtml object is -in fact- divided into 'inside-document' and 'outside-document' sections. All <dtml-var> related tags are 'outside document' sections and the other <dtml-...> tags are 'inside-document' sections. That is to say, the var tags _themselves_ are inside document, their content is outside document. At the moment, the sections are not visible inside the rendered document. Moreover dtml always either renders the whole document, or it does not, except for the inclusion of <dtml-var>'s that are called as 'not rendered'. >From a site-development point of view the different sections are editable by people with different abilities. In Zope terms these abilities are translated into roles: content managers and designers, dtml programmers, sql programmers. Content managers should not be bothered with dtml, programmers should be programming one object at a time. An example: a content manager or designer should not have to be able to edit <dtml-if> tags or occupy himself with namespace issues. It _is_ nice for him to see what other content there is on the page he is designing for and what layout he is designing in. If he uses a wysiwyg editor _and_ a the site has a global stylesheet, it would be a good idea if the stylesheet was included at the time of entering content. The server (Zope) should handle that. What stands in the way of making sections editable is not, in my analysis, the dichotomy between document and object, but the fact that in developing in Zope you are dealing with either rendered documents or non-rendered objects/dtml-templates and never with partially rendered document/template hybrids. Or, in fact you are: the Zope management interface where you edit, say, a DTML Document, _is_ such a hybrid: the management interface itself is rendered while the document is not. The hybrid is just not extended beyond the boundaries of the dtml-template. But there is no real reason to do so as (1)Zope encourages factoring common content and (2) a document is in fact a collection of objects or regions. Because and as long this is so, Zope editing is confined to the dichotomy. What should be done to overcome the problem (an example is under the points> is (as I see it) to 1. devise a way to indentify sections in rendered documents. This could be done by making the rendering machinery mark the begin and end of a tag in the rendered version. 2. devise a way to treat sections as objects and make the objects editable _or_ rendered on basis of the roles of an developer. As far as I can distinguish it, this involves the following steps, but please correct me if I'm mistaken or : * Rendered and non-rendered sections should be included in one document. * Only non-rendered objects should be designated as editable. * Rendering (in editing view) is conditional on (1) the role of the current user (manager, content manager, designer etc)) (2) the needs of that user. In other words: the 'editing view' of a dtml object should show a user: a) which parts of a dtml template would be editible to him and b) he should be able to choose whether to render these object/sections or to edit them. * Outside-documents should alway be fully rendered. They should be treated as atomic. * This obviously means that the updating/uploading machinery should also be able to discern between the editable and non-editable sections. For this a simple block parsing mechanism (possibly derived from the dtml parser itself) should be used. * In order to keep track of what sections/objects of the document in question to update the uploading machinery should have knowledge of what was sent to the client (in whatever form). This will probably be the hardest part to figure out. It could be done by cookies, by including rdf in the document or in its header, and/or by editing in a session-like environment. What could and should be done in this case depends on the client that is used for editing. Therefore, the basic machinery should be the same, but it should have a possibility to plug-in different client-specific interfaces. This seems a very Zopish way to treat the problem. * A few thoughts/proposals for the Zope management interface: in the conventional Zope management interface this could easily be done by including textareas on the spot where an editable object is located. Or the document would be presented as a tree to the user, much in the way XMLDocument is now. This would also allow us to have 'collapsable regions' like many programming editors have (or at least this should be possible in the Zope Management interface and in Mozilla). pff. That was much more than I anticipated. I hope I have made my point clear. I wanted to discuss this, before I gave the idea a shot. A few questions beforehand: - is this a sensible approach to solving the rendered document vs object dichotomy - if so, what would be the best way to implement this? I was thinking of a product that would be called whenever the edit view of a dtml object was called. The product would handle the whole round trip from rendering to updating/uploading, including the parsing of the object. Is this feasible, or did I oversee something that would imply a much deeper reworking of the Zope machinery? Rik

1 0

Structured text + ~s in URLs...
by Edward Jason Riedy 01 Feb '00

01 Feb '00

Structured text doesn't like ~s in URLs. It should. Jason --- StructuredText.py.orig Mon Jan 31 19:00:29 2000 +++ StructuredText.py Mon Jan 31 19:00:30 2000 @@ -473,7 +473,7 @@ aStructuredString = gsub( '\"\([^\"\0]+\)\":' # title: <"text":> - + ('\([-:a-zA-Z0-9_,./?=@#]+%s\)' + + ('\([-:a-zA-Z0-9_,./?=@#~]+%s\)' % not_punctuation_or_whitespace) + optional_trailing_punctuation + trailing_space, @@ -482,7 +482,7 @@ aStructuredString = gsub( '\"\([^\"\0]+\)\",[\0- ]+' # title: <"text", > - + ('\([a-zA-Z]*:[-:a-zA-Z0-9_,./?=@#]*%s\)' + + ('\([a-zA-Z]*:[-:a-zA-Z0-9_,./?=@#~]*%s\)' % not_punctuation_or_whitespace) + optional_trailing_punctuation + trailing_space,

2 1