May 2000 - Zope - Zope lists

Displaying MS Office documents within a Zope site
by Adam Ratcliffe 21 May '00

21 May '00

Hi This message was previously posted to Zope Dev - sorry ! I am using a Zope site to hold a collection of application support documents, these include a mixture of HTML pages and MS Word and Excel documents. The site uses a frameset to contain a DTML-Tree based navigation structure in the left frame, and displays pages in the right frame. When I attempt to open MS Office documents in the right frame they typically open fine the 1st time around, but if I move off the page and seek to revisit them I get a download dialog box rather than the page itself. I'm thinking this could be a caching issue. If anyone was able to help with some ideas how MS Office documents work with Zope it would be most appreciated. Best regards, Adam

2 1

DCOracle v1.3.1b blob insertion error
by Cheuk Cheng 21 May '00

21 May '00

I'm running DCOracle v1.3.1b with Oracle 8.1.6 (8iR2) on a W2k Server. I created a test table with only a primary key and a blob column. Then I tried to insert some test data into it with the code below: import DCOracle, sys, os, DCOracle.dbi dbc = DCOracle.Connect('user/pwd@dbname') cur = dbc.cursor() fn = open('test_img','rb') data = fn.read() fn.close() param = DCOracle.dbi.dbiRaw(data) cur.execute('insert into image_test (no, img) values(35, :p1)', param) dbc.commit() cur.close() dbc.close() The error occurs whenever 'test_img' is greater than 4000 bytes. Perhaps it has something to do with the Oracle VARCHAR2 size limit. If 'test_img' is larger than 4K, I get the following traceback: <DCOracle.dbi.dbiRaw instance at 887d60> Traceback (innermost last): File "DCOracle_test.py", line 14, in ? cur.execute('insert into image_test (no,img) values(35,:p1)',param) File "E:\site\lib\python\Products\DCOracle\ociCurs.py", line 299, in execute r = self._execute(params__, kw) File "E:\site\lib\python\Products\DCOracle\ociCurs.py", line 260, in _execute if rc!=3129: self._error() File "E:\site\lib\python\Products\DCOracle\ociCurs.py", line 109, in _error raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc)) oci.error: (3113, 'ORA-03113: end-of-file on communication channel\012') Did anyone have similar problem? Is it true that DCOracle treats all data (including blob) as string? The 4K limit seems to hint that DCOracle tries to insert my 'test_img' as varchar. Any comments? -CC __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

1 0

ZCatalog OR searching
by Chris Withers 21 May '00

21 May '00

Hi, I have a word and I was to return objects which contain this word in either one index or another (both textindexes). If I do, searchResults(index1='word',index2='word') I don't get what I want as it returns only objects that contain the word in BOTH indices. Is there any way I can get the results I want without resorting to two calls to searchResults and kludging them together? Or is this the correct way to do it? (I think this has the potential to use a LOT of memory if the results sets are large...) cheers, Chris

1 0

RE: [Zope] Memory creep
by Chris McDonough 21 May '00

21 May '00

John, If you can figure out how to use them, the pair of methods implemented on the Control_Panel named "manage_debug" and "manage_profile" might help you... e.g. http://yourserver/Control_Panel/manage_debug . I can't give much in the way of explanation of them, there might be some good archived mail messages on them. You should also probably consult (and add to) the HighlyAvailableZope wiki at http://www.zope.org/Members/tseaver/Projects/HighlyAvailableZope/FrontPa ge (especially "BleedingLikeAStuckPig" :-) > -----Original Message----- > From: John Hile [mailto:johnh1@provide.net] > Sent: Sunday, May 21, 2000 3:40 PM > To: zope-admin > Subject: RE: [Zope] Memory creep > > > Actually, after following several of the threads here, we're > looking into > switching from MySQL to PostgreSQL, but for the moment, I'd > like to figure > out who's holding on to that memory. > > > -----Original Message----- > > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On > Behalf Of Nils > > Kassube > > Sent: Sunday, May 21, 2000 8:05 AM > > To: John Hile; zope(a)zope.org > > Subject: Re: [Zope] Memory creep > > > > > > johnh(a)hilgraeve.com (John Hile) wrote: > > > > [MySQL database] > > > Having two people simultaneously access pages that DID access > > the database > > > without the client running on either machine DID cause > memory creep. > > > > Are you sure that you want to use MySQL for this? > > > > http://openacs.org/why-not-mysql.html > > > > Cheers, > > Nils > > > > > > > > _______________________________________________ > > Zope maillist - Zope(a)zope.org > > http://lists.zope.org/mailman/listinfo/zope > > ** No cross posts or HTML encoding! ** > > (Related lists - > > http://lists.zope.org/mailman/listinfo/zope-announce > > http://lists.zope.org/mailman/listinfo/zope-dev ) > > > > > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) >

1 0

Memory creep
by John Hile 21 May '00

21 May '00

We have been having the problem with memory usage creeping slowly upward that I've seen reported by several others in this list. I read several of the threads on this topic in the archives but, though there were a lot of theories floated, no firm conclusions seemed to be drawn. Like the others, memory usage as reported by 'free' on the '-/+ buffers/cache' line creeps steadily upward until the site crashes. Restarting Zope frees most of the memory. We're running RedHat Linux 6.1, on a dual- 550M processor box with 256Mb of memory, Zope 2.1.4 using Apache, mod-ssl and PCGI, ZMySqlDA 1.1.3. The ZODB holds only non-dynamic data, all user data is kept in the MySQL data base. I tried testing on our development server while no one else was accessing the site with the 'free' utility displaying memory use every 5 seconds in an attempt to find out what activity caused memory usage to creep upward without coming back down. To cut to the chase, I seem to have narrowed it down to access to the MySQL database from multiple threads. As it happens, we have a very thin client piece that can access the server through http outside the browser. Most use of the site is through a browser, but this small client checks with the server occasionally for scheduled tasks when the browser isn't up. In some cases, access through the browser will use a plug-in to trigger the client to check immediately rather than waiting for its infrequent poll interval. After an afternoon of testing, I discovered that, with no one else accessing the site, I could access pages as fast as I was able through the browser only (no client) or from the client only (sped up to poll every few seconds) with no memory creep. But when both were running at once (as they normally do), the memory usage would slowly creep up. Other details: Letting the client poll and query the MySQL database frequently while using the browser to access only pages that did NOT access the DB resulted in no creep. Having two people simultaneously access pages that DID access the database without the client running on either machine DID cause memory creep. Having two people access pages that did NOT access the database without the client running did NOT cause memory creep. Looks to me like there is a memory leak when ZMySQLDA is accessed from multiple threads. Anyone have any ideas on where I could go to pin this down further?

3 2

detect root.
by Sin Hang Kin 21 May '00

21 May '00

Hello, I ask about how to detect root in the list and Got three answer: <dtml-if "_.len(PARENTS) == 1"> We're at the root folder <dtml-else> You can go up from here </dtml-if> <dtml-if "title == 'Zope'"> Title is Zope <dtml-else> No title not zope </dtml-if> <dtml-if "id == ''"> root folder have not identity <dtml-else> there is id </dtml-if> However, all of them fail working in virtual web with siteroot set. How can I detect the root with or without siteroot? Rgs, Kent Sin --------------------------------- kentsin.weblogs.com kentsin.imeme.net

3 4

manage_addImage and Local FS
by Tom Scheidt 21 May '00

21 May '00

I want to use this: <dtml-call "manage_addImage(id=REQUEST['id'], file=REQUEST['file'])"> <dtml-call "RESPONSE.redirect( URL +'/success_html')"> but have the images placed into a folder in Apache. Can I send them directly? I have a local fs in the same folder as the above doc, should i send the images there, will the really end up in Apache? How can I do that? Thanks. Tom Scheidt | www.falsemirror.com | tom(a)falsemirror.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1 0

Re: [Zope] Zope Pgsql 7.0/SQL Schema HeLp!
by Richard Smith 21 May '00

21 May '00

Lindell Alderman wrote: > > > I have Zope all set, and I can run all your standard SELECT, INSERT, > > UPDATE stuff. > > But I have one hitch, I can't seem to figure out how to make it so an > > end user > > could add a name and email address without knowing about the PKEY > > number. This is no problem for a DBA but I want to make it easy for > > anyone to INSERT and UPDATE records. Did I make a bad design choice in > > use unique numbers to glue all the tables together. Is this an interface > > problem. Am I missing something. I need some help. Can someone point me > > in the right direction please? > > > > Richard > You can either use postgresql's serial type or create a sequence > and then use select nextval('sequence_name') and > select currval('sequence_name') to get and set the value of the key field. > > Check out the user's guide on www.postgresql for exact information > on this. > > -L I have the SERIAL type set up already. What is holding me up it that I need to make it possible to INSERT and UPDATE records base on the persons name and not the id number. somthing along the lines of this. INSERT INTO address (per_id,street,city,state,zip) VALUES ('SELECT per_id FROM person WHERE first = '<dtml-var first>' AND last = '<dtml-var last>'','<dtml-var street>','<dtml-var city> ...etc; I can't seem to figure out the SQL statment to use. I need to use a SELECT as a VALUE in an INSERT statment some how. can that be done, or should I use a View with an UPDATE and INSERT rule ? Richard

2 1

RE: [Zope] Calling External Method...
by Chris McDonough 21 May '00

21 May '00

> > DTML Method that calls the External Method: > <dtml-var standard_html_header> > <h2><dtml-var title_or_id></h2> > <dtml-let cmdLine="'./websim'"> > <dtml-var "ExecCGI(cmdLine)"> > </dtml-let> > <dtml-var standard_html_footer> Geez, this is a pretty bad idea security-wise. Your xCGI Python function has a docstring and is therefore web-callable, so basically you're letting anyone who can access your Zope instance run any program on your server by passing it in as the cmdLine, e.g. http://yourserver/ExecCGI?cmdLine=rm%20-rf%20*. I know that's not your problem right now, but you should reconsider this decision at some point. > /usr/local/Zope/lib/python/Products/ExternalMethod/ExternalMethod.py, > line 248, in __call__ > (Object: ExecCGI) > (Info: (('./websim',), {}, None)) > File /usr/local/Zope/Extensions/ExecCGI.py, line 11, in xCGI > TypeError: (see above) I *think* this error message is telling you that it can't format the status code as an integer in your raise statement. Why don't you take out your status checking code and see what happens.

2 1

Squishdot Interfaces Now Documented
by Chris Withers 21 May '00

21 May '00

The python interfaces that Squishdot provides, some of which are available in DTML, are now documented at: http://zope.nipltd.com/Squishdot/Squishterfaces I realised that this was a necessary step before trying to add the ZCatalog-based indexing that will be the main feature of Squishdot 0.4.0 and will enabel Squishdot to work wih Zope 2.2 as well as fixing some bugs. cheers, Chris

1 0