January 2010 - Zope - Zope lists

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

Re: [Zope] Save references in a list as object attribut
by Vladislav Vorobiev 01 Feb '10

01 Feb '10

2 2

Save references in a list as object attribut
by Vladislav Vorobiev 29 Jan '10

29 Jan '10

Hello, I try to save references to objects as attribute in a list. object.refList=getattr([self. context.pfad, 'object'], [self.context.pfad, 'object1']) After adding and transaction commit I can get my linked objects with all attributes and methods myObject.refList [<myType at object>] myObject.refList[0].objectValues()[0].getPhysicalPath() ('', 'path', 'object') myObject.refList[0].objectValues()[0].absolute_url() http://localhost/pfad/object I restart the instance and get some other results myObject.refList [<myType at object>] myObject.refList[0].objectValues()[0].getPhysicalPath() ('object',) myObject.refList[0].objectValues()[0].absolute_url() 'object' It seems that the in list referenced object ist no more in context after restart. the constructor for this looks like: object = myObject() id=myObject myObject.id = id myObject.title= id myObject.refList=getattr([self.context.pfad, 'object'], [self.context.pfad, 'object1']) self.context._setObject(id, ob) The references without list object.ref=objectreference working after restart. Similar conducts Set und PersistentList. Whats the problem anybody an idea? Can anybody reproduce the problem? Zope2.12, python2.6 -- Best Regards Vlad Vorobiev

2 3

using formlib for nonclasic content types
by Roberto Allende 28 Jan '10

28 Jan '10

Hello Following example 18.3.1 and 18.3.2 from phillkon's book, i'm trying to define a MySite class in Zope 2.12, which look like this: class IMySite(IPossibleSite, IContainer): """ """ id = ASCIILine( ... name = TextLine( ... class MySite(SiteManagerContainer, BTreeContainer): implements(IMySite) So far so good, i've an interface and a class extending SiteManagerContainer and BTreeContainer. Problem becomes when i want to define the add form. If i'm not wrong, I cannot use the same machinery as zope3, so i was trying to use formlib: class MySiteAddForm(AddForm): form_fields=form.Fields(IListo) And i doesn't work. The error i'm getting is: NotImplementedError: concrete classes must implement create() or createAndAdd() I was looking info about them but i wonder i'm running with a conceptual gap here, because this is the same problem i had to define MySite inheriting from Folder. The same problem happened there, i was able to define the class but when i needed the form i wasn't able to use formlib and i used old-zope2-like-code. Probably i could try to do smt like that, but i'm very curious to see how can i use formlib in such cases. The question then is, is it possible or would it make sense to do something like this ?. Do you know about a sample code that could be helpful ?. Any comment or hint would be very appreciated. Kind Regards r. -- http://robertoallende.com

2 1

[ZF] Announcement: 2010 Zope Foundation Board Elections and General Meeting
by Tres Seaver 28 Jan '10

28 Jan '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 (apologies in advance for the cross-post: we need this to reach the whole Zope community). The Zope Foundation board is pleased to announce the regular 2010 general meeting of the foundation will be held on Wednesday, 24 February 2010, at 17:00 UTC. The meeting will be conducted via IRC at the following channel: irc://irc.freenode.net/#zope-foundation Prior to that meeting, the current board will conduct an elections in which foundation members will select seven (7) board members in accordance with the foundation bylaws[1]. Summary - ------- - - Nominations open via the foundation(a)zope.org mailing list until Friday, 2010-01-29. - - Voting via e-mail to a closed mailing list, from Wednesday, 2010-02-03 through Friday, 2010-02-19. - - Votes tallied by representatives of the current board, using "Meek and Warrent STV" method using OpenSTV software. - - General meeting and seating of the new board, Wednesday, 2010-02-24. Procedure for Elections - ----------------------- The procedure for the elections is as follows: - - Foundation members may nominate any member by responding to the board's announcment on the foundation(a)zope.org maling list. Nominations will remain open until Friday, 2010-01-29, 23:00 UTC. - - At the close of the nominations period, the board will create a new mailman list, 'zf-elections-2010', and approve all ZF members to post to the list.. In order to preserve anonymity of votes, foundation members will not be subscribers to the list; access to the list archives will be restricted to the "tellers" appointed by the board. - - On Wednesday, 2010-02-03, the Secretary will send an e-mail announcing the opening of the voting period. This email will contain the ballot, with careful instructions about how to rank preferences in the reply. The Reply-to header of this e-mail will be set to the 'zf-elections-2010' list. - - ZF members will vote by replying to that e-mail. Voting will remain open until Friday, 2010-02-19, 23:00 UTC. - - At the close of voting, the board will appoint two of its members as "tellers." The tellers will use the list archive to tabulate the members' votes, using the OpenSTV application[2] configured to use the Meek and Warren STV method[3]. The tellers will report the election results, along with the raw tallies, at a special board meeting to be held on Tuesday, 2009-02-23, 15:00 UTC. - - After canvassing the results from the tellers, the board will notify all nominees of the success / failure of their candidacy, thanking them for their willingness to serve. - - At the general meeting, the last item on the agenda will the announcement of the election results, including a vote to "seat" the board. An online version of this announcement is available at: http://foundation.zope.org/news/2010_election_and_general_meeting/ References - ---------- [1] http://foundation.zope.org/bylaws/zope_foundation_bylaws.pdf [2] http://stv.sourceforge.net/aboutopenstv [3] http://stv.sourceforge.net/votingmethods/meek Tres. - -- =================================================================== Tres Seaver +1 540-429-0999 tseaver(a)palladion.com Palladion Software "Excellence by Design" http://palladion.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktZ3V8ACgkQ+gerLs4ltQ6sDQCfbV+M85FnxeiSypdy0WBHle1A 7+sAn2aZoP5pb0sqK4ir84d9rhm09HiO =urx1 -----END PGP SIGNATURE-----

3 3

Re: [Zope] Safe way to abort or re-start stalled out ZODB pack?
by John Schinnerer 28 Jan '10

28 Jan '10

Thanks Bakhtiar, That's what I was hoping, and I wanted some confirmation from those who've done it. I just did as you indicated - deleted Data.fs.pack, then ran the pack again. It completed successfully. regards, John S. Bakhtiar A Hamid wrote: > On Thu, Jan 28, 2010 at 5:06 AM, John Schinnerer <john(a)eco-living.net> wrote: >> Hello, >> >> This is for >> >> Zope 2.9.8-final, python 2.4.4, linux2 (debian) >> (installed by the Plone 2.5.5 installer if that matters, and using >> zeoserver) >> >> I have a ZODB pack operation started via the ZMI control panel that has >> failed to complete. It appears to be from a disk space issue (traceback >> below). >> >> The zope instance is still working fine on the pre-pack ZODB, and, there >> is a Data.fs.pack file sitting in ../zeocluster/server/var which hasn't >> been modified in the last ten hours. > > > Hi > > we've had the same issue (on an old setup with limited disk space) and > removing Data.fs.pack should suffice. > > We just repack after deleting. > > you can copy Data.fs if you want to. > > hth >> I need to know how to deal with this situation safely - how to abort >> and/or safely re-start the pack (the disk space issue has been dealt with). >> Some questions that have come to mind are: >> Is it safe to just restart zope? >> Will that clear the stalled pack operation automagically? >> Will I need to do something manually with the Data.fs.pack file? >> >> Any assistance appreciated...! >> thanks, >> John S. >> >> Traceback: >> --------------------- >> 2010-01-27T03:51:09 INFO ZEO.zrpc.Connection(S) (127.0.0.1:35831) vote() >> raised exception: [Errno 28] No space left on device >> Traceback (most recent call last): >> File "/opt/Plone-2.5.5/lib/python/ZEO/zrpc/connection.py", line 421, >> in handle_request >> ret = meth(*args) >> File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 465, in >> vote >> return self._wait(lambda: self._vote()) >> File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 583, in >> _wait >> return self._restart() >> File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 599, in >> _restart >> resp = self._thunk() >> File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 465, in >> <lambda> >> return self._wait(lambda: self._vote()) >> File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 539, in >> _vote >> return self.storage.tpc_vote(self.transaction) >> File "/opt/Plone-2.5.5/lib/python/ZODB/FileStorage/FileStorage.py", >> line 891, in tpc_vote >> self._file.flush() >> IOError: [Errno 28] No space left on device >> --------------------------- >> >> -- >> John Schinnerer - M.A., Whole Systems Design >> -------------------------------------------- >> - Eco-Living - >> Whole Systems Design Services >> People - Place - Learning - Integration >> john(a)eco-living.net >> http://eco-living.net >> _______________________________________________ >> Zope maillist - Zope(a)zope.org >> https://mail.zope.org/mailman/listinfo/zope >> ** No cross posts or HTML encoding! ** >> (Related lists - >> https://mail.zope.org/mailman/listinfo/zope-announce >> https://mail.zope.org/mailman/listinfo/zope-dev ) >> > -- John Schinnerer - M.A., Whole Systems Design -------------------------------------------- - Eco-Living - Whole Systems Design Services People - Place - Learning - Integration john(a)eco-living.net http://eco-living.net

1 0

Safe way to abort or re-start stalled out ZODB pack?
by John Schinnerer 27 Jan '10

27 Jan '10

Hello, This is for Zope 2.9.8-final, python 2.4.4, linux2 (debian) (installed by the Plone 2.5.5 installer if that matters, and using zeoserver) I have a ZODB pack operation started via the ZMI control panel that has failed to complete. It appears to be from a disk space issue (traceback below). The zope instance is still working fine on the pre-pack ZODB, and, there is a Data.fs.pack file sitting in ../zeocluster/server/var which hasn't been modified in the last ten hours. I need to know how to deal with this situation safely - how to abort and/or safely re-start the pack (the disk space issue has been dealt with). Some questions that have come to mind are: Is it safe to just restart zope? Will that clear the stalled pack operation automagically? Will I need to do something manually with the Data.fs.pack file? Any assistance appreciated...! thanks, John S. Traceback: --------------------- 2010-01-27T03:51:09 INFO ZEO.zrpc.Connection(S) (127.0.0.1:35831) vote() raised exception: [Errno 28] No space left on device Traceback (most recent call last): File "/opt/Plone-2.5.5/lib/python/ZEO/zrpc/connection.py", line 421, in handle_request ret = meth(*args) File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 465, in vote return self._wait(lambda: self._vote()) File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 583, in _wait return self._restart() File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 599, in _restart resp = self._thunk() File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 465, in <lambda> return self._wait(lambda: self._vote()) File "/opt/Plone-2.5.5/lib/python/ZEO/StorageServer.py", line 539, in _vote return self.storage.tpc_vote(self.transaction) File "/opt/Plone-2.5.5/lib/python/ZODB/FileStorage/FileStorage.py", line 891, in tpc_vote self._file.flush() IOError: [Errno 28] No space left on device --------------------------- -- John Schinnerer - M.A., Whole Systems Design -------------------------------------------- - Eco-Living - Whole Systems Design Services People - Place - Learning - Integration john(a)eco-living.net http://eco-living.net

1 0

Cann't we use 'get' as object name in Zope 2.12 ?
by Baiju M 27 Jan '10

27 Jan '10

Hi, Any idea about this ? >>> app.manage_addFolder('get') Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/opt/baiju/zesite/eggs/Zope2-2.12.1-py2.6-linux-i686.egg/OFS/Folder.py", line 51, in manage_addFolder self._setObject(id, ob) File "/opt/baiju/zesite/eggs/Zope2-2.12.1-py2.6-linux-i686.egg/OFS/ObjectManager.py", line 332, in _setObject v = self._checkId(id) File "/opt/baiju/zesite/eggs/Zope2-2.12.1-py2.6-linux-i686.egg/OFS/ObjectManager.py", line 116, in checkValidId 'The id "%s" is invalid - it is already in use.' % id) zExceptions.BadRequest: The id "get" is invalid - it is already in use. Regards, Baiju M

3 2

Very odd reverse proxy problem . [nginx -> win32 zope]
by kiorky 22 Jan '10

22 Jan '10

The things: * I have a nginx handmade compiled under the hood * I have an official zope+plone installation on native windows * I have a django based application inside the cygwin * I have a tomcat+cas installation on native windows All of that seem to be configured correctly. What i want to do is to make my nginx a reverse proxy of the 3 others applications. Because of some other application needs (wsgi served with flup/socket) i need that nginx to live inside the cygwin installation. That's not my concern afterall :). The nginx works well for static contents and as the the django and tomcat installations reverse proxy. Here come problems with zope+plone. If i hit my http://url/plone (nginx mapped point to the plone install as http reverse proxy), the first request (get /) pass, but the other stall as 206 partial content and are very long to be satisfied. The browser seems to be blocked on some read() call. I tried a bunch of things nginx side (use epoll, use select, tweak proxy parameters, stop proxy buffering, set timeouts, set retrys and so on) but i have not found the right configuration if it is there. But where it is very strange is that if i make an ssh tunnel from localhost:80 to prod_machine:localhost:80, then make some entry into my /etc/hosts to fake the dns name. Then browse to http://myurl/plone, no problem, i have the content, and all http request are satisfied (js & co.). I really don't know how to debug that, can it be because the request enter from cygwin, go out to windows re enter cygwin and go for the client? The fact that throught the ssh tunnel, when i hit the nginx server on my plone install (like "as normal", i dont hit plone but nginx) work perfectly lives me without words. Other strange thing is that the CAS application, also http reverse proxified work like a charm. Other thing is that if i use the windows nginx binary from nginx website, with equal configuration, it works. The only thing is nginx running out of cygwin stack and compiled for win32. If someone has some suggestions .... -- Cordialement, KiOrKY GPG Key FingerPrint: 0x1A1194B7681112AF

1 0

python help needed
by Garry Saddington 19 Jan '10

19 Jan '10

I am trying to upload a csv file (called data) using the following script: i=0 d=data.readlines() for row in d: i+=1 a=row.split(',') if i > 1: subjectid=a[0] entry=a[1] type=a[2] studentid=a[3] try: context.insertestimatesandtargets(subjectid=subjectid,entry=entry,type=type,studentid=studentid) except: continue return "something good" (email editor messed up indentation) insertestimatesandtargets() is a ZSQLmethod. When the call to this method results in an error the script stops and not all data is inserted. Without an error all the data is inserted. So how can I make this script skip over errors and continue? The reason is that there may already be some data in the database table that I want to preserve. regards Garry

2 2