- Zope - Zope lists

Re: [Zope] Deleting Connection that hangs Zope
by Dieter Maurer 04 Jan '01

04 Jan '01

Spicklemire, Jerry writes: > Has anyone found a good way to delete a Database Connection that hangs Zope > at startup? The connection seems to be waiting "forever", and so there is no > access to the Zope interface, so of course I can't delete, or disable the > offending object. You may try to make the "connect" of your database adapter temporarily a no-op (by changing the source and putting in a return). This may let you enter your Zope again and fix the strange object. Dieter

1 0

Re: [Zope] Adding many users
by Dieter Maurer 04 Jan '01

04 Jan '01

Ragnar Beer writes: > I need to add about 150 users to an acl_users folder and I wouldn't > like to do it manually since the data already exists in a python > list. What would be an elegant way to add them all with a python > script? An external Python method or an external automation based on ZClient (Howto on zope.org) For both approaches, you must know the parameters of "manage_addUser". If nowhere else, you will find them in the source: "AccessControl.User.UserFolder.manage_addUser". Dieter

1 0

SQL query from "Multiple Selection Field" (was: [Zope] [Newbie] ZSQL problem) (was: [Zope] [Newbie] ZSQL problem)
by Dieter Maurer 04 Jan '01

04 Jan '01

Hi Michal, Michal Seta writes: > ... query > "select ... where col = <dtml-sqlvar multiple_section type=string>" > works for single value but not for multiple selection ... This is difficult indeed, as you have to fight various strange behaviours. First, it is easy to explain, why your query does not work: When you select more then one value from the selection list, then "multiple_section" will be a list. Your "sqlvar ... type=string" converts this into a string that looks like "[ 'a', 'b', 'c']". This string is then compared to your database column. You easily see, the result will be false. Your SQL query is not correct to search for a value in a list of possible values. You must use something like select ... where col in ( 'a', 'b', 'c' ) How to construct such a query? If you know, that your values do not contain quotes (i.e. '), then you can use "_.string.join" like this: select ... where col in ( <dtml-var "_.string.join(multiple_selection,',')"> ) Now, your code will work, when you select more than one value from the list. It will fail, if you select a single item (or none at all). It fails for a single selected value, because in this case "multiple_selection" is not a list but a single value. Fortunately, if you put the ":list" suffix at the form variable name (like "<select name="multiple_selection:list" multiple ...>"), then you tell ZPublisher, that you want this to be a list. In this case, you will get a list with one value. This works well... ... up to the case, where no value is selected. In this case, the variable is completely missing from the request. You probably will get a "Bad request; missing arguments ['multiple_selection']" from your ZSQL method. In your case, it is probably best, to catch this case in the DTML code that handles your form and report a nice error. After you became more familiar with Zope and the rough edges of HTML form processing, you will hit cases where the above approach is not adequate. You can then ask again in the list (or search the searchable list archive). Dieter

1 0

Re: [Zope] EVAL DTML?
by Dieter Maurer 04 Jan '01

04 Jan '01

Brian Withun writes: > Is it possible to, say, retrieve DTML code from an external database (such > as Sybase) and then have that DTML code render itself? As I recall there is > a security issue with Zope allowing Python to EVAL dtml.. You can't do it in DTML, but you can in an External Python Method: Look at "DocumentTemplate.DT_HTML.HTML" (and "DocumentTemplate.DT_String.String). You create a new "DocumentTemplate.DT_HTML.HTML" from your DTML code and then call it. Dieter

1 0

Re: [Zope] Question: How to generate a core file in Solaris 2.6
by Dieter Maurer 04 Jan '01

04 Jan '01

Michael Best writes: > ... core generation under Solaris ... I have seen Zope cores under Solaris 2.6. This means, * either the problem you see does not result in a situation that usually causes a core dump or * your configuration prevents cores from being generated. I expect the latter. You told us, that you already changed the "ulimit" value. You know, that there are too values, a soft limit that can later be changed and a hard limit that can only be tightened? Maybe, there is some hard limit preventing you from changing the core size limit or Zope wants to generate a core that is larger than the size you specified. You can test core generation independent of Zope (to clean any configuation problems): sleep 500 & kill -QUIT %% This let's "sleep" generate a core. One you get "sleep" cores, you can hit Zope with the "-QUIT" signal. Zope's core will be bigger, therefore, the "ulimit" core limit must be larger. Once, you can reliably force Zope into a core, you can look at your instability again. Dieter

1 0

Python Scripts update
by Evan Simpson 04 Jan '01

04 Jan '01

Python Scripts have gone through a fair number of changes and bugfixes recently. They should now work properly as methods of ZClasses. When you download the source of a Python Script, the title, parameter list, and bindings are added to the source in the form of specially formatted comments. If source with these comments is uploaded or pasted into a Python Script, it will properly set the properties mentioned in the comment block. The default bindings have been changed to be more sensible. If you want to give Python Scripts a try, you can go to http://ps.4-am.com:9000/ , pick a password, and you'll get your own private area in a trunk CVS checkout of Zope in which to play. I promised examples when I first announced this site, and haven't gotten around to writing any. If you have created a script or set of objects on the demo site that you would like to share as an example, please mail me the URL. Cheers, Evan @ digicool & 4-am

1 0

Re: [Zope] Core Session Tracking kudos & namespaces
by Dieter Maurer 04 Jan '01

04 Jan '01

Chris McDonough writes: > .... > Currently, nothing would be acquired, and the <dtml-var a> call will fail > inside of a "with sessiondatamanager" even if we did have a __getattr__ > interface to session data objects.... Are you sure? As I understand it, at least a <dtml-with "sessionDataManager.getSessionData()"> would make available all session data keys as variables, if they had a "__getattr__". If they had a "__getitem__" (maybe, the available "get" is already sufficient), then <dtml-with "sessionDataManager.getSessionData()" mapping> would do the trick. Dieter

4 4

RE: [Zope] Deleting Connection that hangs Zope
by Spicklemire, Jerry 04 Jan '01

04 Jan '01

Steve suggested: > You could remove the adaptor Product from Zope the Zope Products > folder and restart, the object will be broken, but deletable, then > restore the Product and restart Zope. Good Idea! That's about as simple as this sort of thing can get, I suspect. >> Has anyone found a good way to delete a Database >> Connection that hangs Zope at startup? The >> connection seems to be waiting "forever", and so >> there is no access to the Zope interface, so of >> course I can't delete, or disable the offending >> object. >> If there were just a way to set it to not connect >> immediately, prior to startup, that should be >> sufficient. The general question is, "How do you >> access a Zope Object, without running Zope?" I was finally motivated enough to fire up Ty Sarna's Tranalyzer ( http://www.zope.org/Members/tsarna/Tranalyzer ) which makes it quite painless to find a point at which to truncate (the last few records of) the /var/data.fs file. Thanks! Jerry S.

1 0

Login dialog - another newbie question
by Michal Krejza 04 Jan '01

04 Jan '01

Hi Zopitas, I have problem with authentication in Zope. I made small site in our company, and some informations are visible for anonymous user and some for managers. So I need to authorize users before they connect to restricted area. It's late for me, becose access to restricted methods is able through links, which are visible only for managers. Is there any way to make some form for login to Zope. But without another application like LoginManager or MySQL User Folder and etc. My Zope server is running on WinNT and I have problem with these application. Michal Krejza When users connect to a restricted area a dialog box pops up that > looks more or less like this:

3 2

Deleting Connection that hangs Zope
by Spicklemire, Jerry 04 Jan '01

04 Jan '01

Hi Zope Fans, Has anyone found a good way to delete a Database Connection that hangs Zope at startup? The connection seems to be waiting "forever", and so there is no access to the Zope interface, so of course I can't delete, or disable the offending object. If there were just a way to set it to not connect immediately, prior to startup, that should be sufficient. The general question is, "How do you access a Zope Object, without running Zope?" BTW, I take back everything I said about RDBMS Storages being superfluous . . . Thanks, Jerry S.

2 1