March 2009 - Zope - Zope lists

Touching an object / updating the modification time
by Jakob Schou Jensen 27 Mar '09

27 Mar '09

Is it possible to update the modification time of an object (in this case an Image object)? (I need to do this from a python script) Thanks, Jakob

3 2

Different file storage in Zope
by Olivier Nicole 26 Mar '09

26 Mar '09

Hi, I am pretty new to Zope. We need to install a site for our University department. On this site, we plan to store number of big files, like posters, student thesis, research papers, etc. I understand that ZODB is not the best storage for this sort of documents, but that we should rather use something like File System Storage for example. I just build a new Zope instance (buildout) and have Zope 2.10.6-final running along with Plone 3.2.1. What would the best external storage recommended? Looking at the Storage Products available for Zope (http://wiki.zope.org/zope2/StorageProducts) all products look pretty old to me, so I wonder if any is still supported, will continue to be supported in the future. Anyway, I tried to install File System Storage through buildout: buildout.cfg [buildout] parts = zope2 productdistros instance zopepy fss ... zope-instances = ${instance:location} storages = CSIM / directory /web/Plone3.2.1/FSS/storage /web/Plone3.2.1/FSS/backup This build OK, but I don't see where/how I can use FSS inside a test Plone site. It's like FSS is there, and built, but pretty inactive. So, how can I configure FSS, use it? ---- A side question, when I try to add most of the ATContentTypes objects in my test Plone site, ZMI always come to Add ATContentTypes: Portal Types Criterion. Is that a normal behaviour? TIA, Olivier

2 1

Regarding ZODB
by amol kumbhar 25 Mar '09

25 Mar '09

Hi! I am trying to execute following code *import ZODB from Persistence import Persistent class Employee(Persistent): def setName(self, name): self.name = name * but getting following error *Error Type: ImportError Error Value: import of "Persistent" from "Persistence" is unauthorized. You are not allowed to access 'Persistent' in this context* this is my full error log Time 2009/03/24 22:31:33.559 GMT+0530 User Name (User Id) admin (admin) Request URL http://localhost:9673/DeveloperGuide/Simpleinterface Exception Type ImportError Exception Value import of "Persistent" from "Persistence" is unauthorized. You are not allowed to access 'Persistent' in this context Traceback (innermost last): - Module ZPublisher.Publish, line 119, in publish - Module ZPublisher.mapply, line 88, in mapply - Module ZPublisher.Publish, line 42, in call_object - Module Shared.DC.Scripts.Bindings, line 313, in __call__ - Module Shared.DC.Scripts.Bindings, line 350, in _bindAndExec - Module Products.PythonScripts.PythonScript, line 327, in _exec - Module None, line 2, in Simpleinterface *<PythonScript at /DeveloperGuide/Simpleinterface>* *Line 2* - Module AccessControl.ZopeGuards, line 284, in guarded_import ImportError: import of "Persistent" from "Persistence" is unauthorized. You are not allowed to access 'Persistent' in this context Display traceback as text<http://localhost:9673/error_log/getLogEntryAsText?id=1237914093.560.3519022…> REQUEST form-C''cookiesdtpref_rows'20'dtpref_cols'90%'tree-s 'eJzT0MgpMOQKVneEA1dbda4CI67EkgJjLj0AeGcHew'GLog '%7Bleft%3A0%2Ctop%3A0%2Cwidth%3A1175%2Cheight%3A630%2CpriorityDefaults%3A%7BLog%3A4%7D%2CdefaultPriority%3A3%2CtrackRPC%3Anull%7D'lazy itemsSESSION<bound method SessionDataManager.getSessionData of <SessionDataManager at /session_data_manager>>otherTraversalRequestNameStack []AUTHENTICATED_USER<User 'admin'>URL' http://localhost:9673/DeveloperGuide/Simpleinterface'SERVER_URL' http://localhost:9673'AUTHENTICATION_PATH''traverse_subpath[]PUBLISHED<PythonScript at /DeveloperGuide/Simpleinterface>ACTUAL_URL' http://localhost:9673/DeveloperGuide/Simpleinterface'URL0 http://localhost:9673/DeveloperGuide/SimpleinterfaceURL1 http://localhost:9673/DeveloperGuideURL2http://localhost:9673BASE0 http://localhost:9673BASE1http://localhost:9673BASE2 http://localhost:9673/DeveloperGuideBASE3 http://localhost:9673/DeveloperGuide/SimpleinterfaceenvironHTTP_COOKIE'dtpref_rows="20"; dtpref_cols="90%"; GLog=%7Bleft%3A0%2Ctop%3A0%2Cwidth%3A1175%2Cheight%3A630%2CpriorityDefaults%3A%7BLog%3A4%7D%2CdefaultPriority%3A3%2CtrackRPC%3Anull%7D; tree-s="eJzT0MgpMOQKVneEA1dbda4CI67EkgJjLj0AeGcHew"'SERVER_SOFTWARE'Zope/(Zope 2.10.5-final, python 2.4.5, linux2) ZServer/1.1'SCRIPT_NAME''REQUEST_METHOD 'GET'PATH_INFO'/DeveloperGuide/Simpleinterface'SERVER_PROTOCOL'HTTP/1.1' channel.creation_time1237914020CONNECTION_TYPE'keep-alive' HTTP_ACCEPT_CHARSET'ISO-8859-1,utf-8;q=0.7,*;q=0.7'HTTP_USER_AGENT'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.7) Gecko/2009030422 Ubuntu/8.04 (hardy) Firefox/3.0.7'HTTP_REFERER' http://localhost:9673/DeveloperGuide/Simpleinterface/ZPythonScriptHTML_edit… 'SERVER_NAME'0.0.0.0'REMOTE_ADDR'127.0.0.1'PATH_TRANSLATED '/DeveloperGuide/Simpleinterface'SERVER_PORT'9673'HTTP_HOST'localhost:9673' HTTP_ACCEPT'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' GATEWAY_INTERFACE'CGI/1.1'HTTP_ACCEPT_LANGUAGE'en-us,en;q=0.5' HTTP_ACCEPT_ENCODING'gzip,deflate'HTTP_KEEP_ALIVE'300' I think I have to change permissions, but the question is from WHERE please help me out.. Thanks, Amol

3 2

FTP server problem
by Gareth Allen 25 Mar '09

25 Mar '09

Hello, I'm experiencing a strange problem. I've enabled FTP access to my Zope instance, but when I try and login it throws an exception: 2009-03-23T11:14:42 INFO ZServer Successful login. ------ 2009-03-23T11:15:07 ERROR ZServer uncaptured python exception, closing channel <ZServer.FTPServer.zope_ftp_channel connected 196.*.*.*:48336 at 0x2a9c0ecd40> (exceptions.AttributeError:'NoneType' object has no attribute '_fileno' [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|read|69] [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|handle_read_event|391] [/home/zope/Python-2.4.4/lib/python2.4/asynchat.py|handle_read|89] [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|recv|347] [/home/zope/Python-2.4.4/lib/python2.4/asynchat.py|handle_close|156] [/home/zope/instances/www.emss.co.za/parts/zope2/lib/python/ZServer/medusa/ftp_server.py|close|181] [/home/zope/instances/www.emss.co.za/parts/zope2/lib/python/ZServer/medusa/ftp_server.py|close|906] [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|close|360] [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|del_channel|248] [/home/zope/Python-2.4.4/lib/python2.4/asyncore.py|__getattr__|366]) I thought it may be a Plone permissions problem as I was using a Plone user account, but even as the Zope admin user it throws the above error. Passive mode throws the exception. Active mode doesn't throw an error, but doesn't show a directory listing either. Zope version: Zope 2.10.6-final OS: Debian Sarge FTP clients used: FileZilla, standard Linux FTP client and Firefox (as a last resort). Regards, Gareth Allen

2 1

zopectl does not terminate
by Hedley Roos 23 Mar '09

23 Mar '09

Hi all I run my script foo.zctl with "zopectl run foo.ctl param1 param2". This script operates on a large ZODB and catches ConflictErrors accordingly. It iterates over a set, updates data and commits the transaction every 100 iterations. But I've noticed two things: 1. ConflictErrors are never fully caught. The show up in the console (this is acceptable I suppose), but my script stops executing on the conflict and does not continue. The zope process stays alive. 2. In the event of no conflict errors my script executes its last line (print 'done') but the process does not always terminate. If I instruct my script to not update the ZODB at all it terminates without problems. I'm running it on a live site with 7 ZEO clients. I've stopped a client (say client 2) so it is not accessed concurrently and run my script with client2/zopectl. It is in fact a Plone site but that should be irrelevant. Thanks for any help Hedley

4 5

404 error
by garry＠schoolteachers.co.uk 21 Mar '09

21 Mar '09

I am trying to verify my site with google but keep getting this error: We've detected that your 404 (file not found) error page returns a status of 200 (Success) in the header. How could I correct this? Regards Garry

4 4

Re: [Zope] Conflict error
by Miles 20 Mar '09

20 Mar '09

Hi, Thanks Tres. I got to the bottom of what was happening. An attribute was being renamed "transparently" using the following code: def getConnection(self): if getattr(self, '_connection', None): self.db_connection = self._connection return self.db_connection Obviously, this fires every time getConnection is called, setting the attribute and therefore making the database commit. For reference, it should have been: def getConnection(self): if getattr(self, '_connection', None): self.db_connection = self._connection delattr(self, '_connection') return self.db_connection This only commits to the database once. Also out of interest, I found a handy way to find out what was going on, that I haven't come across previously, that might be of interest: >>> app._p_jar._registered_objects [] >>> component.getConnection() >>> app._p_jar._registered_objects [MyComponent.MyComponent] >>> app._p_jat._registered_objects[0].__dict__ {....} Basically I used it to work out which call caused the object to register with the transaction. In this case, there were only a couple of methods that got called, so it was more to verify it didn't get registered any more (the test case was "intermittent", i.e. only for the client :-/ ). Anyway, might be useful for someone, Cheers, Miles

1 0

Conflict error
by Miles Waller 19 Mar '09

19 Mar '09

Hi I have a PAS plugin that pulls user properties from a sql database. Intermittently, I get conflicterrors from the plugin when zope commits its transaction - even though no db changes have been made. Frustratingly, there is very little information in the traceback of actual use, other than the name of the class itself. Is there an easy way to identify what's keeping the database in the transaction so I can correct it? Thanks Miles

2 1

trivial: hello world with filesystem based egg sources
by David Zejda 19 Mar '09

19 Mar '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I try to develop something in the egg way, but still missing a point. I have a nice, fresh chrooted env with python, zope, plone etc. For installation I used buildout. Zope works neatly. In the home dir of chroot there is subdir of my project with subdirs like bin (scripts buildout, instance..), eggs, fake-eggs, products, src.. and in the root of project there is buildout.cfg. I'd like to start with easiest possible piece of python code in the egg form (to be redistributable), which could be treated by zope. I started with paster -t plone and answered a few questions. It created couple of dirs in src. I put the name of newly created directory to buildout.cfg sections [buildout]/eggs, [buildout]/develop, [instance]/zcml and rerun buildout. The path_to_chroot/src/projectname seems to be listed in the Debug Information of Zope instance. And now, please, what to do now, to have a few python lines somewhere in the egg dir, which the zope would know how to deal with? And on what url will be the "hello world" available then? Thank you for a patience.. With regards David -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJsvNP3oCkkciamVERAgNkAJ47T0+XeXwPTEINNHbFfIMVlWfKJgCgh6CS 7xxUW25bnAgBTpD7TeRSmno= =uENF -----END PGP SIGNATURE-----

4 5

ANN: eGenix mxODBC Connect 1.0.1 - Python Database Interface
by eGenix Team: M.-A. Lemburg 19 Mar '09

19 Mar '09

________________________________________________________________________ ANNOUNCING eGenix.com mxODBC Connect Python Database Interface Version 1.0.1 Our new client-server product for connecting Python applications to relational databases - from all major platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Connect-1.0.1-GA.html ________________________________________________________________________ INTRODUCTION The mxODBC Connect Database Interface for Python allows users to easily connect Python applications to all major databases on the market today in a highly portable and convenient way. Unlike our mxODBC Python extension, mxODBC Connect is designed as client-server application, so you no longer need to find production quality ODBC drivers for all the platforms you target with your Python application. Instead you use an easy to install Python client library which connects directly to the mxODBC Connect database server over the network. This makes mxODBC Connect the ideal basis for writing cross-platform database programs and utilities in Python, especially if you run applications that need to communicate with databases such as MS SQL Server and MS Access, Oracle Database, IBM DB2 and Informix, Sybase ASE and Sybase Anywhere, MySQL, PostgreSQL, SAP MaxDB and many more, that run on Windows or Linux machines. By removing the need to install and configure ODBC drivers on the client side, mxODBC Connect greatly simplifies setup and configuration of database driven client applications, while at the same time making the network communication between client and database server more efficient and more secure. For more information, please see the product page: http://www.egenix.com/products/python/mxODBCConnect/ ________________________________________________________________________ NEWS mxODBC Connect 1.0.1 is a patch-level release of our new mxODBC Connect product. * More Robust We have made the client and server more robust in case of communication failures. Even if the client applications fail to shutdown the server connection before exiting, the server will free up resources used by the client on the server side and rollback transactions as necessary. * More Platform Support With the 1.0.1 release we are also providing much better platform support for the mxODBC Connect Client: we have fixed a problem in 1.0.0 that prevented the installation of the pre-built clients on non-Linux systems. The mxODBC Connect Client can now be installed on most platforms supported by Python, since it is written in a platform independent, portable way. The pre-built archives also make it possible to integrate the clients into build system such as buildout (used in Zope and Plone) or other distutils-based deployment systems. * Ideal for Building Bridges As a result, connecting from e.g. Mac OS X to an SQL Server database has never been easier. You can even keep the data sources you already have configured on your Windows machine and connect to them as if your application were running on the database server itself. ________________________________________________________________________ UPGRADING You are encouraged to upgrade to this latest mxODBC Connect release. When upgrading, please always upgrade both the server and the client installations to the same version - even for patch level releases. Customers who have purchased mxODBC Connect 1.0 licenses can download and upgrade their existing installations without having to purchase new licenses or upgrades. The licenses will continue to work with version 1.0.1. Users of our stand-alone mxODBC product will have to purchase new licenses from our online shop in order to use mxODBC Connect. You can request 30-day evaluation licenses by visiting our web-site or writing to sales(a)egenix.com, stating your name (or the name of the company) and the number of eval licenses that you need. http://www.egenix.com/products/python/mxODBCConnect/#Evaluation ________________________________________________________________________ DOWNLOADS The download archives as well as instructions for installation and configuration of the product can be found on the product page: http://www.egenix.com/products/python/mxODBCConnect/ Evaluation licenses for the server part are available free of charge: http://www.egenix.com/products/python/mxODBCConnect/#Evaluation The client part of mxODBC Connect is always free of charge. _______________________________________________________________________ SUPPORT Commercial support for this product is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy, -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Mar 19 2009) >>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ ::: Try our new mxODBC.Connect Python Database Interface for free ! :::: eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg Registered at Amtsgericht Duesseldorf: HRB 46611 http://www.egenix.com/company/contact/

1 0