- Zope - Zope lists

Re: [Zope] UTF-8 problem with zope2.10 and postgresql [Solved]
by Claire Boussard 09 Nov '09

09 Nov '09

----- "Jonathan (dev101)" <dev101(a)magma.ca> a écrit : > ----- Original Message ----- > From: "Andreas Jung" <lists(a)zopyx.com> > To: "Claire Boussard" <claibous2(a)free.fr> > Cc: "zope" <zope(a)zope.org> > Sent: Friday, November 06, 2009 12:47 PM > Subject: Re: [Zope] UTF-8 problem with zope2.10 and postgresql > > > > Am 06.11.09 17:40, schrieb Claire Boussard: > >> > >> In the HTML page > >> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" > /> > >> > > The ZPublisher does not care about that. You may set the > content-type > > explictly as HTTP header and not through http-equiv by calling > > > > RESPONSE.setHeader(key, value) > > > > (no idea how to do that using the ancient technology DTML). > > > <dtml-call "RESPONSE.setHeader('Content-Type','text/html; > charset=UTF-8')"> I tried this but it changed nothing, I think specifiying default-zpublisher-encoding utf-8 in zope.conf does the same. Eventually I have replaced <dtml-var firstname> with <dtml-var expr="firstname.decode('utf8')"> I do'nt really understand why, and it's not very convenient as I must fix all the pages, but it works! Many thanks to all who responded. Claire Boussard

2 1

Re: [Zope] Large BTreeFolder2 batching/pagination
by Ken Ara 08 Nov '09

08 Nov '09

I take your suggestion to find a Catalog-based solution. I have set the subtransactions very low (100). But I have got the following error: Traceback (innermost last): Module ZPublisher.Publish, line 119, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 42, in call_object Module Products.ZCatalog.ZCatalog, line 348, in manage_catalogFoundItems Module Products.ZCatalog.ZCatalog, line 800, in ZopeFindAndApply Module Products.ZCatalog.ZCatalog, line 559, in catalog_object Module transaction._manager, line 110, in savepoint Module transaction._transaction, line 312, in savepoint Module transaction._transaction, line 309, in savepoint Module transaction._transaction, line 737, in __init__ Module ZODB.Connection, line 1034, in savepoint Module ZODB.Connection, line 543, in _commit Module ZODB.Connection, line 571, in _store_objects Module ZODB.Connection, line 1168, in store IOError: [Errno 28] No space left on device I am guessing that this process is using the /tmp directory which unfortunately was incorrectly sized at only 1.9Gb. Can someone confirm this? Then either I must find a way to change the /tmp size, or is there a solution through Zope? Thank you. Ken --- On Mon, 11/2/09, Andreas Jung <lists(a)zopyx.com> wrote: > > We have not been successful to create a Catalog of this many objects. > The process seemed to time out after many hours, probably > hardware-bound. Also, the size of the resulting ZODB is of concern, > but we may try again with the Catalog on a mounted database. > we have ZCatalogs with millions of objects..likely you are indexing everything within one big transaction without using savepoints or subtransactions.. > -aj

2 1

UTF-8 problem with zope2.10 and postgresql
by Claire Boussard 08 Nov '09

08 Nov '09

Hello, I'm trying to upgrade my applications from debian sarge to debian lenny, so from zope2.7 to zope2.10. I've decided to have all in UTF-8 in my new server, which is the default for lenny, for postgresql also. The situation now is : In the database, all is OK If I create a ZSQL method (say sql_candidat) in the ZMI and test it, all is OK (example firstname : Andrée) If I create a dtml method, loop over my ZSQL method, and print the firstname, it's messed up. Example dtml: <dtml-in sql_candidat> <dtml-var firstname> </dtml-in> The result in the browser is : AndrÃ©e A contrario : In the page <input type="text" size="20" name="firstname:utf8:ustring" In the browser, I type Andrée, I click on submit, the data are saved through another ZSQL method (UPDATE SQl statement) and all is OK in the database In zope.conf: locale fr_FR.utf8 rest-input-encoding utf-8 rest-output-encoding utf-8 rest-language-code fr default-zpublisher-encoding utf-8 In the HTML page <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> The HTTP header (with liveHTTPheader in firefox) is correct : Content-Type: text/html; charset=utf-8 Any idea ? Claire Boussard.

9 16

Re: [Zope] sharing instance_home?
by Jürgen Herrmann 05 Nov '09

05 Nov '09

On Wed, November 4, 2009 15:05, Chris Withers wrote: > Jürgen Herrmann wrote: >> no how can i run 2 zope processes from the same instance >> home with 2 different config files? > > What version of Zope is this? > > Should be fine, provided the instances are configured to use different pid files, log files, local zodb cache files, etc... > > Chris > a few observations: - running several zope processes inside one instance_home is very simple via modified runzope shell scripts (just modify config filename) - trying the same via zopectl is a pita because: o when doing a "zopectl start" it calls runzope in the end and does not pass the config filename, instead runzope uses the hardcoded one in itself o zopectl abviously uses hard coded socket name and the daemon manager refuses to start up twice... o i got tired trying to fix that stuff, as making my own set of startup scripts calling runzope only took me very little time. works for me now. what's the point of that really complex daemon manager anyway? - i have not observed any product that puts runtime data in the instance_home, except ThreadSafeCounter which uses lock files in instance_home/var. i want to share these lock files between processes anyway, so this is rather good than bad. no problems with my other products. best regards, jürgen -- >> XLhost.de - eXperts in Linux hosting ® << XLhost.de GmbH Jürgen Herrmann, Geschäftsführer Boelckestrasse 21, 93051 Regensburg, Germany Geschäftsführer: Volker Geith, Jürgen Herrmann Registriert unter: HRB9918 Umsatzsteuer-Identifikationsnummer: DE245931218 Fon: +49 (0)800 XLHOSTDE [0800 95467833] Fax: +49 (0)800 95467830 WEB: http://www.XLhost.de IRC: #XLhost(a)irc.quakenet.org

1 0

sharing instance_home?
by Jürgen Herrmann 04 Nov '09

04 Nov '09

currently i'm running a single zope2 process with relstorage as storage backend. to improve performance for our end users i'd like to fire up a 2nd zope2 process that will handle all internal background processes and db packing. for simplicity's sake i'd like to share the instance_home directory between these two processes, just use a different config file to enter a different http port for each server. no how can i run 2 zope processes from the same instance home with 2 different config files? modifying $INSTANCE_HOME/zopectl to include a different config file name does not work, as it's also contained in $INSTANCE_HOME/runzope. renaming/modifying runzope does not work either, as it's name is hardcoded somewhere in zopectl. thanks in advance and best regards, jürgen herrmann -- >> XLhost.de - eXperts in Linux hosting ® << XLhost.de GmbH Jürgen Herrmann, Geschäftsführer Boelckestrasse 21, 93051 Regensburg, Germany Geschäftsführer: Volker Geith, Jürgen Herrmann Registriert unter: HRB9918 Umsatzsteuer-Identifikationsnummer: DE245931218 Fon: +49 (0)800 XLHOSTDE [0800 95467833] Fax: +49 (0)800 95467830 WEB: http://www.XLhost.de IRC: #XLhost(a)irc.quakenet.org

3 5

Large BTreeFolder2 batching/pagination
by Ken Ara 02 Nov '09

02 Nov '09

We have some BTreeFolder2's containing hundreds of thousands of objects, even one containing over 2 million instances of Folder. That is really no problem in itself. Under our setup, beyond 300-400,000 contained objects, the batching provided by getBatchObjectListing becomes unusable. I've seen this problem mentioned somewhere but never any hint of a solution. We have a new application that will require pagination, or ideally, the ability to go forward and back through the items (any order). Is there a way to refer to the contained items by something like offset? It might be easy if the objects had sequential, consecutive numeric ids, but sadly this cannot be the case. We are using the BTreeFolder2-1.0.2 version that came with Zope 2.10. Thanks. Ken

2 4

Local File System Product
by Jan Schulze 23 Oct '09

23 Oct '09

Hi all, I have to upgrade a very old Zope/Plone site, that is using the "Local File System" Product (http://sourceforge.net/projects/localfs/) This Product has not seen any new release since 2002. Is there any successor Product or is it possible to use default Plone mechanisms to do what localfs does? Best Regards, Jan

3 2

Zope3 on Ubuntu 64
by Brian Myers 19 Oct '09

19 Oct '09

I've installed Zope3 on a 64 bit Ubuntu platform and all seems well. I've run mkzopeinstance and the instance directory is there and looks ok. However, when I try to start the instance, it says [fail] for the zserver instance and there are no entries in the z3.log file. The default instance chosen was 9673, not 8080. I wonder if that's saying it's not finding an available port. But I've port scanned the machine and both 9673 and 8080 are open. Any ideas what to try next? How do I enable more logging output? Thanx in advance, Brian

4 4

Prevent a logger from writing to event.log
by Bert Vanderbauwhede 16 Oct '09

16 Oct '09

Hi, Is it possible to have a logger in Zope that doesn't write to the event.log? All the other loggers can write to the event.log, but just this one logger should not. -- Bert Vanderbauwhede -- "I don't know if you noticed or not, but I'm an extremely arrogant man, who thinks all his plans will work." Rodney McKay, Stargate Atlantis

3 2

Problem with Zodb connections pool
by Claudio Battaglino 14 Oct '09

14 Oct '09

Hi all, I've a system with Zope 2.8.8 that since some weeks is very slow. The python process keeps busy the CPU (98-99%) and the memory used by the process is growing up. Every day a script makes a pack of the ZODB and restarts Zope so the Data.fs size is stable (about 350MB). In the event.log I can see many of this warnings: 2009-10-14T11:59:14 WARNING ZODB.DB DB.open() has 8 open connections with a pool_size of 7 What does it mean? I can see also some of these messages: 2009-10-14T12:14:16 INFO ZODB.Conflict database conflict error... According to you, are the two messages related? Thank you very much claudio

3 2