December 2000 - Zope

Re: [Zope] LoginManager broken?
by dan＠sol.control.com 11 Dec '00

11 Dec '00

"Mayers, Philip J" <p.mayers(a)ic.ac.uk> writes: > Thanks, I'll take a look. > > Re: LoginManager - After a fast turnaround (confirming my ample faith in > Open Source software) Magnus Heino pointed me in the right direction - the > dtml methods and SQL objects need to be inside the UserSource folder, *not* > the LoginManager folder as the Howto implies (or maybe I just can't > read...). Can someone confirm that the SQL methods need to be inside the > UserSource folder? (which is mildly annoying, but there we go...) This isn't required in my experience. The UserSource will find them via acquisition if the permissions are OK. I tend to keep them in a level above the acl_users (i.e. the LoginManager) in question while debugging just in case I wind up turning off permissions to that folder accidentally.

1 0

Re: [Zope] LoginManager broken?
by Oliver Bleutgen 11 Dec '00

11 Dec '00

> Well, not 2.2.4 but 2.2.3, and I had some bugs when ehm replace 2.2.3 with 2.2.2

1 0

Re: [Zope] LoginManager broken?
by dan＠sol.control.com 11 Dec '00

11 Dec '00

You might look at http://www.zope.org/Members/dlpierson/sqlLogin for a different approach that works for me in early testing. Note that it needs additional work before being turned loose on a live site. Dan Pierson "Mayers, Philip J" <p.mayers(a)ic.ac.uk> writes: > Does it even *work*? Even a little bit? Because other than repeating the > same process 12 damn times, so far I'm not convinced. Maybe I'll look in the > source code to see if there's actually anything in the files (other than a > HOWTO.txt, which is empty, which BTW is more annoying than there not being > one). > > The "LoginManager with SQL database" on the Zope site seems to end up with > me having a folder I can't access through the management interface (unless > you count "management" as "this is the index_html" document) Wow, thanks! > Now I have to delete it and start all over again... > > In all seriousness - there *must* be one person who has gotten an SQL-backed > LoginManger working with 2.2.4 - surely? > > Thanks for all the great work (little bugs aside...) - Zope is a wonderful > product! Now if only it could serve XML as well as Cocoon... > > Regards, > Phil > > +----------------------------------+ > | Phil Mayers, Network Support | > | Centre for Computing Services | > | Imperial College | > +----------------------------------+ > > _______________________________________________ > 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] LoginManager broken?
by Oliver Bleutgen 11 Dec '00

11 Dec '00

> Does it even *work*? Even a little bit? Because other than repeating the > same process 12 damn times, so far I'm not convinced. Maybe I'll look in > the > source code to see if there's actually anything in the files (other than a > HOWTO.txt, which is empty, which BTW is more annoying than there not being > one). > The "LoginManager with SQL database" on the Zope site seems to end up with > me having a folder I can't access through the management interface (unless > you count "management" as "this is the index_html" document) Wow, thanks! > Now I have to delete it and start all over again... > In all seriousness - there *must* be one person who has gotten an > SQL-backed > LoginManger working with 2.2.4 - surely? Well, not 2.2.4 but 2.2.3, and I had some bugs when trying it on a copy of a production server. I couldn't get the "old" installation to work in a different directory, although I thought I changed every path in start etc.. I also deleted all pyc files and reran wo_pcgi.py. One symtom was that loginmanager didn't acquire users from a level above. Later on it wouldn't want to to the sql-query, nothing showed up in I postgres' debugging output. Btw. can anybody tell me if and how it's possible to relocate an installed Zope? Back to your question, loginmanager now works fine for me now, and it did so flawlessly on a fresh installed zope. Did you eventually try to use the loginmanager-with-SQL-howto in the toplevel folder? IIRC, this will lock you out permanently. Did you reuse a user name (just a guess that this might cause problems)? Try to find out whether and which sql-queries are issued by LoginManager, I guess other dbs than postgres will also allow to find that out. Oh, and if you try LM in a subfolder, have a look at the undo tab if things go wrong ;-), you might at first use some fake methods at first which always return 1, manager etc. and change them step by step (and say goodbye to security). cheers, oliver

1 0

RE: [Zope] access log analyzer (analog, webalizer etc.)
by sean.upton＠uniontrib.com 11 Dec '00

11 Dec '00

You could use grep/sed, etc, and a some shell scripts (or perl or python scripts). Instead of sed and grep (and regexes, and inconsistent results, and a lot of manual work), what perhaps a lot of folks need is unified, aggregated logging that actually looks into Zope's architecture and uses mod_perl for static stuff and CGIs served in Apache. I've thought about this a bit, and it seems to me that many sites (at least bigger ones) often use a combination of technologies (as well as multi-node server farms) to serve up their site(s). As such, if you are running stuff served from Zope, Apache, CGI, other app servers, etc, you want a unified logging platform. Add to the complication HA/load-balanced/multi-server farms, and you want to be able to aggregate logs from all boxes on all server platforms to log to a unified system. The answer seems to me to be use of a relational database, mod_perl, and the example DBI Apache logger code in O'Reilly's _Writing Apache Modules_ with the following tweaks: 1 - Add persistence to the mod_perl DB connection with Apache::DBI 2 - Tweak the tables to add the following fields: box (server node number, for HA farms) mime-type user object_id (used, along with URL to determine what object is being used by X method) 3 - mime-types determined for Apache-served static pages with RegEx on URL 4 - Zope-served pages are excluded from Apache's logging, use ZSQL methods inside Zope to log (below) 5 - ZSQL method for logging is created. Logs the relevant stats to the relational database AUTHENTICATED_USER is logged to user, and <dmtl-var id> is logged to object_id - mime-type is the object's mime-type 6 - Insert <dtml-call expr="mylogmethod()"> into standard_html_header in top level (all acquired use of standard_html_header will log) 7 - Roll your own report-system using Zope, perhaps... I've already started working on something of this sort for a long-term project I have to implement logging for my company's new HA server farm. Such an approach might also be a good thing if one is using a ZEO setup. So far, I have set up the Apache side of things, logging to MySQL, and I am working on the Zope side of things. The real work, though is not in logging, but report generation, which would be a nice Zope product. Perhaps in a few months, I might have something worth showing... Any thoughts? Sean ========================= Sean Upton Senior Programmer/Analyst Web Infrastructure SignOnSanDiego.com The San Diego Union-Tribune 619.718.5241 sean.upton(a)uniontrib.com ========================= -----Original Message----- From: Martin Winkler [mailto:marwin98@gmx.net] Sent: Sunday, December 10, 2000 5:26 PM To: zope(a)zope.org Subject: [Zope] access log analyzer (analog, webalizer etc.) Hi listies, since we all use names for urls that are not "standardized" - ending with ".html", ".gif" etc - I am wondering how to do a good logfile analyzing with standard tools like those in the subject line. I am usually running zope behind a http-accelerated squid, so I've configured squid to use "emulate_httpd_log on". But how webalizer doesn't recognize whether it's an image or html output. Did someone already write a tool that converts these logfiles like this (or similar): logfileconverter reads the logfile line by line --> checks against the ZODB whether the url outputs a "jpg", "gif" or "html" --> converts the line in the logfile accordingly (e.g. "/mydir/mymethod" to "/mydir/mymethod.html" and "mydir/mypic" to "mydir/mypic.jpg") --> then saves the modified logfile to disk or pipes it to webalizer. Thanks for your input! Martin _______________________________________________ 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

LoginManager broken?
by Mayers, Philip J 11 Dec '00

11 Dec '00

Does it even *work*? Even a little bit? Because other than repeating the same process 12 damn times, so far I'm not convinced. Maybe I'll look in the source code to see if there's actually anything in the files (other than a HOWTO.txt, which is empty, which BTW is more annoying than there not being one). The "LoginManager with SQL database" on the Zope site seems to end up with me having a folder I can't access through the management interface (unless you count "management" as "this is the index_html" document) Wow, thanks! Now I have to delete it and start all over again... In all seriousness - there *must* be one person who has gotten an SQL-backed LoginManger working with 2.2.4 - surely? Thanks for all the great work (little bugs aside...) - Zope is a wonderful product! Now if only it could serve XML as well as Cocoon... Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+

1 0

Fw: [Zope] Incrementing a form field
by Andy McKay 11 Dec '00

11 Dec '00

You could use FSCounter to do your counting: http://www.zope.org/Members/andym/wiki/FSCounter. There is a How-To on using unique_ids: http://www.zope.org/Members/andym/FSCounter/unique_ids In your code try explicilty using an int: > <dtml-call "REQUEST.set('my_number', _.int(my_number) + 1)"> -- Andy McKay, Developer. ActiveState. ----- Original Message ----- From: "César A. K. Grossmann" <ckant(a)fazenda.gov.br> To: <zope(a)zope.org> Sent: Monday, December 11, 2000 10:44 AM Subject: [Zope] Incrementing a form field > Hi! > > I have a form that is used to insert some records to a database, and one > of the fields is a sequence number. I want to increment this number when > the form is used, unless is the first time it is loaded. > > The form (idea copied from the SmartForms HOWTO) have the name > "Register", and is something like this: > > <dtml-var standard_html_header> > > <dtml-if "REQUEST.REQUEST_METHOD=='POST'"> > Record inserted. > </dtml-if> > > <dtml-if my_number> > <dtml-call "REQUEST.set('my_number', my_number + 1)"> > <dtml-else> > <dtml-call "REQUEST.set('my_number', 1)"> > </dtml-if> > > <form action="Register" method="POST"> > A Field <input name="my_field" value="some value"><br> > A Number <input name="my_number" value="<dtml-var my_number>"><br> > <input type="submit" value="OK"> > </form> > > <dtml-var standard_html_footer> > > It work for the first load, but when I press the OK button, I get an > error message: > > Error Type: TypeError > Error Value: illegal argument type for built-in operation > > The traceback: > >  > > What is wrong? How do I increment the value? > > []s > -- > +---------------------------------+---------------------------------+ > | César A. K. Grossmann | Capacitação Solidária | > | ckant(a)fazenda.gov.br | http://www.uol.com.br/umminuto/ | > | http://members.xoom.com/ckant/ | Clique e doe - é de graça | > +---------------------------------+---------------------------------+ > http://www.halcyon.com/sciclub/cgi-pvt/instr/instr.html > A ética do iG: http://antispambr.abranetrj.org.br/not-20001023.html > > One Bell System - it used to work before they installed the Dimension! > > _______________________________________________ > 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

unicode,python20,SQL DB Adapters
by Philipp Auersperg 11 Dec '00

11 Dec '00

Python 2.0 has unicode support and once Zope will officially run with it -> has anybody evaluated how several database adapters will be able to read and write unicode varchars ? (of course only if the DB supports unicode :) DB's with my special interest are: Oracle MSS SQL Server and the database adapters: mxODBC ZOracleDA ZSybaseDA thanks in advance phil

1 0

Incrementing a form field
by César A. K. Grossmann 11 Dec '00

11 Dec '00

Hi! I have a form that is used to insert some records to a database, and one of the fields is a sequence number. I want to increment this number when the form is used, unless is the first time it is loaded. The form (idea copied from the SmartForms HOWTO) have the name "Register", and is something like this: <dtml-var standard_html_header> <dtml-if "REQUEST.REQUEST_METHOD=='POST'"> Record inserted. </dtml-if> <dtml-if my_number> <dtml-call "REQUEST.set('my_number', my_number + 1)"> <dtml-else> <dtml-call "REQUEST.set('my_number', 1)"> </dtml-if> <form action="Register" method="POST"> A Field <input name="my_field" value="some value"><br> A Number <input name="my_number" value="<dtml-var my_number>"><br> <input type="submit" value="OK"> </form> <dtml-var standard_html_footer> It work for the first load, but when I press the OK button, I get an error message: Error Type: TypeError Error Value: illegal argument type for built-in operation The traceback:  What is wrong? How do I increment the value? []s -- +---------------------------------+---------------------------------+ | César A. K. Grossmann | Capacitação Solidária | | ckant(a)fazenda.gov.br | http://www.uol.com.br/umminuto/ | | http://members.xoom.com/ckant/ | Clique e doe - é de graça | +---------------------------------+---------------------------------+ http://www.halcyon.com/sciclub/cgi-pvt/instr/instr.html A ética do iG: http://antispambr.abranetrj.org.br/not-20001023.html One Bell System - it used to work before they installed the Dimension!

1 0

Re: API and namespace
by Alexander DePauli 11 Dec '00

11 Dec '00

Rehi Sven, thanks a lot for your patience with the dummy - which is me :) Sorry to say that my problem consists even when applying your snippet. Your statement <dtml-with "_.getitem('NewFolder')"> looks fine to me, but ZOPE insists on creating the new document in /OldFolder instead of /OldFolder/NewFolder Some more stuff for wondering: If I do a <dtml-with "_.getitem('NewFolder')"> <dtml-var "_.getitem('NewFolder',0)"> to get an actual value for testing purposes, ZOPE returns the *correct* value. But if I do an additional <dtml-in objectItems> id: <dtml-var sequence-key>, type: <dtml-var meta_type> </dtml-in> to get the objects in the actual namespace (surely *after* the above <dtml-with..>, the output is the one of the /OldFolder-namespace, not that of the /OldFolder/NewFolder. ...I'm sure this is a rookie-problem and can be solved by turning a switch or two (perhaps in my brain), but I'm stuck. Do you/anybody has any clue? Thanks in advance + all the best Alexander Sven Hohage schrieb: > For you this is sufficient -> > <dtml- call "manage_addFolder (FolderName)"> > > <dtml-with "_.getitem(FolderName)"> > <dtml- call "manage_add (DocumnetName)"> > </dtml-with> > ~~~~~~~~~~~~~~~~~~~~~~~~~ http://www.herrenausstatter.de - Der Online-Herrenausstatter Kostenlose Serviceline: 0800 -999 66 33 Versandkostenfreie Lieferung - 30 Tage R�ckgaberecht ~~~~~~~~~~~~~~~~~~~~~~~~~ Verwaltungsadresse: DePauli.com Aktiengesellschaft Stahlgruberring 3 - 81829 M�nchen Telefon: 089 / 530 75 170 - Telefax 089 / 514 50 666

1 0