November 2000 - Zope

BUG: Nasty dtml-sendmail bug - Zope 2.2.4b1, Zope 2.1.6
by Dieter Maurer 22 Nov '00

22 Nov '00

Today, I spend 3 hours to analyse a nasty dtml-sendmail bug (Zope 2.1.6): Zope reported an SMTP exception: "recipient required" It turned out that the "messageText" that arrived in "Products.MailHost.MailHost.send" started with an empty line. Therefore, "decapitate" could not find the "To:", "From:" and "Subject:" headers and called "smtplib.send" with an empty "to" list. What really confused me: my DTML code did not show any sign, where this empty line should come from. Moreover, an identically locking DTML object worked as expected. Explanation: A collegue had edited the DTML object causing the problems with a *WINDOWS* editor and then uploaded the file. The Windows editor had added a Control-M after the "<dtml-sendmail mailhost=...>". This Control-M caused the spurious empty line. In the edit view, the browser did not show the Control-M. Therefore, the faulty and the correct DTML objects looked completely identical. I verified that the same bug is in Zope 2.2.4b1, too. Furthermore, the check for missing "To" and "From" is ineffective (as "extractHeader" always adds a "To" and "From" to header, just empty if it can not find the headers). I will put this into the collector. Dieter

1 0

RE: [Zope] Multiple ZODBC sources
by Capesius, Alan 22 Nov '00

22 Nov '00

Thanks All, I was hoping I had missed a clean way to do this. :) Access provides link tables, but what if I had two SQL servers? I thought (still thinking) about the Access link table solution, but I'm not sure I want the ODBC linking through Access to get to SQL. MS SQL Server also supports server links via Transact-SQL/XML. The dtml-in/dtml-with technique suggested by Chris Gray looks the promising. That will eliminate cross-product problems too. Probably the closest thing I'll find to a true join. So, after some digging and trying I found that you can access multiple Databases on the same SQL server by setting the ODBC driver up WITHOUT a default table and qualifying the database as such: select * from DBNAME..TABLENAME This method sacrifices the ability to browse for tables through this DSN, but this can be recovered by creating a secondary table-specific DSN for browsing purposes. ODBC also supports a configuration that allows SERVERNAME.DBNAME..TABLENAME configurations but I haven't been able (yet) to get that working through Zope. This would support direct links to multiple SQL servers. Since the ODBC DSN is part of the ZODBC configuration parameters, I expect that ZODBC cannot provide support for different source types at the ZSQL Method level. As far as writing a method to copy from one table to another, this would be OK in my case because I am using small databases on this app, but not for larger dbs. That would result in (2 + #_of_records) queries against the SQL in a realtime database. My app uses a static table (once a day update) for the Access side, so just moving/migrating this once a day to SQL may be the best bet. The SQL source is a third party package so I'd rather not put my table into their database just in case. (Avoid all that finger pointing later on). The copy table method along with the ZODBC solution above allows me to add a database to the server outside of the 3rd party's database and join tables via Zope ZSQL. >>>-----Original Message----- >>>From: Chris Gray [mailto:cpgray@library.uwaterloo.ca] >>>Sent: Wednesday, November 22, 2000 10:31 AM >>>To: Andrew Kenneth Milton >>>Cc: Capesius, Alan; zope(a)zope.org >>>Subject: Re: [Zope] Multiple ZODBC sources >>> >>> >>>I wonder if something like this would work: >>> >>><dtml-in selectFromTable1> >>> <dtml-in selectFromTable2> >>> <dtml-if idFromTable1 = idFromTable2> >>> ....display parts of the two records.... >>> </dtml-if> >>> </dtml-in> >>></dtml-in> >>> >>>Might be more efficient to make one of the dtml-ins a >>>dtml-with and find >>>the item with the matching id. >>>

1 0

Re: [Zope] Executing Z SQL Methods via a URL request
by Dieter Maurer 22 Nov '00

22 Nov '00

Please do *NOT* send HTML mails into this list! Nick McDowell writes: > I have a Z SQL method that requires an �id� value which it users to perform > a select statement. I am trying to pass this �id� value via a URL, which > calls a DTML method who in turn calls the Z SQL Method. When I remember right, someone introduced into Zope 2.1.6's Z SQL methods that acquisition is stronger than explicitely passed arguments (and arguments from REQUEST, this is your case). One says, it was for security reasons. I think, this is a big bug, and I will change it, whenever I should see it. If it is still in Zope 2.2, then you will have only 2 chances: 1. rename you argument to something that is not acquired (as 'id' is). In your SQL, you can of cause use the column name as it is defined by the table - similar to the following: .... where id = <dtml-sqlvar renamed_id type=string> .... 2. change the code in "Shared.DC.ZRDB.DA.__call__", as I would do. I did not yet work enough with Zope 2.2 to got hit by the bug (if it is still there). Therefore, I do not yet have a patch. Dieter

1 0

Re: [Zope] Speaking of Python Methods....
by Dieter Maurer 22 Nov '00

22 Nov '00

Steve Drees writes: > What's the PythonMethod equivalent of: > <dtml-with callTypes> > <dtml-var "_.getitem(_.str(2)).Name"> > </dtml-with> To get the object: getattr(callTypes,'2').Name then you must do something with it. "dtml-var" would render it. This means call it, if it is callable and convert to a string. The "callTypes" above may need to be replaced by "self.callTypes" or "context.callTypes", if "callTypes" is not yet in the functions namespace. Dieter

1 0

Analysing Zope startup problems (was: [Zope] zope 2.24b1 upgrade on win98 crashing. errno 9?) upgrade on win98 crashing. errno 9?)
by Dieter Maurer 22 Nov '00

22 Nov '00

jimbo writes: > IOError: [Errno 9] Bad file descriptor Whenever there is a Zope startup problem, you should edit the command line starting Zope (in "start.bat"). Add "STUPID_LOG_FILE=zope.log". Start Zope. Of cause, it will crash again. Look into "zope.log". Maybe you have a change to see what went wrong. By the way, I saw a similar problem report in the list. I cannot remember the details. Search the searchable list archive for "Bad file descriptor". Dieter

1 0

Re: [Zope] random object with properties
by Dieter Maurer 22 Nov '00

22 Nov '00

Kevin Worth writes: > I'm trying to find/write a method that will choose a random image > from a folder (easy, using the random how-to) But I also want to > display the caption for the image, which is a property of that image. > > This method: > > <dtml-var expr="_.whrandom.choice(objectValues('Photo'))"> > <dtml-if caption><dtml-var caption></dtml-if> > > presents me with a random photo, but no caption. <dtml-let photo="_.whrandom.choice(objectValues('Photo'))"> <dtml-var photo> <dtml-with photo> <dtml-if caption>....</dtml-if> </dtml-with> Dieter

2 2

Re: [Zope] Date
by Dieter Maurer 22 Nov '00

22 Nov '00

Tom Deprez writes: > Does someone knows how to calculate the date after 6 months of a certain date? > > eg ZopeTime() + 6 months? > > Is there an easy formula for this? Or do I've to check myself for a new > year, leap year When I would need it (and did not find a better method), I would use (in an external method): 1. convert to a Python time tuple 2. add 6 to the month component (creating a new tuple) 3. convert back to a DateTime object. It might be necessary to normalize the time tuple before 3. with an "time.localtime(time.mktime(tup))". Dieter

3 3

Still have error importing DemoPortal.zexp with PTK 0.9.2
by Andrews, Martin 22 Nov '00

22 Nov '00

I am trying to install PPT 0.9.2. After installing PythonMethod from CVS I am still getting an error when trying to import DemoPortal.zexp. Any clues? Zope Error Zope has encountered an error while publishing this resource. Error Type: SystemError Error Value: Failed to import class AnObject from module Products.PythonMethod.PythonMethod 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 /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 187, in publish File /tmp/makeme23613/Zope-2.2.2-src/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 171, in publish File /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: manage_importObject) File /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: manage_importObject) File /tmp/makeme23613/Zope-2.2.2-src/lib/python/OFS/ObjectManager.py, line 519, in manage_importObject (Object: Traversable) File /tmp/makeme23613/Zope-2.2.2-src/lib/python/ZODB/ExportImport.py, line 208, in importFile SystemError: (see above) --- Martin Andrews mandrews(a)netgenics.com

1 0

Free Zope Web space?
by Diarmaid Lynch 22 Nov '00

22 Nov '00

Hi, I'm creating an online newspaper for my school but unfortunately don't have Zope / Web server. Is there anywhere on the web that would serve this for free. Has "Zope-Geocities" been created yet?? Your help would be greatly appreciated.

2 1

Re: Zope and Websphere
by rob.sheppard＠btinternet.com 22 Nov '00

22 Nov '00

There's a round-up of "the Best Web Application Servers" in this month's Linux Magazine (Nov - 8 ball on cover). It includes Zope and WebSphere. Its not really a comparison though, but it might give you some ideas. You could also get some ideas from Kemalus' "Guide for Corporate Decision Makers" (http://www.zope.org/Members/Kemalus/make_zope_dec ision). I'm no marketer, but if you could find a similar document on WebSphere you might be able to do a 'real' comparison. HTH, Rob

1 0