August 2001 - Zope - Zope lists

DCOracle problems after dropping/reloading tables
by Mark Langkau 10 Aug '01

10 Aug '01

Hi, We're using Zope 2.3.2 and DCOracle2 Beta-4 against a remote Oracle 8.1.6 database on RH Linux 6.2. We have a data mart (MCMART) where tables and views are dropped and refreshed nightly. This seems to be the cause of the following error: -- Error Message -- an exception occurred in a DTML method or document. Error type: DatabaseError Error value: (4068, 'ORA-04068: existing state of packages has been discarded\012ORA-04061: existing state of package body "MCMART.MC_MART_RPT" has been invalidated\012ORA-04065: not executed, altered or dropped package body "MCMART.MC_MART_RPT"\012ORA-06508: PL/SQL: could not find program unit being called\012ORA-06512: at line 1') Innermost method: /mc/mc_mart_dyn/mc_dd/daily_sales/show_daily_sales.dtml ------------------ If we reconnect to the Oracle database, the error goes away. The connections from Zope to Oracle remain open during these nightly refreshes, and we are thinking this is causing the error. Is there a way to programatically close and reopen these connections? Or better yet, have Zope/DCO2 detect the error and try to close/reopen the connection? A reasonable solution might be to have the Oracle view refresh process use wget (or similar) to call a script telling DCO2 to close/reopen the database connection. (But then I'm not sure how to handle logging in, so Joe Hacker doesn't help me by doing this himself all day long ;-) Has anyone seen this before? I see that a new version of DCO2 was released last night, but I haven't had time to check that out yet for new functionality. Have I overlooked something that is in the current version? Thanks for your help. Cheers, Mark

2 1

IE problems with Zope Solaris binary?
by Irene Barg 10 Aug '01

10 Aug '01

Hello, I'm running Zope-2.3.2-solaris-2.6-sparc binary release on a Sparc Ultra 60 running Solaris 2.8. I don't have root privilege on my machine, and gcc compiler is not installed, so I just downloaded the Solaris binary. When I start Zope in debug mode, I see: ZServer PCGI Server started .. Unix socket: /home/barg/Zope-2.3.2-solaris-2.6-sparc/var/pcgi.soc I connect directly to my zope site using this URL: http://nickel.as.arizona.edu:8080 Since the binary version is using PCGI, would there be any advantage to starting Zope with the "-p" option and going through my public_html directory? Everything appeared to be working fine until I started investigating a problem that I believed was related to an AOL Proxy server caching, but now I don't know. I have a set of forms that allow users to edit a MySQL database (MySQL 3.23.38, MySQL-python-0.3.5, ZMySQLDA-2.0.6). I develop on a linux system, running Zope 2.3.2 compiled from source. Then I deploy on my Sun. Users accessing my forms from Windows machines running either IE or a AOL enabled browser can query my database, but when they actually try to 'Submit' an update, they get the infamous IE page saying: This page cannot be displayed. The page your are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or your may need to adjust your browser settings. ..... Now, what "should" happen is, when they press the 'Submit' button, a DTML method is called (using method="POST"), this method calls some Python scripts, a ZSQL method, then sends a reply to the client's browser. Of course this never happens on a PC running IE or Nescape 4.7. I do not see this behavior if I come into my Zope site from another Sun workstation in my office (using Netscape 4.7), but I can go down the hall and get the same error on a PC running Windows 2000 and IE. Can anyone tell me what may be going on, or how I can go about debugging this? Thanks you, --irene Irene Barg Email: ibarg(a)as.arizona.edu Steward Observatory Phone: 520-621-2602 University of Arizona FAX: 520-621-1891 Tucson, AZ 85721 http://nickel.as.arizona.edu/~barg

3 5

Adding a zclass programmatically
by Montagne, Michael 10 Aug '01

10 Aug '01

I'm working with the product YihawDirectory. It contains a zclass named YihawChannel which in turn contains other zclasses representing various objects that are collected and displayed. Looks pretty cool. I'm working on a user interface for adding instances to my folder object. From within a YihawChannel instance, I can just call methods directly, excellent. But I can't figure out a nice way to add the first YihawChannel object to my folder. There is an existing YihawChannel_addForm that comes with the product. I sure would like to use that but I can't seem to reference it. This is propbably a very basic question and I've struggled for a while. If someone would point me in the right direction, I'd be grateful -mjm

3 2

Zope & IIS - I'm stupid
by emailgroups＠idomainsolutions.com 10 Aug '01

10 Aug '01

I'm trying to setup Zope with IIS4 and IIS5. I can get it to work when using http://localhost/scripts/zope.pcgi How can I get it so that it can coexist with IIS. I'm also running ColdFusion and cannot remove this and go soley with Zope, especially since I know nothing about it yet. What I would like to do is have one site at http://localhost/test1 that is ColdFusion and another that is http://localhost/test2 that is Zope. I've gone through the web site and through the archives and haven't found a solid answer. Do I need to create vitual directories in IIS and map them somewhere under Zope? Any help would be GREATLY appreciated. I'm excited to use this product but have to use IIS. Thanks Chuck Brockman

1 0

RE: [Zope] Checkbox form data storage was (Help with expr)
by Eric Walstad 10 Aug '01

10 Aug '01

Hi Todd, Please keep this thread on the mailing list... > I have one column named membership type varchar(30) OK. I'm assuming that the field has values like: "D,A,M,I,T" (heehee, couldn't resist :) If so, you will need to convert the list of strings in the "membership" REQUEST variable to a string of comma separated values before you update your database with a ZSQL Method. Hint: read about Python's string.join() function (accessible in DTML with <dtml-var expr="_.string.join()">) Eric. > >Hi Todd, > >Does your database table have *one* string field named > "membership" or are > >there many boolean fields that represent the different > memberships that each > >user record can have? Depending on that answer, you will need to use a > >different method to store the checkbox data in your database. > > > >When your form is submitted, Zope will interpret your check > boxes as a list > >of string values. > >You can verify this by posting your form to a DTML method that includes: > ><dtml-var REQUEST> > >and looking at the form variables. That list represents the > items checked > >in your form. > > > >In your ZSQL Method you can use the <dtml-sqlgroup> , <dtml-sqlvar> and > ><dtml-sqltest> tags to dynamically build your SQL string. > > > >Have a look at the "Passing Parameters to Scripts" and "Dynamic > SQL Queries" > >sections of the Zope Book. There are a lot of great examples there. > > > -----Original Message----- > > > From: Todd Loomis [mailto:tloomis@dmso.mil] > > > Sent: Friday, August 10, 2001 8:45 AM > > > To: eric(a)walstads.net > > > Subject: RE: [Zope] Help with expr > > > Eric: > > > I have a set of check boxes that can be checked if the person is > > > a member. > > > My problem is if I pick more than one membership nothing goes into the > > > database. So when bring the record up to view or edit I get no boxes > > > checked even if they should be, here's my codes: > > > Form: > > > <input type="checkbox" name="membership" value="D"> DMSO   > > > <input type="checkbox" name="membership" value="A"> AMG   > > > <input type="checkbox" name="membership" value="E"> EXCIMS   > > > <input type="checkbox" name="membership" value="M"> > MSWG  <br> > > > <input type="checkbox" name="membership" value="V"> VV&A > > > TWG   > > > <input type="checkbox" name="membership" value="T"> VV&A > > > TST   > > > <input type="checkbox" name="membership" value="I"> MSTWG   > > > > > > SQL: > > > <dtml-var membership type="string"> > > > > > > Todd

2 3

Proxy roles don't work with manage_clone?
by Hamish Lawson 10 Aug '01

10 Aug '01

I have a Python Script that contains a line like this (with appropriate assignments of DestinationFolder, PrototypeObject and folder_id): DestinationFolder.manage_clone(PrototypeObject, folder_id) The script is intended to be run by anonymous users, but only the Manager role has permission to add folders to DestinationFolder (the folder acquires its permission settings ultimately from the root folder, which specifies that the Manager role has all permissions). So I gave the script a proxy role of Manager. Despite this Zope still prompts for authentication credentials. Why doesn't the proxy role seem to be taking effect (another test script has successfully established that the Anonymous User can read the properties of PrototypeObject, in case that was an issue). Hamish Lawson ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

1 0

Proxy role doesn't work for manage_clone?
by Hamish Lawson 10 Aug '01

10 Aug '01

I have a Python Script that contains a line like this (with appropriate assignments of DestinationFolder, PrototypeObject and folder_id): DestinationFolder.manage_clone(PrototypeObject, folder_id) The script is intended to be run by anonymous users, but only the Manager role has permission to add folders to DestinationFolder (the folder acquires its permission settings ultimately from the root folder, which specifies that the Manager role has all permissions). So I gave the script a proxy role of Manager. Despite this Zope still prompts for authentication credentials. Why doesn't the proxy role seem to be taking effect (another test script has successfully established that the Anonymous User can read the properties of PrototypeObject, in case that was an issue). Hamish Lawson

1 0

Re: [Zope] Checkbox Help
by Tino Wildenhain 10 Aug '01

10 Aug '01

Hi Todd, --On Freitag, 10. August 2001 12:35 -0400 Todd Loomis <tloomis(a)dmso.mil> wrote: > Tino: > > Thanks, but now I get in the database ['D', 'A']. Its not ['D', 'A'] its a list with the strings 'D' and 'A' :-) ['D', 'A'] is only a view on the list object if it gets translated to a string directly. It depends on you what you actually want to do with the values. You might probably want to make a SQL statement like this: select ... where something in (value1,value2, ...) A quite "clean" way would be: select ... where something in ( <dtml-in valuelist><dtml-sqlvar sequence-item type=string><dtml-unless sequence-end>,</dtml-unless> </dtml-in> ) ... HTH Tino Wildenhain PS: back to the list, since it seems to be an FAQ today. > > Todd > > > At 06:25 PM 8/10/2001 +0200, you wrote: >> Hi Todd, >> >> as a service, Zope gives you a list if more then one >> value of the same name exist in a form. >> >> For what python types and especially lists are please >> see http://www.python.org/ -> Documentation -> Tutorial >> >> However, if you relie on this and get only one value, >> its not a list. However there are posibilities to >> cast an value explicitely to a list. >> >> If you change your form like this: >> >> <input type="checkbox" name="membership:list" value="D"> DMSO   >> <input type="checkbox" name="membership:list" value="A"> AMG   >> <input type="checkbox" name="membership:list" value="E"> EXCIMS   >> <input type="checkbox" name="membership:list" value="M"> MSWG  <br> >> <input type="checkbox" name="membership:list" value="V"> VV&A >> TWG   >> <input type="checkbox" name="membership:list" value="T"> VV&A >> TST   >> <input type="checkbox" name="membership:list" value="I"> MSTWG   >> >> >> You get always a list, no matter if there is one or any checkbox >> checked. If there is no checkbox checked, you do not get anything at >> all! So you might have to look for it (or use a default). >> >> You should avoid using <dtml-var> in SQL Methods. Instead use >> <dtml-sqlvar> since this quoutes correctly. Also <dtml-var ... sql_quote> >> can be used. If you dont do so, you probably open a security hole. >> >> Regards >> Tino >> >> >> --On Freitag, 10. August 2001 11:53 -0400 Todd Loomis <tloomis(a)dmso.mil> >> wrote: >> >>> All: >>> >>> I have a set of check boxes that can be checked if the person is a member. >>> My problem is if I pick more than one membership nothing goes into the >>> database. So when bring the record up to view or edit I get no boxes >>> checked even if they should be, here's my codes: >>> >>> Form: >>> <input type="checkbox" name="membership" value="D"> DMSO   >>> <input type="checkbox" name="membership" value="A"> AMG   >>> <input type="checkbox" name="membership" value="E"> EXCIMS   >>> <input type="checkbox" name="membership" value="M"> MSWG  <br> >>> <input type="checkbox" name="membership" value="V"> VV&A TWG   >>> <input type="checkbox" name="membership" value="T"> VV&A TST   >>> <input type="checkbox" name="membership" value="I"> MSTWG   >>> >>> SQL: >>> <dtml-var membership type="string"> >>> >>> Todd >>> >>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >>> Todd Loomis >>> Web Developer (SAIC) >>> Defense Modeling & Simulation Office >>> 1901 N. Beauregard Street, Suite 500 >>> Alexandria, VA 22311 >>> Office: 703.824.3407 Fax: 703.379.3778 >>> tloomis(a)dmso.mil >>> >>> >>> >>> _______________________________________________ >>> 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 ) >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Todd Loomis > Web Developer (SAIC) > Defense Modeling & Simulation Office > 1901 N. Beauregard Street, Suite 500 > Alexandria, VA 22311 > Office: 703.824.3407 Fax: 703.379.3778 > tloomis(a)dmso.mil > >

1 0

RE: [Zope] Checkbox and SQL Method
by CHOY,CHARLENE (HP-Boise,ex1) 10 Aug '01

10 Aug '01

Hi Tino and Eric, Thanks for all your help =). I have solved my problem. I implemented my application with the "saver" that Tino suggested and it worked ^_^. Have a nice day! -Charlene -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Friday, August 10, 2001 3:57 AM To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail); 'eric(a)walstads.net' Subject: RE: [Zope] Checkbox and SQL Method Hi Charlene, you can do this with <dtml-var expr="_.string.join(yourlist,',')"> However this is a bit risky. An attacker could fake your form and send arbitratry strings with it! More complex, but saver would be something like that: <dtml-in yourlist> <dtml-unless sequence-start>,</dtml-unless> <dtml-sqlvar sequence-item type=int> </dtml-in> There might even be a group statement for SQL Methods, but I dont remember it at the moment. Note the square brackets you see are only a view on the list object what python provides if you just show the object. Regards Tino --On Donnerstag, 9. August 2001 16:18 -0700 "CHOY,CHARLENE (HP-Boise,ex1)" <charlene_choy(a)hp.com> wrote: > Thanks Eric, I have solved part of my problem =) > I have a new problem now. > After the form is being process I have a list ['1','2','3']. > how do I get rid of the bracket and single quotes because I only need 1,2,3 > as the argument to my sqlmethod. > Thanks in advance for your help. > > -Charlene > > -----Original Message----- > From: Eric Walstad [mailto:eric@walstads.net] > Sent: Thursday, August 09, 2001 4:24 PM > To: CHOY,CHARLENE (HP-Boise,ex1); Zope List (E-mail) > Subject: RE: [Zope] Checkbox and SQL Method > > > Hi Charlene, > > It looks to me like your SQL is set up to only handle one "index" value. If > I understand your question, you need something like this in your SQL: > SELECT * FROM data > WHERE index IN (1, 3, 5, 7, 11); > > You can then use that list to populate the list of "indexes" used in the SQL > IN clause. I think the <dtml-sqltest> tag will do the iteration over the > list for you. > > Check out the "Dynamic SQL Queries" section of the Zope Book for more > details. > > HTH, > > Eric. > >> If I get a list of input values for the argument of my sql >> method from the >> check box, how do I call the sqlmethod to repeatedly display them. My >> sqlmethod only has one argument. >> >> The following is some of the snippet of my codes. >> >> >> ============================= >> sqlmethod: selected_item >> ============================= >> Argument: selected_number >> >> "SELECT * data where >> index = <dtml-sqlvar selected_item type=int>" >> >> >> ****************************************************************** >> >> ============================= >> dtml-method: list_selected_item >> ============================= >> <dtml-var standard_html_header> >> <form action=selected_item action=post> >> <dtml-in lookup_item size=50 start=query_start> //lookup_item is >> another sql >> method >> <dtml-if sequence-start> >> <dtml-comment> there is some more codes here </dtml-comment> >> <table> >> <tr> >> <th>Index</th> >> <th>Checkbox</th> >> >> </dtml-if sequence-start> >> >> <tr> >> <td><dtml-var index null=""></td> >> >> <td><center><input type="checkbox" name="selected_lcn" >> value="<dtml-var index>"> >> </center></td> >> <dtml-if sequence-end> >> >> </table> >> <dtml-comment> Some other codes here </dtml-comment> >> >> </dtml-if sequence-end> >> >> <dtml-else> >> >> There was no data matching this <dtml-var title_or_id> query. >> >> </dtml-in> >> <input type=submit value="Generate Report"> >> </form> >> <dtml-var standard_html_footer> >> >> ****************************************************************** > > _______________________________________________ > 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 )

1 0

Re: [Zope] ZMySQLDA
by Stephan Goeldi 10 Aug '01

10 Aug '01

>From: Andy Dustman <andy(a)dustman.net> > >MySQL-python/MySQLdb still needs to be compiled. Do this with: > >$ python setup.py build ># python setup.py install There is no setup.py in my Zope tree It seems to me, that there are source and binaries, and that one has to guess himself, if it has to be compiled or not. Access to mySQL works now from Zope, so I think I loaded the binary. The outdated stuff in the Products section of www.zope.org is no good marketing for a content management system. _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

2 1