August 2001 - Zope - Zope lists

Fw: [Zope] zsql .dictionaries() question
by David Golden 09 Aug '01

09 Aug '01

Dieter: Thank you for your interest and assistance. Both are appreciated. > > What attribute is not found? > 'dictionaries', apparently. Thought I might be missing something in syntax of context().dictionaries() What I hope are relevant portions of error: *** Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: dictionaries ... Traceback (innermost last): File C:\Program Files\ZopeSite1\lib\python\ZPublisher\Publish.py, line 223, in publish_module File C:\Program Files\ZopeSite1\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\ZopeSite1\lib\python\Zope\__init__.py, line 221, in zpublisher_exception_hook (Object: sqlTrans) File C:\Program Files\ZopeSite1\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\ZopeSite1\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: datX) File C:\Program Files\ZopeSite1\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: datX) File C:\Program Files\ZopeSite1\lib\python\Shared\DC\Scripts\Bindings.py, line 324, in __call__ (Object: datX) File C:\Program Files\ZopeSite1\lib\python\Shared\DC\Scripts\Bindings.py, line 354, in _bindAndExec (Object: datX) File C:\Program Files\ZopeSite1\lib\python\Products\PythonScripts\PythonScript.py, line 336, in _exec (Object: datX) (Info: ({'script': <PythonScript instance at 019AEFA0>, 'context': <SQL instance at 019AE990>, 'container': <Folder instance at 01973730>, 'traverse_subpath': []}, (), {}, None)) File Script (Python), line 2, in datX (Object: <lambda>) File C:\Program Files\ZopeSite1\lib\python\Products\PythonScripts\Guarded.py, line 273, in __getattr__ File C:\Program Files\ZopeSite1\lib\python\Products\PythonScripts\Guarded.py, line 145, in __careful_getattr__ AttributeError: (see above) *** The ZSQL method sqlTrans: select * from owners *** The Python script datX: return context().dictionaries() *** I'm logged in as Manager, traversed to script as file://host/folder/sqlTrans/datX as previously noted. Zope 2.3.3 on Win98 platform. ZODBC and LocalFS products installed as well. *** Please let me know if additional data would be useful. Thanks again.

1 0

Re: [Zope] DCOracle problems after dropping/reloading tables
by Anthony Baxter 09 Aug '01

09 Aug '01

Hi, This looks more like an Oracle problem than a Zope one. Try this: Open an sqlplus session using the same connection string as your zope connector uses. Do some of the same stuff that Zope does, to verify that it works. Leave the sqlplus alive during your nightly refresh. After the drop/create is done, see if you can still do stuff in sqlplus that the Zope server tries to do. I'm guessing that the sqlplus will also be fragged. It may be possible to do wierd Oracle magic to make existing clients work, or it may be that you have to do something like: make a method that just tests for the state of brokenness, called 'oraTest' (for example). Make a python method that does something like: try: oraTest() except: close Oracle connector reopen Oracle connector Then put this at the start of each request that might trigger the fault. Anthony [who's been constantly suprised/disappointed how much stuff in Oracle that you'd _expect_ to be a "reference by name" is instead a "reference by some magic internal ID that you can't find mwahahahaha"] >>> Mark Langkau wrote > 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 > > > _______________________________________________ > 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 ) > -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

1 0

Different external method and acquisition syntax question.
by jelle 08 Aug '01

08 Aug '01

Hi All, I can't seem to find an answer to my external method and acquisition syntax question so here goes: I have three objects: python script(alpha) -> external method(beta) -> zsql(delta) The python script "alpha" is in subfolder "/proj/py_script". The external method "beta" is in subfolder "/proj/ex_python". the zsql object "delta" is in subfolder "/proj/db". The python script "alpha" is invoked and calls: context.ex_python.beta() External method "beta" is fired up and calls: self.db.delta() Which results in a runtime error of: Error Type: AttributeError Error Value: db I've tried moving zsql object "delta" into the "/proj/ex_python" subfolder and changed the code in external method "beta" to read self.delta() Which resulted in a runtime error of: Error Type: AttributeError Error Value: delta Any ideas? Thanks, Jelle --

3 5

Concepts
by mixo 08 Aug '01

08 Aug '01

Is there a way to define a group in Zope? For instance, could I have user1, user2 and user3 as part of a group, say "testers", and the group "testers" can access to certain folders (or something of that sort) in Zope. I want users within a group to be able do updates on folders that group they belong to has been assigned to. Mixo Shiburi I have had a look at "roles", and what they seem to do is define permissions and not groups of people.

4 3

security policies bwt Zope 2.3.0 and 2.3.2
by Irene Barg 08 Aug '01

08 Aug '01

Hello, My development system: Zope Version: Zope 2.3.2 (binary release, python 1.5.2, linux2-x86) Python Version: 1.5.2 (#1, Aug 25 2000, 09:33:37) [GCC 2.96 20000731 (experimental)] System Platform: linux-i386 My deploy system: Zope Version: Zope 2.3.0 (source release, python 1.5.2, linux2) Python Version: 1.5.2 (#10, Feb 12 2001, 15:36:48) [GCC 2.95.2 19991024 (release)] System Platform: freebsd4 I get things working on my development environment, then export the folder, re-import on the deploy machine. I have a database which only allows selected 'users' update permission. I grouped these users and the update methods in a folder called 'Update'. Created a role called 'dbupdate', then disabled all 'Acquire permissions settings' for the Update folder, then enabled the following for the 'dbupdate' role: Access contents information Open/Close Database Connection(s) Query Vocabulary Search ZCatalog Use Database Methods Use Factories Use mailhost services View View History View management screens Enabled all settings for 'Manager' role. On my development machine, this does what I want it to. If someone trys to access the '/ADASS/Datbase/Update' URL it prompts them for a login/password. I exported the 'Update' folder, then imported it (Retain existing ownership info) into my deploy machine. On the deploy machine, I cannot get past the login prompt without getting 'Authorization Failed, Retry?'. If I press the 'Cancel' button, I then get: Zope Error Unauthorized You are not authorized to access title_or_id. I've re-checked and changed my 'users' login several times, and this is not the problem. I've tried setting 'Proxy' to 'Manager' and 'dbupdate' role on: Update/index_html, but this does not fix it either. I've looked at the security settings at the root level, and there are no glaring differences between the two machines. The only difference I see is the difference in the two Zope version numbers 2.3.0 vs 2.3.2. Suggestions? Thanks, --irene ---------------------------------------------------------------- Irene Barg Email: ibarg(a)as.arizona.edu Steward Observatory Phone: 520-621-2602 933 N. Cherry Ave. University of Arizona FAX: 520-621-1891 Tucson, AZ 85721 http://nickel.as.arizona.edu/~barg ----------------------------------------------------------------

2 2

Restricted Products?
by Keith J. Farmer 08 Aug '01

08 Aug '01

Is it possible to install products/ZClasses only for a particular subdirectory? I'm looking to host several different sites and at least one will have some group-specific classes happenning, which I'd not want to interfere with other groups' stuff.

4 3

Cannot add an Edit tab to the management screen
by Bocquillon Philippe 08 Aug '01

08 Aug '01

Hello, I do not see an 'Edit' tab appearing in the management screens of my (python) product with the following instruction: manage_options = ( {'label': 'Edit', 'action': 'manage_editChannelForm'}, )+ObjectManager.ObjectManager.manage_options +RoleManager.manage_options +Item.manage_options Could you tell me what is wrong or what else in the code has to be checked to make it working ? Thanks in advance, Philippe

2 1

zsql .dictionaries() question
by David Golden 08 Aug '01

08 Aug '01

Zope and Python newbie. Insights / direction much appreciated. I'm trying to return a dictionary representation of a ZSQL result via a Python script. I'm accessing the script via a URL like: //host:8080/Application/SqlMethod/DictScript The following seems to work: items=[] for row in context(): rec={} for fld in context().names(): rec[fld]=row[fld] items.append(rec) return items but I'd like to use the result object method, .dictionaries() along the lines of return context().dictionaries() which fails with an attribute error in lib\python\Products\PythonScripts\Guarded.py Interestingly enough return context().names() and return context().data_dictionary both work fine. I expect I'm missing something obvious Thanks in advance David Golden

2 1

manage_addDocument returning a DTML method
by shawn grant 08 Aug '01

08 Aug '01

I'm using Zope 2.4.0 on an Alpha Linux box. I have a Python Script consisting of the following line of code: container.manage_addDocument('test', 'Test Document') , which is creating a DTML Method instead of Document. Any idea as to the reason for this behaviour? thanks.

3 2

Can I look up objects by id
by Chris Bruce 08 Aug '01

08 Aug '01

Is there a way to get a specific object by id even if it resides in a separate folder structure? I have a zclass of UserInformation that resides in /UserInfo/RegistrationInfo and I want to create a contact form that displays information from the above folder. The above folder contains both the information of the sender and the contactee. So I need to look up TWO objects and display information from them on the contact form. The zclass has properties of FirstName, LastName, etc. and these are the fields I need to display on the contact form. The contact form resides in /support/contact. Any help would be greatly appreciated. I have been struggling with this for a couple of days now. Thanks, Chris __________________________________________________ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

2 1