January 2000 - Zope - Zope lists

Attribute Error: tpc_begin
by Bill Scherer 20 Jan '00

20 Jan '00

I'm trying to get ZSolidDA working. I had to make minor changes to sql.c and the Makefile to account for my Solid version 3 libs and includes. The compile went ok, and sql.so is importable and looks ok. I'm trying to run a ZSQLMethod to create a table and I'm getting an exception: Error Type: AttributeError Error Value: tpc_begin Traceback (innermost last): File /opt/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /opt/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /opt/Zope-2.1.2-src/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: SQLcreateTable) File /opt/Zope-2.1.2-src/lib/python/ZPublisher/Publish.py, line 169, in publish File /opt/Zope-2.1.2-src/lib/python/ZODB/Transaction.py, line 236, in commit AttributeError: (see above) I searched an found this related bug, apparently during 2.0.0 beta: http://classic.zope.org:8080/Collector/308/view Any ideas how to fix this anyone? Thanks. details: Zope 2.1.2, using zserver Redhat 6.0. ZSolidDA-2-0-0. SOLID Embedded Engine - v.03.00.0051 (Linux ix86 MT) -- William K. Scherer Sr. Member of Applications Staff Bell Atlantic Mobile

1 0

RE: [Zope] [Q] fsimport.py gone from Zope site?
by Brian Lloyd 20 Jan '00

20 Jan '00

> I just spent 15 minutes searching for Brian Lloyd's fsimport.py > on the Zope site but it seems to have disappeared. I'd > appreciate a pointer to this priceless external method. > > Cheers, > Darran. Hi Darran, fsimport has evolved into load_site.py, which should be in the /utilities directory of your Zope installation. Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

WebDAV with Office 2000
by Bjorn Stabell 20 Jan '00

20 Jan '00

Hi, Has anyone managed to browse a Zope site through WebDAV (Web Folders) from Office 2000? I get this error: Zope has encountered a problem publishing your object. Object name begins with an underscore at: http://webdav.zope.org:2518/_vti_bin Bye, -- Bjorn Stabell <bjorn(a)stabell.priv.no>

3 3

Renderable Base Zclass
by Jeroen Baekelandt 20 Jan '00

20 Jan '00

Hi, I'm desperately trying to understand how to make the CaptionedImage as an example to use Renderable Base ZClass. I just can't get it to work, because I don't really know how to start (me-is-really-new-to-Zope). So I add a product MyImage and add a ZClass to it. The ZClass subclasses Image and Renderable. I got that far. Could somebody explain how to continue? What i basically want is an ordinary Image (with the normal properties) + one extra: the caption, that gets rendered just below the image. I read the ZClass Guide, but the examples in there just don't apply to this one (it seems). Thanks, Jeroen

2 1

RE: Oracle or PostGreSQL connection pool
by Nemeth Miklos 20 Jan '00

20 Jan '00

> Message: 24 > Date: Tue, 18 Jan 2000 09:48:24 +0000 (GMT) > From: Oleg Broytmann > Reply-To: phd(a)phd.russ.ru > To: Zope Mailing List > Subject: Re: [Zope] Oracle or PostGreSQL connection pool > > Hi! > > Is there any way to implement the following thing? > > I have an Oracle database, and by design every user that logs into the > site will be connected to the DB with his/her login/password (that is, > his/her Oracle login/password is the same as for WWW). > It sounds strange. Orcale is very poor of managing connections. The entire transaction process monitor (TPM) business earns of its revenue from this fact. A TPM (just like ZOracleDA) uses its own username/password to connect to a database. This is the only way to maintain an efficient connection pooling strategy. I am very curios of your rationale of thinking of this usage of Oracle. > > I am considering using Zope for the site, but the question is - how can > I create one ZOracleDA connection for every user, and how can I use diferent > connections for different users? > > Cuurently the site is in the process of development, and we are > considering different techiniques. Zope is one of them; another possible > solution will be CGIs + small server (on WWW side) that will handle > long-time pool of connections from WWW to Oracle (CGIs will not be > connected to Oracle directly, but will connect to the server, use a > connection from the pool, etc.) > I do not understand. If you want to use a separate connection for each user, you will not have any pool. I think we can speak of a pool when each connection in the pool has the same database(SID)/user/password. I'd really interested in your goals with this architecture. I read a lot of your mails, Oleg, and I liked them very much, you must have some trick here :-). NM

2 3

Re: [Zope] RE: Oracle or PostGreSQL connection pool
by Anthony Baxter 20 Jan '00

20 Jan '00

>>> Oleg Broytmann wrote > Not my solution, but database programmers/admins. [...] > They (DB programmers/admins) calls it "security". It's really not a very good solution. Aside from anything else, you've still got this one application at the front with all the different connections - how can you be sure that the wrong user can't get a different user's connection? More importantly, this _won't_ scale. If I have 20 users, that will be 20 connections held open. Yuk. And say I want to open 2 or 3 connections per user, to remove the single-threaded nature of it, and it's way way worse. Plus you've got to then worry about the connections being established correctly each time, reallocation of resources when they time out, &c &c &c. Aside: if you're using ZOracleDA to talk to Oracle, and for some reason your Oracle connection gets trashed - restart Zope. Don't bother trying to just close and re-open the connection, I've found that leads to a world of pain. It sometimes works. And other times it makes bad things happen. (I'm also somewhat unconvinced that Oracle's all that secure - would you expose an Oracle server to the internet? I don't think so... :) Anthony

2 1

installation on RH 6.1
by Rohan Veal 20 Jan '00

20 Jan '00

Hi, I have a standard RH6.1 installation, and when compiling the zope src distribution (Zope-2.1.2-src.tgz) with pcgi, I get an error, "cp: /usr/lib/python1.5/config/Makefile.pre.in No such file or directory". I cannot find how to fix this. There is no Makefile.pre.in located anywhere in my python directory tree. Any suggestions. tejay

3 2

Job Positions
by Terry Kerr 20 Jan '00

20 Jan '00

Hi, We are in despirate need of zope/oracle8/C programmers to work in a team which has contracts to develop cutting edge ecommerce applications. It is prefered that applicants have skills in at least two of the areas mensioned, and applicants must have experience in the web and web development in general. The positions are full time starting immediately. Short term contracts or long term employment can be offered. Salarys neg. depending on experience. Adroit Internet Solutions PTY LTD Melbourne, Australia Contact: Terry Kerr (terry(a)adroit.net) PH: (03) 9888 8522 Mob: 0414 938 124 terry

1 0

Problems with PCGI
by Nolan Darilek 20 Jan '00

20 Jan '00

First, a few quick disclaimers: 1. I'm not subscribed to the list, so please CC me with any replies. 2. I know this is probably an RTFM-ish question; I just can't find which FM to read. :) And, I've scanned a few, but I'm obviously doing something stupid and newbieish. :) I'm trying to set up Zope on my local Roxen test webserver. After a few failed attempts of my own, I decided to be smart and search zope.org for docs. I found the great Zope/Roxen howto, and everything almost works. I'm trying to have all URLs on my box directed to Zope, and I'm having a few problems with the Zope rewrite rules posted at http://www.zope.org/Members/Bill/Documentation/RoxenZope. Here is how my browser, Emacs/W3, renders the table with the Roxen rewrite rules: | | ||Preferred ReWrite Ruleset || | | | || || | | | || ^/([A-Z])(.*) || | | | || /Zope.cgi/$1$2 ^/([a-z])(.*) || | | | || /Zope.cgi/$1$2 ^/([0-9])(.*) || | | | || /Zope.cgi/$1$2 || | Do I need to concatenate any of those lines? Whenever I try going to any URL other than /, I get Roxen's default 404 error message. Another problem which I've noticed is that, though I've intended to have Zope generate all HTTP content and use Roxen for all other server-related tasks, Zope is placing :8080's in the URL, thus redirecting requests to ZServer. This isn't what I want. I thought that using the -p option would remove the :8080, but it doesn't seem to be helping. I'm using the Debian Zope package, which lacks the start and stop scripts referenced in many of the docs which I've read. It instead uses a zopectl script, with a ZOPEOPTS variable in /etc/init.d/zope which passes arguments to zopectl. I've set ZOPEOPTS to "-p /usr/lib/cgi-bin/Zope". Can anyone recommend anything else? I'm sure that I'm committing Common Newbie Mistake #2356, but I'm completely clueless about how to fix this one. :) Thanks.

2 1

[Q] fsimport.py gone from Zope site?
by Darran Edmundson 20 Jan '00

20 Jan '00

I just spent 15 minutes searching for Brian Lloyd's fsimport.py on the Zope site but it seems to have disappeared. I'd appreciate a pointer to this priceless external method. Cheers, Darran.

1 0