- Zope - Zope lists

Deny public access to ZMI
by Ustun Kaya 17 Jun '09

17 Jun '09

Hello, Is there a straightforward way of defining which IPs are authorized to access to ZMI? I want to block public interface access and allow it only from internal network - VPN. I don't want authentication box to pop up to any single visitor with a browser. It is Zope 2.9.4. As I searched, I came across with docs of how to write scripts to define access rules to the specific folders. Should I go that way and implement an access rule for /manage? Thanks, Ustun

3 3

external method
by Garry Saddington 16 Jun '09

16 Jun '09

I have the following external method to back up a postgres database, using the following software versions. Zope Version (Zope 2.9.0, python 2.4.2, win32) Python Version 2.4.2 (#67, Sep 28 2005, 12:41:11) [MSC v.1310 32 bit (Intel)] System Platform win32 Zope is running as user scholarpack who is an administrator on win server 2008. / import subprocess def backup(): try: p=subprocess.Popen("c:/scholarpack/postgres/bin/pg_dump scholarpack",shell=True,stdout=subprocess.PIPE) data=p.communicate()[0] f=open('c:/scholarpack/ancillary/scholarpack.sql','w') w=f.write(data) f.close() except OSError: print "There was a problem opening the file for writing" /When I run this through Zope I get an empty file. There are no errors reported. However, if I use the same python that is running zope in an interactive shell and run these commands then it works as expected. Can anyone spot what I am obviously missing? Regards Garry

3 6

Re: [Zope] How to move acl_users from a Zope 2.7.8 server to Zope 2.10.7 ?
by Aleksey Tsalolikhin 12 Jun '09

12 Jun '09

Hi. I am moving a Web application from a Zope 2.7.8 server to 2.10.7. How do I migrate the users in acl_users from the Zope 2.7.8 server to the 2.10.7 one? Andreas Jung suggested exporting it from the old server and importing in the new. Apparently this worked (although I had to blow away the "acl_users" folder on the new server before I could import the "acl_users" folder from the old server; and I had to use zpasswd.py to create "inituser" and "access" files in my Zope root so that I could access the ZMI to import the acl_users folder.) I have very little experience with Zope so I turn to you guys, is this a totally insane thing I did, or is it absolutely correct and I (and Andreas) should be rewarded? :) I did try using the copy_users.py script but had no luck with it. :( The record of my attempt follows. If somebody has experience with migrating acl_users from one server to another, please write me! http://www.zope.org/Products/CMF/docs/admin/andrew_PTK2CMF/view http://www.zope.org/Members/ensane/PTK2CMF/copy_users.py I put the copy_users.py file in /var/lib/zope/Extensions and added it as an External Method (fill out the form as copy_users, copy_users, copy_users and copyUsers) then add a DTML Method as per the instructions ------------------------------------------------------------------------------- I created a DTML Method called do_copyUsers: <dtml-call "copy_users('acl_users', 'copy_of_acl_users')"> but when I ran it, I got: Site Error An error was encountered while publishing this resource. Error Type: KeyError Error Value: 'copy_of_acl_users' Troubleshooting Suggestions * This resource may be trying to reference a nonexistent object or variable 'copy_of_acl_users'. * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the error log. If the error persists please contact the site maintainer. Thank you for your patience. so I created an empty folder called copy_of_acl_users and tried running my DTML method again ,but got: ite Error An error was encountered while publishing this resource. Error Type: AttributeError Error Value: _addUser Troubleshooting Suggestions * The URL may be incorrect. * The parameters passed to this resource may be incorrect. * A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the error log. If the error persists please contact the site maintainer. Thank you for your patience. I also tried removing /copy_of_acl_users and recreating it again, but this time I checked the "create user folder" box. Tried running my DTML method again, but again got Error Type: AttributeError Error Value: _addUser I also created a copy of the acl_users folder in /aleksey_temp/acl_users Modified my DTML method to: <dtml-call "copy_users('acl_users', 'aleksey_temp/acl_users')"> and when I ran it, Zope output a zero byte file called do_CopyUsers Best, Aleksey

3 5

scope of <dtml-let> tag
by indrajit926 indra 12 Jun '09

12 Jun '09

Hello All, I faced a parsing error when I used <dtml-if> and <dtml-let>, like below -----some dtml code----- <dtml-if CONDITION> <dtml-let some_function> <dtml-else> <dtml-let other_function> </dtml-if> -----some code------- ------------------------ </dtml-let> The above code gives parsing error about unexpected </dtml-if> It works fine when I give as below <dtml-if CONDITION> <dtml-let some_function> -----some code------- ------------------------ </dtml-let> <dtml-else> <dtml-let other_function> -----some code------- ------------------------ </dtml-let> </dtml-if> Any help on about this behaviour of <dtml-let>. Thanks in advance, Indra.

2 1

Is there a Zope migration tool?
by Aleksey Tsalolikhin 11 Jun '09

11 Jun '09

My Zope 2.10 server tells me: Note: Zope can export/import objects in two dfferent formats: a binary format (called ZEXP) and as XML. The ZEXP format is the officially supported export/import format for moving data between identicial Zope installations (it is not a migration tool). The XML export/import is unsupported (and possibly broken under certain circumstances) - use it at your own risk. I am moving a Web app from Zope 2.7 to 2.10. I exported it from 2.7 and imported to 2.10 and this worked. But then I saw the above note. Is there a migration tool? Where is it, please? Thanks, Aleksey -- Aleksey Tsalolikhin UNIX System Administrator "I get stuff done!" http://www.verticalsysadmin.com/ LinkedIn - http://www.linkedin.com/in/atsaloli

3 4

Getting Auto Increment value
by Merav Ben-David 11 Jun '09

11 Jun '09

I am working with zope & mysql. I have a table with SERIAL column type, I create "z-sql method" for insert operation, how can I get the value for the auto increment column? I know that in mysql I can call last_insert_id(), how do I call it, should I create another "z sql method" and if I do, how can I be sure the the value return is for my insert command and not for another. Is there a way to call 2 query from the same "z sql method"? I am really lost on this, any help will be wellcom. Thank in advanced.

4 3

ZeoRAID usage in production
by Miles Waller 07 Jun '09

07 Jun '09

Hi, This is mainly a question for Christian, but I'm cc'ing the list as it will be useful knowledge to be generally available. I was looking at this product and thinking about using it in an upcoming assignment. >From the docs: "Keep backups of your data. ZEORaid has good unit test coverage but hasn't seen live action yet, so keep this in mind." - is this still the case? Is anyone else using it at the moment at all for demanding sites? Could you post some stats, experiences and any gotchas at all? How does ZeoRAID cope with the blob storage? Also, what's the timeout for connecting to the zeo storages? Also, I read this bit in the docs: "The RAID server itself remains the last single point of failure in the system. This problem is solved as the RAID server does not maintain any persistent state (except the configuration data: it's listening ip and port and the list of storages). The RAID server can be made reliable by providing a hot-spare server using existing HA tools (taking over the IP when a host goes down) and the existing ZEO ClientStorage behaviour." Is it possible to provide a "pool" of ZeoRAID processes, each talking to the same zeo storages, and put the list of ZeoRAID processes into the client storage configuration so it will round-robin if one is not available? Many thanks for your help, Miles

2 1

call http_host script
by iarly selbir | ski0s 05 Jun '09

05 Jun '09

There are some variable similar $_SERVER['HTTP_HOST'] ( in php ) using Plone? Thanks in advance. Regards, - - iarly selbir | ski0s :wq!

4 4

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