- Zope - Zope lists

Mapping acl_users to a database
by Ken Kinder 22 Mar '00

22 Mar '00

Does anyone have code that map acl_users to a database table? -- Ken Kinder 303.381.7631

2 1

Q: <dtml-in sort=twofields>
by Mario Lang 22 Mar '00

22 Mar '00

Hi. I am constructing a search interface for a catalog. The objects I index have three relevant properties: title (textual title) id (the id, sortable) book_title (the name of the book where the chapter is included) I want to have atabular result like this: Book 1 Chapter 1.1 Chapter 2.1 Book 2 Chapter 1.1 Chapter 4.2 To acomplish this I currently do something like: <dtml-in Catalog sort=id> <tr> <td><dtml-if first-book_title><dtml-var book_title></dtml-if></td> <td><dtml-var title></td> </tr> </dtml-in> But, to have the list look nice, I'd need to specify two fields for sorting, book_title should be the primary field sorted by, and id should be the field all identical book_title entries should be sorted on. Is there a way to do this with dtml-in? CYa, Mario <mlang(a)delysid.org>

2 2

httpd.conf help
by Erick Mechler 22 Mar '00

22 Mar '00

Here's the scenario that I'm dealing with (all of this works w/o Zope, i.e. static content): - user starts at www.mydomain.edu (http) - user goes to www.mydomain.edu/internal which is secure (https) and requires a password for entry - all pages under www.mydomain.edu/internal are secure (https) I'm having trouble getting this to work with out Zope-ified site, however. What I would like is to have Apache handle all password authentication, and I would like it to happen over ssl. Is this possible at all? Any help would be appreciated. Thanks in advance, Erick Mechler

2 1

Roles, Local Roles, and so on
by Oliver Andrich 22 Mar '00

22 Mar '00

Hi, I have a question concerning the Role and Local Role system. Well, am I right with the observation, that Local Roles are only locally assigned global roles? For example I have an user "oandrich" which is globally just a member of Role "user" but in /test/users/andrich for example I can assign him a "Manager" role? Isn't it possible to get really local roles? What I like to have are roles that needn't be defined in a global context and which are only available below a certain directory and are local to this part of the directory tree. Some background why I need this. I am developing a problem tracking system, that is used in my company, but we also of companies that are subproviders of us. I like to do the following. In /rz-online I install the tracking system for us. In /ewr-online I install the tracking system for one subprovider. Well, when I have to define global roles I see the roles the ewr-online admin defines in my possible list of Roles. And he sees mine. Ok, for me this is no problem, but the ewr-online people are a little bit nuts and so this will certainly confuse them. Ok, I can do something like adding global roles named like this JTS_<id of the folder>_<desired name> This is easy and fine to do in Zope, but it is ugly. So, is it possible to get really local roles? Bye, Oliver

1 0

Zope and Oracle ODBC
by Michael Gannon 22 Mar '00

22 Mar '00

Hi there, I'm trying to connect to an Oracle 7.3 database through Zope using a 'Z ODBC Database Connection'. It's giving me an error saying: 'Invalid connection string: gsmInfo' I set up a DSN throught the Control Panel as follows: Data Source Name: gsmInfo SQL* Net Connect String: 2: UserId: testowner This is using the 'Oracle73 Ver 2.5' Driver. I also used the '32-bit ODBC TEST' that comes with Oracle and this connected to the database no problem after entering in a password. Has anyone got any clues or suggestions to the problem. Thanks in advance, Michael Gannon. XML Workshop.

2 1

Role weirdness
by Jon Prettyman 22 Mar '00

22 Mar '00

I have a site containing some content users need to register to see. The way I set this up was: /premium/acl_users[GUF] Using GUF to authenticate and assign users a role of contentSubscriber. At one point in time, I created a user defined role at the root level of my Zope called contentSubscriber. I then changed the security on /premium to require contentSubscriber role to view or access content information. Now, I can't seem to find any mention of a contentSubscriber role anywhere in my Zope management screens OTHER than by looking at a user through /premium/acl_users/userList. None of the Find/Advanced... screens mention my contentSubscriber role either. The odd thing is that my access control scheme appears to work. Other than my random hourly crashes. -Jon

1 0

Re: [Zope] Casting to a list
by Hung Jung Lu 22 Mar '00

22 Mar '00

ken kinder <kkinde-(a)messagemedia.com> wrote: >How can I either cast a string to a list w/o messing up an existing >list, or gain access to Python functions such as type() from a >dtml-if statement? The simple answer is: you don't need to cast. :) Zope provides a solution: your specify in your multiple-select a name like varname:list, and Zope will automatically cast it into a list. That is, append the ':list' to your variable names. Hung Jung ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

2 1

ANN: ZEO goes Open Source
by Jerry Spicklemire 22 Mar '00

22 Mar '00

Open Source, Scalable, 24x7, Unstoppable!

1 0

RE: [Zope] Sybase: How generate id keys? (surrogate keys)
by Alexander Staubo 22 Mar '00

22 Mar '00

I use identity columns with Sybase -- the only problem I've experienced is a tendency to occasionally "burn" ID values, resulting in gaps. If you're not worried about non-sequentiality, identity columns are generally not a problem. Do you anticipate crashes? I have run Sybase for about a year, and never experienced a single crash -- meanwhile, Zope has crashed and/or been restarted many, many times. Aside for identity columns, here's an alternative scheme I used some time ago with an Access database (where, aside from DAO/ADO, you simply cannot obtain the previously inserted "autoincrement" value, causing problems for web-based forms): Create a table such as this create table Ids ( Id int not null primary key nonclustered ) Then create either a stored procedure (don't like 'em) or a Zope DTML Method that will (a) get the lowest available ID, and (b) if the table is getting empty (count < delta), then replenish the table with new, unique values, starting at the ID you just obtained. (If the table is empty when you start out, assume this is the first time the method is run, and simply start with a seed of, say, 1.) Because of transaction logic, IDs will never be "burned", and the only gaps you will experience will come from IDs that disappear when their parent records are deleted. Hope this helps. -- Alexander Staubo http://alex.mop.no/ The difference between theory and practice is that, in theory, there is no difference between theory and practice. > -----Original Message----- > From: Hung Jung Lu [mailto:hungjunglu@hotmail.com] > Sent: Tuesday, March 21, 2000 12:24 AM > To: zope(a)zope.org > Subject: [Zope] Sybase: How generate id keys? (surrogate keys) > > > Hi, > > How do people generate id keys (surrogate primary keys) > in Sybase+Zope? There are some recommended ways of doing it > in Sybase with stored procedures but I can't run stored > procedures in Sybase. > > I am looking at heavy-traffic strategies. So I need something > slightly better than a simple increment table for the keys. > > Any recommendations? Thanks in advance. > > Hung Jung > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com > > > _______________________________________________ > 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] Sybase: How generate id keys? (surrogate keys)
by Sin Hang Kin 22 Mar '00

22 Mar '00

The unique id problem come up again and again. The automatically generated unique id will benefit web author with sql row id object id and may be some others With a view that zope will be run over the network with distributed storage across the net, I would like to suggest we implement a unique id server which can be a zope server serving on another port and serialize all request and return the globally unique id. Does this work? I also suggest zope can be configured to automatically get the object id from this service and have globally unique object ids. Rgs, Kent Sin

2 1