- Zope - Zope lists

Re: [Zope] ZSQL: How to use return value from an 'INSERT'?
by Jens Helweg 17 Nov '99

17 Nov '99

Steen Suder <sfs(a)kollegie6400.dk> wrote: > I'm using PostgreSQL 6.5 and Zope 2.x on RH6. > When inserting a new record in database I'd like to access the return OID > from the INSERT query from within my ZSQL method. > That is: if it returns anything... psql does return the OID. > How do I do? You can execute a second SQL-Method, i.e.: <dtml-var sql_delimiter> SELECT MAX(OID) FROM your_table to get something like an autoincremented primary key that was generated by your INSERT statement. -- helweg(a)innominate.de innominate AG networking people fon: +49.30.308806-14 fax: 77 web: http://innominate.de

2 1

Comments on the Zope Administrator Guide
by Chuck Burdick (TT) 17 Nov '99

17 Nov '99

I am currently considering Zope for a major internal application within our company. I have major concerns that are not documented, and should probably appear in the Zope Administrator Guide. I understand that the ZAG is a work in progress. Perhaps these topics can be covered in a subsequent version. I'm sure others find these to be critical topics as well. 1) Security of the host system 2) Security/Encryption over the wire 3) Database management - The "Zope Management" section should NOT be in the Content Manager's guide, it should be in the ZAG. 4) Database archival and backup 5) Database replication between hosts 6) Performance monitoring 7) Interaction of multiple Zope servers (host systems) 8) Interaction of Zope front-ends (ZServer, Zope's FTP, Apache, wu-FTP, etc.) 9) Centralized authentication models across multiple servers (host systems) If anyone knows where existing documentation is on these topics, I would be very grateful. Thanks, Chuck Burdick Web Administrator/Developer Trading Technologies, Inc. chuck.burdick(a)tradingtechnologies.com (847) 424-8844

1 0

Zope vs. Lotus Notes/Domino
by Chuck Burdick (TT) 17 Nov '99

17 Nov '99

Our company is beginning a project to create a complete intranet system and move towards a more paperless office. Naturally, Notes/Domino has been suggested as a platform/development/delivery mechanism. It seems, however, that Zope might be a better environment for such an intranet system. I would like to present Zope as an alternative to Notes to our infrastructure group. Can you, the Zope community, help me accomplish this? Since Lotus will probably send a rep to our site, I will need information that is of equal professional quality. What are the pros/cons of each environment? How well does Zope address the goals listed below? I don't want to start a flaming war. I am interested in a practical comparison. Here are some of our goals: - Document management - Discussion boards - Live chat (for our support teams) - Knowledge bases (for our support teams and software development teams) - Secure document routing w/ digital signature capabilities - Connectivity to ALL of our back office systems - Accounting, Bug Tracking, Trouble Tickets, HR/Payroll, small databases, etc. Here are some of our prime concerns: - Scalability - many offices working together, integration of many systems, many servers working together, many platforms working together. When I think of scalability, I think of these two possibilities: (1) Suppose we open an office in Japan, and the data link is expensive. We will probably want a server at that location performing efficient data replication. (2) Suppose we acquire/merge with another company. We want to integrate their systems with our systems. - Security - Encryption over the WAN and perhaps over the LAN. Encrypted passwords. Reliable, secure digital signatures. Suppose we want to have employee's stock option agreements on the intranet. This would need to be secure enough to ensure privacy. Suppose we wanted to share financials with our London office. We would need to ensure security over the WAN and that only certain individuals would have access. - Seamless integration - Suppose we want to cross-reference our trouble ticket database with the bug tracking database then tie into the accounting system for support billing. Thanks, Chuck Burdick Web Administrator/Developer Trading Technologies, Inc. chuck.burdick(a)tradingtechnologies.com (847) 424-8844

1 0

Import Error ZServer, ZODB
by Chandu Patil 17 Nov '99

17 Nov '99

I have seen the following a couple of times on my Windows 95 laptop (my learning system). Once with Zope 2.01 and also with the latest Zope2.1 Beta2. After I do some work - like going through the "Boring" example and the Plutonia tutorial, the next time I attempt to restart Zope - it gives me an error to the effect that import Zserver line fails in z2.py. I reinstalled Zope and things start to work. The time before, it was import ZODB failure. Is this peculiar to Win95 or I am doing something illegal? Thanks.

1 0

Re: [Zope] ODBC - 1 step forward - woops I tripped
by Thomas B. Passin 17 Nov '99

17 Nov '99

-----Original Message----- From: rgines(a)purina.com <rgines(a)purina.com> <snip> >Thanks for everyones assistance in getting me this far. Some of you >showed that I am really stupid while >others of you confirmed that I am not yet insane. </snip> Sorry, I don't have anything more to offer right now, but please post whatever you find out. This area - getting data out of databases - is awfully important and we need to be able to get ODBC working reliably. Tom Passin

1 0

login with a login page [Q]
by Bruno Mattarollo 17 Nov '99

17 Nov '99

Hello. Even if the subject may seem funny, it's a real question... :-) I am trying to develop a login page to a site we are developing. I don't want to be prompted with a pop-up window, I just want to user to view a form and write there the user and password and press "Login" as in the Member login page from the Zope.Org site. Does anyone can give me a hint on how to do that? Our user data will be stored in an RDBM database (Oracle8i). I saw the UserDB product. But apparently it's no longer maintained. The functionality is to bring areas for members and areas for anonymous users. Thanks in advance. /B Bruno Mattarollo <brunomadv(a)ciudad.com.ar> --- Python Powered <http://www.python.org/psa/>

2 1

Re: [Zope] login with a login page [Q]
by Otto Hammersmith 17 Nov '99

17 Nov '99

Go for UserDB. It will do exactly what you need and is stable. :) Un-maintained doesn't necessarilly mean "defunct and broken"... most times in the open source community, it means "feature complete and stable". Basically, no one has felt the need to add features and there are no serious bugs (if there were, I'm sure someone would step up and fix it). (On the features front... I'm not saying UserDB is the end all be all of a User Folder product, check out http://www.zope.org/Members/Zen/GenericUserFolder/. :) -Otto. -----Original Message----- From: Bruno Mattarollo brunomadv(a)ciudad.com.ar Sent: Wed, 17 Nov 1999 11:59:23 -0300 To: zope(a)zope.org Subject: [Zope] login with a login page [Q] Hello. Even if the subject may seem funny, it's a real question... :-) I am trying to develop a login page to a site we are developing. I don't want to be prompted with a pop-up window, I just want to user to view a form and write there the user and password and press "Login" as in the Member login page from the Zope.Org site. Does anyone can give me a hint on how to do that? Our user data will be stored in an RDBM database (Oracle8i). I saw the UserDB product. But apparently it's no longer maintained. The functionality is to bring areas for members and areas for anonymous users. Thanks in advance. ______________________________________________________________________ Get Visto.com! Private groups, event calendars, email, and much more. Visto.com. Life on the Dot. Check it out @ http://www.visto.com/info

1 0

Re: [Zope] Re - Making non-aware ZClass CatalogAware
by Anthony Baxter 17 Nov '99

17 Nov '99

as a data point, I used this with an existing ZClass that was also a subclass of Object manager. After the upgrade, things like 'objectValues' would no longer work in the ZClass instance (they'd return no objects). I didn't try to figure out why, I just threw away the changes. So yes, make sure you back up your Data.fs before you play this game. >>> Alexandre Ratti wrote > Hi Alexander, > > > There was a hack some time ago that allowed to change the base classes for > a ZClass. I used it once or twice in 2.0.1. I've never used it in 2.1b. > > Take a look at this email: > <http://lists.zope.org/pipermail/zope-dev/1999-August/001288.html>. It > contains explanations and an external method developped by Andreas Kostyrka. > > Be careful with it: better back up your database before trying it! > > > Cheers. > > Alexandre > > > At 20:40 16/11/1999 -0800, you wrote: > >From: Alexander Staubo <alex(a)mop.no> > >To: "Zope Mailing List (E-mail)" <zope(a)zope.org> > >Subject: [Zope] Making non-aware ZClass CatalogAware > >Date: Tue, 16 Nov 1999 22:44:05 +0100 > > > >I have a bunch of ZClasses that aren't descended from the catalog-aware > >class-wossname. I need to make them catalog-aware. How do I easily do > >this? Can I export to XML and somehow import them in again? > > > >-- > >Alexander Staubo http://www.mop.no/~alex/ > >"Only two things are infinite, the universe and human stupidity, > >and I'm not sure about the former." --Albert Einstein > > > _______________________________________________ > 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 ) -- Anthony Baxter <anthony(a)interlink.com.au> It's never too late to have a happy childhood.

2 1

RE: [Zope] Acquisition isn't always bandwidth and browser-cache f riendly, advice needed
by Toby Dickenson 17 Nov '99

17 Nov '99

> -----Original Message----- > From: Christopher Petrilli [mailto:petrilli@digicool.com] > > The lack of absolute URLs being inserted was a BUG in 2.0, > and is resolved > in the CVS repository and should be in 2.1b2. > Was this a bug in the image tag, absolute_url, or acquisition?

2 1

Re: [Zope] Zope setup with firewall
by Nemeth Miklos 17 Nov '99

17 Nov '99

Thanks a lot! I am going to discuss the topic with my network admin. (1) Just one more thing to make me sure: There is no possiblity to access Zope directly (that is without going out to the Internet) from the local network in this architecture? (2) And another one. What about this "layout": AnyBrowser+SSL <--HTTP--> Apache Proxy+SSL <--> firewall <--> Apache+SSL+pcgi <---> Zope+Fnorb <--IIOP--> SQLBroker+ORBacus <--SQL*Net--> CorporateDatabase(Oracle7) The first Apache would be set up restricting acces with the Location tags in httpsd.conf as you suggested. This would be used only for forwarding appropriate HTTP requests to the second Apache server. All internal users might be able to diractly access Zope through the second Apache server. Miklos Nemeth Ewald Wasscher wrote: > Nemeth Miklos wrote: > > > > I'd like to have the following architecture: > > > > AnyBrowser+SSL <-HTTP-> Apache+SSL+pcgi <--> firewall <--> Zope+Fnorb > > <-IIOP-> SQLBroker+ORBacus <-SQL*Net-> CorporateDatabase(Oracle7) > > > > The users access Zope from the Internet via an Apache+SSL server. > > For security reasons my network administrator (responsible for security) > > does not want to allow any Zope management activity initiated from the > > Internet. > > However I do want to manage Zope from the internal network while web > > clients are using my Zope application at the same time. > > (1) How can I access my Zope from the internal network? Can anyone > > suggests me a solution to my problem? > > The network administrator could try something like the following setup > in > the apache configuration file: > > <Location /zopesite/manage> > order allow, deny > Allow from .iqsoft.hu > </Location> > > Make sure this section comes before the Rewriterules that apply to Zope. > Please take a look at the apache docs and adjust this where needed. Make > sure you test the setup, and don't blame me if something goes wrong. You > could setup certificate authentication for this <Location> to make it > more > secure. At least for Apache+mod_ssl there is a (dirty) way to do this. > > > A less important problem is that my network administrator also wishes a > > secured communication between the Apache+SSL server and Zope (over the > > firewall). This communication is the task of pcgi. > > (2) Is there any solution to do this? > > One solution could be to install some kind of Vitual Private Network > package (IPSec, cipe, PGPnet (commercial), etc). The network > administrator should know what I mean. > > A simpler (but perhaps less secure) option would be the use of sslwrap > (http://www.rickk.com/sslwrap/) or stunnel > (http://blah.lpt.fi/doc/stunnel/) > to SSL-ify the connection between Apache and Zope. > > <--CUT--> > > Ewald Wasscher

1 0