July 2005 - Zope - Zope lists

Zope 2.8 Installation trouble on XP
by Pedro Cristian 28 Jul '05

28 Jul '05

Hi everyone, I'm a beginner in Zope. I've just installed the Zope 2.8 final package. The installation seems to have completed normally. However when the zope instance is run I have the following message : C:\Zope-Instance\bin>runzope.bat C:\Zope-Instance\bin>"C:\Zope-2.8.0-final\bin\python.exe" "C:\Zope-2.8.0-final\l ib\python\Zope2\Startup\run.py" -C "C:\Zope-Instance\etc\zope.conf" Traceback (most recent call last): File "C:\Zope-2.8.0-final\lib\python\Zope2\Startup\run.py", line 56, in ? run() File "C:\Zope-2.8.0-final\lib\python\Zope2\Startup\run.py", line 17, in run import Zope2.Startup File "C:\Zope-2.8.0-final\lib\python\Zope2\__init__.py", line 60, in ? from Zope2.Startup.run import configure File "C:\Zope-2.8.0-final\lib\python\Zope2\Startup\__init__.py", line 26, in ? from ZConfig.components.logger import loghandler ImportError: No module named components.logger There was no previous message with keyword "loghandler" in the mailing list. All Zope services are stopped. Here are the system variable that are relevent : CONFIG_FILE=C:\Zope-Instance\etc\zope.conf INSTANCE_HOME=C:\Zope-Instance Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Pi nnacle\Shared Files\InstantCDDVD\ PYTHON=C:\Zope-2.8.0-final\bin\python.exe PYTHONPATH=C:\Zope-2.8.0-final\lib\python SOFTWARE_HOME=C:\Zope-2.8.0-final\lib\python ZOPE_HOME=C:\Zope-2.8.0-final ZOPE_RUN=C:\Zope-2.8.0-final\lib\python\Zope2\Startup\run.py The Zope instance is the one created by the install package. Seems that something is not working with my configuration, but what? Pedro ___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com

5 7

ZSQLMethod conditional insert
by Thomas Olsen 27 Jul '05

27 Jul '05

Hi This is probably an FAQ but I haven't been able to find and answer. I need a counter for a certain CMFType and want to store the hits in a MySQL database not to fill up the ZODB. I've checked to two suggestions below but they both use two ZSQLMethods first to check if the URL is already in the table, then to do the actual update or insert. http://www.zope.org/Members/element/Simple_SQL_Page_Counter http://zopelabs.com/cookbook/991116439 I'd like to be able to do that just in one ZSQLMethod for efficiency but I cant seem to figure out a way of doing it. The table is very simple: CREATE TABLE mostread ( path varchar(255) NOT NULL default '', num bigint(20) NOT NULL default '0', dt datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (path) ) For now my ZSQLMethod get the argument "path" which is a relative URL and it looks like this: select @lastval:=num from mostread where <dtml-sqltest path type="string"> <dtml-var sql_delimiter> update mostread set num=@lastval+1, dt=now() where <dtml-sqltest path type="string">; </dtml-if> But that naturally only works if there is already a record containing "path". What I want to do is something like this (pseudo-code): select @lastval:=num from mostread where <dtml-sqltest path type="string"> <dtml-var sql_delimiter> <dtml-if "sequence-length > 0"> update mostread set num=@lastval+1, dt=now() where <dtml-sqltest path type="string">; <dtml-else> insert into mostread(path, num, dt) values(<dtml-sqlvar path type="string">, 1, now()) </dtml-if> Is there a way of doing this or should I just create that extra ZSQLMethod? -- Med venlig hilsen Thomas Olsen http://www.headnet.dk

3 4

Re: [Zope] ZPsycopg - Losing Connections
by Felipe Barousse Boue 27 Jul '05

27 Jul '05

Fernando: I have downloaded the source from http://initd.org/pub/software/psycopg/PSYCOPG-1-1/ and compiled it (in RH FC4 and RHEL3, tough) with no problams whatsoever. I am using Zope 2.7.5, Python 2.3.5, Psycopg sources 1.1.19 and PostgreSQL 8.0.3 The only advice would be to upgrade your postgresql to 8.0.3 since the version you are using is a bit outdated. Best regards. Felipe Barousse Boué Piensa Technologies - Bufete Consultor de Mexico www.piensa.com On Wed, 2005-07-27 at 12:00 -0400, zope-request(a)zope.org wrote: > Message: 15 > Date: Wed, 27 Jul 2005 13:45:52 +0100 > From: Peter Bengtsson <peterbe(a)gmail.com> > Subject: Re: [Zope] ZPsycopg - Losing Connections > To: Fernando Lujan <flujan(a)gmail.com> > Cc: zope(a)zope.org > Message-ID: <bc95c280050727054543ca3a7e(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > On 7/27/05, Fernando Lujan <flujan(a)gmail.com> wrote: > > On 7/27/05, David <davidr(a)talamh.org.uk> wrote: > > > Python 2.3.5 - Zope 2.7.5 - PostgreSQL 7.3.4 - Psycopg 1.1.18 - > > > Solaris 8 (Intel) > > > > > > The Psycopg version 1.1.19 solves this problem. :) > > > The 1.1.19 version isn't in debian yet. > $ apt-get show python-psycopg > shows only 1.1.18 :(

1 0

Does Plone need the Zope CMF?
by michael nt milne 27 Jul '05

27 Jul '05

Hi This isn't clear to me. I've installed Zope and Python from source but do I need to also install the Zope CMF for Plone to run properly? This isn't mentioned specifically any where if so. It would good to have some of these components wrapped up etc for easier install. I couldn't find the RPM's on the site. Michael

3 2

reportlab and images
by Nicholas Wieland 27 Jul '05

27 Jul '05

I know, I'm flooding the list ... I use images inside my reports, so I have to open PIL-image objects inside my product. Everything is fine, but I must use the full path, like /Zope-Instance/Products/foobar/image/blah.png, and this is a problem, because the product will have a different path when put in production. My solution is to have a class variable to use, like: imagepath = "/Zope-Instance/.../image" and then use that variable to build the path, but I think it's ugly. How do you solve this problem and just use 'image/blah.png' just like ZPTs, knowing that all image files will be stored in an "image" subdirectory of the product ? TIA, ngw --------------------------------- Yahoo! Messenger: chiamate gratuite in tutto il mondo

2 1

Re: [Zope] product organization
by Nicholas Wieland 27 Jul '05

27 Jul '05

Well, not exactly - just a way to separate access to data from everything else in the product. Maybe a separate class that needs the connection as argument and that just returns the data I need in appropriate data structures by calling class methods. class DataModel (object): def __init__ (self, conn): self.conn = conn self.sqlFetchSomething = SQL (.....) def fetchSomething (self): return self.sqlFetchSomething This is really simple, but I think it gives the idea. Obviously I'd like to perform various operation at the data level, for example return a list of lists for reportlab tables and so on. TIA, ngw --------------------------------- Yahoo! Mail: gratis 1GB per i messaggi, antispam, antivirus, POP3

2 1

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