- Zope - Zope lists

connect to multiple mysql db's question
by Greg Conway 16 Aug '02

16 Aug '02

Hi all, Just a quickie... In order for me to organise my sites a little better, I'd like to seperate out some of my Databases. Can I run a query in Zope combined across two different MySQL connectors? My best guess so far is to create two seperate queries, each using one Database, then a third query to join these two queries.... somehow!! I'm hoping there's an easier way!! Any suggestions gratefully received! Regards, Greg Conway. This electronic transmission and any files attached to it are strictly confidential and intended solely for the addressee. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify us by return and delete the same. Further enquiries/returns can be posted to postmaster(a)gmlnt.com Thank you.

2 1

TAL vs. DTML default example text
by Patrick Price 16 Aug '02

16 Aug '02

If someone can tell me how to do the same thing as <dtml-var standard_html_template> using TAL, I'd appreciated it. What is confusing is that adding a fresh DTML Doc has the standard_page header and footer examples put into it, yet a fresh ZPTemplate has a different example entirely. Apologies for the newbie spamming. -Patrick Price

2 1

Creating files outside of Zope with type ZTL.
by Noah 16 Aug '02

16 Aug '02

Whenever I use Dreamweaver to create a new file in Zope via FTP or WebDAV it comes up as type DTML. How do I create files with default type of Template (ZTL)??? Also, I'm having a lot of trouble simply moving files back and forth from Zope and the file system. file system files in Zope What is the current state of Zope's ability to handle external files? I identified the list of Products below. What are the differences? Is there one coherent, best solution? External File ZFS ExtFile/ExtImage Local File System I'm sort of new to Zope and this is confusing. Why all the fuss just to serve a file from the file system? Why isn't this built-in? Yours, Noah

2 1

show all http headers
by Mark McEahern 16 Aug '02

16 Aug '02

What's the equivalent in Zope to the following VBScript/ASP snippet: For Each x in Request.ServerVariables Response.Write "<p>" & x & " = " & Request.ServerVariables(x) Next For what it's worth, my reason for asking--aside from general debugging knowledge--is because I want to see whether my: squid --> apache --> zope setup is passing along an X-Forwarded-For http header. For now, Apache is recording the internal IP address of the squid proxy in the weblogs, which is pretty useless. // m -

3 2

SQLLog performance
by Peter Bengtsson 16 Aug '02

16 Aug '02

Just looked at http://www.zope.org/Members/hdstich/SQLLog_announce Looks very interesting. Do you know anything about the performance issues of using this instead of normal logging? I suppose that I could look at your idea and build it outside zope as an external application if I really want speed. Peter --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.381 / Virus Database: 214 - Release Date: 2002-08-02

1 0

PHParser
by Kevin Sullivan 16 Aug '02

16 Aug '02

Hi, I know that I should be using Zope for everything, but we have a lot of scripts that were written in PHP and we don't have time to port them just yet. We are using PHParser to allow us to reuse the old scripts. However my scripts now come with X-Powered-By: PHP/4.1.2 Content-type: text/html printed at the top of the screen. Has anyone been able to fix this? I tried making some edits to php.ini. Im asking here, because I don't have this problem on my regular php/apache servers. Thanks. Kevin Sullivan, MCP, A+ Systems Administrator MIT Economics Dept ksull(a)economics.mit.edu 617-253-8895

5 6

Zope on Windows, Apache on Linux ???
by Jaroslav Lukesh 16 Aug '02

16 Aug '02

Hi all, I have my first complette Zope app and I need to publish it from workstation to the net. Does somebody let me know how to make success with %subj% and VirtualHostMonster (or some other method of virtual domains)? I have read many documentation about Zope and apache, but apache need local access to Zope files. I have low power web server linux PC with apache (486/16MB ram), and powerfull (4xCPU, GB ram etc) NTserver with Zope. So it is possible to connect these two different machines? My chief does not want to invest money to better hardware for linux - it is for free, so HW must be free too (no comment, please). Running apache on NT server is impossible from security reasons (is on internal network, not in DMZ). It is possible to serve pages (no more than one hit per 3-10 seconds) with that hardwares? Many thanks for your help. Regards J. Lukesh

6 5

Zope and ZODB database connections
by MKinsley＠empirecorp.org 16 Aug '02

16 Aug '02

> Hello everyone, > > We are currently developing a web application utilizing Zope and our own > ZODB database. > We have a few DTML documents that call external methods (written in > Python). > > We would like to open a ZODB connection to a database and keep it open > while passing the actual connection instance to other external methods > which process/manipulate/return the dynamic data of the web pages. We have > tried to use Netscape cookies to store a ZODB connection instance returned > from an external method 'dbOpenConn' and pass the value of the cookie > (ZODB connection instance) as a parameter to the 'dbCloseConn'. This only > works in the following DTML document. > > <dtml-var standard_html_header> > <h3><dtml-var welcomeMCIF></h3> > <form action="" name="form1" method="post"> > <dtml-let retobj=dbOpenConn> > <dtml-call "RESPONSE.setCookie('wrkaround',retobj)"> > <dtml-var > "dbCloseConn(REQUEST.RESPONSE.cookies.get('wrkaround')['value'])"> > </dtml-let> > <input type="hidden" name="rt_from" value="1"> > <input type="hidden" name="rt_to" value="1"> > <p><input type="submit" name="home2.html:action" value="Request CU > Information"></p> > <table name="home1"> > <tr valign="top"> > <td align="left"><a href="mrm">Member Service > Tracking</a> |</td> > <td align="left"><a href="mkt">Marketing Tracking</a></td> > </tr> > </table> > </form> > <dtml-var standard_html_footer> > > > > We cannot pass the ZODB connection instance to the next page and then as a > parameter to a 'dbCloseConn' on that page because ZODB instances cannot be > stored in a session variable, Python cookie, or another class attribute > (result: Unpickleable error). We can use a volatile attribute _v_ to store > the instance temporarily, but not throughout the session. > > We have also tried to pass a string representation to pages and call > 'dbReturnDtml' to try and evaluate the string and put it in a command line > to execute. The command line is > 'dbCloseConn(<ZODB.Connection.Connection instance at 0xc098804>)' . Using > rexec.RExec r_exec gives us the following error: > > > Zope Error > > Zope has encountered an error while publishing this > resource. > > Error Type: SyntaxError > Error Value: invalid syntax (line 1) > > > > Troubleshooting Suggestions > > The URL may be incorrect. > The parameters passed to this resource may be > incorrect. > A resource that this resource relies on may be > encountering an error. > > For more detailed information about the error, please refer > to the HTML source for this page. > > If the error persists please contact the site maintainer. > Thank you for your patience. > > > > > Traceback (innermost last): > File /usr/local/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line > 150, in publish_module > File /usr/local/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line > 114, in publish > File /usr/local/Zope-2.5.1-src/lib/python/Zope/__init__.py, line 159, in > zpublisher_exception_hook > (Object: mcif) > File /usr/local/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line > 98, in publish > File /usr/local/Zope-2.5.1-src/lib/python/ZPublisher/mapply.py, line 88, > in mapply > (Object: home2.html) > File /usr/local/Zope-2.5.1-src/lib/python/ZPublisher/Publish.py, line > 39, in call_object > (Object: home2.html) > File /usr/local/Zope-2.5.1-src/lib/python/OFS/DTMLDocument.py, line 127, > in __call__ > (Object: home2.html) > File /usr/local/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_String.py, > line 473, in __call__ > (Object: home2.html) > File /usr/local/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_Let.py, > line 76, in render > (Object: strrobj="_['wrkaround']") > File /usr/local/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_Let.py, > line 75, in render > (Object: robj="dbReturnDtml(strrobj)") > File /usr/local/Zope-2.5.1-src/lib/python/DocumentTemplate/DT_Util.py, > line 159, in eval > (Object: dbReturnDtml(strrobj)) > (Info: dbReturnDtml) > File <string>, line 2, in f > File > /usr/local/Zope-2.5.1-src/lib/python/Products/ExternalMethod/ExternalMetho > d.py, line 198, in __call__ > (Object: dbReturnDtml) > (Info: (('<ZODB.Connection.Connection instance at 0xc098804>',), {}, > None)) > File /usr/local/Zope-2.5.1-src/Extensions/mcif_driver.py, line 42, in > dbReturnDtml > File /usr/local/lib/python2.1/rexec.py, line 264, in r_exec > SyntaxError: (see above) > > > > > Is there a way to get this to work or can anyone suggest a better way or > better yet, the right way? The Python external method code we are using is > provide below. > > Your input is much appreciated. Thank you in advance for your support! > > > > > > ##mcif_driver.py (Zope external methods source)## > > import os > import rexec > import modAccounts > import Globals > import string > from Products.PythonScripts.standard import DTML > > def dbOpenConn(fname='/usr/local/Zope-2.5.1-src/var/mcif.fs'): > manager = modAccounts.ManageMCIF() > print "Set connection to MCIF database" > conn = manager.conDatabase(fname) > print "Set!" > print "Set instances to MCIF database" > manager.iniInstances(conn) > print "Set!" > #manager.storeSession(conn) > return conn > > > def dbCloseConn(dbconObj,fname='/usr/local/Zope-2.5.1-src/var/mcif.fs'): > manager = modAccounts.ManageMCIF() > manager.cloDatabase(dbconObj,fname) > print "Connection closed successfully!!!" > > > def dbReturnDtml(objstr): > > myString = '<dtml-var expr="dbCloseConn(' + objstr +')">' > cmdline = eval("'dbCloseConn(' + objstr + ')'") > print eval("cmdline") > cotrll = rexec.RExec() > cotrll.r_exec(cmdline) #error occurs with r_exec > myDTML = DTML(myString) > return myDTML() > > > Marco Kinsley > Web Applications Developer > _____________________ > Empire Corporate FCU > 1021 Watervliet-Shaker Rd > Albany NY 12205 > (518) 292-3800/800-253-0053 > e-mail: mkinsley(a)empirecorp.org > > NOTICE: This e-mail may contain confidential or legally privileged > information and is intended solely for delivery to the specific person > identified as the recipient. Any review, re-transmission, dissemination > or other use or taking of any action in reliance upon this e-mail by > persons other than the intended recipient is prohibited. If you receive > this e-mail in error, please contact us at (mkinsley(a)empirecorp.org) and > delete from your computer system, or otherwise from you records, the > information, which was transmitted to you in error. > >

3 2

Guru Meditations on roles, __roles__ etc?
by John Ziniti 15 Aug '02

15 Aug '02

Would someone in the know care to give a brief introduction to the way in which available roles are presented in the "Security" tab of items which inherit from SecurityManager. I would like the roles available to be culled from our LDAP database (via a LDAPLoginAdapter). Is acl_users automatically asked for any roles it has? Or is this the responsibility of the containing folder/product? Thanks in advance for any advice, John Ziniti

2 1

Sessions question
by List Subscriber ＠ Neurobs 15 Aug '02

15 Aug '02

Hi, I recently updated my python UF product to use Zope's built in Sessions instead of CST. Now I am faced with two problems: 1. How to completely expire all session stuff on logout. At this point of time I am using the following terminate session function to do so: def __terminate_session (Self,REQUEST): REQUEST.SESSION.invalidate() REQUEST.SESSION.getBrowserIdManager().flushBrowserIdCookie() so the question is : Is this enough?? or do I have to something more?? 2. How can I call my UF's user_logout function on expiry of the session?? In CST there was a field that allowed me to set up a method to be called on expiry. I didnt find any such option in the session_data_manager or browser_id_manager. So how do I do that?? TIA AM

2 7