- Zope - Zope lists

Re: [Zope] unlinking stale socket?
by michael nt milne 22 Nov '05

22 Nov '05

Yes, so something must have killed the server and shut it down leading to the stale socket message. However I guess without further checking through the server logs I won't find out exactly why etc. On 11/22/05, J Cameron Cooper <jccooper(a)enfoldsystems.com> wrote: > > michael nt milne wrote: > > Ok, but Zope and Apache were serving nothing until I re-started Zope. > > The server had died for some reason > > Indeed. And that's what it tells you with the "unlinking stale socket": > it was not shut down in an orderly manner previously. > > But that message says nothing about why. > > --jcc > > > On 11/22/05, *Chris McDonough* <chrism(a)plope.com > > <mailto:chrism@plope.com>> wrote: > > > > I think it probably was running after the first time you invoked it. > > The message is only informative, meaning that zopectl died unexpectly > > the last time it was run (without cleaning up after itself). It's > > not a fatal error or at least hasn't been whenever I've seen it. > > > > On Nov 22, 2005, at 10:57 AM, michael nt milne wrote: > > > > > Yes, I noticed that the deamon wasn't running and so re-started it. > > > It started up fine but that was the message I received. Just > > > wondered what happened etc.. > > > > > > On 11/22/05, Chris McDonough <chrism(a)plope.com > > <mailto:chrism@plope.com>> wrote: Note that > > > Zope likely started. Did it? Did you try zopectl stop and > > > zopectl start again? If so, did it work? > > > > > > - C > > > > > > On Nov 22, 2005, at 9:52 AM, michael nt milne wrote: > > > > > > > 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 > > > -- > "Building Websites with Plone" > http://plonebook.packtpub.com/ > > Enfold Systems, LLC > http://www.enfoldsystems.com >

1 0

Proxy setting for Zope and Products
by Renfer Serge (EDU) 22 Nov '05

22 Nov '05

Hello all, I'm responsible of a server (Debian Sarge) which has been put behind a firewall! I am strugling with proxy problems. For instance, CMFSin doesn't seem to work (for syndication slots in Plone), and LDAPUserFolder cannot reach an external ldap server. On the system itself, I have set the http_proxy environment variable (in .bashrc), it works fine for apt-get, for example, but it seems it has no effect on Zope! Do you have any idea if there is a way to inform directly Zope and all its products about a proxy in a simple way, or only products that are proxy-aware can be set to work in such an environment? Thanks in advance! serge

2 1

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