- Zope - Zope lists

Re: [Zope] Add a Document from an existing File
by Dieter Maurer 07 Mar '01

07 Mar '01

Steffen Bergmann writes: > Does anybody know how to add an DTML Document with uploading the > contents from a local File on the filesystem. I need to do this in > DTML Code (or Python?) and not in the managementscreen. What do you mean with "local"? Browser local or server local? If you mean "browser local", then you want the same functionality as provided by the Zope Management Interface. I always recommend in such a case to look at the Management Interface's source code (--> list archive, where to find the source code). If you mean "server local", then you need to read the file content and use it as third parameter to "manage_addDTMLDocument". For security reasons, Zope does not support reading of local files directly. Again, the list archives will show you various ways how to achieve this. Dieter

1 0

Re: [Zope] <dtml-in item> iteration on INSERT method
by Dieter Maurer 07 Mar '01

07 Mar '01

Paz writes: > I've used the <dtml-in item> iteration many times with dbms tables and ZSQL > methods, but always in context of an UPDATE table SET where clause.... > What I WANT to do now is INSERT into table using the same item construction, > when a checkbox in a multiple record form is checked.... In principle, the construct should work the same for "INSERT" as well as for "UPDATE". Due to some HTML-weirdness, checkboxes are quite difficult to handle. They are only "successful" (and included in the form data set) when checked. Unchecked, they are "unsuccessful" and the request simply does not contain any trace of them. This may cause "Bad request" errors from ZSQL methods. There are several ways, how to work around this HTML bug (feature?): all have to do with providing default values. Maybe, the easiest (for a single checkbox) is to provide a default value for the corresponding Z SQL argument. You will find more methods in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

Re: [Zope] LoginManager & Cookie Login
by Dieter Maurer 07 Mar '01

07 Mar '01

Gerald Gutierrez writes: > I noticed that the LoginManager supports Basic Auth Login, Basic Cookie > Login and REMOTE_USER login by default. Does that mean that if I don't use > cookies, and I want a form-based login, LoginManager will not work for me? You will not have a form-based login whenever you use "Basic Authentication", neither in Zope nor with PHP. The reason is that HTTP's basic authentication is a client feature. The client pops up a dialog to obtain login information that it later includes in HTTP requests. The server can not control this dialog. More details in URL:http://www.dieter.handshake.de/pyprojects/zope/book/chap3.html Dieter

1 0

Re: [Zope] How to get the url without the domain part, using <dtml-in>?
by Dieter Maurer 07 Mar '01

07 Mar '01

Ausum writes: > Is it possible to return the absolute url without the domain/IP part, while in > an iteration? Did you try to set the optional "relative" argument of "absolute_url" to "1"? <dtml-in ...> <dtml-var expr="absolute_url(1)"> </dtml-in> Dieter

1 0

Re: [Zope] Redirection anguish
by Dieter Maurer 07 Mar '01

07 Mar '01

John R. Daily writes: > According to old mailing list archives, <dtml-raise type="Redirect"> > should tell the browser to, well, redirect. The "dtml-raise type=Redirect" wants to have an absolute URL as "error value". Thus, <dtml-raise type=Redirect>http://localhost:8080/index_html</dtml-raise> works while <dtml-raise type=Redirect>index_html</dtml-raise> does not. > According to the Zope Book, the same can be achieved via <dtml-call > expr="RESPONSE.redirect(target)"> That works fine for me in all cases. Dieter

1 0

RE: [Zope-dev] RE: ZODBC problem
by Bryan Baszczewski 07 Mar '01

07 Mar '01

Alan, I am having a similar lock-out problem while performing a complex query on SQL Server 2K. All other hits cannot connect until the query returns the results. My research has so far taken me here: http://www.zope.org/Members/petrilli/DARoadmap Which is telling me I am probably using at most a Level-2 DA with my ZODBC. And then here: http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README Which is a Level-3 mxZODBC DA (multithreaded). If anyone sees a problem with what I am about to do, let me know. What do you think? -----Original Message----- From: zope-dev-admin(a)zope.org [mailto:zope-dev-admin@zope.org]On Behalf Of Capesius, Alan Sent: Wednesday, March 07, 2001 12:31 PM To: zope(a)zope.org Cc: zope-dev(a)zope.org Subject: [Zope-dev] RE: ZODBC problem Thanks Dieter, I was kinda looking for a solution, I reviewed the mailing lists but do not see any solutions. I've done some more testing here: Summary: The user selects an involved financial report. The report takes about 55 seconds for Zope to prepare. The first second is the SQL server request and reply. The remaining time is Zope processing (dual 200mhz NT box). My queries are SELECT JOINS. No tables are modified at the server. The problem I see here is that Zope/ZODBCDA is holding the connection to SQL open via ODBC until all processing is complete and then issuing an SQL statement: IF @@TRANCOUNT>0 COMMIT TRAN Zope could free up this connection after one second. (at least in this case) Until Zope does the commit, other users are locked out. For read only queries, there is no need to have the request under transaction control. In any case, Zope should be able to early release the SQL connection and then process on the results. Certainly increasing processor speed will mask this problem and provide better response to users, but I'm hoping for a real fix. Thanks, Alan Network Monitor trace Wed 03/07/01 10:51:50 c:\cap1.TXT Frame Time Src MAC Addr Dst MAC Addr Protocol 1 4.413 006008F6062B COMPAQ851F04 TCP 2 4.413 006008F6062B COMPAQ851F04 TCP 3 4.413 006008F6062B COMPAQ851F04 TCP [....] 193 5.072 006008F6062B COMPAQ851F04 TCP 194 5.073 COMPAQ851F04 006008F6062B TCP 195 5.090 COMPAQ851F04 006008F6062B TCP 196 5.090 006008F6062B COMPAQ851F04 TCP 197 5.090 006008F6062B COMPAQ851F04 TCP 198 5.091 COMPAQ851F04 006008F6062B TCP 199 5.109 COMPAQ851F04 006008F6062B TCP 200 5.127 COMPAQ851F04 006008F6062B TCP // SQL server goes idle after this // python DTML processing occurs here 201 10.834 006008F6062B COMPAQ851F04 TCP // not sure what this is, Data is 0xA8 202 10.834 COMPAQ851F04 006008F6062B TCP // reply, data is empty // page returns to user at 60 second mark // then Zope closes the connection 203 60.385 COMPAQ851F04 006008F6062B TCP SQL: IF @@TRANCOUNT>0 COMMIT TRAN 204 60.386 006008F6062B COMPAQ851F04 TCP 205 60.601 COMPAQ851F04 006008F6062B TCP >Capesius, Alan writes: > > ... > > with further testing I > > have determined that the Zope server itself is not locking up, but rather > > requests to the database (MS SQL7 via ZODBCDA) seem to be queueing up. >My memory tells me faintly that such an issue has already been >discussed in the mailing lists (zope, zope-dev). >When I remember right, ZODBCDA synchronizes all database requests >--> searchable list archives... >Dieter _______________________________________________ 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 training in NW-Europe?
by cg＠cdegroot.com 07 Mar '01

07 Mar '01

We want to train a couple of our web-developers on Zope, so that they can structure websites the "Zope-way", help in setting up content management structures for customers, etcetera. As we're a bit short on training resources ourselves, does someone give Zope training in or near The Netherlands? If not near .NL, would someone be willing to share (against a fee, of course) training materials? Regards, Cees -- Cees de Groot http://www.cdegroot.com <cg(a)cdegroot.com> GnuPG 1024D/E0989E8B 0016 F679 F38D 5946 4ECD 1986 F303 937F E098 9E8B

3 3

Adding Property to newly added Image w/o Image ID
by Ryan Winfield Woodings 07 Mar '01

07 Mar '01

HI All, I am new to Zope (just installed it a week ago) and am absolutely loving it!! I have found the mailing list archive very valuable, but I have a question that I haven't been able to find an answer to yet. I have a form that is used to upload a picture, picture title, and picture description. My DTML method that gets called from this form uses the picture file and picture title to add an image (into a subfolder) like this: <dtml-call expr="_[prop_id].manage_addImage(id='', file=file, title=image_title)"> Then I want to add the description as a property (named image_desc) to the image... but I don't know the id of the image that I just added, so I don't know how call: manage_addProperty('image_desc', image_desc, 'text') How do I access the newly added image in this case? Thanks!! Ryan Woodings __________________________________________________ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

1 0

Re: [Zope] HowTo configure premissions for LoginManager?
by Johan Carlsson 07 Mar '01

07 Mar '01

> I have just setup a LoginManager following > the LoginManager with SQL and Skinscripts by dlpierson. > > Now I'm thinking about how to setup security for my LoginManager. > At the moment it's very open for anyone who has DTML permissions > on my lab server. Not so great. > > LoginManager has premissions set to: > > Manager --- All > Anonymous --- "Access contents information", "Use Database Methods" > "Acquire permission settings?" --- None > > Now, this is needed to allow Anonymous user to login. > But it also makes it possible for a Anonymous to access the following > DTML Method in the root folder: > > <dtml-var standard_html_header> > <pre> > <b>test.acl_users.getUser('a').username</b> > <dtml-with test> > <dtml-with acl_users> > getUser('c').username: <dtml-var "getUser('c').username"> > getUser('c').password: <dtml-var "getUser('c').password"> > getUser('c').getRoles: <dtml-var "getUser('c').getRoles()"> > </dtml-with> > </dtml-with> > </pre> > <pre> > <b>dtml-in "sql_getUserFor(username='c')"</b> > <dtml-with test> > <dtml-with acl_users> > <dtml-in "sql_getUserFor(username='c')"> > username: <dtml-var username> > password: <dtml-var password> > </dtml-in> > </dtml-with> > </dtml-with> > <dtml-var standard_html_footer> > > Which returns (where there is a user named 'c'): > > test.acl_users.getUser('a').username > getUser('c').username: c > getUser('c').password: d > getUser('c').getRoles: ['test'] > > dtml-in "sql_getUserFor(username='c')" > username: c > password: d > > Now the question is how (and where) should I configure permissions > so LoginManager gets secured? > Ok, problem solved. 1. Removed the Anonymous access, which will secure the LoginManager. 2. Add permissions to: LoggingIn --- "Access contents information", "Use Database Methods" 3. Add LoggingIn proxy role to the SkinScript. Regards, Johan Carlsson

1 0

" in a let
by nuno 07 Mar '01

07 Mar '01

Hi all ! Has anyone accomplish to create a string in dtml which has a " (quote) something like <dtml-let my_str="aaabbb " aaabbb"> </dtml-let> I have tried the normal escape character \ but it didn't worked !!! : ( <dtml-let my_str="aaabbb \" aaabbb"> </dtml-let> I think that the use of " in a string is a problem in redering dtml !!! am i wrong !!! please tell me that i am !! regards Nuno

3 3