- Zope - Zope lists

Re: [Zope] Lock and Transaction in Zope.
by Hung Jung Lu 08 Sep '00

08 Sep '00

Hi Aitor, (I am posting to the Zope mailing list, too.) >I have Zope in W2000 >Zope 2.2.1 >Internet Explorer 5.0 Ok. I just tried with Zope on Linux, after I tried with Zope on Windows 98. RedHat 6.2 Zope 2.1.6 Internet Explorer 5.0 Guess what? The thread did not hang. The long thread returns, but the value of your "var" was 2. The situation is then: (1) For Zope running on Windows, the long thread hangs and never returns anything to the browser. (2) For Zope running on Linux, the long thread gets into transaction conflict. But Zope was smart enough to abort the transaction and restart the request again. (Just like what other people said.) I think this should be considered as a bug in Zope for the Windows platform. We should submit the bug report to the Zope bug collector. Notice that it happens for Zope 2.1.6 and Zope 2.2.1, I wonder why no one has reported this bug... (or has it been reported but not been fixed?) regards, Hung Jung _________________________________________________________________________ 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

Set Access Rule wish
by Albert Boulanger 08 Sep '00

08 Sep '00

Its nice that the icon for the method, who is the access rule's target, is changed. However, I think also there needs to be some indicator on the folder involved as well. Over the long weekend, I had accidentally set an access rule (for URL-based SQLSession ID) in the proper folder and also a subfolder (to the same method). Took me several days to discover that other access rule had been set in the subfolder. When your you have mistakes with this kind of stuff, I can be madding and any kind of indicators would be useful. Regards, Albert Boulanger aboulanger(a)vpatch.com

2 1

SiteRoot (SiteAccess) problem
by Joshua Brauer 08 Sep '00

08 Sep '00

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 -------------------------------------------------

2 1

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