- Zope - Zope lists

Re: Re: [Zope] Zope -> MySQL Weirdness
by Tom Rectenwald 28 Nov '04

28 Nov '04

> > From: Cliff Ford <Cliff.Ford(a)ed.ac.uk> > Date: 2004/11/27 Sat AM 09:50:03 GMT > To: Tom Rectenwald <seldan(a)verizon.net> > CC: zope(a)zope.org > Subject: Re: [Zope] Zope -> MySQL Weirdness > > What happens when you run a Select query from the Test tab of the > Database Connection object (select * from <tablename>)? That sometimes > gives a more explicit error message from the database. > > Cliff > > Tom Rectenwald wrote: > > Hello, > > > > I am just starting to learn Zope and am having trouble getting it > > to communicate with mySQL. > > > > Here is what I have done thus far: > > > > - Built and compiled MySQLdb and ZMySQLDA. > > - Installed the 'Z MySQL Database Connection. > > - Entered in the 'Database Connection String' (DB, user, password) > > > > Once done, I went to the 'Test' tab and here is where things get > > weird: > > > > - I can run an INSERT statement with no trouble and verify that > > the DB is updated. > > - However, whenever I run any sort of SELECT query I get the > > following error: > > > > Error Type: TypeError > > Error Value: object does not support item assignment > > > > > > I also get this error when trying to put a SELECT in Z SQL Method. > > I'm very new at this stuff and come from a PHP/Perl/mySQL/postgreSQL > > background, so any help at all is appreciated. If desired, I can > > send the error_log output as well. I just don't get it. :-( > > > > Thank you for an help, suggestions, advice. I've googled this to > > bits to no avail. I am really enjoying Zope so far; just wish I understood it better. > > > > Regards, > > Tom > > > > _______________________________________________ > > 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 ) > Hello, My apologies for the late response. I was getting the same error when running from the test tab. As it turns out, I was running Zope 2.8.01a. Perhaps it was just a compatibility issue. I removed that and compiled Zope 2.7.3 and everything is working wonderfully now. Thanks all for the help. Tom

2 1

displaying view restricted and non-restricted objects together
by Tom Germaine 27 Nov '04

27 Nov '04

I am having a problem restricting view of ZClass objects in a subfolder with local roles defined when they are displayed alongside non-restricted objects. I am using LDAPUserFolder to restrict access to management screens, with authorization linked to Novell groups and passwords; this is working well. I am trying to use same authorization to restrict viewing of dtml documents in a subfolder with a local role defined identical to Novell group names; security is set so that view and view contents of the subfolder is for group members only. Authorization works but for one glaring problem: - when displaying all folders and subfolders contents (titles of dtml documents only) using dtml-tree as in: <dtml-tree (top-level folder id) branches_expr="objectValues(['Folder','(ZClass object)'])" sort=title> authorization is required to display ANY dtml document titles (because the restricted access document titles are also being displayed). What I would like is to have all titles displayed and authorization to view the restricted ones enforced only when trying to access them, because there are multiple subfolders in the tree, each with unique access restrictions. Is there a way to use dtml-tree to accomplish this? I have tried <dtml-tree...skip_authorization=1...> but this just removes the titles of the restricted documents from being displayed, and so makes accessibilty to them impossible. Maybe I should be trying to set the security on the individual dtml document view properties, but don't know what property to define and how to use it. Tom Germaine ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Tom Germaine User Support Help Desk UPEI Computer Services tgermaine(a)upei.ca 566-0465 ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

1 0

RE: [Zope] psyco
by Pascal Peregrina 27 Nov '04

27 Nov '04

Sorry, I did a mistake, in SpeedPack, "monkey patching" is for CMF skins optimization... not ZPT (ZPT is optimized with psyco). -----Message d'origine----- De : zope-bounces(a)zope.org [mailto:zope-bounces@zope.org]De la part de Pascal Peregrina Envoyé : samedi 27 novembre 2004 17:56 À : zope(a)zope.org Objet : RE: [Zope] psyco Some people have made a product that use psyco and also do some "monkey patching" for ZPT optimizations. See http://sourceforge.net/project/showfiles.php?group_id=55262 : SpeedPack I have been using it for a while without any issues. It looks like trying to use psyco.optimize() or psyco.profile() in Zope startup scripts does not work. (I mean the Zope instance does not start correctly). So you have to psyco.bind() every class, or class method you want to speed up. Also, I discovered that you must not use psyco with publishable methods in products (this is if you develop your own Zope products). I mean any method that have REQUEST object in it's named parameters or that is supposed to get its parameters from the HTTP request params. If you psyco.bind() such a method, REQUEST (or params) are None. So for my products I psyco.bind() manually some classes methods, but not the whole class. This is just my own experience of it. I was not able to find documentation. In terms of results, the improvement are "visible", but I have no exact figures to give you. So I would say it's worth trying. Pascal -----Message d'origine----- De : zope-bounces(a)zope.org [mailto:zope-bounces@zope.org]De la part de John Poltorak Envoyé : samedi 27 novembre 2004 17:36 À : zope(a)zope.org Objet : [Zope] psyco How effective is psyco at speed up Zope? I'm interested in speeding up Zope/Plone and would like to know the options available. Is there a Howto on this sort of topic? -- John _______________________________________________ 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 ) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** _______________________________________________ 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 )

1 0

RE: [Zope] psyco
by Pascal Peregrina 27 Nov '04

27 Nov '04

Some people have made a product that use psyco and also do some "monkey patching" for ZPT optimizations. See http://sourceforge.net/project/showfiles.php?group_id=55262 : SpeedPack I have been using it for a while without any issues. It looks like trying to use psyco.optimize() or psyco.profile() in Zope startup scripts does not work. (I mean the Zope instance does not start correctly). So you have to psyco.bind() every class, or class method you want to speed up. Also, I discovered that you must not use psyco with publishable methods in products (this is if you develop your own Zope products). I mean any method that have REQUEST object in it's named parameters or that is supposed to get its parameters from the HTTP request params. If you psyco.bind() such a method, REQUEST (or params) are None. So for my products I psyco.bind() manually some classes methods, but not the whole class. This is just my own experience of it. I was not able to find documentation. In terms of results, the improvement are "visible", but I have no exact figures to give you. So I would say it's worth trying. Pascal -----Message d'origine----- De : zope-bounces(a)zope.org [mailto:zope-bounces@zope.org]De la part de John Poltorak Envoyé : samedi 27 novembre 2004 17:36 À : zope(a)zope.org Objet : [Zope] psyco How effective is psyco at speed up Zope? I'm interested in speeding up Zope/Plone and would like to know the options available. Is there a Howto on this sort of topic? -- John _______________________________________________ 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 ) ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

1 0

psyco
by John Poltorak 27 Nov '04

27 Nov '04

How effective is psyco at speed up Zope? I'm interested in speeding up Zope/Plone and would like to know the options available. Is there a Howto on this sort of topic? -- John

1 0

Zope/Plone API
by jlegris 26 Nov '04

26 Nov '04

Hi Everyone, Does Zope/Plone have a comprehensive API doc similar to JavaDocs? Any pointers would be appreciated. Thanks Joel

4 3

calling scripts from scripts and permission
by massimop＠users.berlios.de 26 Nov '04

26 Nov '04

Hi I would like to call script (the one called 'Script (python)', it should manage the properties of a Folder) from another that have a proxy of Manager My guess was that in this way the first one would be executed with Manager role, but actually I was wrong... it complain that I'm not "allowed to access 'manage_changeProperties' in this context" Am I doing something weird, or is this the way it should work? P.S. the same (first) script, called on the same Folder object whe the authenticated user is the owner of the Folder, works thanks massimo

3 3

Displaying SQL results correctly
by Dean Hale 25 Nov '04

25 Nov '04

Hi I'm extracting content from a database which contains several numbers for example 72, 354. Each number is separated by commas. The numbers correspond to other id's within the table. I'm using below which kind of works however the url is specified as http://157.228.32.93:9191/education/nug_db/detail_html?id=72,%20354 and i'm using below to get the results CourseLike is the field which corrospond to other ID's - 72, 354 CourseTitle is the course title <a href="" tal:define="CourseLike result/CourseLike" tal:attributes="href string:detail_html?id=$CourseLike" tal:content="result/CourseTitle" target="_blank"> <span tal:replace="result/CourseTitle">CourseTitle goes here</span></a> i'd like each id to be repeated separately rather than in the one long url. Any help appreciated. Thanks very much dean --------------- Dean Hale Web Development Manager Information Services University of Sunderland w: http://www.library.sunderland.ac.uk t: +44 (0) 191 515 2424 f: +44 (0) 191 515 2904

2 1

'Unable to find binary "lynx.exe" ' when using Zope's find
by Robert Hill 25 Nov '04

25 Nov '04

I have migrated a Zope site from Linux to Windows, understanding that Zope is platform independent. Everything seems to have gone smoothly, with the exception of one glitch. Whenever I try to use the ZopeFind from the ZMI I get the following error: Error Type: MissingBinary Error Value: Unable to find binary "lynx.exe" Any ideas as to why the site would be dependent on lynx? I'd really like to fix this as it is a fairly large site and I rely on the ZMI's find feature quite often to find the location of scripts and PTs.

10 11

Database Connections
by Jason Leach 25 Nov '04

25 Nov '04

hi: With Psycopg I have noticed that if the DB server is restarted (or just the Database) that Psycopg does not re-connect very well to the DB. Is this a known problem or just on my end? I seem to remember my MySQL server conneciton doing the same back when I used MySQL. Thanks, Jason.

3 2