- Zope - Zope lists

ZSQL: expr and sqltest?
by Richard Wesley 12 Apr '02

12 Apr '02

According to the documentation that comes with Zope 2.5.0, the dtl-sqltest tag can take either a variable or an expr="" tag. But when I do this, I get the message "Invalid atrribute name, "expr" for tag <dtml-sqltest..." What's up? - rmgw http://www.electricfish.com/hawkfish/ ---------------------------------------------------------------------------- Richard Wesley Electric Fish, Inc. hawkfish(a)electricfish.com "Grownups have the most uninteresting explanations for things." - C. S. Lewis, _The Magician's Nephew_

2 2

zope file system limits
by John Hunter 12 Apr '02

12 Apr '02

I am running a zope server on which I store a lot of 5+ MB files on the zope filesystem. When one of the users tried to upload a 28MB file today, she got a Error 28 insufficient space. There is sufficient space on both the data and root partitions that the zope server lives on, so I don't think that is the problem. Does the zope filesystem have size limits that are in the range of 30MB? Thanks, John Hunter Zope 2.5.1b1 (source release, python 2.1, linux2), python 2.1.3, linux2

4 4

loading zclass from zeo client
by Erik A. Dahl 12 Apr '02

12 Apr '02

I'm writing an external zeo client program that needs to interact with zclasses. When I try and load a zclass from the database I get the following: Traceback (most recent call last): File "<stdin>", line 1, in ? File "/home/edahl/zope/lib/python/ZODB/Connection.py", line 471, in setstate state = unpickler.load() File "/home/edahl/zope/lib/python/ZODB/Connection.py", line 142, in _persistent_load return self[oid] File "/home/edahl/zope/lib/python/ZODB/Connection.py", line 103, in __getitem__ klass=self._db._classFactory(self, module, name) File "/home/edahl/zope/lib/python/ZODB/DB.py", line 119, in _classFactory return getattr(__import__(location, _globals, _globals, _silly), ImportError: No module named *UoHgL+xNgSWAgKCB4JIj9A== When I look at the Basic tab on the zclass I see that its Class Id is UoHgL+xNgSWAgKCB4JIj9A== but how do I import a class that is living in the database? Zope is doing it so I assume there is a function somewhere for this but I have yet to find it. Any help or examples would be welcomed. Thanks, -EAD

1 0

dtml-in, ZSQL Method, date argument problem
by N Burnett 12 Apr '02

12 Apr '02

I have been trying for a while to get arguments passed to a ZSQL Method from inside a dtml-in loop. My top level objective is to update a table with multiple changes to date/times and descriptions in records about conference sessions input from a form. Having read many posts here and other documentation, my current attempt should work, but I can't get it right yet. I keep getting a TypeError in the DateTime function indicating that the date isn't being passed in the format I think it should be: Here is the dtml I am trying: (The relevant fields in the table are: ID,StartsAt,aDescription) <dtml-var standard_html_header> <dtml-if expr="REQUEST.has_key('submit')"> <dtml-in s> <dtml-call expr="sessions_modifydates(_)"> </dtml-in> </dtml-if> <form method=post action=sessions_update> <table> <dtml-in sessions_list> <tr><td> <input type=text name=s.ID:records value=<dtml-var ID> size=4> </td><td> <input type=text name=s.StartsAt:records:date value="<dtml-var StartsAt>"> </td><td> <input type=text name=s.aDescription:records value="<dtml-var aDescription>" size=60> </td><tr> </dtml-in> </table> <input type=submit name=submit> </form> <dtml-var standard_html_footer> The (not very well named) ZSQL Method sessions_modifydates is as follows. If it gets a date that DateTime can recognize, it converts it to SQL format: UPDATE tblSession SET tblSession.StartsAt = <dtml-var expr="_.DateTime(StartsAt).strftime('#%m/%d/%Y %H:%M:%S#')">, tblSession.Description = <dtml-sqlvar aDescription type=string> <dtml-sqlgroup where> <dtml-sqltest ID op=eq type=int> <dtml-and> <dtml-sqltest ConferenceID op=eq type=int> </dtml-sqlgroup> (Note that commenting out the updating of the date then allows the description to be updated, so I think everything else works OK. I use 'aDescription' because I thought Description may have been a reserved word somewhere along the line, but it probably isn't.) For completeness, here is the traceback I get: Traceback (innermost last): File C:\Programmer\WebSite\lib\python\ZPublisher\Publish.py, line 150, in publish_module File C:\Programmer\WebSite\lib\python\ZPublisher\Publish.py, line 114, in publish File C:\Programmer\WebSite\lib\python\Zope\__init__.py, line 158, in zpublisher_exception_hook (Object: sss) File C:\Programmer\WebSite\lib\python\ZPublisher\Publish.py, line 98, in publish File C:\Programmer\WebSite\lib\python\ZPublisher\mapply.py, line 88, in mapply (Object: sessions_update) File C:\Programmer\WebSite\lib\python\ZPublisher\Publish.py, line 39, in call_object (Object: sessions_update) File C:\Programmer\WebSite\lib\python\OFS\DTMLMethod.py, line 127, in __call__ (Object: sessions_update) File C:\Programmer\WebSite\lib\python\DocumentTemplate\DT_String.py, line 473, in __call__ (Object: sessions_update) File C:\Programmer\WebSite\lib\python\DocumentTemplate\DT_In.py, line 695, in renderwob (Object: s) File C:\Programmer\WebSite\lib\python\DocumentTemplate\DT_Util.py, line 159, in eval (Object: sessions_modifydates(StartsAt=_['sequence-var- StartsAt'])) (Info: _) File <string>, line 2, in f File C:\Programmer\WebSite\lib\python\Shared\DC\ZRDB\DA.py, line 414, in __call__ (Object: sessions_modifydates) File C:\Programmer\WebSite\lib\python\DocumentTemplate\DT_String.py, line 473, in __call__ (Object: <string>) File C:\Programmer\WebSite\lib\python\DocumentTemplate\DT_Util.py, line 159, in eval (Object: _.DateTime(StartsAt).strftime('#%m/%d/%Y %H:%M:%S#')) (Info: StartsAt) File <string>, line 2, in f File C:\Programmer\WebSite\lib\python\DateTime\DateTime.py, line 671, in __init__ File C:\Programmer\WebSite\lib\python\DateTime\DateTime.py, line 279, in _calcSD TypeError: (see above) Thanks in advance for any advice. Regards Neil __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

2 3

Zope FTP Hang File List Problem
by hpinson＠indepthl.com 12 Apr '02

12 Apr '02

Hi. I am experienceing a problem FTP'ing into zope that has previously been discussed on this list, with no apprent solution. When I FTP to Zope from Win98 or a Mac OSX that are behind a Cisco 675 DSL router running NAT, ftp hangs (according to the Z2.log) at: ==> 200 PORT command successful. == LIST ==> 150 Opening ASCII mode data connection for file list ... hangs i.e. it hangs when FTP tries to list directories and files. I've seen lots of discussion about this, but no solution. Has anyone found one? Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

4 3

nested calls
by jochen 12 Apr '02

12 Apr '02

I got the following problem (I'm using Zope 2.5.0): When my index_html is called the following is supposed to happen: index_html calls a dtml-method in a subfolder which then calls a ZSQL-method stored in another subfolder. It works fine as long as the index_html is accessing the dtml-method and this dtml-method doesn't need to acces another dtml-method not in the same folder. If I try to call another dtml-method in another folder then it simply can't be found. What can I do? Is there something like the context variable in pythonscripts?? By the way: I tried to it with dtml-with but that also didn't work.

2 1

Changing CookieCrumbler
by Inline: F. Zorge 12 Apr '02

12 Apr '02

Hi, I am trying to improve cookiecrumbler (version 0.3) to meet my needs. But I am no Python expert, so I wonder if someone is able to assist me a bit. This is the case: - I want cookiecrumbler to put the username as well as the password into a cookie. - If the cookie is read later, the user is authenticated (with username and password) and logged in without using the login form that comes with cookiecrumbler - If the cookie is not present (or contains a not authenticated user) then cookiecrumbler's login form is presented to the user. Now I looked at the python source of cookiecrumbler and there is a comment saying that only the username is saved in a cookie, so I added the following line to the source: resp.setCookie(self.pw_cookie, pw, path='/', expires=expires) below the setCookie for the username. But now Cookiecrumbler just give me the password instead of the username in de loginform. What do I have to add to the source tot let cookiecrumbler puts username and password into the cookie and read username and password from the cookie to login and authenticate and leave the loginform alone? Thanks in advance Frank Zorge Inline informatisering & consultancy Witte Rozenstraat 48 2311 XX Leiden Telefoon 071 5133577 Fax 071 5121366 Email algemeen info(a)inline-info.nl Email specifiek zorge(a)inline-info.nl Website www.inline-info.nl

2 1

Thread syncronization
by Thomas Guettler 12 Apr '02

12 Apr '02

Hi! Some month ago there was a thread about creating unique IDs. Is it possible to syncronize the threads in zope with the "thread" module in python? [1] If yes, the problem would be easy to solve. And I wonder why nobody told me that. thomas [1] http://www.python.org/doc/current/lib/module-thread.html

2 1

SiteRoot and URL1 cause different namespace error
by Steven Turoff 12 Apr '02

12 Apr '02

Greetings, I'm having a problem resolving URL's running in ZServer mode with a SiteRoot. Some background: httpd.conf contains: ProxyPass / http://localhost:8080/ ProxyPassReverse / http://localhost:8080/ ProxyVia on The SiteRoot is: base = https://my.server.com path = / If I create the following DTML method, I get a "Different Namespace" error: URL is: <dtml-var URL1> <p> Content is: <dtml-var "REQUEST.resolve_url(URL1)"> In testing, I have found that I can fix this error by changing the last line to: Content is: <dtml-var "REQUEST.resolve_url('http://' + REQUEST.HTTP_HOST + URLPATH1)"> This isn't a very elegant solution, though. How can I get Zope to properly resolve the URL1 variable? Thanks, Steve

2 1

Relational database & user permissions (select, add, update, delete)
by Jon Erickson 12 Apr '02

12 Apr '02

I've run into a problem while developing a multi-user database application using Postgresql and Zope with ZSQL methods. I need user\group based security for the database similar to... User A can select from table FOO but cannot update, delete, or add records to FOO. User B can select, update and delete from FOO but cannot add records to FOO. ... but most Database Adapters use a single, static user login for database connections. The single user login provides for easy db connection configuration but doesn't help when you want to use a databases built-in security. I don't really want to program this logic in python when Postgresql already has said features. Does anyone have experience implementing user-level database security in a Zope app? If so, could you reply with some suggestions or examples please. Thanks, Jon Erickson

3 2