May 2001 - Zope - Zope lists

SQLConnectionIDs() equivalent for SQL Methods?
by Andy Gimblett 31 May '01

31 May '01

Hi there, Short version: Is there something like SQLConnectionIDs() which picks up SQL Methods instead of SQL Connections? Long version: lib/python/Products/ZSQLMethods/SQL.py contains a function called SQLConnectionIDs(), which returns a list of SQL Connection objects between "here" and the top of the tree (in in the current folder or any of its parents). This is very handy for things like (from exUserFolder): <tr> <th>Database Connection:</th> <td> <select name="frontierauth_connection"> <dtml-in "SQLConnectionIDs()"> <option value="<dtml-var sequence-item>"> <dtml-var sequence-key></option> </dtml-in> </select> </td> </tr> What I want to do now is something very similar, but I want it to pick up SQL Methods, not SQL Connections. Does anyone know of such a thing? I know I can emulate/modify SQLConnectionIDs() using an external method if need be, I just don't want to reinvent the wheel if what I want is already there. :-) (PS: Really enjoying exUserFolder!) Cheers, Andy -- Andy Gimblett - Programmer - Frontier Internet Services Limited Tel: 029 20 820 044 Fax: 029 20 820 035 http://www.frontier.net.uk Statements made are at all times subject to Frontier's Terms and Conditions of Business, which are available upon request.

1 0

ContentIndexIcons
by Peter Bengtsson 31 May '01

31 May '01

Installed the ContentIndexIcons and it looks pretty promising, but does it only work for File meta_types? I uploaded an image with a pdf as the file and the content type or Image became application/pdf as expected, yet it had the Image icon instead of the ContentIndexIcons one. Is this a bug or is it meant to be or is there something I have to do to generate ContentIndexIcons icons on unlisted objects or something? Peter

1 0

Howto establish mysql connections in zope via python
by p.dejong＠melissendejong.nl 31 May '01

31 May '01

I want to establish a connection to a MySQL database via a python method. I get a authorisation error. Zope asks for a new username/password combination. All combinations that could apply are not correct. Moreover,the database does not require a password for this particular user. If I establish the same connection in Python, I get a connection.

1 0

too much different object types?
by Neunreither, Isabelle 31 May '01

31 May '01

Hi, I have a problem to understand why there are so much different object types in Zope and why you can't access more general categories of objects. I found that it is not logic. If Zope is based on objects, he has to group some objects in more general classes together, so you can access Folder, Documents, Scripts and Images. Folder and Image classes exist, but a class Document which is an super class for the types Files, XML Document, DTML Document, etc. does not exist, as well as a class Script which could be an super class for Python scripts, DTML Methode, etc. i understand that zope needs a precise type for each object, but why can i not access a more general categorie of objects? cheers, Isabelle Neunreither konsylo Messeler-Park-Strasse 74 64291 DARMSTADT Fon: 0 6150 866 196 Fax: 0 6150 866 197 email: in(a)konsylo.com

3 2

Find and Catalog
by After Dark 31 May '01

31 May '01

Can I "Find and Catalog" in a specific folder from my project?? Thanks. -- --Ricardo Kohler Costa ________________________________________________ Don't E-Mail, ZipMail! http://www.zipmail.com/

1 0

RE: [Zope] Virtual Hosting on ZServer Updated
by abg＠comco-inc.com 31 May '01

31 May '01

I'm pretty new to python, and am having a bit of difficulty with the AccessRule code Alan sugggested. I need to be able to map not only domains (bar.com) but virtual domains (foo.bar.com) to locations in Zope. This AccessRule works quite well for the former, but appears to ignore the prefix of the latter (foo). Here's what I've tried so far: I changed this bit of code: hostname="_.string.split(_.string.lower(_.string.split(HTTP_HOST, ':')[0]),'.')[-2:]" domainname="hostname[0] + '.' + hostname[1]" vhmcode="VHosts.gethostfolder(_.None, _, host=domainname)" To this: hostname="_.string.split(_.string.lower(_.string.split(HTTP_HOST, ':')[0]),'.')[-3:]" domainname="hostname[1] + '.' + hostname[2]" domainname2="hostname[0] + '.' + hostname[1] + '.' + hostname[2]" vhmcode="VHosts.gethostfolder(_.None, _, host=domainname)" How do I tell AccessRule to use one method (gethostfolder) for those requests that are in bar.com format, and another method for those requests that are in foo.bar.com format? Also, I'm really not sure if the changes I've made above are going to screw anything up. Any help will be greatly appreciated, and (hopefully) returned at a later time. Thanks. Aaron > -----Original Message----- > From: "Capesius, Alan" <CapesiusA@S...> > Date: Thu Apr 5, 2001 6:22 pm > Subject: [Zope] Virtual Hosting on ZServer Updated > > > Here's an update to my virtual hosting on ZServer solution. > The AccessRule > has been enhanced to allow access to aliased host names that > are not in the > host.domain.com form but rather in a host format. This is > useful if you use > a hosts file with a name for a server (e.g. server01 instead of > www.domain.com) The change prevents an index error in the accessrule. > Request not in domain.com form will revert to the default site. > > The solution uses TinyTable, Virtual Host Monster and AccessRule and a > DTML method to process all inbound requests by domain name similar to > the way in which SiteRoot script things. The best part is > that once set, > the AccessRule does not need to be modified to add new hosts. Host to > folder mapping is performed via entries in the TinyTable, the rest of > the configuration is static. > > Tested with Zope 2.3.0 and TinyTable 0-8-2. > Virtual Host Monster and AccessRule support are built into 2.3.0 > > > Here it is: > > Create a folder in Root called VHosts > Inside VHosts create a folder for each Virtual host > Inside each new Virtual host's folder , create a Virtual Host Monster > called VHM > > Inside VHosts, create a TinyTable called HostsTable > Give the Tiny Table the following columns : domain, folder > Create records for domain to folder mapping as shown here: > "domain1.com", "Folder1" > "domain2.com", "Folder2" > Where the domain names are the virtual names for your server and the > folder names are the folders created inside VHosts. > Entries are CASE SENSITIVE and MUST match the folder names created in > the earlier step. Enter all domains in lower case. > > Inside VHosts create the following DTML Method: > Name: gethostfolder > <dtml-in "VHosts.HostsTable(domainname)"> > <dtml-return folder> > <dtml-else> > <dtml-return "'NULL'"> > </dtml-in> > > In the Root, create a DTML called AccessRule > AccessRule in Root Folder > =================== > <dtml-try> > <dtml-let > hostname="_.string.split(_.string.lower(_.string.split(HTTP_HOST, > ':')[0]),'.')[-2:]" > domainname="hostname[0] + '.' + hostname[1]" > vhmcode="VHosts.gethostfolder(_.None, _, host=domainname)"> > > <dtml-if "vhmcode<>'NULL'"> > <dtml-if "_.string.split(_.string.lower(PATH_INFO), > '/')[-1:]==['manage'] > or > _.string.split(_.string.lower(PATH_INFO), > '/')[-1:]==['manage_main'] or > _.string.split(_.string.lower(PATH_INFO), > '/')[-1:]==['manage_workspace'] "> > <dtml-if "TraversalRequestNameStack[-2:]<>[vhmcode,'VHosts']"> > <dtml-call > "REQUEST['TraversalRequestNameStack'].extend([vhmcode, > 'VHosts'])"> > </dtml-if> > <dtml-else> > <dtml-call > "REQUEST['TraversalRequestNameStack'].extend(['VHM', vhmcode, > 'VHosts'])"> > </dtml-if> > </dtml-if> > > </dtml-let> > <dtml-except> > </dtml-try> > > > > It should look like this: > Root- > AccessRule > VHosts- > HostsTable > gethostfolder > Folder1- > VHM > index_html > Folder2- > VHM > index_html > > > > > > Security Settings: > gethostfolder method: no anonymous access, proxy as manager, manager > has full rights. > HostsTable: No anonymous access, manager full rights > AccessRule: Proxy as manager > > Now, to enable the system, Use the Root folder's Add->SetAccessRule > option and enter "AccessRule" (without quotes) and click Set. > Requests for domain1.com will be drawn from Folder1, 2 from 2 etc.. > Managent of the virtual domain will show only the VHosts > folder contents > for the selected site. > Management of the root site will show the root. > Access to unsupported domains will fall back to root. (perhaps to be a > redirect to a 404 page in the future) > > Display the mappings with /VHosts/HostsTable or via the management > interface. > > Use http://hostname/_SUPPRESS_ACCESSRULE/manage to deactivate the > AccessRule if you have any problems accessing the system. > > All feedback welcome. To the list please. > I will add the config to my tips site shortly. > > Alan Capesius, MCSE > Tech World, Inc. > http://twsite.bizland.com/zopetips.htm > > >

1 0

Netscape Problems
by rroeber1＠unl.edu 31 May '01

31 May '01

>From: "Chris Withers" <chrisw(a)nipltd.com> >To: <zope(a)zope.org> >Date: Thu, 31 May 2001 08:37:57 +0100 >Subject: [Zope] Netscape Problems >I'm getting a bit suspicious about the number of times Netscape and Zope >aren't playing together for me :-S [snip] >Has anyone else experienced any of the above and does anyone have any >solutions? We found some instances where Netscape loads pages very, very slowly and on Windoz can freeze the entire machine for several seconds or even minutes. I have seen this happen with the EventFolder product and most recently with a heavily modified Squishdot that we are using. We thought it was due to Style Sheets, however upon further investigation by our designer, it appears that the use of lots of tables--in particular nested tables--seemed to be the culprit. As we reduced the number of tables in the layout, Netscape loaded the site nearly as well as IE. BTW, Netscape 4.7x behaves this way on the three platforms we tested (Mac, Linux, Windows) Our Zope is version 2.3.2 and we are using FastCGI with Apache 1.3.17 to provide the service. We are frustrated too. -------------------------------------------------------------------- Ronald L. Roeber CIT-IANR University of Nebraska Lincoln, NE 68583 Phone: (402) 472-5630 email: rroeber1(a)unl.edu

1 0

RE: [Zope] How to give caller acquisition path to an object throu gh python script ?
by Ripps, Harrison 31 May '01

31 May '01

> The problem is that "someobject" renders using the > acquisition path of the FOLDER that contains "main" > I want the "someobject" to use the acquisition path of the "main" DTML > object rather than the one of it's folder. Hi Gilles, Unfortunately, I can't offer any advice--I'm having the same problem. Tell me if I'm generalizing the problem correctly with this question: How do you reference an object -other- than the one that currently has "context"? In my case, I'm trying to build a navigation tree that -always- starts with the root folder, even when I'm two or three levels deep... I tried expressing the root folder as the oldest object in the PARENTS list, but my script doesn't appear to perceive it as an object... Cheers, Harrison

1 0

oops .... forgot something
by Christian Theune 31 May '01

31 May '01

------ 2001-05-30T12:22:33 ERROR(200) ZServer uncaptured python exception, closing channel <zhttp_channel connected 10.1.1.3:3570 at 8b394a4 channel#: 23 requests:2> (socket.error:(32, 'Broken pipe') [/home/zope2/ZServer/medusa/asynchat.py|handle_read|80] [/home/zope2/ZServer/medusa/http_server.py|recv|405] [/home/zope2/ZServer/medusa/asyncore.py|recv|301]) ------ 2001-05-30T12:41:11 ERROR(200) ZODB Couldn't load state for '\000\000\000\000\000\000@\017' Traceback (innermost last): File /home/zope2/lib/python/ZODB/Connection.py, line 508, in setstate AttributeError: 'None' object has no attribute 'load' this are the messages i forgot in my last posting -- Christian Theune - ct(a)gocept.com gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981 reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))

6 5

Client Side Form Field Validation - How to ?
by Luca Manini 31 May '01

31 May '01

Hi, the subject says it (almost) all. Taken for granted that one should validate input "also" on the server, everybody (even me) knows many reasons (no post, faster and more user-friendly messsages, ...) for doing something on the client. The first thing that comes to (my) mind is Java (o JavaScript ?). Or would be possible to write some Python (Jython) ? Anyhting already available ? Anything "declarative" (like usign regexp) ? TIA, Luca

2 1