January 1999 - Zope - Zope lists

Re: [Zope] - ANNOUNCE: DCOracle release
by Kevin Littlejohn 18 Jan '99

18 Jan '99

>>> Anthony Baxter wrote > I'd guess that one of the results is larger than can fit in an integer, > maybe? Actually, it looks like it was in dealing with the input parameters, rather than the output ones - I found in ociCurs.py, around line 124, a piece of code that turns a number into an integer if it has no 'scale'. On commenting that out, it appears to work. If someone with a touch more knowledge than I can comment on the ramifications of that, it'd be appreciated ;) > > also, if timestamp's a number, you don't need the ' 's around it. Yeah, I know - I _did_ mention the example given was one of many attempts, right? ;) (quotes/noquotes * fmt/sqlvar * :float/:integer/nothing on input variables = many different possible combinations to assure myself it wasn't a dumb mistake in syntax ;) Oh, one other thing I wanted to double-check: In db.py (back in ZOracleDA), in the 'columns' method, there's the following code: def columns(self, table_name): c=self.cursor try: r=c.execute('select * from %s' % table_name) except: return () desc=c.description That looks like tempting fate to me... Is the 'select * from ' really not going to do bad things? (I'm presuming it doesn't actually trigger the db into _doing_ a 'select * from' unless it calls fetchone()) Is there a less, um, dangerous-looking way of getting the same result? I only ask because select * from most of the tables here would go away for a _very_ long time... KevinL --------------- qnevhf(a)obsu.arg.nh --------------- Kevin Littlejohn, Technical Architect, Connect.com.au Don't anthropomorphise computers - they hate that.

2 1

- ZOracle DA...
by David White 18 Jan '99

18 Jan '99

Hello, I've been quietly following the development of Zope and I'm VERY impressed and happy to see such a wonderful tool available as open source. I've been anxiously awaiting the release of DCOracle and the ZOracle database adapter and was overjoyed to see them arrive last week. Unfortunately, I've run into a little snag which I was hoping someone could help me through. I downloaded both DCOracle and the ZOracle DA (then realizing the ZOracle DA has DCOracle in the src directory...) I extracted the ZOracle DA product to the <Zope_Home>/lib/python/Products location and I then compiled the DCOracle piece in the <Zope_Home>/lib/python.Products/ZOracleDA/src directory. I ran the DCOracle_test.py file and got no errors. Having thought all was well I moved the Buffer.so and oci_.so shared libs to the <Zope_Home>/lib/python/Products/DCOracle directory. When I restarted Zope, the product appeared to be installed correctly as it wasn't 'broken' (no tracebacks), but when I tried to create a connection I got this traceback: ------------------------------------------------------------- Invalid connection string: webtools/webtools Traceback (innermost last): File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 879, in publish_module File /local/app/dc/Zope/lib/python/ZPublisher/Publish.py, line 595, in publish (Info: /Development/manage_addZOracleConnection) File lib/python/Products/ZOracleDA/DA.py, line 121, in manage_addZOracleConnection (Object: Navigation) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 139, in __init__ (Object: RoleManager) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 168, in edit (Object: RoleManager) File /local/app/dc/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 212, in connect (Object: RoleManager) File lib/python/Products/ZOracleDA/db.py, line 127, in __init__ File lib/python/Products/ZOracleDA/DCOracle/ocidb.py, line 65, in __init__ BadRequest: (see above) ------------------------------------------------------------- I have Zope being published through PCGI. I have an apache webserver which is running as a user which 'knows' where ORACLE_HOME so the PCGI process should 'know' this too. Did I just miss something obvioius? Any help is greatly appreciated, and once again thanks for a GREAT tool! Dave -- ---------------------------------------------------- David R. White Raytheon Electronic Systems Process Support (508) 440-2087 528 Boston Post Rd. Sudbury, MA 01776 davew(a)ed.ray.com ----------------------------------------------------

3 2

- FW: Zope, IIS 4.0 argv server error, fixed in new pss.exe ?
by Brian Lloyd 18 Jan '99

18 Jan '99

David reported: > http://www.egroups.com/list/zope/775.html getting the problem listed in the above URL. I can't download the pss.exe file, is there an ftp site or can the fixed me e-mailed. I run a web hosting company, and would like to offer Zope to customers. Thanks, David The Win32 service/IIS update is now available on the Zope 1.9.0 download page: http://www.zope.org/Download/Releases/Zope-1.9.0/index_html

1 0

RE: [Zope] - fsimport recursion error or my error?
by Brian Lloyd 18 Jan '99

18 Jan '99

> > I asked fsimport (mostly unmodified -- I added a couple > MIME TYPES) to bring in > > a directory of images and vrml files and just display the tree > > > >  > > <IMG SRC="/"> > >  > >  ... > > > > fsimport reads the file structure. The strange thing is > that is shows each file > > with the file/image icon, but gives a + like its a > directory. When you click on > > the file, it gives the ENTIRE tree again as a subdirectory. > Are we using #tree > > incorrectly? I think I know what's happenning here. You are not really using #tree incorrectly - you are just being bitten by the interaction of acquisition with the tree tag. Files and Images inherit Acquisition.Implicit. This means that when the tree tag asks an Image or File for its objectValues method, it will get the objectValues method acquired from the parent object of the Image or File (ad infinitum). You don't see this problem with Documents because Documents inherit Acquisition.Explicit, so it doesnt automatically acquire the objectValues method. The solution is for non-collection items like Images and Files to provide their own objectValues which returns an empty sequence, preventing the recursion. I've added a fix for the next Zope release so that non-collection objects will do the right thing. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

- making Zope stop inserting a BASE HREF tag?
by Anthony Baxter 18 Jan '99

18 Jan '99

Hey there, I've got a Zope running under ZopeHTTPServer on an NT4 box - for some reason it keeps inserting a BASE href into the HTML it sends back. For various reasons, this box's name is not what it's really known as - it's proxied in wierd and wonderful ways. For example, the following DTML (from standard_html_header) <HTML><HEAD><TITLE>  </TITLE></HEAD><BODY BGCOLOR="#FFFFFF"> gives this: <HTML><HEAD><TITLE>Zope</TITLE> <base href="http://TSWITCH:9673/"> </HEAD><BODY BGCOLOR="#FFFFFF"> It looks like some code in ZPublisher/Response.py is responsible - is there an easy way to fix this, short of taking an adze to that section of code? I don't _really_ want to hardcode a base - just to let the HTML go straight through, and let the browser figure it out itself. Thanks, Anthony -- Anthony Baxter, NextTelecom. email:anthony@interlink.com.au, voice: +61 416 271 170

4 3

- ANNOUNCE: Zope Database Adapter for Oracle
by Paul Everitt 18 Jan '99

18 Jan '99

The Database Adapter for Oracle is now available: http://www.zope.org/Download/ZOracleDA/ --Paul Paul Everitt Digital Creations paul(a)digicool.com 540.371.6909

3 2

- Zope+Apache
by Michel Pelletier 17 Jan '99

17 Jan '99

Greetings Zopers, I am putting together a new version of Zap, the Zope plus Apache package. I'm also expanding on the current Zap documentation to try and cover all the problems you've had in the past. If you have a working Zope plus Apache implimentation, I'd like the hear from you on the following points: What version of Apache are you using? Is your mod_rewrite staticly compiled in or dynamicly loaded? What part of the Zope+Apache installation and configuration process gave you the most grief? Could you, at your option, send me the _relevant_ portions of your httpd.conf file? After studying them I will delete them, and no-one else will see them. For those of you who DON'T use Zope and Apache: Would you use Zap if it was proven to be stable and easy, or would you stick with your current setup? (ZopeHTTPServer, Medusa, etc..) If you would consider switching to Zap, would you use it for production or just Zope prototyping? For everybody: If Zope and Zap were packaged in RPM format, what installation path would you like to see it in? Do you think an /etc/rc.d/init/zope file would be handy? Please send all replies to michel(a)digicool.com, make sure NOT to cc the list, especialy if you attach your httpd.conf file. Michel Pelletier (michel(a)digicool.com)

1 0

- Proxying and authorization
by Magnus Lie Hetland 17 Jan '99

17 Jan '99

I now serve a zope site (under development) through two proxies, no less, but it works quite nicely... Except for the authorization part. I have to enter my name and password for each of the three servers, which is quite annoying. So... Is there a way of making the browser understand that it should try the same authorization at all three places? Or maybe Zope could use relative URLs so that it would never notice anything other than the "top" proxy? Is there another way of solving the problem? -- Magnus Lie Hetland www.pvv.org/arcadia <arcadia(a)pvv.org>

1 0

- I made a ZSybase Database Adapter...
by Brian Hooper 17 Jan '99

17 Jan '99

Hi there! It's not all that wonderful yet, but I made a Sybase database adapter product using Peter Godman's (http://starship.skyport.net/~pgodman) ctsybasemodule and some simple tweaking of the ZMySQLDA. If you have a use for this, please try it out and give me tips and suggestions! FTP: ftp://www.garage.co.jp/brian/ZSybaseDA-0.9.tgz HTTP: http://www.garage.co.jp/~brian/ZSybaseDA-0.9.tgz --Brian Hooper

1 0

RE: [Zope] - Looping over the characters in a string in DTML...
by Wolf Logan 16 Jan '99

16 Jan '99

i've been thinking about this for a while now, and i was wondering if anyone had considered building a product to support python methods that would be stored in the object database. something like a document, but with real python source. the product could execute the code in a bastion (for security purposes). this would be a somewhat simpler way to handle external methods than using the external methods product, since the method itself would be stored in the object database and be editable through-the-web. i've wanted this so i could write one- or two-line snippets that could be used in "real" documents. -----Original Message----- From: Ty Sarna Sent: 1/16/99 9:36 AM On a more practical note, producing a picklist of years given a start and end date seems like a fairly common thing to want do. Why should I have have to give a content author on my zope site access to the filesystem, just to write a one-line function wrapper around a builtin python function?

1 0