- Zope - Zope lists

Advice on Blob Storage?
by Michael McFadden 15 Oct '15

15 Oct '15

This may be more of a zodb / relstorage question - I hope it's ok to ask on the Zope list. I'm seeing behavior using relstorage and blobs that I didn't expect: If I upload a large file, say 2 gigs, I am noticing that our SQL database also grows by 2 Gigs, along with the blob storage. After a pack, the space is reclaimed on the SQL side, and everyone is happy. FWIW - it's videos that are doing this. I am pretty sure it's the undo log that's growing, based on the fact that a pack reclaims the space. Can this behavior be turned off for a specific field or content type? So undo logs are preserved for everything BUT this monster of a content type? Seems strange to do this tho. Are there other alternatives, like calling .pack() directly on the field's storage after it's set? Our problem is that our sql database grows to a huge size between our weekly packs, and backups of the sql dumps are becoming unmanageable. Our blob backups are ready to deal with this kind of size, but not the sql backups. ---------- Going deeper down the rabbit hole, although I don't think it's relevant, is the fact that I hacked and replaced the storage class for the field. Instead of using AnnotationStorage - which I found used as default for ImageField - I intercept the data during storage.set(), ship it out to a separate storage facility, and replace the data with a happy message "This is not where your data is" which is then written to the blobs. It works just great - keeping our blob storage growth from going crazy. If you try to 'download' the file from Plone, you'll get the text file with the happy message. Now that I've been shown that the Blob Storage is functioning just fine, but the SQL storage size is going off the charts, I hope I'm not back at square one. The goal is to allow users to think they are uploading 4Gb videos into Plone, when under the covers, we're actually shipping the video files off to some fancy off-site storage. (Akamai) So we don't have to store them and back them up on-site, and our blob directories remain manageable in size. The storage hack can be seen here: https://github.com/RadioFreeAsia/rfa.kaltura/blob/master/rfa/kaltura/storag… I'm not proud of it, but it works. -- Mike McFadden Radio Free Asia Technical Operations Division 2025 M Street NW Washington DC 20036 USA This e-mail message is intended only for the use of the addressee and may contain information that is privileged and confidential. Any unauthorized dissemination, distribution or copying is strictly prohibited. If you receive this transmission in error, please contact network(a)rfa.org.

3 5

ANN: eGenix mxODBC Plone/Zope Database Adapter 2.2.3
by eGenix Team: M.-A. Lemburg 14 Sep '15

14 Sep '15

________________________________________________________________________ ANNOUNCING mxODBC Plone/Zope Database Adapter Version 2.2.3 for the Plone CMS and Zope server platform Available for Plone 4.0-4.3 and Plone 5.0, Zope 2.12 and 2.13, on Windows, Linux, Mac OS X, FreeBSD and other platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Zope-DA-2.2.3-GA.html ________________________________________________________________________ INTRODUCTION The eGenix mxODBC Zope DA allows you to easily connect your Zope or Plone CMS installation to just about any database backend on the market today, giving you the reliability of the commercially supported eGenix product mxODBC and the flexibility of the ODBC standard as middle-tier architecture. The mxODBC Zope Database Adapter is highly portable, just like Zope itself, and provides a high performance interface to all your ODBC data sources, using a single well-supported interface on Windows, Linux, Mac OS X, FreeBSD and other platforms. This makes it ideal for deployment in ZEO Clusters and Zope hosting environments where stability and high performance are a top priority, establishing an excellent basis and scalable solution for your Plone CMS. Product page: http://www.egenix.com/products/zope/mxODBCZopeDA/ ________________________________________________________________________ NEWS The 2.2.3 release of our mxODBC Zope/Plone Database Adapter product is a patch level release of the popular ODBC database interface for Plone and Zope. It includes these enhancements and fixes: Feature Updates --------------- * We have integrated a new option to force serialized connects on a per Zope connection object basis. This can be used to work around bugs in ODBC drivers which are not fully thread-safe in the connect phase. The option is disabled per default. Driver Compatibility Enhancements --------------------------------- * ODBC driver compatibility updated. Upgraded to the latest mxODBC 3.3.5 release, adding compatibility enhancements for MS SQL Server. See the mxODBC 3.3.5 release announcements for full details. Installation Enhancements ------------------------- * Added pip install compatibility to mxODBC Zope DA by creating prebuilt archives and uploading a web installer to PyPI. This can be useful if you are installing Zope or Plone using a requirements.txt type approach, e.g. using pip install ThreadLock Products.ZSQLMethods egenix-mxodbc-zopeda * Enabled creating wheels from the prebuilt archives, which helps when running pip with the wheels package installed. pip then tries to build wheels during installation and caches them for future reuse. The complete list of changes is available on the mxODBC Zope DA changelog page. http://www.egenix.com/products/zope/mxODBCZopeDA/changelog.html mxODBC Zope DA 2.2.0 was released on 2014-12-11. Please see the mxODBC Zope DA 2.2.0 release announcement for all the new features we have added. http://www.egenix.com/company/news/eGenix-mxODBC-Zope-DA-2.2.0-GA.html For the full list of features, please see the mxODBC Zope DA feature list: http://www.egenix.com/products/zope/mxODBCZopeDA/#Features The complete list of changes is available on the mxODBC Zope DA changelog page. ________________________________________________________________________ UPGRADING Users are encouraged to upgrade to this latest mxODBC Plone/Zope Database Adapter release to benefit from the new features and updated ODBC driver support. We have taken special care not to introduce backwards incompatible changes, making the upgrade experience as smooth as possible. For major and minor upgrade purchases, we will give out 20% discount coupons going from mxODBC Zope DA 1.x to 2.2 and 50% coupons for upgrades from mxODBC 2.x to 2.2. After upgrade, use of the original license from which you upgraded is no longer permitted. Patch level upgrades (e.g. 2.2.0 to 2.2.3) are always free of charge. Please contact the eGenix.com Sales Team with your existing license serials for details for an upgrade discount coupon. If you want to try the new release before purchase, 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/mxODBCZopeDA/#Evaluation ________________________________________________________________________ DOWNLOADS Please visit the eGenix mxODBC Zope DA product page for downloads, instructions on installation and documentation of the packages: http://www.egenix.com/company/products/zope/mxODBCZopeDA/ If you want to try the package, please jump straight to the download instructions: http://www.egenix.com/products/zope/mxODBCZopeDA/#Download Fully functional evaluation licenses for the mxODBC Zope DA are available free of charge: http://www.egenix.com/products/zope/mxODBCZopeDA/#Evaluation ________________________________________________________________________ SUPPORT Commercial support for this product is available directly from eGenix.com. Please see the support section of our website for details: http://www.egenix.com/services/support/ ________________________________________________________________________ MORE INFORMATION For more information on eGenix mxODBC Zope DA, licensing and download instructions, please write to sales(a)egenix.com. About eGenix (http://www.egenix.com/) eGenix is a software project, consulting and product company focusing on expert project services and professional quality products for companies, Python users and developers. Enjoy, -- Marc-Andre Lemburg eGenix.com Professional Python Services directly from the Source (#1, Sep 14 2015) >>> Python Projects, Coaching and Consulting ... http://www.egenix.com/ >>> mxODBC Plone/Zope Database Adapter ... http://zope.egenix.com/ >>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ ________________________________________________________________________ 2015-09-18: PyCon UK 2015 ... 4 days to go 2015-10-21: Python Meeting Duesseldorf ... 37 days to go ::::: Try our 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

Zope 2: traversing and modifying DTM doc in folders?
by Dan Gaibel 11 Aug '15

11 Aug '15

Greetings, I have a developer here trying to fix a problem with some legacy Zope 2 (2.8.6) material. Basically, she is trying to change properties on a DTML document, but so far cannot get the script to recursively search through folders to act on every document in the hierarchy. Any advice is greatly appreciated! Best, Dan ------------------------------------------------------------------------------------------------------------- Hello, the things we want to do is to find every media file (DTML document) in a folder structure and change their format. They are a few folders deep and the number of folders that contain the file is unknown, so I tried to use a recursive way to get access to every document. So this is what I did, I wrote a script named changeType with parameter "object", which is initially 0. Then when object is 0, just set object = context. If in "object" we found that there's another folder called f, just called changeType(f). The script is shown as below: #parameter object = 0 from Products.PythonScripts.standard import html_quote request = context.REQUEST RESPONSE = request.RESPONSE if object == 0: object = context folders = object.objectValues(['Folder']) for f in folders: fds = f.objectValues(['Folder']) if(len(fds) != 0): f.changeType(f) .......(methods to change format) But this causes an error: Error Type: AttributeError Error Value: ‘str’ object has no attribute ‘objectValues' I think the reason should be, it doesn't seen "object" or "context" as object and context but seen them just as strings. But I have no idea about how could I solve this or if there's any other way I can call a recursive method to get every DTML document in their respective subfolders. Please let me know if you have any suggestion/examples on Zope/found another error in my code/etc.

2 1

__bobo_traverse__ or similiar with python tales expression?
by Sebastian Tänzer 12 Jul '15

12 Jul '15

Hello fellow Zopees, the product we’re using (ZMS) allows methods as attributes to custom object models. These methodes (PythonScript) are created inside a metamanager container as „Wiki.mymethod“, where Wiki is the meta type of the custom object. The pathhandler method of these custom objects modifies __bobo_traversal__ for normal http requests and maps these non-existing methods in that context to existing methods in the metaobj_manager container using the context meta_id. Calling the same method from a PageTemplate or other PythonScript does not reflect that and - not surprisingly - returns an AttributeError: File "/opt/python/zope2-pip/lib/python2.7/site-packages/Products/PageTemplates/ZRPythonExpr.py", line 48, in __call__ return eval(self._code, vars, {}) File "PythonExpr", line 1, in <expression> AttributeError: dummyFunction Is there a way to modify traversal behaviour from the Product or somehow different? Best Sebastian

1 1

Zope in The Netherlands
by Kees de Brabander 10 Jul '15

10 Jul '15

Hi there, I desperately need a zope server, at least for a transition period. Is there in The Netherlands a company that still uses zope or has experience with zope that can help or advise me? tia, Cornelis J. de Brabander

6 10

peter.z@gmx.at erwartet Ihre Antwort. Annehmen?
by peter.z＠gmx.at 06 Jul '15

06 Jul '15

Hallo, peter.z(a)gmx.at möchte Ihnen folgen. ****** Ist peter.z(a)gmx.at Ihr Freund? ****** Ja: http://invites.flipmailer.com/signup_e.html?fullname=&email=zope@zope.o… Nein: http://invites.flipmailer.com/signup_e.html?fullname=&email=zope@zope.o… Klicken Sie hier, um sich aus allen derartigen E-Mails zu entfernen http://invites.flipmailer.com/uns_inviter.jsp?email=zope@zope.org&iid=d…

1 0

peter.z@gmx.at möchte Ihnen folgen. Annehmen?
by peter.z＠gmx.at 30 Jun '15

30 Jun '15

Hallo, peter.z(a)gmx.at möchte Ihnen folgen. ****** Ist peter.z(a)gmx.at Ihr Freund? ****** Ja: http://invites.info-emailer.com/signup_e.html?fullname=&email=zope@zope… Nein: http://invites.info-emailer.com/signup_e.html?fullname=&email=zope@zope… Klicken Sie hier, um sich aus allen derartigen E-Mails zu entfernen http://invites.info-emailer.com/uns_inviter.jsp?email=zope@zope.org&iid…

1 0

Zope 2.13.23 released
by Tres Seaver 29 Jun '15

29 Jun '15

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On behalf of the Zope Foundation and its members, I'm pleased to announce the 2.13.23 release of the Zope2 package: https://pypi.python.org/pypi/Zope2/2.13.23 One key feature is that Zope2 should now be installable via pip, e.g.: - From the changelog: - - Provide a pip-compatible ``requirements.txt`` file for the release. E.g.:: $ /path/to/venv/bin/pip install \ https://raw.githubusercontent.com/zopefoundation/Zope/2.13.23/requirements.… - - LP #789863: Ensure that Request objects cannot be published / traversed directly via a URL. - - Issue #27: Fix publishing of ``ZPublisher.Iterators.IStreamIterator`` under WSGI. This interface does not have ``seek`` or ``tell``. Introduce ``ZPublisher.Iterators.IUnboundStreamIterator`` to support publishing iterators of unknown length under WSGI. - - Document running Zope as a WSGI application. See https://github.com/zopefoundation/Zope/issues/30 - - LP #1465432: Ensure that WSGIPublisher starts / ends interaction at request boundaries (analogous to ZPublisher). Backport from master. - - Fix: Queue additional warning filters at the beginning of the queue in order to allow overrides. - - Issue #16: prevent leaked connections when broken ``EndRequestEvent`` subscribers raise exceptions. - - LP #1387225: Zope 2.13.x w/ zope.browserpage 4.x doesn't start. - - LP #1387138: Zope 2.13.x w/ zope.pagetemplate 4.x doesn't start. - - LP #1386795: Fix ``zopectl start`` with zdaemon 3 and newer. - - Updated distributions: - - Acquisition = 2.13.9 - - DateTime = 2.12.8 - - Products.BTreeFolder2 = 2.13.5 - - Products.ExternalMethod = 2.13.1 - - Products.Mailhost = 2.13.2 - - Products.StandardCacheManagers = 2.13.1 - - ZConfig = 2.9.3 - - zLOG = 2.11.2 - - zope.dublincore = 3.7.1 - - zope.mkzeoinstance = 3.9.6 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.11 (GNU/Linux) iQIcBAEBAgAGBQJVkazmAAoJEPKpaDSJE9HYKd4P+wRQqhyGpbok8PG5QegqhISU Qoyx35ppixD2PrwZU9iRe+dVSSasTF5F9QeC74HO95WMMfByAFGIYd1l0UTQTAA1 tEAsvc+2Uzj5ZlAC9ry+dF6oEHB6QiY56NJNxSMcCyUSJjk0PPHA26SnoxV8IXAg kwBZA6cmcA3x4Vj0UnNlVhWcMPKhQjXpthor0DIOPmkZJXpufk7uKmldUtAE1Jic NTySXsapT6CMKUM2bfEMDFgbx/qEE/yuhmnxRN5+GCLCBmYQG21IpoI5SUrFx8ip U9PWw96ckRGFAsfJD74Rxd2YciTqOeuOtzL7ohrnTSLA78arUBNBYxSHcKHvHCo8 5/f1PrcBJVX4Qac8BHBXrsMAcCczm8JmBlOMjj0dH/XL9lrgXbKQoyyPgH8Puqbm aJd3FSnmL+qvSlB4qHaK9gjHKRz7hOSjXZ2rqMrSX31Tsy8Pnp4sKSVidDGjz04Q 4nogyH3IJM7LLZGqmz1EmOsYzv0WF1t0sL4EM7gcrjhupokrQYMAsAnVtu6I9YIB VAHlHbaVFnQMibyboWf4xi35vlIi7bGBcBnzRqRo7oc/+wIqd8g5+f6RNGIAbp2A 3K4jsF40P/S+3dAZiZ24r529ftfspaUnvbOMjeSruxzIq5g6wAgQSsMrnctIBb6G qBpGLYYsoBejxtwstojh =01nf -----END PGP SIGNATURE-----

1 0

issue with authentication
by Yamana santhosh kumar 27 Jun '15

27 Jun '15

Hello to all zope users....... I have been facing a problem with authentication in zope, i.e when i try to access the zope with *localhost:*8080/manage it is showing that the username and password , it is shown below..... [image: Inline image 1] even though i am giving correct username and password, it is showing that *you are not autherised person to access this resource ......(note:i have changed some check boxes in authentications in acl_users folder)* I hope that any body can help me to this issue.... Thanks in advance.....

3 2

Pack ZODB via cronjob without ZEO
by Jürgen Gmach 22 Jun '15

22 Jun '15

Hello, what is the current ( Zope Version: 2.13.21, python 2.7.9, linux2) recommend way to pack ZODB via cronjob/automatically given that we do not use ZEO. Thank you in advance!

3 3