April 2006 - Zope - Zope lists

Atomic ZSQL on Zope 2.7.5
by Maslak, Michael 27 Apr '06

27 Apr '06

For some reason I thought ZSQL method calls were atomic, but they appear otherwise. Using an eGenix mxODBC Database Connection at /Database/PoPy_database_connection to a SQL Server 2000 back end, I have created a Python script to write SQL commands and feed them in one large string: UPDATE equip SET workstation=1 WHERE eq_id=39315; UPDATE node SET node='M28057' WHERE node_id=13451; UPDATE materiel SET mat_nm='mm-M28057-H-01', owner='mmaslak', datetime='2006/04/24 15:09:07.611 GMT-5' WHERE mat_id=39315; This all gets sent as one string to a ZSQL method where the first two commands execute, but the third fails because it doesn't like the datetime string, which indeed fails when I try it alone in the PoPy connection. Why, oh why doesn't the whole thing fail like I might expect? When I wrap the call in a 'begin transaction ... commit', it becomes atomic. Nothing happens if part of it fails. Great. But failure is not detectable by the Python script. I have used try/except and if/else blocks to ascertain failure. It thinks a non-commit is AOK, not an exception. Is this function of the eGenix ODBC? Of MS SQL Server 2K? Zope/ZSQL/Python? How can I detect failure and maintain atomicity? Michael Maslak, Jr. Associate Software Engineer Anteon Corporation 294 Thames Ave Bay St. Louis, MS 39520

7 8

data.fs packing
by George 27 Apr '06

27 Apr '06

How much free space is required for a succesfull data.fs packing? My data.fsfile size is 2,6 giga.

2 1

Process uploaded text file.
by Jason C. Leach 26 Apr '06

26 Apr '06

Hi, Does anyone have an example (URL is fine) on how to processes a text file via a Python script that has been uploaded from a web form? Thanks, Jason. -- ........................................ .... Jason C. Leach .... PGP Key: 0x62DDDF75 .... Keyserver: gpg.mit.edu

2 1

zope.conf question
by David Pratt 26 Apr '06

26 Apr '06

Hi. Is there a way to create an INSTANCE_HOME variable in zope.conf more dynamically than hardcoding the path. I want an app to be platform portable so this will be different? Alternatively, I have been considering overriding zope.conf settings for use in zope.app.twisted.main and an interested in any suggestion for best approach to this. In z3 services are started with: service = setup(load_options(args)) args are a list ['-C', '/path/to/my/instance/etc/zope.conf'] In load_options, the default zope.conf.in is looked for else it gives it a value of None then options are utilized with options.realize(args) Regards, David

2 3

zope unresponsive
by Andy Altepeter 25 Apr '06

25 Apr '06

Hey All, I'm experiencing hanging issues with my Zope-2.8.6+zeo setup/ RHEL 4. The hanging isn't categorized by 100% cpu usage. Actually, I had the same issues using 2.8.5, but I've upgraded since then. Here's the situation: I have one zeo client connected to a zeo server on the same box. Apache sits in front, using RewriteRules to request data from zope. After some time (could be 2 minutes or an hour), the zeo client stops responding. Apparently this is called a deadlock or a "spinning zope". I've tried using gdb to attach to the zeo client pid, and use the recipe http://zopelabs.com/cookbook/1073504990 to print a traceback, but the call always aborted with SIGABORT. I've captured all of the requests sent to zope during an uptime window (via Z2.log), and using wget to "replay" the requests. I've also pulled from apache's rewrite log all requests proxied to zope, thinking the Z2.log only writes finished requests. I setup another zeo client (on the same box, different port) and used wget to replay these captures as well. Just running these captures does not cause zope to hang. In fact, I have not been able to cause zope to hang by replaying. There doesn't seem to be any one url or sequence of urls that cause zope to hang. I've tried reinstalling the zope instance, but that didn't help. I've tried using requestprofiler.py to inspect the trace.log. This shows a high number of "hangs", but not on a url that actually triggers a spinning zope. Basically, that's where I'm stuck. Is there anything else I can try? Am I missing something? Thanks for the help, Andy

4 3

keeping files in the local filesystem
by gf 25 Apr '06

25 Apr '06

Hi, I am a Zope newbie and would appreciate some counsel from experienced Zope users. I have come across several products (e.g. ExternalFile) for keeping files in the local filesystem. I was wondering about the wisdom of keeping objects, such as images, dtml documents, and page templates, in the local filesystem. On the face of it, it seems like a good idea since tools like version control/management and backup software could manage the files directly. What do you see as the upsides and downsides? Thank you for your input. Best Regards, gyro

2 2

Zope crashes on request of certain page
by Sven Jacobs 25 Apr '06

25 Apr '06

Dear Zope list, I have a serious problem with Zope. Every time a certain page is requested by a web browser for the second or third time (first time always works) the whole Zope server crashes :-( The only thing special about this page are calls of external Python methods from a custom extension. These methods don't do any special magic. They just open a MySQL database (using the MySQLdb module version 0.9.1) and return some HTML output. I was able to catch a somewhat informative error message when Zope was running in debug mode: 2006-03-27T12:18:57 PANIC(300) z2 Startup exception Traceback (innermost last): File /opt/zope/z2.py, line 495, in ? (Object: ZLogger) File <string>, line 1, in ? File /opt/zope/lib/python/Zope/__init__.py, line 37, in ? File /opt/zope/lib/python/ZODB/FileStorage.py, line 202, in __init__ File /opt/zope/lib/python/ZODB/lock_file.py, line 29, in lock_file StorageSystemError: Could not lock the database file. There must be another process that has opened the file. Operating system is SuSE Linux 8.0, Zope version is 2.5.0, Python 2.2, MySQL 3.23.48. I know, pretty old but upgrading any of these software components should be avoided due to emerging costs unless absolutely necessary! So if you have any idea how to fix this problem besides "upgrade to the newest versions" I would be glad to here from you! Thank you very much! -- Sincerely yours Sven Jacobs

7 12

ordinal not in range error in StringIO.py
by Roman Susi 25 Apr '06

25 Apr '06

hi! My code produces the following traceback File "/opt/Zope-2.9.1/lib/python/ZPublisher/Publish.py", line 40, in call_object result=apply(object,args) # Type s<cr> to step into published object. File "/var/zope-2.9/Products/Five/browser/metaconfigure.py", line 403, in __call__ return self.index(self, *args, **kw) File "/opt/Zope-2.9.1/lib/python/Shared/DC/Scripts/Bindings.py", line 311, in __call__ return self._bindAndExec(args, kw, None) File "/opt/Zope-2.9.1/lib/python/Shared/DC/Scripts/Bindings.py", line 348, in _bindAndExec return self._exec(bound_data, args, kw) File "/opt/Zope-2.9.1/lib/python/Products/PageTemplates/PageTemplateFile.py", line 110, in _exec return self.pt_render(extra_context=bound_names) File "/opt/Zope-2.9.1/lib/python/Products/PageTemplates/PageTemplate.py", line 105, in pt_render return output.getvalue() File "/opt/lib/python2.4/StringIO.py", line 272, in getvalue self.buf += ''.join(self.buflist) UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 8: ordinal not in range(128) when frontpage is published. I have analysed self.buflist and it seems that unicode strings are mixed with usual strings. Unicode strings come from .mo file. So, the question is why ZPublisher doesnt coerce different string before serving and what can I do in this situation? .po file has utf8 encoding. Publisher encoding is utf8. Quick and very dirty solution is to mend StringIO.py... Does anybody has better cure? Thanks! Regards, Roman Suzi

2 1

submission
by Khachatur Yengibaryan 25 Apr '06

25 Apr '06

zope-request(a)zope.org wrote: >Send Zope mailing list submissions to > zope(a)zope.org > >To subscribe or unsubscribe via the World Wide Web, visit > http://mail.zope.org/mailman/listinfo/zope >or, via email, send a message with subject or body 'help' to > zope-request(a)zope.org > >You can reach the person managing the list at > zope-owner(a)zope.org > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of Zope digest..." > > >Today's Topics: > > 1. Re: Permissions, files and folders (Paul Winkler) > 2. Re: REQUEST.form variables order (Gaute Amundsen) > 3. Rendering Product by index_html (Thomas Adams) > 4. Re: Rendering Product by index_html (Andreas Jung) > 5. zope-2.8.4 and ZopeXMLMethods (Milos Negovanovic) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Fri, 21 Apr 2006 12:45:43 -0400 >From: Paul Winkler <pw_lists(a)slinkp.com> >Subject: Re: [Zope] Permissions, files and folders >To: zope(a)zope.org >Message-ID: <20060421164543.GB9625(a)slinkp.com> >Content-Type: text/plain; charset=us-ascii > >On Fri, Apr 21, 2006 at 09:54:15AM +0200, Erik Billing wrote: > > >>Btw, what editor would you recommend for writing python outside Zope. I've >>frequently used Eclipse with PyDev before, but it's a bit slow and heavy. >>I've looked around a bit on the free editors without finding anything I like >>so I'm thinking it might be worth trying a commercial editor. What do you >>guys use? >> >> > >Emacs :-) >It takes a bit of work to get it set up nicely, but there are some >really nice features like good pdb integration. > >e.g. try this: put a "pdb.set_trace()" somewhere in your code, and >then run the program from a shell within emacs - e.g. you can start a >shell by typing "M-x shell", and then type the command to run your >program. When you enter pdb, you can step around >the code and emacs shows you where you are in another buffer, opening >modules as you step into them. I've said it before: All hail Ken Manheimer! > >I'm sure plenty of IDEs can do stuff like that, but I'm surprised how >many emacs users don't seem to know it's there. > >(dunno if all that works on Windows, never tried.) > >The code-completion support is pretty rudimentary, though. It seems to >only be good for repeating symbols already in your source file. > >And no built-in browsing of documentation afaict. > > >

1 0

ftp server deadlocking zope
by Michael Kaplan 23 Apr '06

23 Apr '06

Hello, I have a problem with the Medusa FTP server deadlocking Zope completely. I'm using Zope 2.8.5-final, python 2.3.5, sunos5 with standard port settings and port-base 1500, e.g. ZServer.HTTPServer.zhttp_server (Port: 9580) ZServer.FTPServer.FTPServer (Port: 9521) I can connect to the ftp server > ftp localhost 9521 Connected to localhost. 220 FTP server (Medusa Async V24763 [experimental]) ready. Name (localhost:root): ******* 331 Password required. Password: ****** 230 Login successful. ftp> cd dir 250 CWD command successful. The standard ftp commands *cd*, *lcd*, *put* and *get* work fine. But if I try to use *ls*, *dir* or *mkdir* Zope seems to arrive in an infinite loop blocks one cpu completely and has to be restarted. Thanks in advance, Michael

2 1