- Zope - Zope lists

Re: Enhanced sorting facilities
by Oleg Broytmann 23 Apr '01

23 Apr '01

Hello! In response to Brian's comment #12 at http://dev.zope.org/Wikis/DevSite/Proposals/ExtendedDTMLSorting I implemented Extended Sort External Method: http://www.zope.org/Members/phd/Sort/#Ex. The syntax is slightly different: SortEx(sequence, ((key,), (anotherkey, locale))). I wrapped the sort options in one tuple because I need to pass namespace and mapping parameters: SortEx(sequence, ((key,), (anotherkey, locale)), mapping=1). Command-line and Zope tests provided. Oleg. ---- Oleg Broytmann http://phd.pp.ru/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

1 0

Passing parameters to python script objects
by Uwe Fechner 23 Apr '01

23 Apr '01

Hello everyone, I'm a newbee with zope and have the following problem: I want to display calculated results from an SQL-Database. I created an object 'Script (Python)' that looks like: ## Script (Python) "myFunction" ## bind container=container ## bind context=context ## bind namespace=_ ## bind script=script ## bind subpath=traverse_subpath ## parameters=myParam ## title=myFunction ## return myParam[0:-1] Then I created a dtml document object with the content: <dtml-var expr="myFunction('test')"> If I choose 'View' I see: tes This is what I have expected (the function chops the last character). Then i tried: <dtml-in select_all_from_myTable> <p><dtml-var myField1></p> </dtml-in> If i choose 'View' i see: test1 test2 test3 Then I tried: <dtml-in select_all_from_myTable> <p><dtml-var expr="myFunction(<dtml-var myField1>)"></p> </dtml-in> If I choose 'View' I get: Expression (Python) Syntax error: invalid syntax So, how do i have to write this call, that it chops the last character of myField1 ? Best regards: Uwe Fechner

3 2

Search
by zope＠sjeems.nl 23 Apr '01

23 Apr '01

Hi all, I have a question I hope someone could help me with.. I have made a Znieuws (Zclass) for adding newsarticles. If I add a instance through the zope interface everything is ok. The instance is putten into the Catalog with all of it's properties. I've allso made a few pages where you can see all the articles, add articles edit articles and delete news articles. Now my problem is If I add an article through the "user" interface (without seeing the zope interface). The article is put ito the catalog but it misses all of it's properties , except for bobo_modification_time and title. If I now manualy update the Catalog (selecting the catalog, on the catalog tab selecting the article and press update) It gets all of it's properties cataloged and so everything works. Hope someone can help on this. I couldn't find anything in the archives. Thanx, James

1 0

Problem setting up Ultraseek DA
by John Lawson 23 Apr '01

23 Apr '01

Hello everyone, Has anybody had any success integrating the Inktomi search engine with a Zope application? I have been trying to use the Ultraseek DA product, without much success. Creating an Ultaseek DA object fails with "An error occurred connecting to the server. " message. After debugging UltraseekDA.py, I found a problem with the following statement; data=marshal.loads(data) (line 135) I have included a small python program along with it's output which demonstrates the problem (I think). Regards, John Lawson import marshal import httplib h = httplib.HTTP('proxy:8765') h.putrequest('GET', '/da/config.html') h.putheader('Accept', '*/*') h.endheaders() errcode, errmsg, headers = h.getreply() f = h.getfile() data = f.read() #get the marshalled data f.close() print headers data=marshal.loads(data) >>> Server: Inktomi Search 4.1.0 Date: Mon, 23 Apr 2001 12:25:46 GMT Content-type: application/x-python-marshal Content-length: 41473 Traceback (innermost last): File "C:\Program Files\Python\Pythonwin\pywin\framework\scriptutils.py", line 301, in RunScript exec codeObject in __main__.__dict__ File "C:\Program Files\Python\ultraseek_test.py", line 12, in ? f.close() ValueError: bad marshal data >>>

2 3

ZmxODBC vs ZODBC
by alan runyan 23 Apr '01

23 Apr '01

ok. just got ZmxODBC working: * install ZmxODBC and ZODBC * copy the sql.pyd file from the ZODBC directory to the ZmxODBC directory * copy mx /lib/python/Shared to /lib/python ;) to get it in the PYTHONPATH * uncomment #from sql import * that is in ZmxODBC/dbi.py (could be dba.py, I forgot) and all works well. * crank zope up and hopefully you get no errors ;) now, I havent look too heavily into this, but it seems that ZmxODBC seems to work just fine. I heard some people saying it was unpredicatable. could someone please point me to instability problems you may have found with ZmxODBC? I am looking for the most reliable way to access ODBC datasources from ZOPE. I have used mxODBC (outside of ZOPE) before and its worked quite well. I'm doing a unrealistic test w/ httpperf and I'm not having problems and memory usage isnt blowing up. I dont see any problems. mind you, I'm only using it against MS Access - SQLServer will be tomorrow. please email me if you have reproducible problems w/ ODBC and ZOPE. I have a client that is interested in ZOPE on Windows -- so far it looks like it works reasonably well w/ ZmxODBC and Access (they will be using Access and SQLServer). thanks, runyaga

2 1

Re: [Zope] Database Access Question
by Oliver Bleutgen 23 Apr '01

23 Apr '01

> hi, > I'm trying to get the Zope zen when it comes to zSql methods and a custom > user > folder. I've got a Win32 application that I'm trying to evolve into a > combination > of WebObjects and Zope applications. I'm hoping to share an > authentication > mechanism/scheme between the 3 applications. The current Win32 app uses a > combination of database protection and a custom "license" mechanism to > enable/disable application features based on a user's role. I need to > replicate > this functionality in Zope. > I would like to have a user folder that authenticates a user based on a > combination > of database password (i.e., like the username and password that the > zODBCDA > connection uses for the connection string) and a custom users table (if > the user > gets that far), and a license file product that sits in the custom user > folder and > provides role information. I've looked at LoginManager and UserDB and > don't know > which one to start with, or even if either of them is an appropriate > launch point. Hi Chris, my first idea would be to create the database connections when the user is created, i.e. in a special per-user folder and hardwire the db-login and passwd in the database connection. In the folder above I would use LoginManager (don't know about UserDB, though). LoginManager has a method which is called userAuthenticate which returns true (or 1) if the user is authenticated. Use that for checking your users against any datasource you like, for instance <dtml-in "SQL_get_password(username=username)"> <dtml-if "_.crypt(password,_['sequence-item'].real_password)==_['sequence-item'].real_password"> <dtml-return "_.int('1')"> </dtml-if> </dtml-in> for checking against crypted passwords in an external database. Theres also a Method called userRoles which returns a list of the roles the users has. This could check your license files with the help of an external method in order to return the appropriate roles which then could be used in zope with custom roles. cheers, oliver

1 0

Database Access Question
by Chris Walters 23 Apr '01

23 Apr '01

hi, I'm consider myself a Zope newbie even though I've done a number of projects with DTML and zClasses; I've yet to implement a Zope product from scratch or deploy what I would consider to be a complex app. However, that's about to change! I'm trying to get the Zope zen when it comes to zSql methods and a custom user folder. I've got a Win32 application that I'm trying to evolve into a combination of WebObjects and Zope applications. I'm hoping to share an authentication mechanism/scheme between the 3 applications. The current Win32 app uses a combination of database protection and a custom "license" mechanism to enable/disable application features based on a user's role. I need to replicate this functionality in Zope. I would like to have a user folder that authenticates a user based on a combination of database password (i.e., like the username and password that the zODBCDA connection uses for the connection string) and a custom users table (if the user gets that far), and a license file product that sits in the custom user folder and provides role information. I've looked at LoginManager and UserDB and don't know which one to start with, or even if either of them is an appropriate launch point. Does this sound like a reasonable thing to try? Can anyone suggest alternative mechanisms to unify the authentication of users between these 3 development and application environments? We already have a database in place, so that is pretty easy to modify if necessary. I know about LDAP but that would mean major changes to the legacy win32 code that I'd like to avoid if possible. Any hints would be greatly appreciated.

1 0

Re: [Zope] Using odd numbers
by Sven Hohage 23 Apr '01

23 Apr '01

Hello Gitte, To use the odd and even -attribute you have to be inside an iteration. <dtml-in someSequence> <dtml-if sequence-id-odd> <tr bgcolor="blue"> <dtml-else> <tr bgcolor="red"> </dtml-if> <td> some stuff here</td> </tr> </dtml-in> Hope this helps. Sven

1 0

finding zope python libraries.
by ghaley＠mail.venaca.com 23 Apr '01

23 Apr '01

hi, i've been noticing something happening in a rather sporadic way. sometimes when i try to install a new product -- the specific example right now is LoginManager -- i cannot get it to install correctly. i notice that some of the *.pyc files do not get generated; when i try to run these from the console, i get errors that indicate the .py file cannot find the appropriate class.method, etc., although in the lib/python/ directory, the class and methods are there. if i launch python from the console into interactive mode, and do the following, $ python >>> import sys >>> sys.path the returned value does not display the zope/lib/python/ directory -- so after reading a lot of python documentation, cruising the zope.org search facility, i can define the pythonpath in my shell, but this is good only for my console, how do i make these zope python libraries available to zope? ciao! greg. Gregory Haley DBA/Web Programming Venaca, LLC.

1 0

RE: [Zope] Debian zope2.1.6-7 installation, can't login 1st acces s
by Farrell, Troy 23 Apr '01

23 Apr '01

Basic, I am not very familiar with version 2.1.6, so I cannot help you specifically. I can however, recommend that you upgrade to a later Zope version. The latest stable version is 2.3.1 and is available at http://www.zope.org/Products/Zope/2.3.1/ If you move to a newer version and continue to have difficulty, I'll be happy to help you troubleshoot it. Troy -----Original Message----- From: basicprinting(a)earthlink.net [mailto:basicprinting@earthlink.net] Sent: Saturday, April 21, 2001 8:55 PM To: zope(a)zope.org Cc: debian-powerpc(a)lists.debian.org Subject: [Zope] Debian zope2.1.6-7 installation, can't login 1st access Something is very wrong with my copy of the Zope 2.1.6-7 Debian pkg. I can't seem to get it to do anyhing. http access is messed. when I type $ lynx http://localhost:9673/ I do not get the Welcome to Zope screen I get a password prompt which doesn't accept my Super/Emergency/Administrator/accessfile username & password. repeated attempts get a 401 error screen, which says I am unathorized I have tried all the suggestions in the /usr/share/doc/zope/README.Debian.gz (All the archived messages I've run across reiterate these changes I've already tried.) $ /usr/sbin/zopectl stop $ /usr/sbin/zope-zpasswd username: superuser password: admin123 encoding: SHA domains: $ chown -R www-data.www-data /var/lib/zope/* $ /usr/sbin/zopectl start Starting Zope . . . . . . . . . . . . . . . . done. #but it still doesn't give me the welcome screen and demands name/passwd $ lynx http://localhost:9673/ unable to access without authorization --retrying username: superuser password: admin123 denied 401 errorscreen Unauthorized ---------------------------------------------------------------------------- ---- boring newbie's details of machine's setup follow ---------------------------------------------------------------------------- ---- Started with a virgin Debian Installation: powermac 7200 (ppc601/75) Format HD and install Base System CD- binary-powerpc-1.iso 08-Dec-2000 default stable archive Installer prompts for additional software, from the SimpleTaskInstaller I chose Newbie Help and Finished the install. (this is the cleanest install I've figured out as a newbie) login as root Modify sources.list point to debian.org site $ apt-get update $ apt-get -u install python-base finishes successfully $ apt-get -u install zope works away then... gives me message about changes to ports, etc then prompts for username & password. and starts up Zope successfully. At least that's what it thinks $ lynx http://localhost:9673 should at least give me the welcomescreen. but I get - cannot access without authorization I immediately stop zope with /usr/sbin/zopectl stop and then make changes suggested in README.Debian.gz as mentioned above.

1 0