September 2000 - Zope

Re: [Zope] SiteRoot (SiteAccess) problem
by Joshua Brauer 08 Sep '00

08 Sep '00

No, I unpacked the tarball in the Products directory. Any more ideas? Any idea how to get SiteRoot to show up on the available items list? Josh At 6:20 PM +0200 9/8/00, Wouter van Hilst wrote: >Hi, > >Did you unpacked the tarbal in the Zope-root? Then its not working. You have >to unpack it in the directory: Zope-2.2.1-linux2-x86/lib/python/Products: >then it must work! > >regards, > >Wouter >-------------------------------------------------- >deeldrie >grafische vormgeving - fotografie - interactieve vormgeving >Donker Curtiusstraat 63 >1051 MC Amsterdam >T (020) 681 36 99 >F (020) 681 38 65 > > >> From: Joshua Brauer <Joshua.Brauer(a)colostate.edu> >> Date: Thu, 7 Sep 2000 15:53:30 -0600 >> To: zope(a)zope.org >> Subject: [Zope] SiteRoot (SiteAccess) problem >> >> I'm running a new server with 2.2.1 and Siteaccess 2.0.0 b3 and I don't get a >> "SiteRoot" item in the available items list. I can copy site roots and move >> them, but I cannot create new site roots... After reinstalling SiteAccess (& >> restarting) I still have problems. Any ideas? >> >> >> >> >> General Info: >> >> * Zope version: Zope 2.2.1 (binary release, python 1.5.2, linux2-x86) >> * Python version: 1.5.2 (#1, Feb 1 2000, 16:32:16) [GCC egcs-2.91.66 >> 19990314/Linux (egcs- >> * System Platform: linux-i386 >> >> Installed Products: >> AspSucks (Installed product AspSucks) >> BTreeFolder (Installed product BTreeFolder (BTreeFolder-0.1.1)) >> Calendar (Installed product Calendar (calendar-0-9-0)) >> Confera (Broken product Confera) >> DemoPortal (Through-the-web Sample Portal) >> ExternalMethod (Installed product ExternalMethod (External Method-1-0-0)) >> Fortune (Installed product Fortune) >> Glossary (Glossary ZClass) >> Hotfix_06_16_2000 (Installed product Hotfix_06_16_2000) >> Hotfix_2000-08-17 (Installed product Hotfix_2000-08-17) >> IMAPAdapter (Broken product IMAPAdapter) >> KMnetNews (KM|net News) >> KnowledgeKit >> LoginManager (Installed product LoginManager (LoginManager-0-3-0)) >> MIMETools (Installed product MIMETools) >> MailHost (Installed product MailHost (MailHost-1-2-0)) >> NewsSyndicate (Installed product NewsSyndicate (NewsCenter 0.0.5)) >> NotMail (Broken product NotMail) >> OFSP (Installed product OFSP (OFSP-1-0-0)) >> PTKBase (Installed product PTKBase) >> PTKDemo (Installed product PTKDemo) >> Photo (Installed product Photo (Photo-0-4-0)) >> Planner (Planner) >> Poll (Installed product Poll (Poll-0-6-0)) >> PythonMethod (Installed product PythonMethod (PythonMethod-0-1-7)) >> Redirector (Installed product Redirector) >> SiteAccess (Installed product SiteAccess (SiteAccess-2-0-0b3)) >> Squishdot (Installed product Squishdot (Squishdot-0-7-1)) >> TinyCal (Installed product TinyCal (calendar-0-9-0)) >> TinyTable (Installed product TinyTable (TinyTable-0-8-2)) >> WebPages (WebPages Class) >> Wizard >> WorldPilot (Installed product WorldPilot (WorldPilot 1.00.3)) >> XMLDocument (Installed product XMLDocument (XML Document 1.0a6)) >> ZCallable (Installed product ZCallable) >> ZCatalog (Installed product ZCatalog (ZCatalog-2-2-0)) >> ZFDocument (Installed product ZFDocument) >> ZGadflyDA (Installed product ZGadflyDA) >> ZPhotoAlbum (Z Photo Album) >> ZPyGreSQLDA (Installed product ZPyGreSQLDA (ZPyGreSQLDA-0-0-3)) >> ZRTChat (HTML Chat for Zope) >> ZSQLMethods (Installed product ZSQLMethods) >> ZopeTutorial (Installed product ZopeTutorial (Zope Tutorial 1.0)) >> beehiveCal (Installed product beehiveCal (Version 0.2.0)) >> seminarCalendar (Seminar Calendar) >> >> -- >> ------------------------------------------------- >> Joshua Brauer >> Computer Support Scientist >> Department of Biochemistry and Molecular Biology >> Colorado State University >> Fort Collins, CO 80523 >> (970) 491-1080/pager: (970) 498-7995, #5837 >> ------------------------------------------------- >> >> _______________________________________________ >> 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 ) -- ------------------------------------------------- Joshua Brauer Computer Support Scientist Department of Biochemistry and Molecular Biology Colorado State University Fort Collins, CO 80523 (970) 491-1080/pager: (970) 498-7995, #5837 -------------------------------------------------

1 0

RE: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1
by Farrell, Troy 08 Sep '00

08 Sep '00

I appreciate your response. I had copied the data.fs over to the server with no success. I have the (buzzword alert)"web app" up and running on ZODBCDA. I still haven't solved the ZJetDA problem, but with ODBC, I may well ignore it. I wonder if iODBC or unixODBC is able to connect to access. I will let you know if I figure it out. My Zope versions are the same and I have the same products on each. I think I must have screwed up my permissions somewhere, but I think it might be on the NT side instead of Zope. I say this because the superuser cannot test the adapter successfully with permissions wide open with and without acquisision. More to come. Thanks. Troy -----Original Message----- From: Rik Hoekstra [mailto:rik.hoekstra@inghist.nl] Sent: Friday, September 08, 2000 4:33 AM To: Farrell, Troy Cc: 'zope(a)zope.org' Subject: Re: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1 "Farrell, Troy" wrote: > > As you have no doubt heard my cries for help, I figure that very few are > running NT4. More than would admit it, probably. Perhaps no one knows the answer to what seems to be a rather specific situation. For one, I have the impression most people use zodbc connections to access database then use the zjetadapter (so do I, so chances are I might be just blabbering). > I am having a permissions difficultie with ZJetDA trying to > modify data in an Access97 database. On my server, the DA is able to SELECT > * FROM tablename with no problem, but when it comes to INSERT INTO tablename > VALUES (...) or UPDATE, I get a Query Error with a value of INVALID > OPERATION. I mirror (It is identical, i checked 5+ times) all the objects > on my NT4 laptop and it works ok. The databases are Identical, I copied the > working one to the non-working server and still no go. The traceback is as > follows: > hm one stupid question: isn't by accident the working one read-only by accident (this happened to me more than once and it _will_ happen if the access file is not copied properly. Who knows what copying properly is - please speak up). > __call__ > (Object: bmsdb_jet_select_browse_state_sub_insert_into_temptablebrowse) > File C:\PROGRA~1\JESTER\lib\python\Products\ZJetDA\db.py, line 130, in > query > Query Error: (see above) you could try this with the zodbc adapter. Please make sure you odbc connection is made under the system account though. > > Rant: > I've been working on this for days. I don't seem to understand the security > model since I didn't have any problems before 2.2.x. If I cannot get this > resolved, I'll move back to the 2.1.x series. I really want this to work as > it is my companie's introduction to open source software. Have a :) day. hm is the Zope version the same on your laptop and your server then? If so, then the security thing should be the same on both, right? If not - then how can you say all objects are the same? Did you copy you data.fs database from one machine to the other? success, let us know how it goes hth Rik _______________________________________________ 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 )

1 0

Using Zope DB connection from a Python class
by Ivan Raikov 08 Sep '00

08 Sep '00

Greetings, For the past few days, I've been unsuccessfully trying to use a Zope ODBC connection from within a Python class. I have the following situation: 1. A Python class, Order, which has this method: def create (self, cust_id, connection_id = None, itemcode = None, quantity = 0): while self is not None: if hasattr(self, 'objectValues'): for o in self.objectValues(): if hasattr(o, 'id'): if o.id == connection_id: self.connection = o self.cust_id = cust_id self.itemcode = itemcode self.quantity = quantity query = 'insert into orders (cust_id, itemcode, quantity) values (%s, \'%s\', %s)' % (self.cust_id, self.itemcode, self.quantity) if self.connection != None: self.connection._begin() result = self.connection.query (query) print result self.connection._finish() 2. A Zope class, TestOrder, which subclasses Order. Its constructor tries to invokes 'create', however upon executing the SQL query, Zope either dies and is restarted, or just sits there, doing nothing, until the HTTP connection times out. In either case, the new record is not written in the database. 3. Zope 2.1.7 Z ODBC DA 3.0.3 Solid dev kit 2.3 RedHat Linux 6.1 on i386 Please help. Thanks, Ivan Raikov

5 4

Underscore Caracter
by Marcus Mendes 08 Sep '00

08 Sep '00

Hello, I need replace 0x20 (space caracter ) to Undescore Caracter. I need also a function that UNDO this operation. How can I to do this in DTML sintaxe? Thanks. Marcus Mendes

11 20

DCOracle examples
by Celio C. Guimaraes 08 Sep '00

08 Sep '00

I have just installed the DCOracle package to access an Oracle 8.0.5 server with python1.6. I have run with success the test script DCOracle_test.py connecting to the Oracle database. I would like to see some python examples of the DBI API with queries and so on. Could you give any help? Celio Guimaraes Institute of Computing Unicamp - Campinas - Brazil

1 0

Icons in a product
by Petr Knapek 08 Sep '00

08 Sep '00

Hi Zopists, I would like to know if there is any possibility how to publish an icon on the web which is in www folder of my own created product. That is I want to put some icons into the www folder of my product and to have possibility to show them on the web. The problem with my own stylesheet of my product is similar. Is there any possibility to put it in the product (not ZODB) and later use it. In both cases I don't want put anything into /Control_Panel/Products/myProduct/ over web interface. I use Zope 2.1.6 I need to put any icon into my python product and later have possibility to call this icon on the web. Where to put it in my folder structure on the box and what the URL will be? Thanks for help, Petr -- Petr Knápek NEXTRA Czech Republic, s.r.o., Veveří 102, 659 10 Brno, Czech Republic e-mail: mailto:petr.knapek@nextra.cz tel:+420-5-41 558 394 FAX:+420-5-41 558 390

2 1

Help: PATH_INFO==>object
by Li Dongfeng 08 Sep '00

08 Sep '00

I am writing a service for other pages to use as form action. How can I reference the caller object in DTML/python? I can only think of this: First use PARENTS[-1] to get to the root object of the site. Then split the PATH_INFO containing the caller's path, and go down from the root to every subfolder in PATH_INFO and then get to the caller object. But this is not very elegant. Can anyone give better solution to this?

2 3

Re: [Zope] MetaData?
by kamon ayeva 08 Sep '00

08 Sep '00

OK, checking the Advanced ZCatalog Howto, I just found I could maybe use something like <dtml-in "Catalog(meta_type=['DTML Method','Document', 'Anothermetatype])"> Method or Document or Anothermetatype: <dtml-var "Catalog.getpath(data_record_id_)"><br> </dtml-in> to solve my problem. Haven't yet tested, so I dunno if it's my best option. -- Kamon >From: Chris Withers <chrisw(a)nipltd.com> >To: kamon ayeva <kayeva(a)hotmail.com> >CC: zope(a)zope.org >Subject: Re: [Zope] MetaData? >Date: Fri, 08 Sep 2000 13:06:50 +0100 > >kamon ayeva wrote: > > How can I get the id or title of (Document) instead of the url ? > >Aren't they in the MetaData returned by the catalog query? > >If they aren't, add them ;-) > >cheers, > >Chris _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

Re: [Zope] MetaData?
by kamon ayeva 08 Sep '00

08 Sep '00

Hi Chris, >From: Chris Withers <chrisw(a)nipltd.com> >To: kamon ayeva <kayeva(a)hotmail.com> >CC: zope(a)zope.org >Subject: Re: [Zope] MetaData? >Date: Fri, 08 Sep 2000 13:06:50 +0100 > >kamon ayeva wrote: > > How can I get the id or title of (Document) instead of the url ? > >Aren't they in the MetaData returned by the catalog query? They are. But I guess the text searching is on the 'abstract' method, and what I need is something like PARENTS[] to jump to the container. Or am I missing something about good usage of ZCatalog ? >If they aren't, add them ;-) > >cheers, > >Chris -- Kamon _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

1 0

ZCatalog or Traversal question ?
by kamon ayeva 08 Sep '00

08 Sep '00

Hi, I want to query content built with CatalogAware ZClasses on my site. I am able to get the abstract document ('abstract' method) which is a subobject of the document I want to display (let say 'Document' ZClass). But I don't know how to display the id of the resulting 'Document'. With the following snippet I get a partial solution since I get the url: <dtml-in Catalog> <dtml-if "meta_type=='DTML Method' and id=='abstract'"> <a HREF="http://www.mydomain.com<dtml-var "Catalog.getpath(data_record_id_)">/../"> <dtml-with "Catalog.getobject(data_record_id_)"> <dtml-var "REQUEST['URL2']"> </dtml-with> </a> </dtml-if> </dtml-in> How can I get the id or title of (Document) instead of the url ? Many thanks. -- Kamon Ecubateur _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.

2 1