July 1999 - Zope - Zope lists

using sequence variables
by Graham Chiu 26 Jul '99

26 Jul '99

Hi, I would like to take a list of words, and remove all the parens, commas so that it becomes space separated. I tried this:  value:  and this shows the list correctly  Sequence:  and this shows each element of the list   but it dies on the last REQUEST.set ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz

2 2

RE: [Zope] Starting Zope2 on Win95
by James M. Slack 26 Jul '99

26 Jul '99

I can't retrieve localhost:8080, because ZServer won't start. (I get a Naviation Error in IE). I tried removing and re-installing TCP/IP, as you suggested (rebooting after each step), to no avail. I also tried putting my hostname in the code ip = socket.gethostbyname ('jimslackxl') # was: socket.gethostname()) This didn't help either. ping localhost works fine. Also, I use Apache regularly on this machine for localhost access. Any other ideas? On Mon, 26 Jul 1999, Anthony Pfrunder wrote: > Ok, > > Try viewing your management screen on the machine that the server is > running by going to: > > http://localhost:8080/manage > > If you get a dns error then Windows is not seeing the HOSTS file for some > reason. If so, try removing and re-installing TCP/IP (love Windows don't > you ;). If THAT doesn't work you could try replacing the gethostbyname > bit with a manual assignment as Zope only uses it for log displays. > > Ensure that you are using Zope 2.0.0b1 (either the offical release OR the > Windows Enhanced version located at http://student.uq.edu.au/~s341625) > I've tested both versions on a stock win95 and they work. > > Cheers, > > Anthony Pfrunder > Computer Systems Engineering > University of Queensland > > PS: CC to my mail address as I'm temporarly off the zope lists due to > network problems > >

1 0

Premature end of script headers error (Apache/Zope.cgi v.2b1)
by Joshua Brauer 26 Jul '99

26 Jul '99

I've been using Apache mod_rewrite with Zope 1.x for a while now and it works great. Tonight I installed v2b1 and set up a new server. I can access it fine using Zserver, but I get the following error in Apache's log (Zope.cgi never creates the log file I expect.) [Zserver and Apache are not running at the same time...] httpd: [Sun Jul 25 21:18:24 1999] [error] [client 10.1.1.1] Premature end of script headers: /websites/Zope2/Zope.cgi Zope.cgi looks similar to the installs I have of Zope 1.x. Any ideas? ___________________________________________ Joshua Brauer joshua(a)brauer.org http://www.brauer.org ___________________________________________

1 0

RE: [Zope] ANNOUNCE: XMLDocument 1.0a1
by Alexander Staubo 26 Jul '99

26 Jul '99

>-----Original Message----- >From: Jim Fulton [mailto:jim@digicool.com] >Sent: 25. juli 1999 14:13 >To: Alexander Staubo >Cc: Zope Mailing List (E-mail); 'Amos Latteier' >Subject: Re: [Zope] ANNOUNCE: XMLDocument 1.0a1 > > >Alexander Staubo wrote: >> >> Now all we need is an XSL processor so we can transform XML >documents to >> HTML etc. on the fly. Anybody know of a Python >implementation of such a >> gizmo? > >There are a couple. We plan to integrate FourThought's 4XSL >with Zope. Thanks for the pointer. Unfortunately it only works on Unix, though. >I expect this will look like "XSL methods". Well, how would you invoke them? It would be appropriate, say, to have a single folder's XML documents all point to one XSL style sheet. In fact, since the XSL style sheet of a document can be defined in the XML itself -- the syntax escapes me, but I believe it was an XML SI -- this information could be used for overriding the "default" XSL style sheet. >Also node that *all* Zope objects support DOM at some level >as of Zope 2.0 beta 1. Any examples of this? >So it will be possible to use DOM-aware >tools (like 4XSL) with any Zope object. We used 4XSL to test out >initial DOM integration. >Jim > >-- >Jim Fulton mailto:jim@digicool.com >Technical Director (888) 344-4332 Python Powered! >Digital Creations http://www.digicool.com http://www.python.org -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_

1 0

RE: [Zope] How to connect to Sybase using ZSybaseDA
by Alexander Staubo 26 Jul '99

26 Jul '99

Remember that server name != host name. Sybase distinguishes between the identifier of the database server and the machine running the server. Afaik, there's no way to tell ctsybase the host name, but I could be wrong there. Also note that the server name is case sensitive, so "Turtle" != "turtle". You might try isql: isql -U qawila1 -P figtree -S turtle ...should verify whether the parameters are correct as typed. If you find that you need to type: isql -U qawila1 -P figtree -S mysybase -H turtle ...which means "turtle" is the host name, and "mysybase" is the server name, then the host name is definitely part of the equation. -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_ >-----Original Message----- >From: A J Wilson [mailto:ajwilson@ezy.net.au] >Sent: 26. juli 1999 03:29 >To: Alexander Staubo; Zope Mailing List (E-mail) >Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA > > >I tried to connect manually using the script suggested below. >The output is >shown below. I would appreciate if someone could interprete >it for me and >advise how I might fix the problem. > >Many Thanks >Austin > >Python 1.5.1 (#10, Jul 25 1999, 07:21:22) [GCC 2.7.2.3] on linux2 >Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam >>>> import ctsybase >>>> c = ctsybase.ctsybase({'user': 'qawila1', 'password': 'figtree', >'server': 'turtle'}) >Traceback (innermost last): > File "<stdin>", line 1, in ? >SybaseError: ['failed to connect to server', ('client', 4, 84083715, >'ct_connect(): network packet layer: >internal net library error: Specified server name attribute >could not be >found', 0, '', 0, 'ZZZZZ')] >>>> > >----- Original Message ----- >From: Alexander Staubo <alex(a)mop.no> >To: Zope Mailing List (E-mail) <zope(a)zope.org>; 'A J Wilson' ><ajwilson(a)ezy.net.au> >Sent: Monday, July 26, 1999 8:31 AM >Subject: RE: [Zope] How to connect to Sybase using ZSybaseDA > > >> Note that ZSybaseDA has a bug that keeps it from publishing errors >> correctly. Check the line number given in the traceback. >Verify that you >> login ID has access to the database and table. >> >> You can test this manually thus (replace user name, >password, server and >> database with real values): >> >> import ctsybase >> c = ctsybase.ctsybase({'user': 'bob', 'password': 'bob', >> 'server': 'MYSYB'}) >> c.execute('use my_database') >> >> which should go through okay if it works, give you a (hopefully) >> human-readable error response if not. >> >> -- Alexander Staubo http://www.mop.no/~alex/ >> "Give me an underground laboratory, half a dozen atom smashers and a >> beautiful >> girl in a diaphanous veil waiting to be turned into a >chimpanzee, and I >> care >> not who writes the nation's laws." --S. J. Perelman >> >> >> -----Original Message----- >> From: A J Wilson [mailto:ajwilson@ezy.net.au] >> Sent: 25. juli 1999 22:33 >> To: zope(a)zope.org >> Cc: rossl(a)med.usyd.edu.au >> Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA >> >> >> I have a Sybase database which I can access through isql, MSAccess, >> Sybase Central etc. When I tried to access it using the >ZSybaseDA using >> the connection string in the form [dbusername] [password] >[machinename] >> [databasename] I get an error saying "Invalid connection >string:". Any >> other suggestions. >> >> Regards >> Austin >> >> >> >From: rossl(a)med.usyd.edu.au >> >Date: Sat, 24 Jul 1999 18:14:06 -0700 >> >To: zope(a)zope.org >> >Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA >> > >> >try >> >[dbusername] [password] [machinename] [databasename] >> > >> >eg >> > >> >bob bobspass redhat1 zopestuff >> > >> >(Of course, you need to use the sybase utilities to make database >> zopestuff and accessible by bob using bobspass) >> > >> ><003001bed623$61e130a0$0202a8c-(a)lalaland.net.au> wrote: >> o>riginal article:http://www.egroups.com/group/zope/?start=8450 >> > Hi >> > >> > I managed to compile the ZSybaseDA under Redhat 5.1. Now >I need help >> to connect to the database. Zope is running on the same machine as >> >Sybase ASE. Could someone please tell me the format for >the Database >> Connection String? >

2 1

RE: [Zope] Starting Zope2 on Win95
by Rob Page 26 Jul '99

26 Jul '99

> I have a HOSTS.SAM file in C:\WINDOWS with the entry > 127.0.0.1 localhost the hosts.sam that comes with windows is the SAMple. copy hosts.sam hosts that should work --Rob

2 1

RE: [Zope] Zope 2 ODBC date errors
by Jay, Dylan 26 Jul '99

26 Jul '99

Its that damm timezone problem in zope. If the python string returned as your timezone is not known to zope it barfs. This problem has been going on for months and I feel because it is something that only effects non-american zope users there has not been enough effort into fixing it. In fact I have fixed this bug and submitted it and am disappointed that it has not made into the source yet as was promised. This is a show stopping bug. In certain countries any application that uses dates from sql where a timezone is not supplied is going to crash!!! Please stop being so US centric and fix this bug!!! > -----Original Message----- > From: Graham Chiu [mailto:anon_emouse@hotmail.com] > Sent: Sunday, July 25, 1999 10:28 > To: zope(a)zope.org > Subject: [Zope] Zope 2 ODBC date errors > > > > I've installed the Win32 2.0.0b1, and now find that *all* my Zsql > queries where dates are returned using the ODBC adapter, now fail. > > Here is a traceback from a test > > <!-- > Traceback (innermost last): > File F:\Zope2\lib\python\ZPublisher\Publish.py, line 256, in > publish_module > File F:\Zope2\lib\python\ZPublisher\Publish.py, line 161, in publish > File F:\Zope2\lib\python\ZPublisher\mapply.py, line 154, in mapply > (Object: manage_test) > File F:\Zope2\lib\python\ZPublisher\Publish.py, line 98, in > call_object > (Object: manage_test) > File F:\Zope2\lib\python\Shared\DC\ZRDB\DA.py, line 307, in > manage_test > (Object: sqlShowBasketDescription) > File F:\Zope2\lib\python\DocumentTemplate\DT_String.py, line 502, in > __call__ > (Object: <string>) > File F:\Zope2\lib\python\DocumentTemplate\DT_In.py, line 591, in > renderwb > (Object: sqlShowBasketDescription) > File F:\Zope2\lib\python\Shared\DC\ZRDB\RDB.py, line 272, in > __getitem__ > ValueError: Invalid value, 1999-07-19 21:34:50, for LDATE in record 0 > > ------- > Regards, Graham Chiu > gchiu<at>compkarori.co.nz >

2 1

RE: [Zope] How to connect to Sybase using ZSybaseDA
by Alexander Staubo 26 Jul '99

26 Jul '99

Note that ZSybaseDA has a bug that keeps it from publishing errors correctly. Check the line number given in the traceback. Verify that you login ID has access to the database and table. You can test this manually thus (replace user name, password, server and database with real values): import ctsybase c = ctsybase.ctsybase({'user': 'bob', 'password': 'bob', 'server': 'MYSYB'}) c.execute('use my_database') which should go through okay if it works, give you a (hopefully) human-readable error response if not. -- Alexander Staubo http://www.mop.no/~alex/ "Give me an underground laboratory, half a dozen atom smashers and a beautiful girl in a diaphanous veil waiting to be turned into a chimpanzee, and I care not who writes the nation's laws." --S. J. Perelman -----Original Message----- From: A J Wilson [mailto:ajwilson@ezy.net.au] Sent: 25. juli 1999 22:33 To: zope(a)zope.org Cc: rossl(a)med.usyd.edu.au Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA I have a Sybase database which I can access through isql, MSAccess, Sybase Central etc. When I tried to access it using the ZSybaseDA using the connection string in the form [dbusername] [password] [machinename] [databasename] I get an error saying "Invalid connection string:". Any other suggestions. Regards Austin >From: rossl(a)med.usyd.edu.au >Date: Sat, 24 Jul 1999 18:14:06 -0700 >To: zope(a)zope.org >Subject: Re: [Zope] How to connect to Sybase using ZSybaseDA > >try >[dbusername] [password] [machinename] [databasename] > >eg > >bob bobspass redhat1 zopestuff > >(Of course, you need to use the sybase utilities to make database zopestuff and accessible by bob using bobspass) > ><003001bed623$61e130a0$0202a8c-(a)lalaland.net.au> wrote: o>riginal article:http://www.egroups.com/group/zope/?start=8450 > Hi > > I managed to compile the ZSybaseDA under Redhat 5.1. Now I need help to connect to the database. Zope is running on the same machine as >Sybase ASE. Could someone please tell me the format for the Database Connection String?

2 1

"Access contents information" and SQL Methods; bug?
by Alexander Staubo 26 Jul '99

26 Jul '99

I have an interesting problem with a part of a site that needs to be limited to privileged editors. Let's call this role "Editor". The problem is, unless I give the "Access contents information" permission to the "Anonymous" role, SQL Method calls are not permitted, even if I give _all_ permissions to the "Editor" role. It's that curious?  equals to my editor user (defined in folder somewhere above the restricted folder), and  gives me ['Editor']. Btw, I've disabled acquisiton of permissions on the restricted folder. Unless I give "Access contents information" to "Anonymous", the following traceback is emitted when authentication fails: Error Type: Unauthorized Error Value: 0 [...] Traceback (innermost last): File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 256, in publish_module File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 161, in publish File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/mapply.py, line 154, in mapply (Object: index_html) File /usr/src/Zope-2.0.0b1-src/lib/python/ZPublisher/Publish.py, line 98, in call_object (Object: index_html) File /usr/src/Zope-2.0.0b1-src/lib/python/OFS/DTMLDocument.py, line 171, in __call__ (Object: index_html) File /usr/src/Zope-2.0.0b1-src/lib/python/OFS/DTMLDocument.py, line 166, in __call__ (Object: index_html) File /usr/src/Zope-2.0.0b1-src/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: index_html) File /usr/src/Zope-2.0.0b1-src/lib/python/DocumentTemplate/DT_In.py, line 680, in renderwob (Object: SqlTest) Unauthorized: (see above) I experienced the same error with 1.11.0pr1, but I chose not to report it but rather wait until 2.0 to test it out. I've tried setting up a test folder in case it was caused by something in my site; same behaviour. The problem only applies to SQL Methods -- any other permission with any other object/op seems to work as expected. For now, I'll enable "Access contents information" for the "Anonymous" role, but in the long run I feel this is a bad solution. -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_

1 0

RE: [Zope] manage_workspace redirects to index_html! EMERGENCY!
by Alexander Staubo 26 Jul '99

26 Jul '99

>At 01:18 AM 7/26/99 +0200, Alexander Staubo wrote: >>It turns out -- and until I hear anything else, I chalk this >up as a bug >>-- that if you rescind all permissions from the "Manager" role, Zope >>will behave like described below. Try it -- it's weird. > >The issue is that as of Zope 2, the management screens are tailored to >match your permissions. If you don't have permissions for the >method that >produces a management screen, it won't be shown to you. The available >management tabs are trimmed to match what you are authorized to do. >Therefore if there are say 5 management tabs on a given object >and you only >have permissions to see one of them, 'View', then that's what >you'll get >back from 'manage_workspace'. So clicking on an object in the >management >screen would show you 'index_html' in this case. > >Also the product add list will now not display objects that >you don't have >adequate permissions to create. So far so good... >>The behaviour is slightly different under beta 1, but still >not correct. >>If I login as the "superuser", theoretically I should have unlimited >>access, correct? > >Right. If you log in as the superuser but still see restricted >management >screens this is a bug. If this is the case and you haven't >already filed it >in the Collector, please do so. > >Thanks, and sorry for the confusion. ...then it's now officially a bug. :-) I am indeed logging in as the superuser. My observation is that it seems as though the superuser only has the "Manager" role. This borders on an insult, but are you sure you guys didn't somehow implement such a rule without telling each other? :-) If I rescind all permissions from the Manager role, the top-level folder only shows the "Properties" and "Find" tabs. I did post it to the Collector. If you cannot reproduce this behaviour, I can supply my Data.fs file for inspection. It was generated from a .bbb file by bbb.py, in case that is relevant. -- Alexander Staubo http://www.mop.no/~alex/ "QED?" said Russell. "It's Latin," said Morgan. "It means, So there you bastard." --Robert Rankin, _Nostramadus Ate My Hamster_

1 0