- Zope - Zope lists

Re: [Zope] product organization
by J Cameron Cooper 27 Jul '05

27 Jul '05

Nicholas Wieland wrote: >> As usual, my question is rather simple :) >> I'd like to know what are the best practices for product organization >> - for example I have _tons_ of queries to sqlserver, and my main >> class is becoming less manageble every time I look at it :/ >> I like the way SQL integrates in Zope, what I don't like is having a >> giant __init__ and a lot of _sqlSomething at the end of the class. >> >> Can I associate queries to something else than a _variable ? >> Something like a dictionary or a class ? Can I move SQL calls outside >> the initializer ? I'd prefer to have a class for data access and >> another one to glue all the parts together, maybe I'm plain wrong but >> I think that my product would be a lot cleaner. >> What are the best practices for FS based products ? > If you're writing SQL queries attached to a Product and using them in said Product, you should look at ExtZSQL: http://www.zope.org/Members/jccooper/extzsql It was made for precisely this problem. --jcc -- "Building Websites with Plone" http://plonebook.packtpub.com/ Enfold Systems, LLC http://www.enfoldsystems.com

1 0

use combined propertysheet variables to form a file name for a zObject
by Allen Huang 27 Jul '05

27 Jul '05

I made a propertysheet for a customed zclass and I wish to use some variables and combine them to form a name for my newed created object. Say I have variable a = 'name a' b = 'value b' c = 'string c' what do I encode in my dtml method some_add <dtml-with "NewsClass.createInObjectManager(REQUEST['??????'], REQUEST)"> ?????? into the combination of a, b, and c ? --------------------------------- Start your day with Yahoo! - make it your home page

2 1

find a file's type
by Allen Huang 27 Jul '05

27 Jul '05

is there any dtml codes that can display a file's type? I made a site that allows a person to send up a document file. But in the end what I really wanted is to let people to upload .doc files. Since I didn't put any restriction on it, people always send up a smaller .pdf file instead. So how do I encode my webpage to show the file type of the file that have already being uploaded?? --------------------------------- Start your day with Yahoo! - make it your home page

2 1

ZPsycopg - Losing Connections
by David 27 Jul '05

27 Jul '05

Python 2.3.5 - Zope 2.7.5 - PostgreSQL 7.3.4 - Psycopg 1.1.18 - Solaris 8 (Intel) Hi I am experiencing a new problem, that was not present in the past on the above server. From the Zope error log: Exception Type OperationalError Exception Value PQsendQuery() -- There is no connection to the backend. Traceback (innermost last): Module ZPublisher.Publish, line 92, in publish Module ZPublisher.BaseRequest, line 433, in traverse Module Products.exUserFolder.exUserFolder, line 869, in validate Module Products.exUserFolder.exUserFolder, line 1133, in listOneUser Module Products.exUserFolder.pgAuthSource.pgAuthSource, line 244, in listOneUser Module Shared.DC.ZRDB.DA, line 454, in __call__ <SQL instance at 922dd70> Module Products.ZPsycopgDA.db, line 228, in query OperationalError: PQsendQuery() -- There is no connection to the backend. When I check in psql, I can see a connection still being there. Using the query: SELECT count(pg_stat_activity.datname) AS count, pg_stat_activity.datname FROM pg_stat_activity GROUP BY pg_stat_activity.datname; (Is this really showing active connections? Or just recent usage?) If I use the close connection and then open connection buttons in the Z Psycopg Database Connection in Zope, I get the connection usually back. Sometimes I have to re-submit the properties to make it work, though. Properties settings are: "Connect immediately" is checked "Use Zope's internal DateTime module (instead of mxDateTime)" is checked Transaction isolation level: Serializable Backend encoding: UTF-8 "Output Unicode strings" is not checked This is fast becoming a real headache for us! What has changed? We have recently increased the max_connections and shared_buffers for PostgreSQL and now run more Zope instances with now averaging about 40 connections from the database (using the query above). So this is an increase. Any help on how I can find out what's going on here is very welcome! (or in short: HELP, PLEASE!) Cheers

4 4

unwise.exe missing on linux
by michael nt milne 27 Jul '05

27 Jul '05

Hi Does anyone know if the zope uninstall program 'unwise.exe' can be got separately? I have installed zope on linux but the unwise.exe program isn't within the package. Thanks Michael

2 1

Zope Foundation Update
by Rob Page 27 Jul '05

27 Jul '05

Foundation Update ---------------- This note updates progress on forming of the Zope Foundation. To remain transparent as possible, we are communicating in as timely a manner as possible. First, we have contacted the Software Freedom Law Center (SFLC) which specializes in the formation and maintenance of the legal structures that support open source software. From our first conference call with our primary POC there (who also helped with the Plone Foundation), we took away some homework items including: (1) draft trademark license agreement between Zope Corporation and the Zope Foundation (2) draft/initial set of ByLaws and related formation documents that capture the spirit of what we've been discussing for a while now (i.e., Eclipse Foundation-inspired membership and Apache Software Foundation-inspired operations). We have made progress on (2) but stopped when we discovered a trademark violation that needs to be addressed before Zope Corporation can properly license the trademarks to the Zope Foundation. During my stay at EuroPython I learned that eighteen months ago (and without Zope Corporation's knowledge or consent) Zope Europe Association (ZEA) registered a trademark consisting of the Cirlce-Z (the stylized Z surrounded by a circle) followed by the word ZOPE (hereinafter "Circle-Z-Zope"). The mark they registered is identical to the corporate logo used by Zope Corporation. In the three weeks since learning of ZEA's illegitimate registration of our marks we have tried diligently (but unsuccessfully) to get ZEA to unconditionally transfer the rights of the registration. We have offered to reimburse the registration fees paid by the ZEA to the WIPO (World Intellectual Property Organization) in order to facilitate the transfer. We have further offered to preserve their license to use the Zope mark in the conduct of their business as an association of Zope companies. ZEA's registration represents an abuse of registration and management of international trademarks and the misappropriation of a mark that is clearly the property of Zope Corporation. We are sorely disappointed that ZEA is unwilling to transfer the marks quickly and quietly so that we can proceed swiftly toward the formation of the Zope Foundation. We know that the establishment of a fair trademark license for the entire Zope community is an _essential_ component of the Zope Foundation. It is possible that we will come to a conclusion with the ZEA prior to the conclusion of a trademark dispute process. However, as a result (and unfortunately), until this matter is resolved using the established legal/trademark management processes, we are not able to proceed with the Zope Foundation. We will keep the community updated as milestones are reached, so that you know what the new target dates are for the formation of the Foundation at the same time that we do. We recognize that there are lingering questions about the trademark and our management thereof. We have captured our position on these marks in an open letter to the Zope Community. You can find this letter at: o http://www.zope.com/about_us/legal/ ZopeCorpTrademarkManagement_OpenLetter.html As an aside, the ZEA has also registered the Plone logo as a trademark. It is not our business, but came as a surprise to us, that the Plone Foundation is not the owner of the Plone trademark. -- Rob Page V: 540 361 1710 Zope Corporation F: 703 995 0412

6 6

Traceback Lines for Send Mail Error
by Asad Habib 26 Jul '05

26 Jul '05

If it helps, the last lines in the traceback are as follows: Module DocumentTemplate.DT_String, line 474, in __call__ Module Products.MailHost.SendMailTag, line 116, in render Module Products.MailHost.MailHost, line 125, in send Module Products.MailHost.MailHost, line 144, in _send Module smtplib, line 254, in __init__ gaierror: (7, 'No address associated with nodename') Thanks. - Asad

4 9

How to display unicode character given its code
by Itai Tavor 26 Jul '05

26 Jul '05

Hi, This is a bit OT but this list is the best place I know to ask it :) I have a form which uses UTF-8, the text entered in the form then has to be converted to iso-2022-jp. If any character is entered that isn't valid for iso-2022-jp I get: UnicodeError: ISO-2022-JP encoding error: invalid character \u2013 What I need to do is display the offending character in the error message. So the question is, how do I take the '2013' and display the appropriate character? TIA, Itai

2 3

Running more than one instance on windows often block each other
by Sune B. Woeller 26 Jul '05

26 Jul '05

Hi list, I run a few zope instances on a windows machine (xp). I start them either with runzope.bat or as services. The behaviour below is independent of this. But sometimes a running instance (A) seems to block another instance (B) from starting. This does not happen every time. If I stop instance A and start B again, it runs fine. The funny thing is that sometimes B starts fine even with a running A. (Or vice versa). Of course I set them to run on different port numbers in zope.conf. (HTTP, FTP etc.) I can see (with the excellent (and free) 'Process Explorer' from sysinternals) that the python processes always opens port 19999, and connects by that port to themselves on another port (for instance 2550). Maybe my problem has something to do with this? Has anybody experienced the same behaviour? greetings, Sune

3 5

RE: [Zope] cpu performance zope/zeo
by John Snowdon 26 Jul '05

26 Jul '05

We're using dual cpu (not dual core) 64bit AMD Opteron (Sun Fire V20's) based systems and are VERY impressed with their performance; our python benchmarks show dual Opteron 250 systems outperforming dual twin-core Xeon 3.6GHz with the same code. Almost everything we run is ZEO based and hosted over 2 or more boxes (7 or 8 in the case of our biggest system). We couldn't be happier with the combination of Opteron and ZEO. We benchmarked 64bit Opteron, 64Bit UltraSparc III, 32bit Xeon and 64bit Xeon for our applications. Opteron trounces them all in day to day use. Sun's dual core Opteron offerings are coming out VERY soon. So that will make the V20 a 4-way system, and the V40 an 8-way system! As a guide, our standard spec for a ZEO hosted Zope server is 2 x Opteron 250/252, 4Gb, dual Gbit NIC, dual 10krpm SCSI drives in RAID1 (the main ZEO backend server is a similar spec but utilising a big SATA array in RAID50). We've found we can host 6 or so big sites (resident seize of 250mb or more) on each node and still get excellent performance by duplicating across several nodes. We have ZEO served sessions and use Pound to load balance across the pool without any stickyness - meaning on each page access users will (potentially) go to a new box - resulting in much finer grained balancing and use of resources. Performance is *excellent*. -John John Snowdon - IT Support Specialist -==========================================- School of Medical Education Development Faculty of Medical Sciences Computing University of Newcastle >-----Original Message----- >From: zope-bounces(a)zope.org [mailto:zope-bounces@zope.org] On >Behalf Of Srdan Zagorac >Sent: 26 July 2005 06:27 >To: zope(a)zope.org >Subject: [Zope] cpu performance zope/zeo > > >Hi > >I need a suggestion / advice regarding the CPU options for the best >ZOPE and ZEO performance. eg 32 vs 64 bits architecture, >single vs dual >core, hyper threading. >Is there any bechmarks already posted on the web?? > >Thanks > >-- >------------------------------------- >Srdan Zagorac >Software Developer / Webmaster / DB Administrator >Bioengineering Institute >University of Auckland >email: srdan.zagorac(a)auckland.ac.nz >url: http://www.bioeng.auckland.ac.nz >ph: +64 9 373 7599 ext. 82046 >fax: +64 9 367 7157 >------------------------------------- > >_______________________________________________ >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