December 2009 - Zope

problem with commits in SQLAlchemyDA
by Maric Michaud 27 Apr '10

27 Apr '10

Hi all, I wanted to use SQALchemyDA with a standalone Zope 2.11 (we only depends on CMFCore). i tried to get it up using easy_install, which is pretty straightforward, once removed the incompatible zope.component package needed in the dependencies. It ends up with the following installed packages (skipping zope 3 components) : zope.sqlalchemy-0.4-py2.4.egg z3c.sqlalchemy-1.3.10.1-py2.4.egg SQLAlchemy-0.5.5-py2.4.egg Products.SQLAlchemyDA-0.4.1-py2.4.egg At first glance, this works well, but the DA actually can't manage to commit any sql requests (I try only for insert in Mysql and postgres but I'm sure it's always true). This is quite an unexpectable behavior for a DA. I think the problem is related to this thread I found on tg-trunk newsgroup : http://www.mail-archive.com/turbogears-trunk@googlegroups.com/msg07302.html There is a misleading comment in the docstring of zope.sqlalchemy.datamanager.join_transaction speaking of a DirtyAfterFlush SessionExtension, which I never seen except in plone code. In the last I finally manage to make it work by monkey patching SQLAlchemyDA itself this way : try : from Products.SQLAlchemyDA import da from z3c.sqlalchemy import getSAWrapper, createSAWrapper if '0.4.1' in da.__file__ and not hasattr(da.SAWrapper, '_patched__wrapper_property') : da.SAWrapper._patched__wrapper_property = da.SAWrapper._wrapper def _always_invalidated_wrapper(self): """The property '_wrapper' patched by CFENet to correct what seems to be a bug in SQLAlchemyDA which prevents any commit.""" from zope.sqlalchemy.datamanager import STATUS_INVALIDATED if self.dsn: try: return getSAWrapper(self.util_id) except ValueError: return createSAWrapper( self.dsn, forZope=True, transactional=self.transactional, engine_options={'convert_unicode' : self.convert_unicode, 'encoding' : self.encoding}, extension_options={'initial_state': # the whole # point is here STATUS_INVALIDATED}, name=self.util_id) return None da.SAWrapper._wrapper = property(_always_invalidated_wrapper) except ImportError : pass Anyone has any insights about this problem, any comments on my solution, did it have been reported and corrected, or am I simply missing something ? -- _____________ Maric Michaud

5 21

exUserFolder and Zope 2.12
by Baiju M 02 Jan '10

02 Jan '10

Hi, In exUserFolder there are few exceptions raised like this: raise 'LoginRequired', self.docLogin(self, request) This will not working in Zope 2.12 (Python 2.6) Any idea, how to change it ? Regards, Baiju M

3 6

Change admin's password
by iarly selbir | ski0s 31 Dec '09

31 Dec '09

There are some command to change admin's password, in my env I have a server with many instances and I need change it for all Thanks in advance for some tip. Regards, - - iarly selbir | ski0s :wq!

4 12

utilities @ the site level
by Jim Pharis 31 Dec '09

31 Dec '09

Can I register utilities at the site level in zcml? And once I have the local utility registered, how do I pass that site manager context to my browser/forms so I can do things like createObject. createObject seems to fail because it can't find the utility, but I think that's because its not looking for the utililty at the site level. I'm using Zope2.12 w/five.localsitemanager. Thanks, - Jim

2 3

Zope developers in local government or with transparency/participation projects
by Steven Clift 30 Dec '09

30 Dec '09

We are gathering software developers interested in local government transparency and community participation here: http://e-democracy.org/locallabs It is a new e-list/online group. It would be great to have a healthy Zope contingent among us. Steven Clift E-Democracy.org

1 0

Zope2.12
by Jim Pharis 25 Dec '09

25 Dec '09

I'm trying to wrap my head around what the changes in Zope2.12 can mean for how I develop in Zope2 now. I've developed things in Zope3 and am getting stuck attempting the same methods in Zope2.12. So I see now that etc/ now has a site.zcml. But what is missing is the package-includes directory that provides the wiring to zcml directives in the varies packages. Why are those configurations missing from Zope2.12.2 etc/? I am trying to make it so a site can be added the same it is added in the Web Component Development with Zope 3 book and finding that the browser directives that declare the menu item and container view are missing from the wiring. Overall, it would be helpful for the Zope2.12 documentation to give a better idea about how to develop in the new ZTK way. I'm sure someone is working on it though. Thanks, - Jim

5 21

DateTime Issues
by Justin Dunsworth 24 Dec '09

24 Dec '09

I am having difficulties with time zones and rendering proper times/dates. My time zone is GMT-6 (CST)... mysql reports the proper time/date, running <dtml-var expr="e.strftime('%c')"> shows Zope has the right date, running a query straight from the SQLMethod shows the proper time in relation to the field in mysql. However, when I try and run the variable in the dtml document it gives the time in GMT+0. For example... in mysql I have "2009-12-23 10:41:06" as the date of the record. Running the SQL Method returns it as '2009/12/23 10:41:06 GMT+0' -- So far so good but when I run <dtml-var comment_date fmt="%m-%d-%y %H:%M"> in my document it gives: 12-23-09 04:41. I can get fmt=ISO (and other similar time functions) working and showing the proper date/time but I'd rather have a little more control over how the time is displayed. Is there any suggestions on what to do? I've looked many places and couldn't find the answer. I am running Zope 2.11.4-final, python 2.4.4, win32 Regards, -J

3 5

Fork another process from Zope
by Baiju M 22 Dec '09

22 Dec '09

Hi, Is it possible to fork another process within Zope ? Any suggestion ? Regards, Baiju M

2 1

Session bugs around CAS4PAS integration in Plone
by Encolpe Degoute 18 Dec '09

18 Dec '09

Hello, These last months we have a random bug around CAS authentication. Preamble: CAS plugins are multiple but all are based on CAS4PAS : - CAS4PAS - Products.CAS4PAS - collective.castle - collective.cas4plone They all doing more or less the same job with different maintainers... They are all in the collective but outside http://svn.plone.org/svn/collective/PASPlugins/ Guys, can we try to work together ? If you only need rights to upload a release on pypi just ask them, don't start a fork. Our problem is user can obtain another session opened with CAS when the server is overloaded. It happens only one the first page loaded for a session and once the user get the session he keeps it until is logout. There is no web cache and Zope serve pages directly to them. There is 4 threads and 5000 objects in session cache. We suspect a session cache bug but we don't know how to debug it as the bug comes randomly when the server is overloaded (more than 5 concurrent users). Any tips to build a test environment for this ? Regards, -- int i;main(){for(;i["]<i;++i){--i;}"];read('-'-'-',i+++"hell\ o, world!\\n",'/'/'/'));}read(j,i,p){write(j/p+p,i---j,i/i);} -+- Dishonorable mention, Obfuscated C Code Contest, 1984 Author requested anonymity -+-

4 3

Debugging conflict errors in (old) zope
by Marco Bizzarri 18 Dec '09

18 Dec '09

Hi all. I'm facing some of these conflicts: ZODB.POSException.ConflictError database conflict error (oid 0x03dc5870, class BTrees._OOBTree.OOBucket, serial this txn started with 0x0382d2aa7ec19444 2009-12-18 10:18:29.708477, serial currently committed 0x0382d2aac531e099 2009-12-18 10:18:46.217539) File "/var/local/zope/base2891/lib/python/Zope2/App/startup.py", line 167, in zpublisher_exception_hook v.reraise() File "/var/local/zope/base2891/lib/python/ZPublisher/Publish.py", line 120, in publish transactions_manager.commit() File "/var/local/zope/base2891/lib/python/Zope2/App/startup.py", line 233, in commit transaction.commit() File "/var/local/zope/base2891/lib/python/transaction/_manager.py", line 84, in commit self.get().commit(sub) File "/var/local/zope/base2891/lib/python/transaction/_transaction.py", line 381, in commit self._saveCommitishError() # This raises! File "/var/local/zope/base2891/lib/python/transaction/_transaction.py", line 379, in commit self._commitResources() File "/var/local/zope/base2891/lib/python/transaction/_transaction.py", line 427, in _commitResources rm.tpc_vote(self) File "/var/local/zope/base2891/lib/python/ZODB/Connection.py", line 637, in tpc_vote s = vote(transaction) File "/var/local/zope/base2891/lib/python/ZEO/ClientStorage.py", line 893, in tpc_vote return self._check_serials() File "/var/local/zope/base2891/lib/python/ZEO/ClientStorage.py", line 877, in _check_serials raise s Set up is a python 2.3 + Zope 2.8 with ZEO; I've tried to figure what the object is with a zopectl debug: >>> app._p_jar[0x03dc5870] Traceback (most recent call last): File "<stdin>", line 1, in ? File "/var/local/zope/base2891/lib/python/ZODB/Connection.py", line 207, in get p, serial = self._storage.load(oid, self._version) File "/var/local/zope/base2891/lib/python/ZEO/ClientStorage.py", line 746, in load return self.loadEx(oid, version)[:2] File "/var/local/zope/base2891/lib/python/ZEO/ClientStorage.py", line 769, in loadEx data, tid, ver = self._server.loadEx(oid, version) File "/var/local/zope/base2891/lib/python/ZEO/ServerStub.py", line 192, in loadEx return self.rpc.call("loadEx", oid, version) File "/var/local/zope/base2891/lib/python/ZEO/zrpc/connection.py", line 536, in call raise inst # error raised by server TypeError: invalid oid 64772208 The question now is: how can I debug such a problem? Of course, I thought I could add some debug code in the _check_serials, but I'll do that just if there is no other way. Regards Marco -- Marco Bizzarri http://code.google.com/p/qt-asterisk/ http://notenotturne.blogspot.com/ http://iliveinpisa.blogspot.com/

1 0