- Zope - Zope lists

ZOracle LOB Questions
by Alexander Schad 31 Jul '00

31 Jul '00

Hello! i have Oracle 8.1.6 ZOracleDA 2.2 installed with Zope 2.1.6 on a red hat linux machine. i have an oracle table with one column containing blobs. Now i have the following problems: 1. How can i retrieve data from that table in zope or in python (syntax) ? 2. How can i insert data to that table ? i need the zope syntax something like: insert into blob_table values ('<dtml-var image>') ??? or the python syntax i have written a little script: import DCOracle, sys, os, DCOracle.dbi dbc = DCOracle.Connect('mozdb_dba/mozdb_dba') cur = dbc.cursor() fn = open('test_img.jpg','rb') data = fn.read() fn.close() param = DCOracle.dbi.dbiRaw(data) cur.execute('select blobcol from blobtable') dat = cur.fetchone() cur.close() dbc.close() print dat when i try to execute it i get the following error: Traceback (innermost last): File "blobtest.py", line 12, in ? dat = cur.fetchone() File "DCOracle/ociCurs.py", line 339, in fetchone self._error() File "DCOracle/ociCurs.py", line 109, in _error raise error, (rc, oci_.OracleErrorMessage(self._c.lda, rc)) oci.error: (24813, 'ORA-24813: cannot send or receive an unsupported LOB\012') 3. Is there a way to call a stored procedure or function that actually return values ? i succeeded in retrieving one particular value out of a table but when i try a function like : select * from some_table i fail... 4. Changes.txt: Z Oracle DA Releases 2.2.0 Added a small feature that allows you to access LOBs in the Oracle database. To do this, you must have your maximum number of results set to '1'. Otherwise, it won't work. i don't know what this is referring to. where should i make this change? Ciao, Alex -------------------------------------------------------------------------- Alexander G. Schad (Programmer) beehive elektronische medien gmbh -------------------------------------------------------------------------- mailto:ags@beehive.de mailto:service@beehive.de http://www.beehive.de fon: (+49 30) 84 78 20 fax: (+49 30) 84 78 22 99

2 2

Trouble installing on Solaris
by Paul Smith 31 Jul '00

31 Jul '00

Hi After playing with Zope on NT for a while, I decided it was time to try it on Solaris. I have duly downloaded the file, followed the installation instructions for the precompiled binary version, but when I run ./install I get get the following error: ------------------------------------------------------------------------------ Compiling python modules ld.so.1: /work3/cultivate-eu/Zope-2.1.6-solaris-2.6-sparc/bin/python: fatal: relocation error: file /work3/cultivate-eu/Zope-2.1.6-solaris-2.6-sparc/bin/python: symbol fseeko: referenced symbol not found Killed I can't find any references to this error anywhere. Can anyone help out here? Thanks Paul ------------------------------------------------------------- Paul Smith : paul.smith(a)bristol.ac.uk http://www.ilrt.bris.ac.uk/ Institute for Learning and Research Technology University of Bristol, BS8 1HH, UK Tel: 0117 928 7192 Fax: 0117 928 7112

1 0

Re: [Zope] Python/Zope API
by Kapil Thangavelu 31 Jul '00

31 Jul '00

"Alexandre A. Rodioukov" wrote: > > Kapil Thangavelu <kvthan(a)wm.edu> writes: > > > > 2. Are there ways to improve it? For example I would love to know how > > > you can check if you can actually render an object. (For example > > > you can not render Control_Panel). > > > > To render your python product objects in Zope like > > <dtml-var yourObject> > > you just define a method __str__ > > I probably wasn't clear enough describing the issue :) I don't want to > render Product, i want to make Zope to render some object from ZODB > from python... i.e. to obtain rendered HTML code of some dtml > document/method from external python method for filtering/doing some > magic :) purposes. Yikes, its __call__ that gets rendered not __str__. About your question... you still want to call __call__ :) ala dtml_code_to_be_rendered() from within python. if you're accessing any other zope elements that are not native to it(likely) you will need to pass in the proper namespace and methods. Something along the lines dtcbr(client, namespace, request, response, *). you can safely leave most of these blank. the keys ones in this context are probably namespace and client. i played around with this and got rendering simple pages but nothing with other zope objects. take a look at the source for more inspiration. Zope/lib/python/OFS/DTMLDocument.py and HTML class. Hope that helps Kapil

1 0

Limiting folder space
by Brendon Grunewald 31 Jul '00

31 Jul '00

I want to use Zope to offer registered visitors to my site a little free webspace on the site. Since I use hosting service that restricts and charges me for space, I would like to restrict the size that their zope folders can consume. Hence: Is there any simple way of limiting the amount of space that a folder is allowed to consume including its subfolders? Alternatively, is there anyway of checking how much space a folder with subfolders consumes? Regards, Brendon ------------------ 70South: the No.1 source for Antarcticles. For the latest news and views on Antarctica visit : http://www.70south.com

6 6

ANN: ZUBB 0.5.0 Release (Now works with Zope 2.2)
by J. Atwood 31 Jul '00

31 Jul '00

After further testing I have a work around for 2.2 users. See the install doc for more information. I have uploaded the update to ZUBB. Both the changes and readme are linked below. There are a few major presentation and feature changes. http://www.zope.org/Members/BwanaZulia/ZUBB/ http://www.zope.org/Members/BwanaZulia/ZUBB/README http://www.zope.org/Members/BwanaZulia/ZUBB/CHANGES http://www.zope.org/Members/BwanaZulia/ZUBB/INSTALL As always the sample / test / development board is http://www.bwanazulia.com/kenya/discussions/test/ I have about 6 of these boards in production environments and things seem to be pretty stable as I work to squash bugs. My major concern for now is to see how many posts it can handle before I have to move to something like the SQL based version (which is still in the basic planning stages and will be a whole new game). So far I have been able to push it up to about 500 posts. If you are using it and have pushed it farther let me know. Suggestions, comments are welcome. J

1 0

Starting Zope
by Costagliola Giovanni 31 Jul '00

31 Jul '00

Hello All, How can I to start Zope whit a different user than root and cath the default HTTP port? If I try for example: su - -c './start -w 80 -u zope' I receive an error becouse root hasn't granted the need privileges on /Zope/var/ directory. Thanx -- >////////< / * * / / < / __________oOOo______/______/_____oOOo________ (°> Giovanni Costagliola (jancos) //\ email: jancos(a)technologist.com V_/_ voice: +39 (0)347 1174139 _____________________________________________ / / / / ( ( ______ \ \ / /#####*** * * * \ \/ /####*** * * \ /###*** * * * \ /##*** * * \_______/#*** * * *

4 4

Log Out
by Kapil Thangavelu 31 Jul '00

31 Jul '00

Is there a way to log out of Zope without presenting a netscape dialog or killing the browser? i'd prefer that users have a link 'logout' that takes them back to the /root/index_html as anonymous

2 1

FSSession - don't call FSSession twice!
by icottee＠bluefountain.com 31 Jul '00

31 Jul '00

I've been using the excellent FSSession product (many thanks Mr Christoforou) to hold some information on the language a user wishes to display a page in. I kept having weird errors however - every now and again I'd change some code somewhere completely unrelated (even just adding a user) and FSSession would break. Undoing the last change wouldn't help. The error was to do with _v_data and (I think) _v_id or something similar. This post isn't about that problem. >From reading through the extremely useful nipltd archives it appeared the problem was not doing a <dtml-call FSSession> at the beginning of the code. This was bemusing because that code was sitting in my standard header and called everywhere. However, I had an uneasy workaround which did a 'try' on using FSSession and if it failed initialise it in the normal way. I say 'uneasy' because I didn't know why I needed it and when I added another bit of code to handle another cookie that needed to be recorded it broke again. This post isn't about that problem either. I decided enough was enough today and thought I'd try and find out what was happening. So I could give some proper information to Pavlos Christoforou I downloaded the latest version of FSSession and tried to reproduce my error. Bang - I got a much more impressive error. Whenever I went to any of my pages that used FSSession I got the following. Zope has encountered an error while publishing this resource. Error Type: OSError Error Value: [Errno 2] No such file or directory Followed by the following traceback Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 175, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 235, in commit File /usr/local/zope/lib/python/ZODB/Transaction.py, line 296, in commit File /usr/local/zope/lib/python/Shared/DC/ZRDB/TM.py, line 122, in tpc_finish (Object: TM) File /usr/local/zope/lib/python/Products/FSSession/FSSession.py, line 84, in _finish (Object: TM) File /usr/local/zope/lib/python/Products/FSSession/FSSession.py, line 193, in final_commit (Object: FSSession) OSError: (see above) Interestingly the line above 193 in FSSession.py is a comment which reads 'should never fail'. Well it does and the reason is (as you may have guessed from the title) that I called FSSession twice. Line 193 appears to rename a .tmp file and I'd guess that by calling it twice my second attempt fails as the file has already been renamed. Obviously this isn't the way I should be doing things and I'm going to have a go and see if the new version of FSSession cures my earlier problems. The reason I mention this now is that the problem causes any future attempts at transactions to give the following error - which can only be remedied by restarting zope. Error Type: TransactionError Error Value: A serious error, which was probably a system error, occurred in a previous database transaction. This application may be in an invalid state and must be restarted before database updates can be allowed. Beware though that if the error was due to a serious system problem, such as a disk full condition, then the application may not come up until you deal with the system problem. See your application log for information on the error that lead to this problem. So if you make the same mistake as I did on a production server you will not be popular :-). I'm running this on Zope 2.2.0 by the way (although it happens on the previous production version as well). Hope this is of some use Ian

3 2

Re: [Zope] Starting Zope
by Cary O'Brien 31 Jul '00

31 Jul '00

Bill wrote... > > Of course, it is entirely possible the user meant something other than s/he wrote. ;) But > that last one doesn't seem to indicate that. > > To put it succinctly: > If you want Zope to bind to port 80 on *nix > you have few options: > > o Change Zope to run SID ** Bad Idea > o Modify the kernel so _anyone_ > can bind to ports under 1024 ** even worse > o START Zope as root, run it as a > non-priviledged user, preferably one without > a login. > You could also run zope behind Apache. The Apache bits that handle root permissions seem pretty well accepted. This doesn't really run Zope listening to port 80, but if you go to port 80 on the machine running Apache, you get to zope. One advantage is that you can bounce Zope all day long without even touching root. Plus depending on your setup you can have Apache running on a separate machine. This can be better depending on the situation (i.e. development machines behind a firewall with private addresses. The downside is that you need to become aquainted with the wonderful worlds of mod-rewrite and site-access[1]. Plus you may take a performance hit. -- cary [1] Can someone explain (or point me to the reason) why the <base> tag is necessary? It sure can make life difficult! > File permissions are irrelevenat when binding to ports under 1024 on Unix. > > > > > -- > Do not meddle in the affairs of sysadmins, for they are easy to annoy, > and have the root password. > > --__--__-- >

1 0

Zope/Apache/ProxyPass
by Joshua Brauer 31 Jul '00

31 Jul '00

I'm having trouble getting Zope and Proxy Pass to work the way I expect.... Specifically if you look at this site: http://www.bmb.colostate.edu:8111/ it's really supposed to proxypass to webdev.bmb.colostate.edu, but the ProxyPassReverse directive doesn't seem to clean/modify/correct the base tag in the header as I understand it should.... Here's the proxypass section of my httpd.conf for apache: ProxyRequests on NoCache * ProxyPass / http://webdev.bmb.colostate.edu/ ProxyPassReverse / http://webdev.bmb.colostate.edu/ ProxyPass /misc_ http://webdev.bmb.colostate.edu/misc_ ProxyPass /p_ http://webdev.bmb.colostate.edu/p_ And in the past I've tried it as: ProxyRequests on NoCache * ProxyPass /Zope/ http://webdev.bmb.colostate.edu/ ProxyPassReverse /Zope/ http://webdev.bmb.colostate.edu/ ProxyPass /misc_ http://webdev.bmb.colostate.edu/misc_ ProxyPass /p_ http://webdev.bmb.colostate.edu/p_ Ideas? Thanks, Josh -- ------------------------------------------------- Joshua Brauer Computer Support Scientist Department of Biochemistry and Molecular Biology Colorado State University Fort Collins, CO 80523 (970) 491-1080/pager: (970) 498-7995, #5837 -------------------------------------------------

3 2