May 2009 - Zope - Zope lists

Re: [Zope] convert python to dtml
by Jaroslav Lukesh 06 Aug '09

06 Aug '09

> Odesílatel: Exteam <exteam6(a)yahoo.co.in> > hi all, > i'm stuck at this point, > can some one convert thge following python code in to > dtml & help me. > i'm not able to convert it in to dtml. Why do you want to recode into DTML? I think that is piece of good code and much faster than DTML. You could try following replacing (original line of your code, follows with DTML code), but not tested: > rec = context.test_select_sql() <dtml-call "REQUEST.set(rec , test_select_sql())"> > print "Fields definitions" Fields definitions > recordset = rec.dictionaries() <dtml-let "recordset = rec.dictionaries()" > rownum = 1 <dtml-call "REQUEST.set(rownum,1)" > for record in recordset: <dtml-in recordset> > print "Row %d" % (rownum), "check", record Row <dtml-var rownum>, check <drml-var sequence-item><br> > rownum = rownum + 1 <dtml-call "REQUEST.set(rownum,rownum+1)" </dtml-in> and so on on the rest of code. > for key in record.keys(): > print key, "=", record[key] > print "-" * 80 > return printed

3 7

Announcing: Zope 4.0 project
by Tres Seaver 04 Aug '09

04 Aug '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On behalf of the Zope community, I am pleased to announce the creation of the "Zope 4.0" project. After extensive discussion with the Zope wizards in conclave at PyCon 2009, the new project's website has been launched: http://zopefour.org/ Enjoy! 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.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJ01VR+gerLs4ltQ4RAiljAKCACB9aMtI3YnsXPZss4hdEDrA7FACgsqv7 3jR6FQeEy0qpX4D4NOX+HsA= =q8Fu -----END PGP SIGNATURE-----

19 73

Zsql and oracle CLOB column
by harshad behere 27 May '09

27 May '09

Dear list, While inserting data into one of the oracle table's CLOB column using zsql via python script, we observed that zope process (running in debug mode) is getting terminated/killed if length of text data >= 4094 with message on command prompt Input string too long, limit 4096 Whereas for text data with length >=4001 and <=4093 - It throws following error OperationalError on <Products.mxODBCZopeDA.ZopeDA.DatabaseConnection "DSN=test_clob_oracle" thread 3672/3672 at 0x3ac3530>: ('HY000', 1704, '[Oracle][ODBC][Ora]ORA-01704: string literal too long\n', 6113) python script details: print context.clob_zsql_test(i_description='A'*4095). return printed zsql details - INSERT INTO CLOB_TEST(description) VALUES(<dtml-sqlvar i_description type="string">) Table/column details : id - number description - clob Where as if we use mxODBCZopeDA execute API with following insert query syntax string_value = 'A'*5000 query = """ INSERT INTO CLOB_TEST(document) VALUES(?) """ result = test_connection.execute(query, string_value) it works fine even with text data having length > 10000 After googling on the same found that execute method uses/support parameters binding (is it similar to oracle bind varibles ? thats may be reason why it works well). Do we have similar support for zsql or is there other workaround ? Configuration/other details are as follows : RDBMS : Oracle Database 10g Release 10.2.0.1.0 ODBC used : Oracle ODBC which shipped with Oracle-Client-10g Python adapter : mxODBC Python ODBC Interface - 2.1 Related Zope Product : mxODBCZopeDA-1.0.10 Zope : Zope 2.11.1-final Python : python 2.4.4 Operating system : win32 ZEO setup : Yes No of ZEO nodes : one Threads per ZEO node : 10 Any kind of pointers/suggestions would be of great help. Thanking you, Harshad.

1 1

Error packing database
by Fabian Schoeck 27 May '09

27 May '09

Dear list, when trying to pack my data base, I get the following error: ------- 2009-05-26T18:30:52 ERROR ZODB.DB packing Traceback (most recent call last): File "/var/www/zope/lib/python/ZODB/DB.py", line 605, in pack self._storage.pack(t, referencesf) File "/var/www/zope/lib/python/ZODB/FileStorage/FileStorage.py", line 1377, in pack self._commit_lock_release() error: release unlocked lock ------ 2009-05-26T18:30:53 ERROR Zope.SiteErrorLog http://localhost:8080/Control_Panel/Database/main/manage_pack Traceback (innermost last): Module ZPublisher.Publish, line 115, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 41, in call_object Module App.ApplicationManager, line 426, in manage_pack Module ZODB.DB, line 605, in pack Module ZODB.FileStorage.FileStorage, line 1377, in pack error: release unlocked lock ------ I searched the web for help, but did not find anything really helpful. Is this due to some timeout of the web browser? The Data.fs is quite large (7 GB). Should I rather pack the data base via shell and not using the ZMI? What is the command to do so? Thanks, Fabian

2 1

Re: [Zope] Installing Zope 3
by Jan Ulrich Hasecke 26 May '09

26 May '09

I think that http://www.zope.org/Products/ should be updated. No chance for a newbie to find http://wiki.zope.org/zope3/Zope3Wiki juh

3 3

Installing Zope 3
by Jan Ulrich Hasecke 26 May '09

26 May '09

Hi all! What if I want to read Philipps book about Zope 3 – shall I download the Zope 3 tarball from zope.org 3.3.1 from 2007-01-14? This looks pretty old and outdated. Zopeproject does not install all packages that are needed for the examples in the book. Any hint how to install Zope, if you want to follow the book? juh

1 0

[action required] Zope Contributor Agreement change
by Jens Vagelpohl 24 May '09

24 May '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, Please exclude the mass-email, most of you will receive this more than once, we're hoping to catch any current contributor whose email address on zope.org is not current. Anyone who has svn.zope.org checkin privileges and has not received personal email with the content below, please read and follow the instructions, otherwise you may find yourself without access. Thanks! jens - ----------------------------------------------- You may be aware that the copyright for software stored in the software repositories on svn.zope.org has recently been assigned to the Zope Foundation, from the earlier copyright holder Zope Corporation. The old contributor agreements expressly assigned a joint copyright to Zope Corporation for any software checked into svn.zope.org repositories. With the Zope Foundation taking over these copyrights, the agreement with the contributors needs to change so that the Zope Foundation is the joint copyright holder for all new code coming into the repositories. For you as a contributor this means you need to submit a new contributor agreement[1] if you want to stay on as an active contributor to Zope and/or the other software hosted in the repositories on svn.zope.org. Here's how: - - download the new agreement[1] - - fill in the new agreement, and since you are a current contributor it is OK to enter Jim Fulton (jim(a)zope.com) as the required reference committer - - sign and date the agreement - - either scan the agreement and email it to foundation-info(a)zope.org, or fax it to the Zope Foundation fax number +1 (703) 842-8076 To ensure a timely copyright transition we ask you to submit the new contributor agreement no later than June 17, 2009. The Zope Foundation board will try to contact any contributor who has not replied at that point between June 18 and June 26, and on June 26 checkin access will be removed for those who have not sent in the new agreement. Thanks again for your support! Jens Vagelpohl Secretary, Zope Foundation Board of Directors [1] http://foundation.zope.org/agreements/ZopeFoundation_Committer_Agreement -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.8 (Darwin) iEYEARECAAYFAkoZOwkACgkQRAx5nvEhZLLfxwCglA45Oyk3fIr8uUasH5O4BQc9 VIEAnA2Tdk/Yh3C5bDlnIcaCklcQd/Ci =/wUA -----END PGP SIGNATURE-----

1 0

Redirecting from inside a TAL macro ...
by Analog Kid 20 May '09

20 May '09

Hi All: I have a macro that is used in several other page templates. In some circumstances, I need to redirect to another URL. Can I do this using python:here.REQUEST.RESPONSE.redirect(<NEWURL>) so that the master page that uses this macro is redirected to the NEWURL? Regards, G

3 2

Pyexpat and Zope 2.9.5
by Fabian Schoeck 19 May '09

19 May '09

Dear list, I am trying to get Zope 2.9.5 compiled with Python 2.4.3 using the python-ldap module. I compiled my own Python and copied the site-packages, so the ldap module is available. When I run "import ldap", the module is imported correctly. Then I run "configure" in my Zope folder, which gives me the notification that I need pyexpat installed. However, I do have the pyexpat.so exactly in the run path that it should be (the path is also printed in the error message). Is this a known problem or could you give me advice what I am doing wrong? If I compile Zope with the --ignore-expat option, then I get the following error message ('xml.sax.drivers2.drv_pyexpat'), so this is not an option for me. Thanks, Fabian

1 0

Script (python) config
by Joseph Thomas (s) 18 May '09

18 May '09

We upgraded from zope 2.9 to 2.10 and in the process upgraded plone as well. There's script that simply returns a list of groups to which a user belongs. In the old system both users in the system and not in the system (ie ids not in zope) would get HTTP 200 when invoking the script thru a URL (obviously the non-system users would get an empty list).. Now when system users invoke the script the script returns the list of groups to which they belong, however, when a user not in the system invokes the script it returns a 401. Is there some authentication/security setting that we're missing that's preventing non-system users invoking the script? We may have overlooked some small thing (file system permissions, ZMI permissions, authentication settings etc) when configuring things in the upgraded environment....any ideas would help. Thanks Consider our environment; please print this e-mail only if truly necessary. Thank you!

2 1