- Zope - Zope lists

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

try tag doesn't seem to work.
by Jay, Dylan 20 Jan '00

20 Jan '00

I am not having much success trying to catch an exception from ZClient. >From the following code <ol> <dtml-in locs> <li>&dtml-loc_name; <try> <dtml-var "WebClient(loc)"> <dtml-if "WebClient(loc)"> (ok) </dtml-if> <except> (failed) </try> </li> </dtml-in> </ol> I get the following error Error type: bci.NotAvailable Error value: (10060, 'winsock error') (File: http://135.9.1.4/cgi-bin/provsn/DenverGetFile.py Line: []) None None for None <!-- Traceback (innermost last): File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Publish.py, line 214, in publish_module File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Publish.py, line 179, in publish File C:\PROGRA~1\PROVIS~2\lib\python\Zope\__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Publish.py, line 165, in publish File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: testLocations) File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: testLocations) File C:\PROGRA~1\PROVIS~2\lib\python\OFS\DTMLMethod.py, line 145, in __call__ (Object: testLocations) File C:\PROGRA~1\PROVIS~2\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: testLocations) File C:\PROGRA~1\PROVIS~2\lib\python\DocumentTemplate\DT_In.py, line 691, in renderwob (Object: locs) File C:\PROGRA~1\PROVIS~2\lib\python\DocumentTemplate\DT_Util.py, line 335, in eval (Object: WebClient(loc)) (Info: loc) File <string>, line 0, in ? File C:\PROGRA~1\PROVIS~2\lib\python\Products\ExternalMethod\ExternalMethod.py, line 248, in __call__ (Object: WebClient) (Info: (('http://135.9.1.4/cgi-bin/provsn/DenverGetFile.py',), {}, ('http://www.yahoo.com/', None, None))) File C:\PROGRA~1\PROVIS~2\Extensions\WebClient.py, line 8, in web_client File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Client.py, line 344, in call File C:\PROGRA~1\PROVIS~2\lib\python\ZPublisher\Client.py, line 221, in __call__ (Object: DenverGetFile.py) bci.NotAvailable: (see above)

2 1

Re: [Zope] Where does Zope store HTTP file uploads?
by Tres Seaver 19 Jan '00

19 Jan '00

J C Lawrence <claw(a)kanga.nu> wrote: > > On Wed, 19 Jan 2000 16:02:22 -0000 > Phil Harris <phil.harris(a)zope.co.uk> wrote: > > > In my case there was 'traffic' in the c:\temp dir. > > > Is there such a notion on Unix? > > Unix systems commonly have multiple "temp" directories, /tmp, > /usr/tmp, and /var/tmp being the common ones, each with slightly > different policies as to when they will be cleared out and their > contents deleted. > > Last I checked Python's tempfile() used /tmp by default. Python's tempfile module searches using the following candidates, in order: os.environ[ 'TMP' ] os.environ[ 'TEMP' ] os.environ[ 'TMPDIR' ] "\TEMP" # WinNT only "C:\TEMP" " " macfs.FindFolder( MACFS.kOnSystemDisk # Mac only :) , MACFS.kTemporaryFolderType ) "/usr/tmp" "/tmp" os.getcwd() / os.curdir and uses the first one it can create a file in. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

Re: [Zope] Properties container: Descend from Folder or DTMLDocument?
by Tres Seaver 19 Jan '00

19 Jan '00

Jim Washington <jwashin(a)vt.edu> wrote: > I am working on a ZClasses thing that makes forms and automagically > saves form data into the ZODB. I am assuming the response record (After > the 'submit' button is pressed) will be written once (e.g, a test or > survey) and changed rarely or never, so it is proper to use the ZODB. > > I do not want to use a DB product, since if you change the form, you > need to modify the table, and that is not nice, either. > > So, what I want is a thing that just has Properties I can add at > runtime. > > Should this new ZClass descend from Folder or DTMLDocument? From the > application's point of view, they are equivalently good, since both have > Properties I can modify. Technically, though, which would be better? Any Zope class can have properties, although if you want to customize the properties of each individual instance, you will need to pick up one of the two you mention (or create a new one in Python which subclasses PropertyManager.PropertyManager). In that case, select between them based on whether you want the item to be "folderish", that is, to allow adding other objects via Zope. -- ========================================================= Tres Seaver tseaver(a)palladion.com 713-523-6582 Palladion Software http://www.palladion.com

1 0

Re: [Zope] Seeking a customisable 'portal' app
by J C Lawrence 19 Jan '00

19 Jan '00

On Wed, 19 Jan 2000 13:54:52 -0600 Eric W Sink <eric(a)sourcegear.com> wrote: > I admit that I am being deliberately obtuse here: > For me, "the standard fashion" is visiting: > http://www.zope.org/Resources/MailingLists > where I see no mention of the zope-ptk list. http://www.zope.org/Products/PTK http://www.zope.org/Products/PTK/index.html http://lists.zope.org/mailman/listinfo/zope-ptk -- J C Lawrence Home: claw(a)kanga.nu ----------(*) Other: coder(a)kanga.nu --=| A man is as sane as he is dangerous to his environment |=--

1 0