- Zope - Zope lists

Newbie - parameterized query...
by fowlertrainer＠anonym.hu 12 Dec '03

12 Dec '03

Hello , My problem is that: I have ZPT pages, and scripts. I want to check some infos with SQL query. This an example: script: ------- ss=context.REQUEST.SESSION r=0 uusr=usr.lower() result=context.LoginScripts.dbcheckUsrPwd(uusr,pwd) if len(result)>0: r=1 ss['userid']=row[0] ss["username"]=usr ss["full username"]=row[1] return(r) zsql: ----- params: usr,pwd select * from inst_prguser where webusr=<dtml-sqlvar usr type="string"> and webpwd=<dtml-sqlvar pwd type="string"> The result is: "Missing input variable, usr". I think this is wrong in zsql - it have wait for dtml-var. But how to I do it in good way to the zsql get good parameters ? Thanx. -- Best regards, fowlertrainer mailto:fowlertrainer@anonym.hu

4 3

Re: Environment for Python Development
by E. Frerich 12 Dec '03

12 Dec '03

1 0

RE: [Zope] Help on identification
by Tiller, Michael (M.M.) 12 Dec '03

12 Dec '03

> From: J Cameron Cooper [mailto:jccooper@jcameroncooper.com] > Subject: Re: [Zope] Help on identification > > > Tiller, Michael (M.M.) wrote: > > >I'm trying to setup a Zope server on our corporate intRAnet > set. We have a > >formal system of authenticating users. It is centralized. > I don't want to > >go into too much detail, but suffice it to say that I can > invoke a program > >and it will tell me whether the person requesting my page has a valid > >certificate and, if so, who the person is. > > > >What is the best scheme for integrating such a program into the Zope > >authentication and identification process. Key things are: > > > >1) The user does not provide a password, only the validity of the > >certificate is checked. > > This detail I cannot really advise on. You're trying to get a > certificate? If it comes in REQUEST it's easy to get. It comes in REQUEST. There is no issue here, I just added this as information. The important point is that no password is required from the user. > >2) How do I invoke an external program from Zope?!? > > > > > Any filesystem-based code can do it, using the usual Python > calls. (This means External Methods and Products.) Great. I just wanted to confirm that. Unfortunately, I don't have easy access to the file system (although I'm not completely blocked) so I wanted to know if there was a way around this. In a sense, it is reassuring that there isn't. :-) > > 3) Are there any "out-of-the-box" user folders that can > > handle this? I couldn't find any. If not, what is the best > > open ended product and what would I need to do? > SimpleUserFolder I looked into this, but it wants to feedback into the user source. It wants to be able to create new users and edit the roles and password of an existing user. I'm not in a position to provide any of this. > ExtensibleUserFolder exUserFolder says that the one method that is mandatory is "listOneUser" which has to return the username, password and a list of roles for the user. In our system, I already know the identity of the person. I don't need to authenticate them. > PluggableUserFolder This folder is quite generic. Based on my reading of the "INTERNALS.txt" file, I would need to provide my own identification method (which would fit pretty simply into this), the authentication would really do nothing and the authorization should be based on local user data (information about roles) that would be maintained over and above our intranet indentification/authentication system. So this one is a possibility but a possibility with a perhaps steep learning curve and lots of coding. > all provide some simplified API for arbitrary user sources, > authorization, and authentication. The closest thing I have found is "RemoteUser" which identifies a user based on the REMOTE_USER environment variable. This would work great if I had access to REMOTE_USER, but it isn't clear that I will. In any case, it seems to function the way I want (it doesn't care about passwords, it just grabs the user's identity and adds them to the user folder if they don't exist already). This is along the lines of what I want, but it is going to require me to hack it a little bit in order to support our specific system. I was hoping for something that I might be able to configure "through the web". I'll also look into how authentication is done with SSL since that is very similar to what we do. Thanks. > --jcc -- Mike

1 0

Creating a Zope Product
by Asad Habib 12 Dec '03

12 Dec '03

Does anyone know how to create a Zope Product? One example would be the Local File System Object that I am using. If you could point me to some resources that would be great. Thanks. - Asad

3 2

Environment for Python Development
by Asad Habib 12 Dec '03

12 Dec '03

Hello. Do any of you know of an IDE(preferably open source) that I can use to develop/debug/test python code in? Thanks. - Asad

2 1

Changing the Appearance of the Contents of a Local File System Object
by Asad Habib 12 Dec '03

12 Dec '03

Hello. I have a folder that I have created at the root level and inside this folder I have placed one Local File System object. The Local File System object contains two File objects. When I view the Local File System object by clicking on the 'View' option provided by the management interface, I can see that it contains two File objects. What I would like to do is to change the way that these File objects are displayed. Specifically, I would like to show only certain attributes that these File objects have and hide others. Right now, the following attributes are shown: type, icon, size, and last modified time(mtime). I would like to hide the size and last modified time(mtime) attributes. I want these attributes to be set but I do not want their values to show. FYI, I am using the Local File System Product. Any help would be greatly appreciated. Thanks. - Asad

1 0

too fast growing data.fs
by Carrer Yuri 12 Dec '03

12 Dec '03

Hi! my data.fs is growing too fast. I just insert some object at day, edit scripts... and it grows from 50MB to 400MB in two weeks! how can I solve it other than pack daily? what should I look for? thanks :)

6 6

Zope not starting properly under softlimit: Internal server error
by Heimo Laukkanen 12 Dec '03

12 Dec '03

I'm witnessing very strange behaviour on one box and was asked to help. On the box is running a zope cmf-site that refuses to start if softlimit is set, even though the softlimit would be set quite high. This is extremely strange since the service itself ( afaik from the people who manage it ) doesn't want to hog large amounts of memory or when running consume lots of it. If softlimit is set on the startscript then zope does start, but produces only 'internal server error' message to requests. Any help would be appreciated. Details below: kernel 2.4.18-27.7.x daemontools-0.76 Python 2.1.3 zope 2.6.0 Starting Zope: cd $INSTANCE_HOME /usr/local/bin/softlimit -m 536870912 \ /usr/bin/python2.1 z2.py \ -p $INSTANCE_HOME/Zope.cgi \ -u zope \ -z $INSTANCE_HOME \ -Z 1 \ -L fi_FI(a)EURO.ISO-8859-1 \ -l $INSTANCE_HOME/var/Z2.log \ >> $INSTANCE_HOME/var/Z2.log 2>&1 \ -- -huima

2 1

starting zope in bsd
by David Bear 12 Dec '03

12 Dec '03

the more I think I know the less I really do.. sorry about this but I've confused myself I want to run zope as user www. so in the start script I use "-u www". If I am root and run ./start & zope barfs on me and gives me the message that I need to read the setuid.txt file... okay. (I chowned all zope files to www:www) But I don't want to run zope as root, and zope won't listen on port 80.. so, back to running zope as user www. I can su to user www, run zope and all is well. terrific. Now I want to put a startup script in /usr/local/etc/rc.d. So now I'm back to starting zope as root again right? How can I get the startup scripts to launch zope as user 'www'? I'm using freebsd and zope 2.6.? latest. -- David Bear phone: 480-965-8257 fax: 480-965-9189 College of Public Programs/ASU Wilson Hall 232 Tempe, AZ 85287-0803 "Beware the IP portfolio, everyone will be suspect of trespassing"

3 2

Apache URhell (revisited)
by mh 12 Dec '03

12 Dec '03

Thanks to those that responded off-list to my original query, but I'm still having no joy whatsoever in getting Zope to properly handle requests proxied to it from Apache. My Apache configuration is: <VirtualHost 10.0.0.2> ServerName www.test.com ServerAlias test.com RewriteEngine On RewriteLog "/var/log/httpd/rewrite_log" RewriteLogLevel 9 RewriteRule ^/(.*) http://localhost:8080/VirtualHostBase/http/test.com:80/VirtualHostRoot/$1 [L,P] </VirtualHost> (RewriteRule directive shown wrapped over three lines.) test.com is defined as a zone on my local name server pointing to 10.0.0.2. I have a VirtualHostMonster in the Zope's root folder with no mappings defined there. Also in the root folder is a folder "test.com" with the default DTML document index_html. When a request is made to www.test.com, Zope intercepts it but displays the (acquired?) content from the root folder's index_html. Snippets from the error_log show this: TraversalRequestNameStack [] VirtualRootPhysicalPath ('',) URL 'http://test.com:8080/%241' SERVER_URL 'http://test.com:8080' URL0 http://test.com:8080/%241 URL1 http://test.com:8080 BASE0 http://test.com:8080 BASE1 http://test.com:8080 BASE2 http://test.com:8080/%241 (No idea what the %241 implies, but it's there in the error log) PATH_INFO '/VirtualHostBase/http/test.com:8080/VirtualHostRoot/$1' HTTP_HOST '127.0.0.1:8080' REQUEST_METHOD 'GET' PATH_TRANSLATED '/VirtualHostBase/http/test.com:8080/VirtualHostRoot/$1' The "/$1" on the end of PATH_INFO and PATH_TRANSLATED would suggest to my naive eyes that Zope isn't properly mapping the URL to a local resource, but that's just conjecture on my part. VirtualRootPhysicalPath also looks a little suspect. If I make an explicit request for http://10.0.0.2:8080/VirtualHostBase/http/test.com:80/VirtualHostRoot/ (as suggested by an off-list response), then again, the root folder's index_html is returned, not that of test.com. Requests to 127.0.0.1 as opposed to 10.0.0.2 generate the same result. Muchos kudos to anyone who can shed some light! mh

1 0