- Zope - Zope lists

- Need installation recommendation
by LD Landis 18 Jan '99

18 Jan '99

Hi, Ok... Before getting into Zope+Gadfly, et al, I played around with installing Gadfly into the /usr/local/lib/python1.5 directory (since I didn't see any harm in having that there, from my perspective)... I see that gadfly is also installed in the Zope lib... I currently have the gadfly code in two places. Now that I'm ready to install the DCOracle stuff, etc... what is the best way to do that? Do you recommend having separate library areas for each thing (like gadfly, DCOracle, etc)? or just jam them all into the same lib? Is there anything about the DCOracle packaged in the Zope adapter that would prevent just using what is placed elsewhere (e.g. /usr/local/lib/python1.5 or subdir)? Now that I'm getting ready to start running a much more fully featured Python... I'm looking for "the voice of experience" in how to lay it out so that it can be managed. -- Cheers, --ldl ----------------------------------------------------------------------------- LD Landis ldl(a)HealthPartners.Com N0YRQ Voice 612/883-5511 Fax 612/883-6363 HealthPartners, 8100 34th Avenue So, PO Box 1309, Minneapolis, MN 55440-1309 Shape your life not from your memories, but from your hopes. (Borrowed) -----------------------------------------------------------------------------

3 2

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