- Zope - Zope lists

Problem with AdManager
by David 03 May '05

03 May '05

Hi Setup is: Zope 2.7.5, Python 2.3.5 (UNIX/gcc 2.95) (No ZEO, no CMF, no Plone!) We are trying to use the AdManager ZClass, a great product doing exactly what we needed. Testing this on the developer's machine, we had no problems. But having now done a "small scale" stress testing (requesting about 20 pages per second) on the server, some pages suddenly throw errors of the following kind (see traceback below). The errors are not all 100% like this one, but similar enough, I guess. The errors occur on a ratio of about 1:4 (so 4 successful pages, then one error). [I know this is not really scientific or would stand in a statistical analysis, but just to give you an idea.] We could also not find any connection between the errors and any of the 5 banners we're using for testing. (The product rotates which banner is displayed.) -- from the traceback -- ZODB.POSException.ReadConflictError Sorry, a site error occurred. Traceback (innermost last): Module ZPublisher.Publish, line 175, in publish_module_standard Module ZPublisher.Publish, line 149, in publish Module ZPublisher.Publish, line 149, in publish Module ZPublisher.Publish, line 149, in publish Module ZPublisher.Publish, line 139, in publish Module Zope.App.startup, line 163, in zpublisher_exception_hook Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module OFS.DTMLMethod, line 144, in __call__ Module DocumentTemplate.DT_String, line 474, in __call__ Module DocumentTemplate.DT_Var, line 214, in render Module OFS.DTMLMethod, line 137, in __call__ Module DocumentTemplate.DT_String, line 474, in __call__ Module DocumentTemplate.DT_Var, line 214, in render Module OFS.DTMLMethod, line 137, in __call__ <DTMLMethod instance at 91a9b90> URL: /advert_chooser/manage_main Physical Path:/advert_chooser Module DocumentTemplate.DT_String, line 474, in __call__ Module DocumentTemplate.DT_With, line 76, in render Module OFS.DTMLMethod, line 137, in __call__ <DTMLMethod instance at 9281cb0> URL: /site/advertisements/show_banner/manage_main Physical Path:/site/advertisements/show_banner Module DocumentTemplate.DT_String, line 474, in __call__ Module DocumentTemplate.DT_With, line 76, in render Module DocumentTemplate.DT_In, line 703, in renderwob Module DocumentTemplate.DT_Util, line 192, in eval __traceback_info__: date_end Module ZODB.Connection, line 599, in setstate Module ZODB.Connection, line 628, in _is_invalidated ReadConflictError: database read conflict error (oid 0x3244, class *ilYYN6piu7CmJucspzx0gA==.AdBanner) -- end traceback -- Any idea what is happening here?? This is beyond my understanding of Zope/ZODB and as it only happens occasionally, it does not seem to be a straight bug. Any suggestions on what I could try would be very welcomed. (If you are using a Banner Ad Manager that is a proper product, not a ZClass, that runs on a plain Zope, let me know.) Thanks in advance, DR

2 1

[ANN] TextIndexNG 3.0 beta 1 released
by Andreas Jung 03 May '05

03 May '05

I am pleased to announce the release of TextIndexNG V 3 beta 1. TextIndexNG V 3 is a complete new implementation based on Zope 3 technologies and can be used both in Zope 2.8 or 2.7 (with Five) or in Zope 3. What's new? - multi-field indexing and query support - multi-lingual support - configurable converters (through ZCML) - new indexing API (allowing you to hook your custom content types with TextIndexNG through Zope 3 adapters). Requirements: - Zope 2.8 or Zope 2.7 (+ Five) or Zope 3 (Zope 3 has nothing like catalogs yet) TextIndexNG V3 will *not* run with bare Zope 2.7 installations without Five (and this will not be changed in the future). Download: http://sf.net/projects/textindexng For installation issues refer to doc/README.txt from the archive. It's basically the same procedure as with former versions except you *need* to recompile the extension modules. TextIndexNG V 3 is published under the GPL. Andreas Jung ----------------------------------------------------------------------- - Andreas Jung ZOPYX Software Development and Consulting - - E-mail: info(a)zopyx.com Web: www.zopyx.com - -----------------------------------------------------------------------

1 0

(no subject)
by cla 03 May '05

03 May '05

Hi would like to know how to put multiple dynamic drop down boxes in zope using dtml or python scripts(if possible) scheme: box1:----> box2 --> box3 --> ... call database and fill call database and fill thanks O SAPO já está livre de vírus com a Panda Software, fique você também! Clique em: http://antivirus.sapo.pt

6 5

bypass authentication
by u1207440 03 May '05

03 May '05

I made a signup form for my website and I want to check if the username already exists in acl_users folder without having to log in as administrator. How do I do that, what and where do I have to modify my permission for so I can use acl_users.getUser(REQUEST.name) without having to login first?? (Zope tells me that I don't have permission to use the getUser method)

2 1

ZSQLRelay Problem
by Evrim Ozcelik 02 May '05

02 May '05

Hi, My zope server is running on fedore core3. I want to connect to ms sql server running on windows xp platform using FreeTDS, SQLRelay and ZSqlRelayDA. My sqlrelay.conf can be seen below: <?xml version="1.0"?> <!DOCTYPE instances SYSTEM "sqlrelay.dtd"> <instances> <instance id="mssql" port="9000" socket="/tmp/examplesocket" dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="reconnect" debug="none"> <users> <user user="evrim" password="123456"/> </users> <connections> <connection connectionid="db1" string="sybase=/usr/local/etc/freetds.conf;user=evrim;password=123456;server=MyServer2k;db=LKSDB;" metric="1"/> </connections> </instance> </instances> As you seen there is only 1 listener socket created. I can execute the first sql command successfully but i can't execute the second command. The sqlrelay error shown in the log file: Client Library error: severity(78) layer(0) origin(0) number(51) Error: Attempt to initiate a new SQL Server operation with results pending. I think the connection does not end after the execution. When all the listener sockets used the system becomes useless. Then i restart the sqlrelay service in order to clear the sockets. What must i do ? The listener socket must be empty after the execution.

1 0

RE: [Zope] high loads, more threads, spinning wheels
by Jim Abramson 02 May '05

02 May '05

Thanks Stefan & Jens... > > if yes, would upping the number of ZODB connections > effectively raise > > the ceiling - e.g. 12 ZODB connections -> 12 threads should perform > > properly ? Is increasing the number of ZODB cx's > possible, let alone > > advisable? (why the default of 7 - not 6 or 8?) > > > > Upping the number of threads is unlikely to give you better > performance. The only case where this could make sense is if > you had something like a highly saturated RDBMS backend, > tying up your worker threads. > Well this is *exactly* the issue I'm facing. I need to soften the impact of this situation if possible, and it's going to be ZEO in the end, but rolling this out is probably not going to be possible in the very short term. > But - Zope threads don't operate like you probably expect > from knowing Apache and similar models. For one, they *never* > will run in parallel. > Python employs a global interpreter lock (GIL), so there will > only be a single thread "working" at all times. What you want > is to up the number of processes (interpreters) not the > number of threads. Hence ZEO. > So far I've done some very off-the-cuff tests upping the threads/connections to 12/16 and banging on it with jmeter. The results were favorable in comparison to the default config. Could this have been a fluke? Jim

3 2

Charset
by Jean＠adimp.ch 02 May '05

02 May '05

Hello the list, In Zope.conf ( ZOPE 2.7.5-final ) I changed "rest-input-encoding" and "rest-output-encoding" to send "UTF-8" and then restarted the server. But in my webbrowser, the files are always received in "windows-1252". Please, what can I do to receive UTF-8 from ZOPE 2.7.5-final? Best regards. Jean Tinguely. ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.

5 7

RE: [Zope] high loads, more threads, spinning wheels
by Jim Abramson 02 May '05

02 May '05

Can this be taken to mean that: - the practical maximum number of threads to run your single (non-ZEO) zope instance is {number of zodb connections in pool} else you risk deadlock if yes, would upping the number of ZODB connections effectively raise the ceiling - e.g. 12 ZODB connections -> 12 threads should perform properly ? Is increasing the number of ZODB cx's possible, let alone advisable? (why the default of 7 - not 6 or 8?) More concretely, is there any good way to increase the request-handling capacity of a standalone instance, beyond the limits imposed by the defaults, without deploying ZEO? > > To put it in a very simple way, you should not tweak the > threads setting unless you really know what you are doing. If > your goal is performance the usual way of going about that is > to run ZEO and add ZEO clients as needed. > > You're bumping into the very simple fact that there are two > items interacting badly: Threads and the connections in the > Zope database connection pool. A thread, under normal > circumstances, can only do work if it has a connection to > work with, and wwill only release the connection when the > request is finished. There are 7 connections in the pool by default. > > jens >

4 3

upload into a ZObject
by u1207440 01 May '05

01 May '05

Does anyone know how to upload a file or an image into a ZObject? I have created a simple ZClass that makes ZObjects to simulate book information like title, author, etc. I have selected to upload images and files into the ZObject, but I don't have a clue what dtml codes I should use to do that. Can anyone give me some pointers?? Also, if I have a book object that was stored in either one of two folders a and b (assuming don't know where) and I need to get its internal information like the book title and author, how do I look for it using dtml??

2 1

Security issues
by cla 01 May '05

01 May '05

Hi! Im developing a portal using, zope and i had been some problems with the security of some template pages that I have created. Those pages are accesible just puting the correct path in the url, even if they are only for manager access. I have already try the security tabs that are associated to witch document, but with no sucess. What can i do to resolve this big problem. thanks SMS GRÁTIS do seu PC para qualquer rede nacional (TMN, Vodafone, Optimus e PTC). Basta instalar o SAPO Messenger e adicionar amigos! Vá agora a : http://messenger.sapo.pt/sms/

2 2