December 2008 - Zope

problem with a form in IE 7
by C 15 Dec '08

15 Dec '08

We are running Zope 2.9.8 on Macintosh OS X Server 10.5.5 behind Apache 2.x. I am having a problem when trying to submit one of my forms in IE 7. This only happens on Windows XP and it only started happening recently (we think in the past week). The form contains several select boxes. When the user selects a value from one of the select boxes, it submits the form and processes the selection. The error I receive is an IE error that says: "Internet Explorer Cannot Display the Webpage". And for some reason, all of my selectbox values are showing in the URL as parameters. This is not supposed to happen. If I remove the parameters from the URL line and press enter, it works fine. I have another page that works similar to this one (with multiple select boxes that submit the form upon selection), that doesn't experience the same problem. I even changed my form action to go to a plain html page, and it still tries to pass all of my form variables in the URL string. I went to Microsoft's trouble shooting page for this error. I've tried deleting my browser history, clearing out any cached items, and also re-starting IE without "Add-Ons". The server has been restarted as well. None of these options have resolved the issue. Neither the Apache log nor the Zope error log shows these errors. Has anyone encountered this problem? If so, what have you done to resolve the issue?

4 6

single zsql on multiple tables or multiple zsql s
by indrajit926 indra 15 Dec '08

15 Dec '08

Hi All, In my project iam using zsqls. Now i want to improve performance of project.So i thought to reduce number of zsqls,expecting it may improve performance. using one zsql to fetch values from different tables ,can increase performance ?(instead of using multiple zsqls on multiple tables). Is there anyother ways to improve performance in using zsql.please suggest me if any. Thanks in advance, Raj.

3 3

Modifying Cookie crumbler
by Mr SZ 14 Dec '08

14 Dec '08

Hi All, I have been using cookie crumbler for my site.From the code, I figured out that it stores a base64 encoded value of the username:pass in the cookie. My doubt is how do I modify this behaviour of CC? CC allows me to override the set and expire the authCookie methods.I don't want my user's credentials store in a cookie encoded using base64. Also, is it a good idea to store the users password in the session data? The reason being that the users are not stored on zope and their passwords are one time tokens received from an external auth service.I felt that if I store them in zodb, then it becomes difficut to flush them out after every session. Regards, SZ " life isn't heavy enough,it flies away and floats far above action" Start your day with Yahoo!7 and win a Sony Bravia TV. Enter now http://au.docs.yahoo.com/homepageset/?p1=other&p2=au&p3=tagline

2 1

Unknown directive for xmlrpc
by Bertus Van der Linden 14 Dec '08

14 Dec '08

zope.configuration.xmlconfig.ZopeXMLConfigurationError: File "/home/nolbert/miqra/mbm-dev-buildout2/parts/instance/etc/site.zcml", line 15.2-15.23 ZopeXMLConfigurationError: File "/home/nolbert/miqra/mbm-dev-buildout2/products/worldcookery/configure.zcml", line 8.2-8.31 ZopeXMLConfigurationError: File "/home/nolbert/miqra/mbm-dev-buildout2/products/worldcookery/roles.zcml", line 3.2 ConfigurationError: ('Unknown directive', u' http://namespaces.zope.org/zope', u'role')

2 1

The proxy server received an invalid response from an upstream server.
by rugbert 14 Dec '08

14 Dec '08

My client's zope has two back ends, /manage and /tools. tools is the one with the more user friendly interface and manage is the utilitarian one. When users goto /tools tho, and click the "assets" folder the site times outs with this: [code] Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /tools/assets/. Reason: Error reading from remote server [/code] However, I can get there just fine through manage. Any thoughts? -- View this message in context: http://www.nabble.com/The-proxy-server-received-an-invalid-response-from-an… Sent from the Zope - General mailing list archive at Nabble.com.

3 2

Re: [Zope] Problem using dtml-in in ZSQL method
by Françoise CONIL 12 Dec '08

12 Dec '08

Trying : select * from mytable <sqltest mylist multiple type=int column=id> did not work, it generates a ProgrammingError - Module Shared.DC.ZRDB.DA, line 374, in __call__ - Module Products.ZMySQLDA.db, line 273, in query ProgrammingError: (1064, "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '<sqltest mylist multiple type=int column=id> LIMIT 1000'") My problem was that I tried to test my Z SQL method through the ZMI, testing with a python script worked fine with the following Z SQL method : SELECT * FROM MyTable <dtml-sqlgroup where> <dtml-sqltest mylist column=id type=int multiple> </dtml-sqlgroup> I also modified the "mylist" parameter declaration to specify that it is a list of integers which is set to none if no parameter is passed. liste:list:int=none Thanks for your reply

2 2

nginx proxy zope/webdav, can't see files
by mictlan tecutli 11 Dec '08

11 Dec '08

hi, i´m trying to connect davfs to zope/webdav by way of nginx. this works fine (once davfs is configured correctly) conecting directly (that is w/out nginx in the middle). with nginx in the middle i can not see the files. that is "ls /davfs/mout/point" shows an empty folder. i can upload to that folder, if i mount directly to a folder where my user has permissions. but can´t see the files there. the folder is not empty. again, i can list the files using davfs without nginx as. on the nginx list i was told that the probem was most likely due to path formation. here is the client request, responces from nginx and zope and the configuration of nginx vhost. hopefully someone on this list can shed some light on the issue. > Probably, the problem is that in nginx case you use "PROPFIND /dav/nomndaa1/" > while server responses to "PROPFIND /nomndaa1/" or "PROPFIND /plune/nomndaa1/" > (according previously posted configuration). This may confuse the client, > if it expect to see response to "PROPFIND /dav/nomndaa1/": response may > have "/nomndaa1/" or "/plune/nomndaa1/" pathes. so if i understand i should be able to fix this with a proxy_redirect like: proxy_redirect http://10.10.10.30:1980/nomndaa1/ http://$host:$server_port/dav/ this _is not_ working for me. the following is the client request, nginx and zope responces, as well as a modified vhost for nginx. client: Sending request headers: PROPFIND /dav/ HTTP/1.1 Host: lapalabradelagua.org User-Agent: davfs2/1.3.3 neon/0.28.2 Connection: TE TE: trailers Depth: 1 Content-Length: 314 Content-Type: application/xml nginx log: "PROPFIND /dav/ HTTP/1.1" 207 11500 "-" "davfs2/1.3.3 neon/0.28.2" zope log: "PROPFIND /nomndaa1/ HTTP/1.0" 207 11784 "" "davfs2/1.3.3 neon/0.28.2" complete nginx vhost: server { listen 10.10.10.20:80; server_name .myhost.org; if ($request_uri ~* ^/login_(.*)) { rewrite ^/login_(.*) https://$host/login_$1 permanent; break; } location /dav/ { proxy_pass http://10.10.10.30:1980/nomndaa1/; proxy_pass_header Server; proxy_set_header Host $http_host; proxy_set_header X-Forwarded-For $remote_addr; proxy_redirect http://10.10.10.30:1980/nomndaa1/ http://$host:$server_port/dav/; } location / { proxy_pass http://10.10.10.30:6081/VirtualHostBase/http/myhost.org:80/nomndaa1/Virtual…; proxy_set_header Host $http_host; } saludo, kev

1 0

How manage error with zsql
by Miguel Beltran R. 11 Dec '08

11 Dec '08

I tried to insert data using an zsql, insert fine How manage error with zsql. Before <dtml-try> <dtml-call insert_data> Data inserted!!! <dtml-except> Error type:<dtml-var error_type> Error type:<dtml-var error_value> </dtml-try> Now (All files are ZPT) [index_html] ... <form action="proyecto_alta.html"> <input type="text" name="field1" id="field1" /> ... <input type="text" name="field2" id="field2" /> </form> [proyecto_alta.html] <div tal:on-error="structure here/error_insertar"> tal:condition="context/insert_data.zsql" tal:content="string: Data inserted!!!"> </div> [error_insertar] error=_['error'] if error.type==ZeroDivisionError: return "<p>Can't divide by zero.</p>" else: return """<p>An error ocurred.</p> <p>Error type: %s</p> <p>Error value: %s</p>""" % (error.type, error.value) But say Tipo Unauthorized Valor You are not allowed to access 'type' in this context TraceBack Traceback (innermost last): - Module ZPublisher.Publish, line 119, in publish - Module ZPublisher.mapply, line 88, in mapply - Module ZPublisher.Publish, line 42, in call_object - Module Shared.DC.Scripts.Bindings, line 313, in __call__ - Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec - Module Products.PageTemplates.ZopePageTemplate, line 330, in _exec - Module Products.PageTemplates.ZopePageTemplate, line 427, in pt_render - Module Products.PageTemplates.PageTemplate, line 96, in pt_render - Module zope.pagetemplate.pagetemplate, line 115, in pt_render - Module zope.tal.talinterpreter, line 271, in __call__ - Module zope.tal.talinterpreter, line 346, in interpret - Module zope.tal.talinterpreter, line 981, in do_onError_tal - Module zope.tal.talinterpreter, line 346, in interpret - Module zope.tal.talinterpreter, line 745, in do_insertStructure_tal - Module Products.PageTemplates.Expressions, line 199, in evaluateStructure - Module zope.tales.tales, line 696, in evaluate *URL: /ceed/finanza/proyecto/proyecto_alta.html* *Line 1, Column 0* *Expression: <PathExpr standard:u'here/error_insertar'>* *Names:* {'container': <Folder at /ceed/finanza/proyecto>, 'context': <Folder at /ceed/finanza/proyecto>, 'default': <object object at 0x0075A528>, 'here': <Folder at /ceed/finanza/proyecto>, 'loop': {}, 'nothing': None, 'options': {'args': ()}, 'repeat': <Products.PageTemplates.Expressions.SafeMapping object at 0x02382828>, 'request': <HTTPRequest, URL=http://sic/finanza/proyecto/proyecto_alta.html>, 'root': <Application at >, 'template': <ZopePageTemplate at /ceed/finanza/proyecto/proyecto_alta.html>, 'traverse_subpath': [], 'user': <User 'admin'>} - Module zope.tales.expressions, line 217, in __call__ - Module Products.PageTemplates.Expressions, line 139, in _eval - Module Products.PageTemplates.Expressions, line 91, in render - Module Products.PageTemplates.ZRPythonExpr, line 79, in call_with_ns - Module Shared.DC.Scripts.Bindings, line 327, in __render_with_namespace__ - Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec - Module Products.PythonScripts.PythonScript, line 327, in _exec - Module None, line 2, in error_insertar *<PythonScript at /ceed/finanza/proyecto/error_insertar>* *Line 2* Unauthorized: You are not allowed to access 'type' in this context (Example taked from http://www.plope.com/Books/2_7Edition/AppendixC.stx#2-28<http://www.plope.com/Books/2_7Edition/AppendixC.stx#2-28> ) -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

4 7

Re: [Zope] Problem using dtml-in in ZSQL method
by Jaroslav Lukesh 11 Dec '08

11 Dec '08

first, convert mylist to string before calling ZSQL method: <dtml-call "REQUEST.set('strmylist', _.str(mylist))"> And then call the ZSQL method: <params> strmylist:string="[0]" </params> SELECT * FROM MyTable WHERE id in (<dtml-var "strmylist[1:-1]" sql_quote>) ----- Original Message ----- From: Françoise CONIL To: zope(a)zope.org Sent: Thursday, December 11, 2008 11:21 AM Subject: [Zope] Problem using dtml-in in ZSQL method Hello, My ZSQL method receive a *mylist* parameter that should be an integer list : [21,35] The following code does not work : SELECT * FROM MyTable WHERE id in (<dtml-in mylist> <dtml-sqlvar sequence-item type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Type de l'erreur* NameError *Valeur de l'erreur* 'client' may not be used as an argument name in this context This other code does not work better : SELECT * FROM MyTable WHERE id in (<dtml-in mylist prefix="myid"> <dtml-sqlvar expr="myid_item" type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Same error* However, if I use a dictionary list of this type [{'id':21},{'id':35}] with the following code, it works (but it's heavy) SELECT * FROM MyTable WHERE id in (<dtml-in mylist mapping> <dtml-sqlvar id type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) The python script that calls my ZSQL method has already build the integer list and I would like to use it as is. Thanks for your help _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )

2 2

Problem using dtml-in in ZSQL method
by Françoise CONIL 11 Dec '08

11 Dec '08

*Hello, *My ZSQL method receive a *mylist* parameter that should be an integer list : [21,35] The following code does not work : SELECT * FROM MyTable WHERE id in (<dtml-in mylist> <dtml-sqlvar sequence-item type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Type de l'erreur* NameError *Valeur de l'erreur* 'client' may not be used as an argument name in this context This other code does not work better : SELECT * FROM MyTable WHERE id in (<dtml-in mylist prefix="myid"> <dtml-sqlvar expr="myid_item" type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Same error* However, if I use a dictionary list of this type [{'id':21},{'id':35}] with the following code, it works (but it's heavy) SELECT * FROM MyTable WHERE id in (<dtml-in mylist mapping> <dtml-sqlvar id type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) The python script that calls my ZSQL method has already build the integer list and I would like to use it as is. Thanks for your help

3 2