- Zope - Zope lists

RE: [Zope] upgrade to 2.2 and zsql methods problems
by Brian Lloyd 17 Jul '00

17 Jul '00

> I have the exact same problem. > > Júlio > Hi guys - For those of you (I've mostly heard ODBC adapter users) having authorization problems with your SQL methods, heres the scoop: Database connections use one of two classes in the framework for wrapping up result data returned from queries. One of those classes (that understands results in RDB format) was missing a required security assertion. The results returned by the ODBC adapter were bitten by this - probably there are other adapters that could be affected. I've attached a patch file for the file: lib/python/Shared/DC/ZRDB/RDB.py ...as well as an updated version of the whole file (since I know a lot of you will be on Windows w/o patch :) Either patch or replace the file and restart Zope to fix the problem. This is also checked in for a 2.2.1 release that will probably happen after a few weeks when enough people have upgraded to shake out any other problems. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

SECURITY ROLES and < DTML-IN>
by Theodore Patrick 17 Jul '00

17 Jul '00

I am having trouble rendering a <DTML IN> in ZOPE 2.2.0 to any user regardless of roles. I have allocated the proper rights to all objects used and nothing happens. The <IN> will not let any user view its contents. <DTML IN> I am using an <IN> in a DTML Document to render the contents of an SQL_Method from and Oracle Database. There are 3 objects. 1. Database Connection(ORACLE) - Working and can run test. OK 2. SQL_Method(VIEW_METHOD)- Working and can see results when run. SQL: select id, v_id vid, item_name name, url from item The SQL method returns columns: id, vid, name, url as expected. OK 3. DTML Document - Works fine with an IN that renders folder properties. Change the Source of the <DTML IN to the SQL_Method and it will prompt me for user authentication. <dtml-in VIEW_METHOD size=1000 start=query_start> <dtml-var id>, <dtml-var vid>, <dtml-var name>, <dtml-var url> </dtml-in> When used it prompts the user to login - REGARDLESS OF CURRENT LOGIN and returns the following error. Traceback (innermost last): File C:\PROGRA~1\island8\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\PROGRA~1\island8\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\PROGRA~1\island8\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\PROGRA~1\island8\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: view) File C:\PROGRA~1\island8\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: view) File C:\PROGRA~1\island8\lib\python\OFS\DTMLMethod.py, line 167, in __call__ (Object: view) File C:\PROGRA~1\island8\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: view) File C:\PROGRA~1\island8\lib\python\DocumentTemplate\DT_In.py, line 602, in renderwb (Object: view_method) Things I have tried. 1. Opening up security all the way on all objects. Doesn't work. It continues to ask me to log-in. 2. Proxy the DTML Documents ROLE to a higher role for the SQL_METHOD. Fails just as before. Is this a bug? Can anyone else confirm this. PLATFORM: WINDOWS NT 4 ZOPE: 2.2.0 Final Release.

1 0

ColdFusion->Zope converter
by John Leach 17 Jul '00

17 Jul '00

Anyone have one of these ? (or tips on writing such a thing?) John Leach http://www.bosware.com.au

2 1

PCGI and 2.2.0 final horribly broken?
by Bill Anderson 17 Jul '00

17 Jul '00

I can't get this combo to work at all. All I get is """ C-Runtime errno: Connection refused PCGI Error: (102) failure during connect to ZServer """ Anyone have any suggestions? File permissions are fine... Bill -- Do not meddle in the affairs of sysadmins, for they are easy to annoy, and have the root password.

2 1

Case sensitivity
by Ian Sparks 17 Jul '00

17 Jul '00

One of my pet peeves with web servers is that : mysite.com/Members is different to : mysite.com/members (but there is no difference between MYSITE.COM and mysite.com) is there any way of making Zope case-insensitive? - Ian Sparks.

4 3

Re: [Zope] 2.2 installation problem on Linux
by Andy Pahne 17 Jul '00

17 Jul '00

not for me. everything worked fine on my redhat 6.0 box. first I thought upgrading would be a nightmare but after all it took me 10 minutes and all my sites are up and running smoothly :-) andy >Hi, > >this seams to be a bugglet in the final distribution, the pcgi_wrapper is >not build by the install script. This worked in beta 4. You can fix it by >running it manally in the pcgi-directory like: > >cd pcgi >sh configure >make > >On Sat, 15 Jul 2000, Ragnar Beer wrote: > >> Howdy! >> >> Zope 2.2 (linux2) installs and works fine using ZServer but for >> whatever reason there is no pcgi-wrapper built in the pcgi dir so >> that I cannot call Zope.cgi. I checked again and again but ./install >> doesn't give an error message. What am I doing wrong? >> >> --Ragnar

1 0

Re: [Zope] upgrade to 2.2 and zsql methods problems
by J�lio Dinis Silva 17 Jul '00

17 Jul '00

I have the exact same problem. Júlio >From: "Erik Myllymaki" <erik(a)pacific-shores.com> >To: <zope(a)zope.org> >Subject: [Zope] upgrade to 2.2 and zsql methods problems >Date: Sun, 16 Jul 2000 22:34:28 -0700 > >Hello, > >I just upgraded to 2.2 from 2.1.6 on a WinNT machine. Things went well, >except my zsql methods won't run from the site. I can manage and test them >from the management pages, but if I call them from the site I get an >*unauthorized* error. This happens even wen I log in as superuser or the >owner of that zsqlmethod object. I have tried to recreate some of the >queries from scratch and applying new ownership and wide open permissions, >but this doesn't seem to work either. > >Zope is running as a service and I am using the ODBC adapter to connect to >MSSQL Server. As I say, the queries all un as expected from the management >test screens. > >Any ideas? > >Thanks, > >Erik Myllymaki >erik(a)pacific-shores.com > > >_______________________________________________ >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 ) > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

1 0

Re: [Zope] Long Data Type
by Dieter Maurer 17 Jul '00

17 Jul '00

Ronnie Sengupta writes: > Can anybody who has succesfully managed to insert text data (greater than 2k > or 4k) into Oracle 8i 8.1.6 with DCOracle version 1.3.1 please explain how > it is to be done. > > I have seen several other posts in this mailing list. But nothing fruitful. > > The same goes for Stored Procedures. Can't get them to work either. > > I am a web developer for a site called www.zdnetindia.com. We are using Zope > with Mysql. Planning on Migrating to Oracle. DCOracle currently does not support LOB's (neither CLOB's nor BLOB's). DC is looking for funders to upgrade DCOracle to use the Oracle 8 OCI interface. Currently, the Oracle 7 OCI interface is used mainly with a few 8 extensions. Dieter

2 1

suggestions for what to run in front of ZEO'ed zopes for failover?
by Roman Milner 17 Jul '00

17 Jul '00

I'm wondering if anyone can suggest something good to run in front of 2 zopes talking to a zeo server - for failover and load balancing. I have been using a tool called 'balance' which works really well - but for failover it only works if the socket to one of the zope servers doesn't connect. We occasionally have a situation where the socket will still answer but the zope server hanges and never returns an answer. So, I'm looking for something with configurable timeouts on responses. Does any one know of anything like that? Thanks, ^Roman

3 2

CalendarTag fix for Zope 2.2
by Tres Seaver 17 Jul '00

17 Jul '00

Here is a small patch to make the lovely calendar tag play nice with DT_Util.namespace() in Zope 2.2: $ diff -c lib/python/Products/Calendar/CalendarTag.py \ lib/python/Products/Calendar/CalendarTag.py.org *** lib/python/Products/Calendar/CalendarTag.py Sun Jul 16 21:39:27 2000 --- lib/python/Products/Calendar/CalendarTag.py.org Sun Jul 16 21:41:40 2000 *************** *** 248,254 **** __call__ = render def render_day_(self, md, date, firstday): ! ns = namespace(md, date = date, mode = self.mode, firstday = firstday, --- 248,254 ---- __call__ = render def render_day_(self, md, date, firstday): ! ns = namespace(self, date = date, mode = self.mode, firstday = firstday, namespace() now insists that its self argument be an InstanceDict, which caused it to barf. -- ========================================================= Tres Seaver tseaver(a)digicool.com Digital Creations "Zope Dealers" http://www.zope.org

3 2