- Zope - Zope lists

zope.org product pages problem: swrelease_edit_form
by Tobias Herp 21 Oct '03

21 Oct '03

Hi, editing my software release (http://zope.org/Members/to_be/htmlarea3/0.5.1/swrelease_edit_form) I got the following error message: Your user account does not have the required permission. Access to 'edit' of (SoftwareRelease at /zopeorg/Members/to_be/htmlarea3/0.5.1) denied. Your user account, to_be, exists at /acl_users. Access requires one of the following roles: ['Manager', 'Reviewer']. Your roles in this context are ['Anonymous', 'Authenticated', 'Member', 'Owner']. Could please someone fix the permissions to enable the Owners to manage their content? Thanks, Tobias

3 2

RE: [Zope] RDBMS Applications and direct calling of script(python)andsql methods
by Derek S. Wilson 21 Oct '03

21 Oct '03

Yeah, using dtml-sqlvar fixed it. I'm having a different problem now... I need to get a list of users in ACL_USERS to create a form where people can assign stuff to different users. Here's the code for the display... <SELECT NAME="AssignedTo"> <dtml-in "acl_users.getUserNames()"> <OPTION LABEL="<dtml-var sequence-item>" VALUE="<dtml-var sequence-item>"><dtml-var sequence-item></OPTION> </dtml-in> </SELECT> But when I try it using a regular (non-manager/owner) it says: Error Type: Unauthorized Error Value: You are not allowed to access getUserNames in this context What could be wrong? Thanks, Derek Wilson -----Original Message----- From: Erik Myllymaki [mailto:erik.myllymaki@aviawest.com] Sent: Thursday, October 09, 2003 4:34 PM To: Derek S. Wilson; zope(a)dylanreinhardt.com; Eric Merritt Cc: Zope Users Subject: Re: [Zope] RDBMS Applications and direct calling of script(python)andsql methods I use this ZSQL method to return the ID number of my users: ------------------------------------------------------------------------ ---- ------------- select employee_id from staff where login = <dtml-sqlvar "REQUEST.get('AUTHENTICATED_USER')" type=string> ------------------------------------------------------------------------ ---- ------------- > Says keyerror AUTHENTICATED_USER when I try it. > > Thanks, > Derek Wilson > > > -----Original Message----- > From: Erik Myllymaki [mailto:erik.myllymaki@aviawest.com] > Sent: Thursday, October 09, 2003 3:54 PM > To: zope(a)dylanreinhardt.com; Eric Merritt > Cc: Zope Users > Subject: Re: [Zope] RDBMS Applications and direct calling of > script(python)andsql methods > > > > On Thu, 2003-10-09 at 13:36, Eric Merritt wrote: > > > Lets take simple example, assume that each user has > > > an id that is keyed to his 'stuff'. The zsql method > > > must be passed this id to access his stuff. This is > > > all fine and good, A script(python) method could > > > provide this to the zsql method behind the scenes > > > without any great issue. The problem comes in when the user > > > attempts to access this zsql method from via its url. Going this > > > route he could pretty easily supply and arbitrary id and get > > > access to information that he shouldn't have. > > > > Yes, that would be a problem... so don't do it that way. :-) > > > > Instead, have Zope provide you the name of the user from its > > authentication machinery. That's *much* harder to spoof. > > > > To get this, cook up a Python script called get_user and use this > > for the code: > > > > ---- > > from AccessControl import getSecurityManager > > return getSecurityManager().getUser().getUserName() > > ---- > > > > Now include a call to get_user() when you need to pass in the > > username > > > as a parameter to your query. > > > Any reason why you shouldn't just use <dtml-var AUTHENTICATED_USER> > as a parameter to your SQL query? > > just curious... > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev )

2 1

RE: [Zope] Invalidate RAM cahce manager programatically
by Jim Kutter 21 Oct '03

21 Oct '03

Ok. What I am doing is rather than get data from the DB directly, I "cache" it in a Zcatalog. This give me the added side benefit of using the ZCTextIndex's search capability for all content on my site as well. How I do this is this: certain SQL methods use classes to massage the result set into a loose class (there are no or few methods on these classes). Then that class is passed to the Zcatalog with it's row_id as the object identifier. Here's the code sample that adds "feature" objects to the catalog (the metadata_ids are unique and constant). Python script catalogItem(metadata_id=0) exists in my feature ZCatalog if metadata_id is not 0: <-- whoops. Just saw this funny, the code seems to work though features = context.sql.feature.getMetadata(metadata_id=metadata_id) else: features = context.sql.feature.getMetadata() for feature in features: print "Cataloging metadata_id: %s<br>" % feature.metadata_id # get my authors and their companies for author in context.sql.feature.getAuthors(metadata_id=feature.metadata_id): print "Adding author: %s<br>" % author.name feature.addAuthor(author) feature.setPreferredTopic(context.sql.feature.getPreferredTopic(feature. metadata_id)) uid = '%s' % feature.metadata_id print "Added to catalog with ID: %s<br>" % uid container.catalog_object(feature, uid) return printed I do this for almost all other "content types" we have here with little or no change. Could that goof with the "is not 0" be the cause for the uncatalog issue? -jim -----Original Message----- From: Chris Withers [mailto:chrisw@nipltd.com] Sent: Wednesday, October 15, 2003 8:47 AM To: Jim Kutter Cc: zope(a)zope.org Subject: Re: [Zope] Invalidate RAM cahce manager programatically Jim Kutter wrote: > What I discovered was that calling catalog_object doesn't re-catalog the > SQL results like I thought it would. I had to uncatalog_object first, > then catalog_object to have the changes from the database kick in. I > presumed that multiple calls to catalog_object would overwrite the > ZCatalog's entry with new data. They do, you must be doing something pretty weird for this not to work. What does your code which calls catalog_object look like? Chris

2 1

FYI: Epoz 0.5.2 released
by Maik Jablonski 21 Oct '03

21 Oct '03

Hi, I've just packed up a new release of Epoz - the cross-browser-wysiwyg-editor for Zope & Plone (and of cource all other Zope-based applications). Epoz requires IE >= 5.5, Mozilla >= 1.3.1 or Netscape >= 7.1. Where can I download Epoz? http://www.zope.org/Members/mjablonski/Epoz Can I see a demo (sorry, not updated yet)? http://mjablonski.freezope.org/epoz/test.html/edit And now the changes in no special order... - Added strikethrough-button. Now you can use Epoz to correct websites online if you are a teacher...;) - Added nice workaround for all people who want cleaner html-code from Epoz: switching the views (wysiwyg, source) automatically before submitting the form will give you browser-cleaned-up-code (Mozilla does a nice job, IE is crap anyway). - Added hungarian-translation. Thanks to Tamas Decsi and Gabor Suveg! - Fixed bug in epoz_toolbox. The default_charset was broken. Thanks to Marian Saeger for the patch! - Fixed a minor bug in the Plone-Toolbox: Images with single quotes in the title weren't opened in the popup. Thanks to Tony Addyman. - Added a dummy blank page. IE breaks over SSL if no source is given in the inline frame. Thanks to Brian Brinegar for his patches! - Sanitized the Epoz-init-string in __init__.py with dictionary. Thanks to Philipp von Weitershausen for his patch! - Improved i18n-layer. Untranslated strings will now fall back to default-english. Thanks to Sergey Volobuev for his help and patches! - fixed typo in the example in the README.txt. Thanks to Luiz Fernando. Hope you like it... Cheers, Maik

3 6

problem CMFOODocument
by johan 21 Oct '03

21 Oct '03

Hi, I have the following problem : I try to install CMFOODocument into Products directory. As far as I know I intsalled libxml2, libxslt and its python bindings, according to http://www.icoya.org/download_area/zope/libxml2-zope When I rebooted zope, I receive the following error , apparently problem with lixml2mod.so. Anybody has an idea ? Greetings, Johan Traceback (most recent call last): File "/usr/local/src/zope/lib/python/OFS/Application.py", line 541, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/usr/local/src/zope/lib/python/Products/CMFOODocument/__init__.py", line 19, in ? import OODocument File "/usr/local/src/zope/lib/python/Products/CMFOODocument/OODocument.py", line 46, in ? import libxml2 File "/usr/lib/python2.1/site-packages/libxml2.py", line 1, in ? import libxml2mod ImportError: /usr/lib/python2.1/site-packages/libxml2mod.so: undefined symbol: xmlValidateNamesValue Zope Version (Zope 2.6.1 (source release, python 2.1, linux2), python 2.1.3, linux2) Python Version 2.1.3 (#1, Sep 7 2002, 15:29:56) [GCC 2.95.4 20011002 (Debian prerelease)] System Platform linux2

1 0

RE: [Zope] Zope Advice for Java Man
by Meilicke, Scott 21 Oct '03

21 Oct '03

Oh - that reminds me, I was able to setup an excel sheet as an ODBC source (on a windows server). However no one could edit the excel file to update it since it was locked by the ODBC driver. Hence my move to COM. Scott -----Original Message----- From: J. Cameron Cooper [mailto:jccooper@jcameroncooper.com] Sent: Monday, October 20, 2003 4:06 PM To: Zope Users Subject: Re: [Zope] Zope Advice for Java Man >>>Can I convert an Excel sheet to read into Zope? >>> >>> If you mean looking at live data from Zope in Excel through ODBC or something then probably not unless you store your data in an external relational database (though I'm really not familiar with all those MS things). --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought." _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.

2 1

APE and version control?
by Johan Carlsson 21 Oct '03

21 Oct '03

Hi Shane, I'm a bit interested in what you meen by "apply version control to your objects". How would this work? Ape/doc/outline.txt : """ Finally, the framework is useful for many purposes outside ZODB. Once you have built a system of mappers, you can use those mappers to import and export objects, synchronize with a data store, and apply version control to your objects. The concepts behind ApeLib open exciting possibilities. """ Best Regards, Johan Carlsson -- Johan Carlsson Tel: + 46 8 31 24 94 Colliberty Mob: + 46 70 558 25 24 Torsgatan 72 Email: johanc(a)easypublisher.com SE-113 37 STOCKHOLM

3 10

DBTab, ZEO and DirectoryStorage
by Dario Lopez-Kästen 21 Oct '03

21 Oct '03

Hi, sent this to the dirstorage-list but no one had tried this combination yet, so I am trying at zope(a)zope.org instead. I am about to try to replace LocalFS with DirectoryStorage for an, eventually, huge number of files and documents uploaded to our Zope app. LocalFS does not conceptually work over ZEO, so I am switching to use DirectoryStorage and store everything in the ZODB instead. I am planning on using DBTab with DirectoryStorage and ZEO. Are there any problems that I should be aware of? Regarding configuration, DBTab has support for custom storages not known to it but I need help infiguring out how to configure DBTab for using DirectoryStorage Any help is appreciated, /dario - -------------------------------------------------------------------- Dario Lopez-Kästen, IT Systems & Services Chalmers University of Tech.

1 0

Re: [Zope] creating objects in dtml?
by Dylan Reinhardt 21 Oct '03

21 Oct '03

[forwarded to list] On Mon, 2003-10-20 at 19:32, Ted holden wrote: > > > What I really need is for a user to open a dtml page and create (his/her) > > > object in doing so, and then use it. > > > > That's certainly possible... but then what? You want this object to > > only exist during the time the user has a session? > > > > To answer the first part, the URL to create a new instance of a product > > is usually something of the form: > > > > container/manage_addProduct/product_name/product_nameAdd > > > > Again, thanks. Is there an example of something like that lying around > somewhere? Take a look at the code behind the "Add" pick list in the ZMI. That has a number of examples. And please keep the discussion on the list. On this list, pressing "reply" will only address your reply to one person, not the whole list. Unless your mail client has a "reply to list" option, the correct way to maintain a discussion on this list is "reply to all". That may seem bizarre, but it's how Mailman works (by default) and if you spend any time on Python lists, you'll need to learn to live with it. :-) HTH, Dylan

1 0

Re: storages comparation
by Josef Meile 20 Oct '03

20 Oct '03

> > * fiability > > Is that a spelling erorr?. He, he, nice to see that I'm not the only one who invents english words, am I inventing something now? :-) By the way, he wanted to say "reliability". I guess he speaks spanish or a similar language. Anyway, the point is that I saw your matrix and found it great. I just have another question related to it: How easy is migrating from FileStorage to the other ones? (with a simple zope installation and a zope installation with ZEO). I think it would be a good point for the matrix too. Thanks, Josef

3 2