- Zope - Zope lists

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

Re: [Zope] ZCatalog
by Chris McDonough 17 Jul '00

17 Jul '00

Jonathan, Please respond to the list as well as to me so others can benefit. What's happening here is that your catalog is named "s". I should have noticed this the first time around. But I didn't. The bit you want is: <a href="<dtml-var "s.getpath(data_record_id_)">"> <dtml-var title> Whether you use "raw" or "title" depends on what you want to see. If you want to see the "raw" DTML that makes up the object that gets referenced in the catalog as a link, use "raw". If you want to see the title as a link, use "title". If your catalog isn't named "s", and the DTML is actually wrong where it says "<dtml-in s size=50 start=query_start>", change "s" to whatever the catalog is named. What Zope is doing: 1. Iterating over the catalog in batches of fifty responses in the line that says: <dtml-in s size=50 start=query_start> 2. Doing some stuff at the beginning of the batch (all the "if sequence-start" stuff) 3. Showing results, if any with a link (the bit you're adding) 4. Doing some stuff at the end of a batch (all the "if sequence-end" stuff) 5. Showing a meaningful message if there were no results. Jonathan Desp wrote: > > yes, so I quess: > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > <dtml-var title> > > will become: > > <a href="<dtml-var "catalog.getpath(data_record_id_)">"> > <dtml-var raw> > > then I did it, > > here I tryed my search: > > http://www.atomasoft.com/gosearch > > and it's not working. > > All is great with my source or I need to shutdown zope if I want to see the > result working.. ? > > Do you know if there is any other changing to do? > > here is my new source again: > > <dtml-var standard_html_header> > <dtml-in s size=50 start=query_start> > <dtml-if sequence-start> > > <dtml-if previous-sequence> > > <a href="<dtml-var URL><dtml-var sequence-query > >query_start=<dtml-var > previous-sequence-start-number>"> > (Previous <dtml-var previous-sequence-size> results) > </a> > > </dtml-if previous-sequence> > > <table border> > <tr> > <th>Raw</th> > </tr> > > </dtml-if sequence-start> > > <tr> > <td><a href="<dtml-var "catalog.getpath(data_record_id_)">"><dtml-var > raw></a></td> > </tr> > > <dtml-if sequence-end> > > </table> > <dtml-if next-sequence> > > <a href="<dtml-var URL><dtml-var sequence-query > >query_start=<dtml-var > next-sequence-start-number>"> > (Next <dtml-var next-sequence-size> results) > </a> > > </dtml-if next-sequence> > </dtml-if sequence-end> > > <dtml-else> > > There was no data matching this <dtml-var title_or_id> query. > > </dtml-in> > > <dtml-var standard_html_footer>

2 2