- Zope - Zope lists

unlinking stale socket?
by michael nt milne 22 Nov '05

22 Nov '05

Hi My zopeinstance went down and I was getting an 'upstream server' unknown message from apache. On restarting zope from ./zopectl this was the message I got..... unlinking stale socket /home/zopeinstance/var/zopectl/sock,sleep/ No handlers could be found for logger 'root' Does anyone have any idea on how to prevent this at all, or what happened here? Thanks Michael

2 4

convert DTML Document to a folder.
by Martin Koekenberg 22 Nov '05

22 Nov '05

Hello, Is it possible to convert a DTML Document to a folder, Both with properties ? I use Zope 2.8.4. Regards, Martin Koekenberg

5 6

dtml-sqlvar problem with large strings?
by Joshua Burvill 22 Nov '05

22 Nov '05

Hello All, I am uploading and encoding files and then trying to insert the file content into a database. It works fine for small files (under about 20KB), but fails for larger ones with the error: Error Type: ProgrammingError Error Value: (-104, 'execute.isc_dsql_prepare: Dynamic SQL Error. SQL error code = -104. Unexpected end of command. ') See below for traceback etc. Using zope 2.6.4 on win32 with kinterbasdbda (not sure what version), firebird 1.0 It sounds like the sql command is getting trucated or something with the larger strings. Can anybody offer suggestions? Many Thanks, Josh ##################################### I have a form to upload a file: <dtml-var standard_html_header> <form method="post" action="upload_process" enctype="multipart/form-data"> <input type="file" name="quote_file"> <input type=hidden name=shipment_id value=&dtml-shipment_id;> <input type="submit"> <dtml-var standard_html_footer> A script to process the file: from Products.PythonScripts.standard import html_quote request = container.REQUEST RESPONSE = request.RESPONSE fil = request.quote_file data = fil.read() ct = fil.headers['Content-Type'] encdata = context.encode(data) print ct print len(data) context.insert(quote_file_data=encdata, quote_content_type=ct, shipment_id=request.shipment_id) return printed A zsql method: insert into quote_files (quote_file_data, quote_content_type, shipment_id) values (<dtml-sqlvar quote_file_data type=string>, <dtml-sqlvar quote_content_type type=string>, <dtml-sqlvar shipment_id type=int> ) External methods (encode_decode.py) for encoding and decoding the possibly binary file contents: def encode(bindata): from base64 import encodestring return encodestring(bindata) def decode(strdata): from base64 import decodestring return decodestring(strdata) My database table: CREATE TABLE QUOTE_FILES ( QUOTE_FILE_ID INTEGER NOT NULL, QUOTE_CONTENT_TYPE VARCHAR(50) CHARACTER SET NONE, SHIPMENT_ID INTEGER, FILENAME VARCHAR(500) CHARACTER SET NONE, QUOTE_FILE_DATA BLOB SUB_TYPE 3 SEGMENT SIZE 1 ); Exception traceback Time 2005/11/21 16:01:45.513 GMT+11 User Name (User Id) josh (josh) Request URL http://mrisydney:8080/Bigbird/shipments/admin3/quotes/upload_process Exception Type ProgrammingError Exception Value (-104, 'execute.isc_dsql_prepare: Dynamic SQL Error. SQL error code = -104. Unexpected end of command. ') Traceback (innermost last): . Module ZPublisher.Publish, line 98, in publish . Module ZPublisher.mapply, line 88, in mapply . Module ZPublisher.Publish, line 39, in call_object . Module Shared.DC.Scripts.Bindings, line 306, in __call__ . Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec . Module Products.PythonScripts.PythonScript, line 307, in _exec . Module None, line 16, in upload_process <PythonScript at /Bigbird/shipments/admin3/quotes/upload_process> Line 16 . Module Shared.DC.ZRDB.DA, line 428, in __call__ . Module Products.kinterbasdbDA.db, line 198, in query . Module Products.kinterbasdbDA.kinterbasdb, line 585, in execute ProgrammingError: (-104, 'execute.isc_dsql_prepare: Dynamic SQL Error. SQL error code = -104. Unexpected end of command. ') Display traceback as text REQUEST form quote_file <ZPublisher.HTTPRequest.FileUpload instance at 04B2FD6C> shipment_id '13096' cookies lazy items SESSION <bound method SessionDataManager.getSessionData of <SessionDataManager instance at 023D1718>> other AUTHENTICATION_PATH 'Bigbird' traverse_subpath [] SERVER_URL 'http://mrisydney:8080' shipment_id '13096' PUBLISHED <PythonScript at /Bigbird/shipments/admin3/quotes/upload_process> URL 'http://mrisydney:8080/Bigbird/shipments/admin3/quotes/upload_process' AUTHENTICATED_USER josh TraversalRequestNameStack [] quote_file <ZPublisher.HTTPRequest.FileUpload instance at 04B2FD6C> URL0 http://mrisydney:8080/Bigbird/shipments/admin3/quotes/upload_process URL1 http://mrisydney:8080/Bigbird/shipments/admin3/quotes URL2 http://mrisydney:8080/Bigbird/shipments/admin3 URL3 http://mrisydney:8080/Bigbird/shipments URL4 http://mrisydney:8080/Bigbird URL5 http://mrisydney:8080 BASE0 http://mrisydney:8080 BASE1 http://mrisydney:8080 BASE2 http://mrisydney:8080/Bigbird BASE3 http://mrisydney:8080/Bigbird/shipments BASE4 http://mrisydney:8080/Bigbird/shipments/admin3 BASE5 http://mrisydney:8080/Bigbird/shipments/admin3/quotes BASE6 http://mrisydney:8080/Bigbird/shipments/admin3/quotes/upload_process environ HTTP_ACCEPT_ENCODING 'gzip, deflate' CONTENT_TYPE 'multipart/form-data; boundary=---------------------------7d5bb2a201dc' PATH_TRANSLATED '\\Bigbird\\shipments\\admin3\\quotes\\upload_process' HTTP_ACCEPT 'image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*' GATEWAY_INTERFACE 'CGI/1.1' HTTP_ACCEPT_LANGUAGE 'en-au' REMOTE_ADDR '192.168.2.37' SERVER_PORT '8080' HTTP_USER_AGENT 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)' CONTENT_LENGTH '72706' channel.creation_time 1132549273 SERVER_PROTOCOL 'HTTP/1.1' PATH_INFO '/Bigbird/shipments/admin3/quotes/upload_process' HTTP_HOST 'mrisydney:8080' REQUEST_METHOD 'POST' SCRIPT_NAME '' SERVER_SOFTWARE 'Zope/(Zope 2.6.4 (binary release, python 2.1, win32-x86), python 2.1.3, win32) ZServer/1.1b1' HTTP_CACHE_CONTROL 'no-cache' CONNECTION_TYPE 'Keep-Alive' HTTP_REFERER 'http://mrisydney:8080/Bigbird/shipments/admin3/quotes/upload_form?shipment_ id=13096' SERVER_NAME 'mrisydney.sydney.mri.com.au'

2 3

Check Interval
by Kozloski, Matthew E 22 Nov '05

22 Nov '05

I have a fairly large zope installation (thousands of users, ~130G combined zeo storages) and have been playing with the check interval. I have a single Xeon 3.2 that runs the show (both ZEO and Zope). I notice that when I set the check-interval at 826 (pystone / 50) the performance is horrible. In my case the lower I set the check interval, the faster the site is (quite significantly). Its not a problem - I'm just curious as to why this is/may be. From reading docs/postings online, it seems to me that the higher the check interval is, the faster the site should be (up to a point -- law of diminishing returns sort of thing). It is completely opposite for me and inquiring minds want to know... Thanks - Matt ________________________________ Matthew E. Kozloski Systems Administrator Specialized Technology Resources, Inc. 10 Water ST Enfield, CT 06082 USA t: 860-749-8371 f: 860-749-8234 e: matthew.kozloski -at- strus.com

4 3

<EMBED ...> problem
by David De Maeyer 21 Nov '05

21 Nov '05

Hi all, Got a weird problem with Zope... One of our user reported the following issue (under Zope 2.6.0): One html page makes use of the <EMBED> tag to show and play a MPEG video using the Windows Media Player. When we tried to edit that page for a minor text revision and saved that page, Zope did throw a 'Dynamic tag "embed" not allowed.'... and the change made to the page was lost. We then decided to remove the <EMBED> tag, just did a cut, and proceeded with the text revision. It worked but as one could expect we couldn't get the <EMBED> tag pasted into the document without having Zope complaining about that tag. Therefore a simple question: how do we get Zope to properly deal with this <EMBED> tag again? Is it is a configuration problem? Any idea? Regards David De Maeyer ___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com

5 5

Re: [Zope] probably a simple answer..
by hpinson＠indepthl.com 21 Nov '05

21 Nov '05

I'm thinking Kate means that she is writing to an Excel file on a Zope/Windows server, acting as a simple database, perhaps via ODBC. Kate can you clarify what you are trying to do? Thanks. -- Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Phone: 505 994-2135 Fax: 505 994-3603

5 6

does anyone know of something like this
by Kate Legere 21 Nov '05

21 Nov '05

I develop for a library and wanted to know if there was a zope product that might accomplish what we're looking for before we build it ourselves. We have a number of book club sets that are loaned out to patrons for a 6 week period. The way in which this differs from our regular collection is that patrons can reserve a set by date rather than just joining a waiting list. Right now the way it works is almost beyond belief in it's complexity and archaic-ness. As I say, we can build an application that will handle this but it seems like it might be a common enough situation that if there was already something out there that we could just modify we might be better off doing that. Kate

2 1

Render a string as tal
by Mark Gibson 21 Nov '05

21 Nov '05

I would like to be able to render an arbitrary string as tal, having the tal statements evaluated correctly. How would I go about doing this? -- Mark Gibson <mark(a)dimensional.com>

5 10

Re: ZopeTestCase.Functional and sessions?
by Stefan H. Holek 21 Nov '05

21 Nov '05

Well, yes. As you have already discovered, publish() creates it's own REQUEST (also see ZPublisher.Test). All you have after a call to publish() is the response object. Note that you *can* check ZODB- based variables after publish(). However the REQUEST is not stored in the ZODB... Which begs the question why you need publish() in the first place. It is only useful if you want to test the Publisher, i.e. the status code, or some returned headers and cookies. Everything else can be tested directly. How to put a session object into self.app.REQUEST is demonstrated in the testShoppingCart.py example test. Stefan On 21. Nov 2005, at 03:46, Paul Winkler wrote: > Yes, everything is fine unless you attempt to access the session > from the test code. So I can't see any way to e.g. assert that after > publishing a page, a certain variable is set in the session. > For example, I wish I could rewrite your test like so: > > def testUseSessions(self): > response = self.publish(self.folder_path+'/use_session') > self.assertEqual(response.getStatus(), 200) > self.assertEqual(self.app.REQUEST.SESSION.get('foo', 'xxx'), > 'bar') > -- Anything that happens, happens. --Douglas Adams

1 0

minimizing conflict errors
by Dennis Allison 20 Nov '05

20 Nov '05

I have a DTML method which provides the primary navigation control in a portion of our system and so is very heavily used. It is a primary source of conflict errors and so is being rethought. Zope 2.8.4, ZEO 3.4.2, ZODB 3.4.2, Python 2.4.2 or 2.3.5 MySQL 4.0.20, MySQL-Python 1.2.0, MYSQLDA 2.0.9 ZODB 3.4.2 does not raise a conflict error on a read-read conflict, one of the reasons fr moving to Zope 2.8.4. The structure of the naviagation method is simple enough. Everything is wrapped in a <dtml-let> which sets a number of parameters mostly by reading them from the SESSION (with an interface function) or plucking them from the relational database with a query. In the scope of the let is dtml code which, when rendered, provides the various navigation links. In various sections there are additional <dtml-let> blocks and additional queries to the relational database and several <dtml-in> loops. Looking at the code, I don't understand why I am seeing conflicts. As I understand things, neither variables in the <dtml-let> space nor the REQUEST/RESPONSE space are stored in the ZODB so modifications to them don't look like writes to the conflict mechanism. Am I incorrect in my understanding?

3 2