- Zope - Zope lists

Re: [Zope] NT Authenticated Users
by Dieter Maurer 28 Feb '01

28 Feb '01

Mark Derricutt writes: > I'm looking at porting a DelphiCGI/IIS application over to Zope, however, > the current application uses IIS in non-anonymous mode, which supplies the > HTTP request with a LOGON_USER paramater, which contains the NTDOMAIN/USER > of the user requesting the page. > > Is there anyway to do this under Zope/Python (or even Apache), one of the > requirements of the application is that I can handle this automatic > authentication of NT users. Zope is able to get authentication information from the "REMOTE_USER" request member. You may use a SiteAccess AccessRule in your root folder to copy "LOGON_USER" into "REMOTE_USER". There is a HowTo on Zope.org about SiteAccess use for such purposes. Dieter

1 0

Re: [Zope] Can Zope handle this project?
by Dieter Maurer 28 Feb '01

28 Feb '01

iap_y2fun.com writes: > I was asked to propose a solution for a insurance company. > This comany has: > 20,000,000 records of insurance contracts, > 7,000,000 records of accounts, > 60,000 records of products, > The storages required for the above records amount to 200GB. > This system is built for the agents which amount to 25,000 persons. > The estimated traffice is 100,000 page views/day. > The Platform doubtless is Linux or *Unix. > ***I would like to adapt zope to slove this problem. *** > I has experienced ZEO to handle hige traffic site, but in this case it seems > that the ZODB is the key dancer. > My question are: > A) If it is possible for a Data.fs grows up to 200GB? ( Mounted fs?) > B) Can "BTree Folder" handle 20 million of objects in a single folder? If > not, how many ? > C) Can ZCatalog handle 20 millions of objects (indexed fields could up to > 200 millions)? > Any suggestion is appreciated. I expect the data is now in a database. I would leave it there (or put it there, if not yet there). Data.fs might grow in principle to 200 GB, but I think of this as a horror szenario. This huge file would be in a single partition (I doubt, Unix supports files spread over several partitions). Doubt that you have such large partitions. When Zope starts, it builds an index for "Data.fs". While the index is much smaller than the file itself, it still will be huge and it is held in memory. Do not do this! My confidence in ZCatalog is limited, too. You have to carefully choose the commit granularity. I, definitely, would go for a standard database solution and use Zopes excellent database integration to interface with the data in the database. Dieter

2 1

Re: [Zope] zope mail archives
by Dieter Maurer 28 Feb '01

28 Feb '01

Milos Prudek writes: > Downloaded archive mailboxes (for individual months) > http://lists.zope.org/pipermail/zope/. Put them into Netscape messenger > folder. Works nicely but each message appears twice. Any hints? > > Except downloading the whole raw archive in MBOX format :-) 98MB is > quite a lot, and makes no sense to download larger and larger archive > each month... You the the searchable archives hosted by NIP (found via zope.org)? With them, you may not need to download the archiv files themselves. Dieter

3 2

Re: [Zope] Z SQL Method Question
by Dieter Maurer 28 Feb '01

28 Feb '01

Donald Braman writes: > I'm trying to build a query with three optional variables and three > optional operators. I think I have a form that supplies the variables > correctly, but am less certain about DTML use in a SQL query. Here's > what I'm doing: > > SELECT * FROM cases > WHERE makepublic = 't' > <dtml-if citationin>AND citation <dtml-var citationop> citationin > </dtml-if> > <dtml-if casenamein>AND casenameshort <dtml-var casenameop> casenamein > </dtml-if> > <dtml-if yearin>AND year <dtml-var yearop> yearin </dtml-if> Have a look at "dtml-sqlgroup". This may allow you to get rid of the nasty "dtml-if". I expect, "citationin", "casenamein" and "yearin" are Z SQL arguments and not field names? In this case, you would need a "dtml-sqlvar" to access their value. Dieter

1 0

RE: [Zope] Problem with ZSQL query results...sort of...
by Schmidt, Allen J. 28 Feb '01

28 Feb '01

tHANKS BUT NO LUCK EITHER. oOPS...dANG cAPS lOCK... The DTML method was generated for my by ADDing a Z Search Method and selecting my ZSQL method. Aside from formatting some of the fields returned...the rest of the mechanics of it were untouched. In fact, I exported the Whole thing out to another Zope installation and the original configuration of the method works!!! Ahhhhhhh!!! Thanks Troy! -----Original Message----- From: Farrell, Troy [mailto:troy.farrell@wilcom.com] Sent: Wednesday, February 28, 2001 2:40 PM To: 'Tino Wildenhain'; Schmidt, Allen J.; 'zope(a)zope.org' Subject: RE: [Zope] Problem with ZSQL query results...sort of... Is there any particular reason you think you are exempt from the laws of the mighty Python? Shouldn't that be: <a href="<dtml-var URL><dtml-var "_['sequence-query']">query_start=<dtml-var "_['next-sequence-start-number']">"> Sorry. I couldn't resist :) Troy -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Wednesday, February 28, 2001 1:29 PM To: Schmidt, Allen J.; 'zope(a)zope.org' Subject: RE: [Zope] Problem with ZSQL query results...sort of... --On Mittwoch, 28. Februar 2001 14:00 -0500 "Schmidt, Allen J." <aschmidt(a)nv.cc.va.us> wrote: > How about like this. This is how I changed it right after I had originally > created it but did not like the look of it. This does not work either... > > > > > <dtml-if sequence-end> > <dtml-if next-sequence> > <a href="<dtml-var URL><dtml-var > sequence-query>query_start=<dtml-var next-sequence-start-number>"> try: <a href="<dtml-var URL><dtml-var sequence-query>query_start=<dtml-var next-sequence-start-number>"> instead. (without any newlines inside dtml-var ) Regards Tino > (Next <dtml-var next-sequence-size> results) > </a> > </dtml-if next-sequence> > </dtml-if sequence-end> _______________________________________________ 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 )

1 0

RE: [Zope] Problem with ZSQL query results...sort of...
by Farrell, Troy 28 Feb '01

28 Feb '01

Is there any particular reason you think you are exempt from the laws of the mighty Python? Shouldn't that be: <a href="<dtml-var URL><dtml-var "_['sequence-query']">query_start=<dtml-var "_['next-sequence-start-number']">"> Sorry. I couldn't resist :) Troy -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Wednesday, February 28, 2001 1:29 PM To: Schmidt, Allen J.; 'zope(a)zope.org' Subject: RE: [Zope] Problem with ZSQL query results...sort of... --On Mittwoch, 28. Februar 2001 14:00 -0500 "Schmidt, Allen J." <aschmidt(a)nv.cc.va.us> wrote: > How about like this. This is how I changed it right after I had originally > created it but did not like the look of it. This does not work either... > > > > > <dtml-if sequence-end> > <dtml-if next-sequence> > <a href="<dtml-var URL><dtml-var > sequence-query>query_start=<dtml-var next-sequence-start-number>"> try: <a href="<dtml-var URL><dtml-var sequence-query>query_start=<dtml-var next-sequence-start-number>"> instead. (without any newlines inside dtml-var ) Regards Tino > (Next <dtml-var next-sequence-size> results) > </a> > </dtml-if next-sequence> > </dtml-if sequence-end> _______________________________________________ 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 )

1 0

RE: [Zope] Problem with ZSQL query results...sort of...
by Schmidt, Allen J. 28 Feb '01

28 Feb '01

<SNIPPED> Started to reply right after I hit send on the last one. Outlook is breaking the lines apart. I put yours into the method, sans linebreaks and it is identical to mine. Sorry for the extra traffic about this but I am stumped since it was working fine!! Thanks Allen

1 0

bobobase docs?
by Joshua 28 Feb '01

28 Feb '01

Hi I'm just getting around to reading the documentation on Zope and I cannot find references to the bobobase_modification_time in the API docs. Can someone point me to a reference that would have it and it's syntax? Thanks Joshua

1 0

RE: [Zope] Problem with ZSQL query results...sort of...
by Schmidt, Allen J. 28 Feb '01

28 Feb '01

How about like this. This is how I changed it right after I had originally created it but did not like the look of it. This does not work either... <dtml-if sequence-end> <dtml-if next-sequence> <a href="<dtml-var URL><dtml-var sequence-query>query_start=<dtml-var next-sequence-start-number>"> (Next <dtml-var next-sequence-size> results) </a> </dtml-if next-sequence> </dtml-if sequence-end> Allen -----Original Message----- From: Tino Wildenhain [mailto:tino@wildenhain.de] Sent: Wednesday, February 28, 2001 1:14 PM To: Schmidt, Allen J.; 'zope(a)zope.org' Subject: Re: [Zope] Problem with ZSQL query results...sort of... Hi Allen, --On Mittwoch, 28. Februar 2001 12:19 -0500 "Schmidt, Allen J." <aschmidt(a)nv.cc.va.us> wrote: > I have a system that has been working fine. Changed some things on a DTML > method that calls the query but have since changed it back because of the > errors. > > > This part at the bottom of the search method had been working fine. Now I > get errors from next-sequence-start-number. I am getting a KeyError when > accessing a query when more than 50 which is the default size. > > IT WAS FINE!!! It is the generic code from the generated search method > created. > > > <dtml-if sequence-end> > > <dtml-if next-sequence> > > <a href="<dtml-var URL><dtml-var sequence-query > >query_start=<dtml-var > next-sequence-start-number>"> ^^^^^^^^^^^^^^ was this new line intended? If its in your app too, I would expect the error there. Regards Tino > (Next <dtml-var next-sequence-size> results) > </a> > > </dtml-if next-sequence> > </dtml-if sequence-end> > > > The production application is down while I look into this. > ANY suggestion is appreciated! > > Allen > > _______________________________________________ > 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 )

2 1

RE: MS Exchange
by Ian Epperson 28 Feb '01

28 Feb '01

Chris Withers [mailto:chrisw@nipltd.com] wrote: > > There doesn't seem to be a way to get to it from LDAP (grumble), and > > IMAPv4 is only giving me limited information (Contact Name and > > Notes). > > Is that using python's IMAP library, imaplib.py? Yes it is. Also, to verify that the library wasn't dumping anything, I telnetted to the IMAP port on Exchange and checked the data. Yesterday I also discovered that I can have Exchange provide the data in "Exchange Rich Text Format". It comes in as a base 64 encoded MS-TNEF attachment to the message retrieved via IMAP. ALL the contact information is included within it. Now if I could only decode it... ...Looks like I may be able to do it with a perl module from: http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?dist=Convert-TNEF-0.10 > > My last ditch will be to write an ASP page running on the Exchange > > server to present that info to Zope for processing. > > If you need to do that, serve it out as XML and write a > python sax parser to > process it :-) Jim Herbert wrote: > Well, whatever API there is on the windows box, you can presumably write a > python (or perl, or C++, or java, or whatever) program that queries that > information and makes it available via xml-rpc. Depending on your needs, > you could for example use the zope side as the xml-rpc server, and push > the contents of the info into zope nightly or something. > > Or, there's a very trivial to use xml-rpc server written in python that > you could run on the exchange side, and let zope be the client side of the > call. Excellent ideas! I've been balking at this because I don't want to rely on the exchange server as who knows if any interface I use will still be there in Exchange 2002 or whatever. Also, I wanted to try to keep all coding in one box that might be sold directly to a future client (Is it just me, or do employers always try and sell their one-off solution to others?) I suppose relying on the MS-TNEF data vs. relying on the COM interface within Windows isn't all that different. I think the MS-TNEF data (if I can decode it) would be a cleaner solution though. Gaa! When I finish this I'll try and make it available for others (haven't actually written a Python module yet.) Thanks for the help!

1 0