- Zope - Zope lists

db newbie
by Micah Freedman 14 Sep '00

14 Sep '00

Hi, I'm just discovering Zope and it seems to have a lot of promise. I'm a front end designer/developer and I'm hoping Zope will allow me to create a database driven site without too much fuss. The database is small, but moderately complex. I'm pretty sure it needs to be relational, as opposed to a tiny table. I feel strange, asking such basic questions, but I don't really know where to get started. I know a little bit about relational databases, but only a little. I've seen in the zope tutorial that you can send an SQL query to the database and use it to populate a list, but where do you build the initial database? I have MS Access. Do I build something in that on my desktop and upload it somewhere? Do I create a form to create the db from scratch? Is there somewhere I can read about all this (in a nice Tutorial, step-by-step fashion)? Would it help if I described the functionality I'm looking for? Thanks, Micah

3 2

Simple dtml-unless problem
by Tim Hicks 14 Sep '00

14 Sep '00

I have the following code in my standard_html_header <dtml-unless "id == 'index_html'"> <img src="<dtml-var path>/images/transparent.gif" width=400 height=12 alt=""> <H1 align="center"><dtml-var title></h1> </dtml-unless> The problem is, it displays the <img> and <h1> stuff even when the page that the standard_html_header is being dropped into is index_html. I'm pretty sure I'm missing something really silly here, but if anyone could point it out, I'd really appreciate it. cheers tim

4 7

FW: [Zope] FW: list of users tied to database
by tom smith 14 Sep '00

14 Sep '00

---------- From: tom smith <tom(a)othermedia.com> Date: Thu, 14 Sep 2000 09:01:22 +0100 To: tom smith <tom(a)othermedia.com> Subject: Re: [Zope] FW: list of users tied to database <dtml-in "theOTHERintranet.acl_users.getUserNames()"> <dtml-let TheUserName==<dtml-var sequence-item>> <dtml-in "get_email('UserName=<dtml-var TheUserName>')"> <dtml-var Email><br> </dtml-in> </dtml-let> </dtml-in> Thanks for the efforts of everyone so far, but alas, the code doesn't quite work. Forgive me, but could I/we/you try again. I've created a sql method called get_users() which has UserName as a parameter, which is the same as the zope login. I'm trying to get a list of emails (from a database) based on the contents of the acl_users folder. I'm trying to extend the notion of a user, giving them extra attributes and using a database to do it. cheers all tom

1 0

DCOracle Connection with Oracle 8.0.5
by Celio C. Guimaraes 14 Sep '00

14 Sep '00

I have just installed the DCOracle package V 1.3.1b on a Linux Red Hat 6.2, to access an Oracle 8.0.5 Server with python1.6 I have run with success a few tests with the scott/tiger user tables, however: 1) In order to connect successfully I had to drop the @sid parameter: dbc=DCOracle.Connect('scott/tiger@ora8') returns with error: ORA-12154 : TNS: could not resolve service name 2) I would like to connect to a remote oracle server. In this case the @sid parameter is essential. How could this problem be fixed? Is it a simple parsing problem in the oci_8.c Logon routine? which is the correct string to pe passed? @myserver.ic.unicamp.br:ora8 did not work either! Celio Guimaraes Institute of Computing Unicamp - Brazil

3 2

zope 2.2.1 and python 1.6
by Jon Nathan 14 Sep '00

14 Sep '00

hello, i couldn't find anything in the list archives or the docs about python 1.6 from python's site, it looks like there are a lot of changes that could break code. can i run zope 2.2.1 on python 1.6 or should i stick with 1.5.2? thanks, -jon -- Jon Nathan jon(a)blading.com http://www.rupture.net/~jon/

5 7

Re: [Zope] Zope and the GPL poison pill
by Karl Anderson 13 Sep '00

13 Sep '00

Correct me if I'm wrong (and don't bother with the discussion on the merits or non- of the GPL, I don't care in this context), but: In order to link/incorporate a GPL'd module, you have to be able to distribute the entire work under the GPL. RMS says that the ZPL isn't compatible with the GPL; either you can't get something via rights given by the ZPL, then distribute it under the more restrictive rights of the GPL (the copyleft virus). Or vice versa. Therefore, assuming RMS is correct, GPL'd components can't be distributed as part of a Zope solution. You can link & use them, or distribute one and provide a pointer to the other for the other party to install, just not distribute them together to anyone else. Is this correct? If it is, the GPL isn't very appropriate for the license of a Zope product, becuase it's a packaging nightmare. -- Karl Anderson karl(a)digicool.com

9 13

Re: [Zope] Zope and the GPL poison pill
by Magnus Alvestad 13 Sep '00

13 Sep '00

[Danny William Adair] | Now Nils and Oleg are giving me the creeps. There are several issues here. First, it is not obvious that including one GPL'ed product in a zope site and then distributing that site obliges you to distribute any further source code. Only if you (embrace and) extend that specific product would the GPL hit you. Second, even if it does, remember that a zope site almost always includes source anyway. I guess the exception would be if you have binary-only python files or linked pre-compiled c-code or something like that. But it would be very hard to claim that those parts were 'infected' by a product on your site being GPL'ed. Third, you are only obligated to distribute source to parties you have already distributed the binary version to. I can't really see a customer buying a zope site from you and not expecting 'source' anyway. -Magnus (I'm not a lawyer)

8 13

Re: [Zope] Logging out of Zope
by Dieter Maurer 13 Sep '00

13 Sep '00

Stuart Foster writes: > Is there a way to allow an authenticated user to logout of Zope? > I want to allow a user to logout and someone else login. This is a FAQ. Please search the list archive to get various hints. Dieter

2 1

Re: [Zope] problem logging in to /manage resource
by Dieter Maurer 13 Sep '00

13 Sep '00

Hi Manuel > I've been tryhing hard for the last two weeks to use > zope but I can't seem to get it to go past the /manage > resource. I'm running zserver, I tried the default > password, changing it with zpasswd, removing domain > restrictions, everything, but it still gives me > authentication failed. Please help me. I'm going > insane here. The problem is probably, that we do not have your problems. I, personnally, installed Zope and connected to it without any problem. I simply cannot imagine what may go wrong in your installation. The same is probably true for the other list readers, too. The only thing, that is relevant for the first access to "manage" is the file "access". Thus, there may be a problem in this file (or Zope uses a file "access" different from that you expect). What I can offer you: send me your access file (together with name/password, of cause -- you may recreate "access" with new name/password such that I do not get secrets from you). I can try it in my installation. Maybe, I am able to see what goes wrong. Dieter PS: Your mail address is really strange (at least as I see it through the digest). I, therefore, post to the list (sorry, list).

1 0

RE: [Zope] how to change the 'Zope' realm/resource??
by Dieter Maurer 13 Sep '00

13 Sep '00

Brian Lloyd writes: > The realm is currently an attribute of the RESPONSE object. > .... > Note that wouldn't help with "per folder" realm changing. > I'm open to suggestions on that. One way I suppose would > be to subclass Folder and implement an extended version > of __bobo_traverse__ that changed the realm upon traversal. Or (ab)use the SiteAccess product (an external method as AccessRule setting the RESPONSE's realm attribute. Dieter

1 0