- Zope - Zope lists

RE: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs -- Connecting M S Access to Zope by ZODBC
by Farrell, Troy 14 Mar '01

14 Mar '01

Have you set up your Access Database as a System DSN? Time for a mini-HOWTO: Jfarr knows that I did this a lot when I first started with zope. I kept bugging him for help :) I'm on WinNT4 SP6a: First, select Data Sources (ODBC) from the Control Panel. We want to add a System DSN. After selecting Add under the System DSN tab, we get a lovely 'Create New Data Source' dialog. Highlight Microsoft Access Driver (*.mdb) and select Finish. This brings up yet another dialog box asking questions: ODBC Microsoft Access Setup. Fill in the blanks: Data Source Name: Think of this like a zope id. I used something like bmsprofdb for the 'Business Media Services Profiles Database'. Description: Uh. I think this deserves it's own HOWTO :) The group of buttons labeled Database is for selection of an existing database, creation of a new one, repair and compaction of an existing database. For more information on these, see MS Access Help. For most setups, you won't want to select a System Database, and I don't know much about it, so you are on your own there. If you click options, you will see an additional group of settings. You may have to tweak these if you have heavy traffic, but if you have heavy traffic, you probably need a different database :) Clicking Advanced gives you the power to set more advanced options, like usernames, passwords, and working directories. This is also Access specific stuff. After you have setup this, go to Zope and select add a new ZODBC adapter. You will see the system DSN you have added. Highlight and add. The world is your oyster. Troy -----Original Message----- From: Loren Stafford [mailto:lstafford@morphics.com] Sent: Tuesday, March 13, 2001 11:37 AM To: diarmaid(a)bigfoot.com; zope(a)zope.org Subject: RE: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs Show us the error message and traceback. And, if you could use a better subject line, maybe more people would look at your message. -- Loren > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of > Diarmaid Lynch > Sent: Tuesday, March 13, 2001 07:41 > To: zope(a)zope.org > Subject: [Zope] Re: Zope digest, Vol 1 #1246 - 50 msgs > > > Hi there, > > I'm setting up a MS Access database for a project I'm working and > would like to use it with my Zope site.....having a little trouble > though. Installed the Zope ODBC adaptor but don't know how to > connect it to Zope? > > keeps giving me "bad request" errors when I try to specify a > connection string / any connection string! > > Is there more to installing the ODBC adaptor than just importing it > to the products folder? > > Seeking guidance ... > > Cheers > > _______________________________________________ > 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 ) > _______________________________________________ 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 )

2 1

using getPhysicalRoot
by Antonio Costa 14 Mar '01

14 Mar '01

Hi there I'm having the following problem with the getPhysicalRoot method. 1. I call this method inside an object: a = self.getPhysicalRoot() 2.1. If I "exec" the object from Zope by clicking on it everything works fine 3.1. If I call this object from another object via: return target_obj.index_html(id_query,title_query,blurb_query,path_query,meta_type_query,REQUEST) when it executes the a = self.getPhysicalRoot() instruction I get the following error: Error Type: TypeError Error Value: call of non-function (type string) If I print the type of the object with print type(self) I get the following: In 2.1 <extension class Acquisition.ImplicitAcquirerWrapper at 401a7234> In 3.1 <extension class Products.ModeratorResults.ModeratorResults.ModeratorResults at 84e9850> where ModeratorResults is my Object which is located in the file Products/ModeratedResults. I dont understand why it appears 3 times (Products.ModeratorResults.ModeratorResults.ModeratorResults). -- URL: http://www.terravista.pt/Enseada/1831 http://accosta.planetaclix.pt http://students.fct.unl.pt/~anjc PT is Portugal ####### # # # #" #" # Linux ##vvvvv## Rules! ## vvv ## # ## ## ## ### ### +++##### ##++ ++++++# #++++++ +++++++# #+++++++ +++++#######+++++ +++ +++

1 0

MSSQL7 ZSQL method works, can't use in DTML
by Rich Young 14 Mar '01

14 Mar '01

Hi all- I'm trying to set up a dual-zope arrangement to allow use of my MS-SQL Server 7.0 database data in linux-based web docs. Perusal of the Zope Book & the mailing list archives got me only so far -- specifically, I can connect to the database, I can browse it from the ZODBC object, I can create a ZSQL Method using it, and test it, and get the data I oughta get. All of this had me thrilled, until I tried to use the ZSQL method in a dtml document, as follows: <dtml-var standard_html_header> <H2>Here's SQL output:</H2> <UL> <dtml-in test> <LI><dtml-var tour_name></LI> </dtml-in>   </UL> <dtml-var standard_html_footer> This document, when viewed, starts prompting me for username & password, and refuses to accept anything that oughta work. I've created a user in MS-SQL specifically for this purpose, and it doesn't work. My own privileged login name and password don't work. I've tried creating variations on the basic ODBC datasource, wherein the connection type is SQL-Server LID/PW instead of trusted connection; TCP-IP connection instead of Named Pipe; I've even tried using a dummy Access DB with linked tables (that work fine in Access) to create an MS-Access ODBC datasource. All of these fail in the exact same way: Zope Error Zope has encountered an error while publishing this resource. Unauthorized Sorry, a Zope error occurred. Traceback (innermost last): File C:\Program Files\ZopeXPlus\lib\python\ZPublisher\Publish.py, line 222, in publish_module File C:\Program Files\ZopeXPlus\lib\python\ZPublisher\Publish.py, line 187, in publish File C:\Program Files\ZopeXPlus\lib\python\ZPublisher\Publish.py, line 171, in publish File C:\Program Files\ZopeXPlus\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: SqlOutput) File C:\Program Files\ZopeXPlus\lib\python\ZPublisher\Publish.py, line 112, in call_object (Object: SqlOutput) File C:\Program Files\ZopeXPlus\lib\python\OFS\DTMLDocument.py, line 170, in __call__ (Object: SqlOutput) File C:\Program Files\ZopeXPlus\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: SqlOutput) File C:\Program Files\ZopeXPlus\lib\python\DocumentTemplate\DT_In.py, line 682, in renderwob (Object: test) Unauthorized: 0 (once again, SqlOutput is the name of the dtml doc in question.) I have a feeling that http://www.zope.org/Members/roberth/ZMSSQLServer is a vital clue, but I haven't found it very helpful yet. This is mainly because I don't see any failed login attempts in the SQL Server logs, and I am without clue as to how one verifies/sets the user the main zope process runs as in a Windows environment. Oh, yeah. Machine #1 (database): NT 4.0, SQL Server 7.0; Machine #2 (windows connection to DB): Win98, Zope 2.3; Machine #3 (eventual Linux webserver): Redhat 6.2, Zope 2.3, etc. Any help greatly appreciated. --Rich Young rich at xplus dot com

1 0

dtml-var AND dtml-tree
by nuno 14 Mar '01

14 Mar '01

Hello, I'm trying to submit a form to a dtml-document (as action) which i did. But if a have a dtml-tree in the action Document the recursion doesn't work on clicking on the +/- icon when i try to access a dtml-var passed through the form. something like this: dtml-document_one has: <form .... action="dtml-document_two"> <input type="text" name="test" value="0"> </form> dtml-document_two has: <dtml-tree expr="PARENTS[0].dir1.dir2" branches_expr="objectValues(['Folder','DTML Document'])"> <IMG border="0" SRC="<dtml-var SCRIPT_NAME>/<dtml-var icon>"> <dtml-var id> </dtml-tree> <dtml-var test> If i click on the +/- of the tree it gives me an error on finding the object test ! The value is displayed on the first load, but the recursion doesn't work !! Has anyone accomplished something like this working ??? thanks, Nuno

1 0

Re: [Zope] Multiple selection property as list
by Dieter Maurer 14 Mar '01

14 Mar '01

Alexander James Tucker writes: > .... > In > <dtml-if expr="'Some group' in groups"> > "groups" is a string, > in > <dtml-in groups> > it is a list > .... I cannot believe this! Both "groups" are resolved in the same way. Dieter

4 5

Newbie: uploading file with python script (problem with it)
by Hans de Wit 14 Mar '01

14 Mar '01

Hello, I have a problem uploading files via a form and a python script. The content of the uploaded file after uploading it is only a string, ie the name of the file, not the file itself. I followed the guestbook example of the Zopebook. This is the receiving Python script. # create a unique file id id='entry_%d' % len(context.objectIds()) # create the file afile=context.REQUEST['afilename'] context.manage_addProduct['OFSP'].manage_addFile(id,afile) *** afilename is a field on the form the "sending" form: <form action="addFile"> Add file:<input type="file" name="afilename:string" size="30"><br> <input type="submit" value="upload"> </form> Thanks for any advice Met vriendelijke groeten, Hans de Wit h.de.wit(a)scp.nl

2 1

Perl/Zope, How to get REQUEST's and RESPONSE's
by Greg Green 14 Mar '01

14 Mar '01

Hello, I have tried numerous ways to use the REQUEST and/or the RESPONSE object's in perl methods in Zope without success. I have a Perl Script: arguments: self, REQUEST, RESPONSE Code: return $REQUEST->items(); And i get an error: Error Type: PerlError ErrorValue: Usage: Python::PyObject_GetAttr(o, attrname) at .../perl/Zope.pm line 118. Also I tried an unrestricted Perl script, testperl.pm: --------------------------------------------------------------------- package testperl; require Exporter; @ISA = qw(Exporter); @EXPORT = qw(testit); sub testit { local $self = shift @_; local $REQUEST = shift @_; local $RESPONSE = shift @_; return $REQUEST->items(); } return 1; --------------------------------------------------------------------- This is installed in ZopeBase/Extensions/ZopeExt/testperl.pm When I try it I get: ErrorType: PerlError ErrorValue: Undefined subroutine &ZopeExt::testperl::testit called Please reply to me directly as I am not on the list. Thanks, -- Greg Green Advanced Design Systems Math & Computing Technology Boeing (425) 865-2790

1 0

Worldpilot
by Takashi Veikko Linzbichler 14 Mar '01

14 Mar '01

Hi, out there ! As there seems to be quite some confusion about worlpilot on this list: disclaimer: I'm not involved in any way in wp development or anything the like. But that's what I found out until now: * The site www.wrorldpilot.nl is not the official wp development site, but as there is no other one by now the only one where you're able to download the lateset stable wp. * theres a mailing-list that's quite populated: worldpilot-users(a)lists.sourceforge.net * wp does not work ((at least not well) with Zope > 2.1.6 * Ryan Hughes (wp's developer) is aware of all these shortcomings and wants to resume wp development as soon as he finds time for this. BTW: Check out GUD, looks good ! :-) ta -------------------------------------------------------------------------- smartferret it-consulting Dipl.-Ing. Linzbichler KEG Dipl.-Ing. Takashi Veikko Linzbichler Tannhofweg 28/3 A-8044 Graz, Austria Tel.: 0316 / 39 89 40 -0 Fax: 0316 / 39 89 40 -20 Mobil: 0676 / 31 26 286 eMail: takashi.linzbichler(a)smartferret.com WWW: http://www.smartferret.com --------------------------------------------------------------------------

2 1

Should the use of hasRole() be discouraged?
by Hamish Lawson 14 Mar '01

14 Mar '01

I've read comments from others whereby they've reluctantly been obliged to give users a certain role in order for some products to work, due to a hasRole() call in the product. But why do products call hasRole()? I would have thought that for most cases the proper thing to do was to test for the user having the necessary *permission*; that is, the product shouldn't test for the user having the 'Editor' role, but for having the 'Edit' permission (roles just being a means to simplify the allocation of permissions to users). Or have I missed something? Hamish Lawson ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

2 1

FTP File System in Linux!
by Christopher J. Kucera 14 Mar '01

14 Mar '01

Found this on Freshmeat this morning: http://ftpfs.sourceforge.net/ I thought it could possibly be of some import. Basically, it's a kernel module that allows you to mount an FTP session as if it were a filesystem. This could be of great help to people who are trying to get away from using Zope's web interface all the time. I've not actually tried it myself yet, so I can't vouch for it's usefulness, but it should be an interesting project to watch evolve . . . -CJ

3 3