- Zope - Zope lists

Error when connecting to MYSQL
by Thomas Adams 30 Jan '05

30 Jan '05

Hello Zopistas, I'm currently using MySQL-python 0.9.2 Zope 2.7.3 Pythom 2.3.4 MySQL 4.0.16 ZMySQLDA 2.0.9 When I try to create or open a mysql database connection I get the following error message: Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.ZRDB.Connection, line 163, in manage_open_connection Module Products.ZMySQLDA.DA, line 126, in connect Module Products.ZMySQLDA.db, line 193, in __init__ AttributeError: server_capabilities Does anybody have an idea about this. Have I used the right versions of the tools above

2 1

Accessing the ZODB from other applications via ODBC on windows
by Thomas Adams 29 Jan '05

29 Jan '05

Hello, Perhaps this is a newbie question, but I didn't find something similar in the list now. I want to connect to the ZODB from another applications (something that runs on windows, in this case it should be in MS Access), and read some data entries which I need for this application. Is there a ODBC-Diver availabe for the ZODB, that allows one to access the ZODB from another application? Regards Thomas Adams

3 2

User-private folderish object
by Richard Jennings 29 Jan '05

29 Jan '05

Hi All, A python product I am developing needs a 'user-private' folderish object. This seems to be a need that others might have solved but googling has not turned up any results. If I have to do this, my first strategy would be to as follows: Use a __before_publishing_traverse__ hook on my root object to create a session data object. Use its onAdd method to create the user-private object in the root object. Use its onDelete method to destroy the user-private object. I am assuming that this will cause the owner of the 'user-private' object to be the person who logged in and that setting its __ac_roles__ as 'Owner' will limit access to the object to just the session owner. (seems a bit complicated, though!) My question to the Zope cognoscenti is: Is this a viable strategy? Is there a better solution? I use python 2.3 & Zope 2.7.1 TIA Rich

2 1

WEBPAGE ERROR
by Lopez Melvin 29 Jan '05

29 Jan '05

Greetings, Please help me with this error. http://67.19.219.106:88/QIPRO/index Please let me knwo how to fix it. I think is the Siteroot, but we don't know how to fix it.

1 0

January Bug Day Roundup
by Chris Withers 28 Jan '05

28 Jan '05

Hi All, Well, it was certainly a quiet one. Both Andreas and myself were busy and things felt very quiet indeed... One 3 issues resolved, but lots of work done by Tres on some nasties. Special mention must go to brentmh/Crouton who was brave enough to try and solve a bug in dtml's sequence stuff: http://collector.zope.org/Zope/456 Brave man! Anyway, looks like not-having-it-on-a-Friday was major flop, even the one person who always asks for it not to be on a Friday wasn't there, so we'll see you all again, last Friday of February! cheers, Chris PS: Here's the lowdown: Resolved: #533 - ZMI "find" doesnt find in File with text #1469 - win32 install 2.7.2 XP SP1 #1648 - bug with medusa FTP Wontfix: #1331 - Most Frequently used product selection #1418 - Hotfix for TAL issue has no version check Rejected: #1422 - AssertionError after installing Zope Hotfix Release, 2004/07/13 #1485 - Re-ocurrence of Hotfix_2002-03-01/security_alert #1555 - more flexible logger config (duplicate) #1578 - Mounting a non-folder object fails #1670 - No log out button in Zope ..and here's the "player stats" :-) Resolved Assists Wontfix Rejected Deferred shh 1 ajung 1 chrisw 1 1 1 5 tseaver 3 Tiran 1 Crouton 1 -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk

2 1

Performance Monitoring
by Marc Burgauer 28 Jan '05

28 Jan '05

Hi After having tried to get a couple of commercial apps running without success (lack of platform support), I wonder if somebody on the list can point me to a product. I need to build a server cost model for an existing Zope/PostgreSQL app, currently running on Solaris/Intel. I want to be able to measure: - CPU and Memory load of PostgreSQL, Zope and Apache processes - Disk usage - Network usage I am not a UNIX guru, hence I was looking to a commercial solution, assuming I'll learn from it. I need to be able to predict requirements as usage is increasing. Any help very appreciated. Cheers Marc -- Marc Burgauer Sharedbase Solutions Ltd 60 Dumfries Road Elvanfoot ML12 6TF http://www.sharedbase.com Tel: +44 (0) 870 765 5600 Fax: +44 (0) 1864 505 166 Mob: +44 (0) 7909 913 903 Company registration: SC226521 VAT registration: 789 7904 46 Registered office: 29 Brandon Street, Hamilton ML3 6DA

2 1

adding dtml/zpt methods to product classes
by Keith Alperin 28 Jan '05

28 Jan '05

Greetings Zopistas! I have been a Zope tinkerer for a few years and have never been able to adequately solve this problem: When I create a Product class with DTML/ZPT methods, how can I make those methods members of the class rather than simply instance methods? These examples should illustrate what I mean. My first try was like this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def __init__(self,resourcePath, imageFolder): self.my_method = Globals.HTMLFile("dtml/my_method",globals()) That works fine until you want to add a new method to your class like so: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def __init__(self,resourcePath, imageFolder): self.my_method = Globals.HTMLFile("dtml/my_method",globals()) self.my_new_method = Globals.HTMLFile("dtml/my_new_method",globals()) new instances of your product will get the my_new_method, but instances that have already been created will not. My second try was like this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def my_method(self, REQUEST): """ template """ if (not hasattr(self,"my_method_member")): self.my_method_member = Globals.DTMLFile("dtml/my_method",globals()) return self.my_method_member(self,REQUEST) This allows me to add methods to the class at any time and all instances will get the method. However, for some reason, when I use this pattern, i get strange acquisition results (for example, some of my objects children's dtml methods will use the parent's namespace for lookups). Currently, I'm doing this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def my_method(self, REQUEST): """ template """ self.my_method_member = Globals.DTMLFile("dtml/my_method",globals()) return self.my_method_member(self,REQUEST) which seems ugly, and like it might have performance problems, but i haven't had any acquisition problems yet. My real question here is: What is the standard way to handle this problem of being able to add dtml/zpt methods to classes such that all instances of those classes get the new methods? Thanks in advance for any insight. Sincerely, Keith Alperin

2 2

Is Zope in Use in the law firm sector?
by Maik Ihde 28 Jan '05

28 Jan '05

Hi there does anyone know of a succesful Zope-Project (especially together with CMF/Plone or similar CMS) in a major law firm ? Background: We use a Zope-based CMS for our Website and are also using a small Plone based Intranet App for our IT Department. At the moment there is a strong interest in implementing a solution which shall cover Intranet, collaborative Document Management, eLearning and various "Connectors" to other Systems like SAP R3 and Lotus Notes. Of course there are some hi-class ECMS Systems like Hyperwave which go into that direction. But these are expensive pieces of software, and I personally would rather like to see a Zope based solution here. I know of a few major Zope Projects in Germany, like the ones at Ver.di (largest trade union in Germany) and TU München (Technical University of Munich) which address really large Scale Installations. But are there any references about Intranet Solutions for larger law firms with like 500-1500 Users? Kind Regards Maik

1 0

Investigating a reference leak...
by Ben Last (Zope) 28 Jan '05

28 Jan '05

Dear Zopistas I've been trying to track down what's either a memory or a reference leak in a Zope 2.7.3 (Python 2.3.4) system. The symptoms are that after several days of normal running on the agressively proxy-cached production site or a few hours on the development site under simulated load, the number of OFS.Image.Image references reaches very high levels, such as 17761. In the cache at that time are just 4345 images. There are only 1332 images on the whole site, so assuming (as I understand it) that each of the 5 Zope thread has its own cache, there should be a maximum of (1332 * threads) = 6660 Images. The site never creates new Images, it just loads existing ones. In a bid to see where these references are being created, I installed LeakFinder, but that doesn't help me because Images are persistent objects, and thus their __init__ methods are not called (LeakFinder appears to patch just the __init__ and __del__ methods for tracking). Thus I've been on a quest to find a place to stick a patch that will show me, for a persistent object, from where a reference to it is being created. I've tried __setstate__, and overridden it for OFS.Image.Image to print a traceback to stdout. Then I run the development Zope site with bin/runzope and watch. This shows me Images being created in the expected places, but not in quantities that would explain those huge refcounts. So; to questions: 1) Is there a better place than __setcache__ to identify where references to Images are being created? I don't fully understand the way in which persistent objects are actually created and populated. 2) Our site is very dependent on ExternalMethods (Zope provides the visual layout, business logic is in ExternalMethods, all from one module). In some of those methods, the code loads Images in order to look up information about them - this is because we have some particular standards for things like Image tags which the built-in tag() method can't support, so we have to build our own. Thus there's code like: img = getattr(self.Images,'image.gif') #all images live in /Images, got by acquisition from self buildTag(img.title,img.width,img.height) #use image attributes to build fuller tag del img #avoid leaving references around (this is paranoid!) Is there any reason that this is bad practise? I see __setstate__ for images being called from this code and then again shortly afterwards when the Image is served up to the browser. I'd be very grateful for any help on this! Regards to all Ben Ben Last Technical Director SleepyDog

2 2

RE: [Zope] adding dtml/zpt methods to product classes
by Pascal Peregrina 28 Jan '05

28 Jan '05

Why don't you simply define the DTML/ZPT objects attributes outside any class method ? class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): my_method = Globals.HTMLFile("dtml/my_method",globals()) my_new_method = Globals.HTMLFile("dtml/my_new_method",globals()) ... This is what I do, and any new DTML/ZPT object I define that way gets added to any existing instance of this class type when I restart Zope (or when refresh my product). Pascal -----Message d'origine----- De : zope-bounces+pperegrina=lastminute.com(a)zope.org [mailto:zope-bounces+pperegrina=lastminute.com@zope.org]De la part de Keith Alperin Envoyé : vendredi 28 janvier 2005 04:59 À : zope(a)zope.org Objet : [Zope] adding dtml/zpt methods to product classes Greetings Zopistas! I have been a Zope tinkerer for a few years and have never been able to adequately solve this problem: When I create a Product class with DTML/ZPT methods, how can I make those methods members of the class rather than simply instance methods? These examples should illustrate what I mean. My first try was like this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def __init__(self,resourcePath, imageFolder): self.my_method = Globals.HTMLFile("dtml/my_method",globals()) That works fine until you want to add a new method to your class like so: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def __init__(self,resourcePath, imageFolder): self.my_method = Globals.HTMLFile("dtml/my_method",globals()) self.my_new_method = Globals.HTMLFile("dtml/my_new_method",globals()) new instances of your product will get the my_new_method, but instances that have already been created will not. My second try was like this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def my_method(self, REQUEST): """ template """ if (not hasattr(self,"my_method_member")): self.my_method_member = Globals.DTMLFile("dtml/my_method",globals()) return self.my_method_member(self,REQUEST) This allows me to add methods to the class at any time and all instances will get the method. However, for some reason, when I use this pattern, i get strange acquisition results (for example, some of my objects children's dtml methods will use the parent's namespace for lookups). Currently, I'm doing this: class HyperTextArea(Implicit, Globals.Persistent, RoleManager, Item): def my_method(self, REQUEST): """ template """ self.my_method_member = Globals.DTMLFile("dtml/my_method",globals()) return self.my_method_member(self,REQUEST) which seems ugly, and like it might have performance problems, but i haven't had any acquisition problems yet. My real question here is: What is the standard way to handle this problem of being able to add dtml/zpt methods to classes such that all instances of those classes get the new methods? Thanks in advance for any insight. Sincerely, Keith Alperin ********************************************************************** 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