August 2002 - Zope - Zope lists

Pb with ZGDchart or ZSQLMethod ??
by David PEYRIERES 22 Aug '02

22 Aug '02

Hello, I have a problem with ZGDChart 0.6.2 . I've linked it to a ZSQLMethod (via an ZODBC Database Connection) to plot data curves. When, at least, 1 data misses, there's no graph plotted. How can I do to plot this even if I got misses ? (NB: I've tried the SQL fonction nvl(col,substitute value) into my SQL Method to obtain values when ODBC returns no values, but it doesn't work !!) Thanks. mailto david.peyrieres(a)meteo.fr

1 0

POSKeyError ... uh-oh
by Paul Winkler 22 Aug '02

22 Aug '02

A big chunk of my dev server has apparently just vanished. When I click on the folder in question, I get the following. Have I hosed my ZODB somehow? This is bizarre. I swear I didn't do anything to or in that folder anytime recently, and a search through Undo tab in the parent folder confirms that. I'm running zope 2.5.1, python 2.1.3 on linux. Haven't seen anything like this before, and searching lists.zope.org doesn't turn up anything helpful. Restarting zope doesn't magically fix it... ------------------- Zope Error Zope has encountered an error while publishing this resource. Error Type: POSKeyError Error Value: 000000000001a81b Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Powered by Zope Traceback (innermost last): File /zope/temp/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line 150, in publish_module File /zope/temp/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line 114, in publish File /zope/temp/Zope-2.5.1-src/lib/python/Zope/__init__.py, line 159, in zpublisher_exception_hook (Object: PatientPortal) File /zope/temp/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line 98, in publish File /zope/temp/Zope-2.5.1-src/lib/python/ZPublisher/mapply.py, line 88, in mapply (Object: manage_main) File /zope/temp/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line 39, in call_object (Object: manage_main) File /zope/temp/Zope-2.5.1-src/lib/python/Shared/DC/Scripts/Bindings.py, line 252, in __call__ (Object: manage_main) File /zope/temp/Zope-2.5.1-src/lib/python/Shared/DC/Scripts/Bindings.py, line 283, in _bindAndExec (Object: manage_main) File /zope/temp/Zope-2.5.1-src/lib/python/App/special_dtml.py, line 172, in _exec (Object: manage_main) File /zope/temp/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_In.py, line 637, in renderwob (Object: objectItems) File /zope/temp/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_In.py, line 763, in sort_sequence (Object: objectItems) File /zope/temp/Zope-2.5.1-src/lib/python/ZODB/Connection.py, line 447, in setstate File /zope/temp/Zope-2.5.1-src/lib/python/ZODB/FileStorage.py, line 582, in load (Object: /zope/devzope_inst_home/var/Data.fs) File /zope/temp/Zope-2.5.1-src/lib/python/ZODB/FileStorage.py, line 577, in _load (Object: /zope/devzope_inst_home/var/Data.fs) File /zope/temp/Zope-2.5.1-src/lib/python/ZODB/FileStorage.py, line 2134, in _loadBack POSKeyError: (see above) -- Paul Winkler "Welcome to Muppet Labs, where the future is made - today!"

2 5

WebDav with Dreamweaver- cannot checkin edited file
by Kelley, Sean 22 Aug '02

22 Aug '02

Hi, I am using Dreamweaver 4 and Zope 2.5.1 and have given a particular file WebDav permission of lock, unlock, and access to anonymous and I can check out the file but cannot check it back in. I get the error that "cannot put myfile.html" What could be happening here? BTW this is a file created in CMF 1.2 which was upgraded to 1.3 Sean Kelley Technology Coordinator City of Santa Rosa Phone: (707) 543-3353 Pager: (707) 581-3061

2 1

Re: [Zope] webalizer, zope, apache and virtual hosts
by Jack Coates 22 Aug '02

22 Aug '02

On Tue, 2002-08-20 at 11:17, Jan Ulrich Hasecke wrote: > Jack Coates <jack(a)monkeynoodle.org> schrieb: > > > I use an iframe in a dtml document -- see > > http://www.monkeynoodle.org/webalizer/ > > How did you configure your apache to serve this static content? > > Ciao! > juh > > -- > Damit erhebt Heidegger das Sein zum alleinigen Autor aller > wesentlichen Briefe und setzt sich selbst als dessen aktuellen > Schriftführer ein. Wer in solcher Position redet, darf auch Stammeln > aufzeichnen und Schweigen publizieren. Sloterdijk <IfModule mod_rewrite.c> RewriteEngine on RewriteLog "vhost_rewrite_log" RewriteLogLevel 1 # Let Apache handle requests for non-Zope content RewriteRule ^/static/(.*) /path/to/htdocs/$1 [L] RewriteRule ^/icons/(.*) - [L] RewriteRule ^/cgi-bin/(.*) - [L] RewriteRule ^/server-status/(.*) - [L] RewriteRule ^/manual/(.*) - [L] RewriteRule ^/webalizer/(.*) - [L] # Send the worms back home RewriteRule ^.*\.(exe|ida|dll).* http://127.0.0.1 </IfModule> -- Jack Coates Monkeynoodle: A Scientific Venture...

2 2

RE: [Zope] LDAPUserFolder Question
by Meilicke, Scott 22 Aug '02

22 Aug '02

(9) Aug 21 07:27:53: scott.meilicke not found (getUser) More info: When I do a search for meilicke against the cn within the users tab: cn=Scott.Meilicke,cn=Recipients,ou=North America 3,o=Crane I am using: cn=Recipients,ou=North America 3,o=Crane as the Users Base DN. When I change Login Name Attribute from cn to sn and try to login I get a traceback from zope, attached below. No entry in the LDAPUserFolder log. Thanks for helping out. Traceback: Zope has encountered an error while publishing this resource. Error Type: INAPPROPRIATE_AUTH Error Value: {'desc': 'Inappropriate authentication'} Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page. If the error persists please contact the site maintainer. Thank you for your patience. Traceback (innermost last): File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 223, in publish_module File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 187, in publish File D:\PROGRA~1\inside\lib\python\Zope\__init__.py, line 226, in zpublisher_exception_hook (Object: portal_ldap) File D:\PROGRA~1\inside\lib\python\ZPublisher\Publish.py, line 162, in publish File D:\PROGRA~1\inside\lib\python\ZPublisher\BaseRequest.py, line 450, in traverse File D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, line 614, in validate (Object: acl_users) File D:\PROGRA~1\inside\lib\python\AccessControl\User.py, line 616, in validate (Object: acl_users) File D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, line 594, in authenticate (Object: acl_users) File D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, line 505, in getUser (Object: acl_users) File D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, line 262, in _lookupuser (Object: acl_users) File D:\PROGRA~1\inside\lib\python\Products\LDAPUserFolder\LDAPUserFolder.py, line 845, in _searchResults (Object: acl_users) INAPPROPRIATE_AUTH: (see above) -----Original Message----- From: Jens Vagelpohl [mailto:jens@zope.com] Sent: Wednesday, August 21, 2002 4:57 AM To: Meilicke, Scott Cc: 'zope(a)zope.org' Subject: Re: [Zope] LDAPUserFolder Question could you provide the exact text of the log entry that says "First.Last not found"? that enables me to check where in the code it failed. jens On Tuesday, August 20, 2002, at 07:07 , Meilicke, Scott wrote: > Hi - I am trying to authenticate against LDAPUserFolder 1.5. I'm using a > MS > Exchange 5.5 directory (I know, I know...). I can connect, and search for > members based on both the cn and sn, but can't authenticate using CMF 1.1 > and the CMFLDAP tools. I'm trying to authenticate using the cn. When I > do > a search, the cn shows as First.Last. When I try to logon using > First.Last, > I get a logon failure, and the log set at debugging level(9) shows > First.Last not found. > > Any thoughts on being able to authenticate? > > Thanks - Scott > The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.

2 1

Evaluating python with my own variable bindings
by Ross Boylan 22 Aug '02

22 Aug '02

I would like to bind symbols to values, e.g, Q1=True, Q2=False.... and then allow the user to specify arbitary logical expressions like Q3 and Q4 or (given different bindings) Q2 == 5 It would be fine if they could execute arbitrary python scraps. It looks to me as if this might be a job for a PythonScript. I was going to evaluate an arbitrary string, but since PythonScript has a security and binding framework it seems better to use it. So I have two questions: 1) Is PythonScript the most appropriate tool? In particular, I am concerned because I am not calling it from the web, but from some code in my product. The API reference does not refer to this case as a possible use. 2) Exactly how do I bind the symbols for use within the script? In case you are wondering, I'm doing this for rules like "only answer question 5 if you said yes to questions 3 or 4". Thanks.

2 7

RE: [Zope] dtml-sqltest op=like optional?
by Chris Beaven 22 Aug '02

22 Aug '02

It should be: <dtml-sqltest name op=like type=nb multiple optional> -----Original Message----- From: Charlie Reiman [mailto:creiman@kefta.com] Sent: Thursday, 22 August 2002 11:36 a.m. To: zopelist(a)robertson.net.nz; zope(a)zope.org Subject: RE: [Zope] dtml-sqltest op=like optional? It has been a while since I tried this with sqltest, but have you tried the 'nb' flag as well? <dtml-sqltest name op=like type=string multiple optional nb> My impression was optional and string didn't do what I wanted unless the nb option was also set. > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > zopelist(a)robertson.net.nz > Sent: Wednesday, August 21, 2002 3:30 PM > To: zope(a)zope.org > Subject: [Zope] dtml-sqltest op=like optional? > > > Greetings, > I am trying to get > > select * from customer > <dtml-sqlgroup where> > <dtml-sqltest id op=gt type=int optional> > <dtml-and> > <dtml-sqltest name op=like type=string multiple optional> > <dtml-and> > <dtml-sqltest contact op=like type=string multiple optional> > </dtml-sqlgroup> > > to work - my intention is that none or more variables are needed. > > It seems that unless the type is int, I get > > select * from customer > where > (name like '' > and contact like '' > ) > > Is there anyway around this or to default the value of name and > contact to '%' without lots of dtml-if statements? > > (actually - the like statement does not enter the wild card so > like='Acme' does not return Acme Corp) > > BTW - connecting to a Postgres DB - if that makes a difference > > Don > > > > > > _______________________________________________ > 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 ) > _______________________________________________ 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

random.choice()
by Nathan Valentine 22 Aug '02

22 Aug '02

import random print random.choice(["true", "false"]) In a stand-alone .py file, this will print either "true" or "false". In a Python script in the ZODB, it prints "None". What gives? -- --- Nathan Valentine - nathan(a)nathanvalentine.org Jabber: NRVesKY AIM: NRVesKY ICQ: 39023424

1 0

random.choice()
by Nathan Valentine 22 Aug '02

22 Aug '02

import random print random.choice(["true", "false"]) In a stand-alone .py file, this will print either "true" or "false". In a Python script in the ZODB, it prints "None". What gives? -- --- Nathan Valentine - nathan(a)nathanvalentine.org Jabber: NRVesKY AIM: NRVesKY ICQ: 39023424 -- --- Nathan Valentine - nathan(a)nathanvalentine.org Jabber: NRVesKY AIM: NRVesKY ICQ: 39023424

1 0

dtml-sqltest op=like optional?
by zopelist＠robertson.net.nz 21 Aug '02

21 Aug '02

Greetings, I am trying to get select * from customer <dtml-sqlgroup where> <dtml-sqltest id op=gt type=int optional> <dtml-and> <dtml-sqltest name op=like type=string multiple optional> <dtml-and> <dtml-sqltest contact op=like type=string multiple optional> </dtml-sqlgroup> to work - my intention is that none or more variables are needed. It seems that unless the type is int, I get select * from customer where (name like '' and contact like '' ) Is there anyway around this or to default the value of name and contact to '%' without lots of dtml-if statements? (actually - the like statement does not enter the wild card so like='Acme' does not return Acme Corp) BTW - connecting to a Postgres DB - if that makes a difference Don

2 1