November 1999 - Zope

ODBC or local interbase woes
by Graham Chiu 17 Nov '99

17 Nov '99

I've had this problem which I mentioned months back now - going back to 1.11pr1 ( or whatever it was called ) which I have always assumed was my fault :-( Using NT4/SP4 I set up a local Interbase server via ODBC to authenticate users, and it always died whenever I first accessed those pages for the very first time after starting up Zope. Thereafter it would be fine. I have just now noticed that when Zope starts up, the Interbase monitor actually shows no connections. I hit my authentication pages for the first time, still no connections and Zope reports an error about the database not being open. I reload the page, and the connection now appears in the Interbase monitor, and Zope is fine! Just trying some experimentation, I see now that Zope does not open the ODBC connections until I open the management interface. Shouldn't Zope open all active ODBC connections as part of it's initialisation start up? ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

1 0

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