- Zope - Zope lists

Re: [Zope] - IIS Authentication!
by Phil Harris 21 Jan '99

21 Jan '99

I have already tried that, but I get the error message as shown in the original post 8^( I'm now trying to get this thing to work on Linux with Apache and am having similar problems, oh god I wish I knew what I was doing 8^). Thanks anyway. Phil wmlph(a)d032.ml.uwcm.ac.uk ----- Original Message ----- From: Brian Lloyd <Brian(a)digicool.com> To: 'Phil Harris' <wmlph(a)d032.ml.uwcm.ac.uk>; Jim Fulton <jim.fulton(a)digicool.com> Cc: <zope(a)zope.com> Sent: Thursday, January 21, 1999 2:44 PM Subject: RE: [Zope] - IIS Authentication! >> I checked the user info and even created a new user, >> everything looks OK to >> me. >> >> The user's created are in the top level userfolder and have a role of >> 'manager'. >> >> As I said in my original post, I couldn't get anyone to log >> in with the >> instructions in the docs. So I have activated >> basic-authentication, would >> this have anything to do with it? > >Phil, > >Under IIS, you need to _both_ Basic and NT authentication >turned *off*. If either is turned on, IIS will attempt to >handle the authentication itself - it will never even consult >Zope :( > > >Brian Lloyd brian(a)digicool.com >Software Engineer 540.371.6909 >Digital Creations http://www.digicool.com > >

1 0

RE: [Zope] - IIS Authentication!
by Brian Lloyd 21 Jan '99

21 Jan '99

> I checked the user info and even created a new user, > everything looks OK to > me. > > The user's created are in the top level userfolder and have a role of > 'manager'. > > As I said in my original post, I couldn't get anyone to log > in with the > instructions in the docs. So I have activated > basic-authentication, would > this have anything to do with it? Phil, Under IIS, you need to _both_ Basic and NT authentication turned *off*. If either is turned on, IIS will attempt to handle the authentication itself - it will never even consult Zope :( Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

- How to specify multiple sort columns when grouping with IN
by Brad Clements 21 Jan '99

21 Jan '99

I'm using a ZSQL method to Select rows from a database. Depending on user input, I may need to group by "apt_use, faa_cnty, faa_city, apt_name" (in that order). I want to use things like first-APT_USE, first-FAA_CNTY, etc. My database has individual indexes on all of the above fields, but there isn't a single index on all of these fields. I've been using  To group, do I need to create a new combined key in the database, or can I specify something like sort="apt_use;faa_cnty;faa_city" etc. (it doesn't work) but something like that, or will the use of the first- tags automatically cause grouping? Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com ICQ: 14856937 We must come down from our heights, and leave our straight paths, for the byways and low places of life, if we would learn truths by strong contrasts; and in hovels, in forecastles, and among our own outcasts in foreign lands, see what has been wrought upon our fellow-creatures by accident, hardship, or vice. - Richard Henry Dana, Jr. 1836

2 1

Re: [Zope] - pcgi and multi concurrent access
by Service Informatique CHSR 21 Jan '99

21 Jan '99

>In the future, the application itself will be able to >handle multiple requests simultaneously. This will be >especially emportant if there are requests that consume alot >of application time, like indexing large databases. i suppose this mean that with this new version of pcgi, one has to write thread-safe code (although I still have to lean what thread-safe code is :-)). For example, one wouldn't write this: class MyData: """give access to my data""" def __init__(self): self.curs=db.cursor() # shared data -- bad def request0(self): """list the table0 content""" self.curs.execute("select * from table0") return self.curs.fetchall() def request1(self): """list the table1 content""" self.curs.execute("select * from table1") return self.curs.fetchall() bobo_application=MyData() One would write this instead: class MyData: """give access to my data""" def request0(self): """list the table0 content""" curs=db.cursor() curs.execute("select * from table0") return curs.fetchall() def request1(self): """list the table1 content""" curs=db.cursor() curs.execute("select * from table1") return curs.fetchall() bobo_application=MyData() Am i right? (about the fact that one should write thread-safe code *now* to support the new pcgi way of doing) Of course, this code is just an example, it is not what i intend to do. Also, why do i get each answer twice? I suppose you guy hit the "reply to all" button, which reply both to me and to the list. On another list, they hack the messages in such a way that when you reply to the sender, it gets to the list, not the sender. I don't know how they do it, but it works. Maybe you could do something similar for zope(a)zope.org ? Regards, Jephte CLAIN Service Informatique CHSR

3 2

- Using SQL Methods as containers
by Brad Clements 21 Jan '99

21 Jan '99

On 1/18, Amos wrote that the use of __bobo_traverse__ isn't necessary, and that "SQL Methods can be treated like containers .. In general you can reference database objects via URLs". Unfortunately, there was no more information than that. What I need to do looks like I'll need to override __bobo_traverse__ in a subclassed folder. have no idea how to do that exactly.. I have a folder hierarchy, like this: /Airports/PTD Where 'PTD' is a subfolder of Airports. If a person enters /Airports/ALB, and ALB does not exist as a subfolder of /Airports, what I want to happen is /Airports/AirportInfo?identifier=ALB So, /Airports/ALB could be either a true folder object under /Airports, and if it isn't there then the equivilant of /Airports/AirportInfo?identifier=ALB should be used instead. It'd be neat if a folder could have a "default document", that is, a document to be loaded if a requested folder object couldn't be found. My default document could then "import" the AirportInfo page appropriatly. Any suggestions? -- Also, regarding using #tree as a within-document expander/contracter, I've been thinking that what would probably be better is something called  that works like an , since that's more in line to what I need. The toggle would be "true" or "false" depending on the cookies, and the default state of the toggle (default false) I've looked at the TreeDisplay source .. hmm. Time to learn python.. What a strange langauge.. Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com ICQ: 14856937 We must come down from our heights, and leave our straight paths, for the byways and low places of life, if we would learn truths by strong contrasts; and in hovels, in forecastles, and among our own outcasts in foreign lands, see what has been wrought upon our fellow-creatures by accident, hardship, or vice. - Richard Henry Dana, Jr. 1836

1 0

- Problems with Z ODBC
by Christian Martel 21 Jan '99

21 Jan '99

i'm trying to connect Oracle Database with Oracle73 ver 2.5 ODBC driver through Zope; But it fails with a invalid connection string error. Is it possible Zope doesnt deal with userId and pwd request from Oracle ? Is it an other way to connect with Z (Aqueduct is not in add form) Thanks for your help Christian Martel

3 2

- Relative URL Secret?
by chalaouxf＠synbio.tpgnet.net 21 Jan '99

21 Jan '99

Hi All, How to use relative URL with ZOPE? It seems to be different from current HTML! :( ? FR François-Régis Chalaoux Bioinformatics Group Synthélabo Biomoléculaire 67080 Strasbourg Cedex FRANCE Tél : 03 88 60 87 14 Fax : 03 88 45 90 70

2 3

Re: [Zope] - IIS Authentication!
by Phil Harris 21 Jan '99

21 Jan '99

I checked the user info and even created a new user, everything looks OK to me. The user's created are in the top level userfolder and have a role of 'manager'. As I said in my original post, I couldn't get anyone to log in with the instructions in the docs. So I have activated basic-authentication, would this have anything to do with it? If I don't turn that on though then the 'superuser' can't login, 'rock-me-hardplace' 8^( Any other ideas. Phil wmlph(a)d032.ml.uwcm.ac.uk ----- Original Message ----- From: Jim Fulton <jim(a)digicool.com> To: Phil Harris <wmlph(a)d032.ml.uwcm.ac.uk> Cc: <zope(a)zope.com> Sent: Thursday, January 21, 1999 1:12 PM Subject: Re: [Zope] - IIS Authentication! >Phil Harris wrote: >> >> Hi, >> >> Thanks for responding. >> >> The new user has manager role! > >Hm. Are you sure? Is the Manager role selected in the user's >role list? > >> I assume that this user would have access to the whole Zope 'web', am I >> right? > >By default, yes. It's odd that you can get in with >the superuser id and password and not the new user id and >password. > >Double check the user, password, and role. > >Jim > >-- >Jim Fulton mailto:jim@digicool.com >Technical Director (540) 371-6909 Python Powered! >Digital Creations http://www.digicool.com http://www.python.org > >Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email >address may not be added to any commercial mail list with out my >permission. Violation of my privacy with advertising or SPAM will >result in a suit for a MINIMUM of $500 damages/incident, $1500 for >repeats. >

1 0

- ANNOUNCE: New Zope Guides Available
by Amos Latteier 21 Jan '99

21 Jan '99

Greetings Zoperators: I am happy to announce that we've finally finished updating the old 'Principia' guides to reflect the current state of Zopish affairs. Three cheers for Jim Fulton for his efforts on this! http://www.zope.org/Documentation/Guides The result is three new guides which teach you how to use Zope. * Z SQL Methods User's Guide * Z Document Template Markup Language User's Guide * Zope Manager's Guide The Z SQL Methods User's Guide explains how to access SQL data with Zope. The DTML User's Guide explains how to access and control web objects from within Documents using DTML tags. It includes a fairly exhaustive discussion of such topics as batch insertion, the tree tag, request variables, etc. The Zope Manager's Guide introduces Zope and gives a gentle introduction to creating and manipulating web objects. The guides are available in four popular flavors: * Online HTML * Online PDF * gzipped tarred Postscript * gzipped tarred HTML These new guides have something for everyone, including many things never before revealed! It's all there, from an explanation of what that Product directory in the Control Panel is good for, to detailing the initialization arguments for a DocumentTemplate HTML objects, to a friendly introduction to using basic Zope components. Enjoy! -Amos -- Amos Latteier mailto:amos@digicool.com Digital Creations http://www.digicool.com

4 3

Re: [Zope] - IIS Authentication!
by Phil Harris 21 Jan '99

21 Jan '99

Hi, Thanks for responding. The new user has manager role! I assume that this user would have access to the whole Zope 'web', am I right? TIA Phil wmlph(a)d032.ml.uwcm.ac.uk ----- Original Message ----- From: Jim Fulton <jim(a)digicool.com> To: Phil Harris <wmlph(a)d032.ml.uwcm.ac.uk> Cc: <zope(a)zope.com> Sent: Thursday, January 21, 1999 11:55 AM Subject: Re: [Zope] - IIS Authentication! >Phil Harris wrote: >> >> Hi all, >> >> My first posting to the list so be patient 8^). >> >> I set up the server as specified in the docs, but when I do this I get an >> error message as follows:- >> >> ------------------------------------------------------------------------- --- >> --- >> HTTP Error 401 >> 401.5 Unauthorized: Authorization failed by ISAPI/CGI app >> >> This error indicates that the address on the Web server you attemped to use >> has an ISAPI or CGI program installed that verifies user credentials before >> proceeding. The authentication used to connect to the server was denied >> access by this program. >> >> Please make a note of the entire address you were trying to access and then >> contact the Web server's administrator to verify that you have permission to >> access the requested resource. >> >> ------------------------------------------------------------------------- --- >> ---- >> >> So I turned on the basic-authentication and was able to log in as the user >> specified in the 'access' file. >> >> Great! >> >> I have now created a new user 'test1' with password 'test1' but am unable to >> login as this user, it just will not validate. >> >> I must be doing something wrong 8^(. >> >> Any ideas. > >What roles did you give this new user? > >Jim > >-- >Jim Fulton mailto:jim@digicool.com >Technical Director (540) 371-6909 Python Powered! >Digital Creations http://www.digicool.com http://www.python.org > >Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email >address may not be added to any commercial mail list with out my >permission. Violation of my privacy with advertising or SPAM will >result in a suit for a MINIMUM of $500 damages/incident, $1500 for >repeats. >

2 1