- Zope - Zope lists

SQLSession help needed!
by root 21 Nov '99

21 Nov '99

I did get my SQLSession installed. Thank you Harry. However, I am having trouble getting the SESSION.set(...) to work. Here is the code I am using. <html> ZipCode = <dtml-var ZipCode> Distance = <dtml-var Distance> <dtml-var "SESSION.set('myZipCode', ZipCode)"> <dtml-var "SESSION.set('myDistance', Distance)"> <frameset cols="30%,70%"> <frame src="<dtml-var Root>/Menu" name="Menu"> <frame src="<dtml-var Root>/Main" name="Main"> </frameset> </html> Here is the error I am getting: ! Temporarily Unavailable The resource you requested is temporarily unavailable - please try again later. (116) unable to connect, fd=5 If I <dtml-comment> out the SESSSION.sets on down. I do see the values of Zipcode and Distance working correctly. I am connecting to a Postgresql database. Zope/Apache/Postgresql are all running on my Linux box. I have created the Sessions and Session_data tables as prescribed. I have included a <dtml-call Session> in my standard_header_html file. Just to see if the code was working at all, I modified the SQLSession.py:__init__ routine to put the sessionName into the Session_data table. I can see this information just fine using a <dtml-var "REQUEST['SESSION']"> command. This shows one key called session (this is the name I gave it in __init__) and the value of sessionName (the value I assigned). This is the type of error I have received plenty of times when the SQL statement was incorrect somehow. Just how do you debug this error? I looked at standard_error_html and I do not see this error text. How do you find out which object /line is causing the problem? Thank you for the help. Clayton.

3 2

Re: [Zope-dev] User authentication using UserDB
by Anthony Baxter 21 Nov '99

21 Nov '99

>>> Stephan Richter wrote > But now how can I use this login and the Zope security features to actually > shut off sections of my site. Basically I want to make certain directories > only available to the logged in user. Note: I also created a new role. All > users that are authenticated and have this role can see a certain directory. > Is it right that I have to use the "Security" tab? What do I have to do? Yep - you should go to the security tab for the folder(s) that are accessible only to auth'd users, and for each of 'view', 'access contents' and whatever else you want to shutoff: uncheck the 'acquire permission settings' box make sure 'anonymous' doesn't have the box checked check the box for your new role Anthony

1 0

User authentication using UserDB
by Stephan Richter 21 Nov '99

21 Nov '99

hello everyone, I just learned how to use UserDB to have a login on my page. Okay, I got to the point where I can login and the AUTHENTICATED_USER is set to my new username. But now how can I use this login and the Zope security features to actually shut off sections of my site. Basically I want to make certain directories only available to the logged in user. Note: I also created a new role. All users that are authenticated and have this role can see a certain directory. Is it right that I have to use the "Security" tab? What do I have to do? regards, stephan -- Stephan Richter iXL - Software Designer and Engineer CBU - Physics, Computer Science and Chemistry Student

1 0

Cookies - folder specific?
by Tim Haines 20 Nov '99

20 Nov '99

Hi there everyone, I've just been playing with cookies so as I can understand them better. One thing I am finding is the cookies are set in the current zope "level" or "folder". i.e., I have the following structure: / setmycookie showcookie /FolderA setmycookie /FolderB setmycookie When I run /setmycookie, I can then run /showcookie, /FolderA/showcookie, and /FolderB/showcookie and see the cookie (I'm still learning, but I think this works because of zopes acquisition). When I run /FolderA/setmycookie, I can then run /FolderA/showcookie and /FolderB/showcookie and see the cookie. However, /showcookie does not show the cookie. This leads me to believe that the cookie has been set at the /FolderA level. Please let me know if this is not the case. A question I have is, can I tell my /FolderA/FolderB/setmyCookie to set the cookie in /FolderA. I have tried various things such as: <dtml-with "FolderA"> <dtml-call "RESPONSE.setCookie('thecookie', 7)" > </dtml-with> But I can't seem to get it setting the cookie in FolderA. Can anyone tell me how to do this? If you are going to be nice and respond to me, please reply to my hotmail address as well as to the list. Thanks. Tim.

2 1

Zope 2.x bug in loading products w/links--URL's
by Ross Boylan 20 Nov '99

20 Nov '99

http://www.zope.org/Members/rboylan/index_html describes the bug http://www.zope.org/Members/rboylan/product_bug has the zip file I have submitted these items for review; they don't seem to be publicly visible even if you use the URL directly. I don't see any security settings on my folder or the individual itesms. If I've done something wrong, please let me know. Otherwise, wait for approval. My Zope name is rboylan

1 0

Feature queries/suggestions
by Shalabh Chaturvedi 20 Nov '99

20 Nov '99

Hello: I've just started playing around with zope. Is is possible to do the following things:- 1. Configure my web server/zope so that zope handles requests for only specific files/under a specific folder etc ? 2. Get Zope to use the OS filesystem instead of it's own (or have some way of auto-syncronization so that I can modify a file in the directory and zope imports it automatically) ? 3. Get Zope to periodically (say once a day) fire a method and build a page but not rebuild it every time it is requested ? Thanks Shalabh

3 2

Re: passing variables from one DTML method to another ...
by Darran Edmundson 20 Nov '99

20 Nov '99

I wonder if someone can add to the recent comments about passing parameters from one DTML method to another, viz. > <dtml-if "some_condition"> > <dtml-var "render_item(_.None, _, input_var1='value1')"> > <dtml-else> > <dtml-var "render_item(_.None, _, input_var1='value2')"> > </dtml-if> My problem is that I am trying to pass parameters from my feedback form method "feedback_form" to the send method "feedback_send", ie. <form action="feedback_send(_.None, _, testvar='testval')" method="post"> ... </form> or <form action="<dtml-var feedback_send(_.None, _, testvar='3.14')>" method="post"> ... </form> Neither of these work. Note, these parameters aren't the form data, but params I don't want the user to have edit access to. Any ideas are much apppreciated. Cheers, Darran. -- Darran Edmundson [Darran.Edmundson(a)anu.edu.au]

2 1

oracle date-type
by Martin Hofer 20 Nov '99

20 Nov '99

hi out there does someone know, how to query oracle-date fields using dcoracle?? the sqlvar and sqltest-commands don't support type=date!!! thanks in advance mARTin hofer --------------------------------------- o Fa. Intakt Telekommunikation GmbH o --------------------------------------- F�rberberg 69 8330 Feldbach - Austria mail: hofer(a)intakt.at o tel: +43/03152 3030-0 fax: +43/03152 3030-4 | --- mobil: +43/0699-1016 1847 | | | internet: www.intakt.at | | | ---------------------------------------

2 1

HELP: popen2.Popen3 on solaris 2.6 failing
by Li Dongfeng 20 Nov '99

20 Nov '99

popen2.Popen3 caused exception in solaris 2.6. I had a Zope product using popen2.Popen3 to open a long running sub-process and use select.select to get status. Now our sun sparc machine upgraded to solaris 2.6 so I had to re-install all(I'm not root). I downloaded Zope-2_1_0b2-solaris-2_6-sparc.tgz and installed it in my home directory, started using only Z Server. All work OK but my product. The following is a testing external method that broke the server: from popen2 import Popen3 def test_popen3(self): print "Inside test_popen3" lp = Popen3("echo This is a test", 0, 0) print "After Popen3" return "test_select\n" When trying the method, the server give the following error message and restarts, the error message is at the end of the mail. Anyone met the same kind of problem before? Using popen2.Popen3 worked in my old solaris 2.5 installation. ========================== 1999-11-20T07:03:59 PROBLEM(100) ZServer Computing default hostname ------ 1999-11-20T07:03:59 INFO(0) ZServer Medusa (V1.13) started at Sat Nov 20 15:03:59 1999 Hostname: maun03.ma.polyu.edu.hk Port:8080 ------ 1999-11-20T07:03:59 INFO(0) ZServer FTP server started at Sat Nov 20 15:03:59 1999 Authorizer:None Hostname: hilbert Port: 8021 ------ 1999-11-20T07:03:59 INFO(0) ZServer PCGI Server started at Sat Nov 20 15:03:59 1999 Unix socket: /home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/var/pcgi.soc ------ 1999-11-20T07:03:59 INFO(0) ZServer Monitor Server (V1.5) started on port 8099 Inside test_popen3 Traceback (innermost last): File "/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/z2.py", line 583, in ? asyncore.loop() File "/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/ZServer/medusa/asyncore.py", line 107, in loop poll_fun (timeout) File "/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/ZServer/medusa/asyncore.py", line 55, in poll (r,w,e) = select.select (r,w,e, timeout) select.error: (4, 'Interrupted system call') ------ 1999-11-20T07:05:23 ERROR(200) ZServer uncaptured python exception, closing channel <zhttp_channel connected 158.132.82.114:2037 at 567b10 channel#: 0 requests:1> (socket.error:(11, 'Resource temporarily unavailable') [/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/ZServer/medusa/asynchat.py|handle_read|80] [/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/ZServer/medusa/http_server.py|recv|406] [/home/maldf/Zope-2.1.0b2-solaris-2.6-sparc/ZServer/medusa/asyncore.py|recv|256]) ------ 1999-11-20T07:05:27 PROBLEM(100) ZServer Computing default hostname

1 0

ZSQL Create Table
by rgines＠purina.com 20 Nov '99

20 Nov '99

I've been trying to create tables through ZSQL Methods and have been getting some strange results. From the few posts that I have seen in the archives it looks like there have been some behavioral changes from Zope 1.x to 2.x that effect the ZSQ addMethod. For example, from the ZSQL add form method if you use Create table testtwo (col_c varchar, col_d varchar) as the 'Query' you get a responce to the effect that this is not a query ... which I would agree with, but I'm not in the habit of arguing with my computers. If you try to run the Method a second time you get the error Error, exceptions.NameError: cannot create TESTTWO, exists Using the template from 'Sample of DTML Scripting and Gadfly' at classic.zope.org:8080/Documentation/HowTo/SampleGadfly/index_html I try to execute ...  ... The error I get is Error Type: AttributeError Error Value: manage_addZSQLMethod With a traceback of Traceback (innermost last): File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 214, in publish_module File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 179, in publish File D:\PROGRA~1\GYNZER~1\lib\python\Zope\__init__.py, line 201, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 165, in publish File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\OFS\DTMLMethod.py, line 145, in __call__ (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: GadflyTestCreate) File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_Util.py, line 321, in eval (Object: Sample.manage_addZSQLMethod('create_table','','zopadelic','','create table zopista (col_a integer, col_b integer)')) File <string>, line 0, in ? File D:\PROGRA~1\GYNZER~1\lib\python\DocumentTemplate\DT_Util.py, line 125, in careful_getattr AttributeError: (see above) I looked at the SQL.py file and the attributes seem to be passing correctly, but I'm still a python newbie ... although ramping up quickly. Any assistance would be apprecited. Thanks.

2 1