- Zope - Zope lists

mysterious dataloss clues?
by Martijn Faassen 26 Aug '01

26 Aug '01

Hi there, I'm posting this in the hope someone will be able to help me with some mysterious data lossage we've been experiencing. I basically am completely clueless what could be the cause of this, so any hint would be useful. Some boring numbers first: We have an application running on Zope 2.3.0, connecting to Postgresql 7.0 using ZPoPyDA 1.2. The version of PoPy is 2.0.2. This is on Debian 2.2 (with some upgraded packages such as Postgresql). Now to the meat of the issue: For some reason, at random times, Postgresql seems to magically lose some records that were already there and should've been committed. This seems to happen within a few hours of the time the records were first created. All trace of the records disappears from the database; we can see the holes in the autoincrement primary key fields (and we never do any delete ourselves that could cause this). The lossage seems internally consistent; a bunch of records that's interrelated all disappears. The records disappearing are not all part of a single Zope transaction; instead there are bunch of ZSQL insert operations in a set of pages. It's just as if there's some kind of long running transaction that at some point magically expires. Very weird. We haven't been able to reproduce the problem; it just seems to happen. Vaguely associated with it is another, possibly related problem; occasionally Zope does not see a record with an id that is definitely in the database. After a few more tries, it works again. We haven't been able to confirm a firm temporal relationship between this problem and the one described, but it's possible one somehow affects the other. Is it possible that due to some strange interaction postgresql's transaction machinery ends up in some flakey state, so that something is never committed that really should be? I'm now trying to change all the tires and the engine as well; upgrading this and that to see if the problem will go away. But some clues in which direction I should search would be greatly appreciated. Anyone ever saw something like this? I really wish I could be more specific. :) Regards, Martijn

2 2

Re: [Zope] Advice needed: load balancing wih ZEO and Apache on Solaris.
by Bak ＠ kedai 26 Aug '01

26 Aug '01

> >My question is this; > >What can I do to get requests from myserver.ncl.ac.uk farmed out to my ZEO >server-client farm? we've been using balance as a front end to all our ZCs, and everything is peachy. there's another balance like program at freshmeat that'll do the same (forgot the name). balance.sourceforge.net

1 0

Namespace question
by complaw＠hal-pc.org 25 Aug '01

25 Aug '01

I have an object with a built-in method (called "check_id") for determining whether the value from a retrieved object has the same id as one of the elements in the current object's lines property. What I want to do is make an edit form that has a <SELECT> element with a complete list of object id's of a given type (meta_type = 'Doctrine') and compare each of those id's to the id's stored in the current object's lines property. If there is a match, I want the <OPTION SELECTED> statement written. Otherwise, it would be simply <OBJECT>. Note, the Doctrine object has (of course) an id. The lines property has a list of id's that are subsets of the total number of Doctrine objects. Here is the code... <SELECT NAME="doctrines:list" SIZE="5" MULTIPLE> <dtml-in "objectValues('Doctrine')"> <dtml-if "check_id(sequence-item.id)"> <OPTION VALUE="<dtml-var id>" SELECTED><dtml-var title></OPTION> <dtml-else> <OPTION VALUE="<dtml-var id>"><dtml-var title></OPTION> </dtml-if> </dtml-in> </SELECT> The question that I have is that <dtml-if "check_id(sequence-item.id)"> doesn't work. Any hints as to what the problem might be? TIA, Ron

3 2

zope as databasefrontend?
by Ralf Duda 25 Aug '01

25 Aug '01

Hello, maybe I'm on the way against the zope internal philosophy ... We use a postgresql Database and MS Access :( as frontends. Now we would like to use zope as frontend and skip Access. The Access applications are quit simple but depents on a rather complex permission structure, realized in postgresql. Now to zope ----------- One way is to create a zope connection with the highest access permissions on the database. Now if a user logged in, a script checked out what the user is allowed to do (maybe with complex SQL statements and special database rows). :( In my opinion a better way would be: A user logged in and then the database connection would be established, with the username/password and of course the right database permissions. This connection should be open until the user logout. :) I haven't found any hind on this kind of connection. (Late database connection) In general, is it possible to do it? Must it realized it completely in a extra phyton script? (sounds complicated) Or is there maybe any example, which I had not found? o) Thank's for any help! best regards, Ralf Duda

2 1

Can anybody Help?
by Todd Loomis 25 Aug '01

25 Aug '01

I've created a form that allows users to create folders, however I need to assign permissions to the folders which match there roles. Also I'm using Zope 2.2.5 and need way to make form logins, can this be down? Thanks, Todd

3 2

ZMC and Loginmanager Help
by Todd Loomis 25 Aug '01

25 Aug '01

I was trying to test ZMC and Loginmanger after install I get the following errors: 2001-08-24T16:05:21 ERROR(200) Zope Could not import Products.LoginManager Traceback (innermost last): File C:\PROGRA~1\WebSite\lib\python\OFS\Application.py, line 552, in import_pr oduct File C:\Program Files\WebSite\lib\python\Products\LoginManager\__init__.py, li ne 1, in ? File C:\Program Files\WebSite\lib\python\Products\LoginManager\LoginManager.py , line 7, in ? ImportError: No module named ZPatterns.PlugIns ------ 2001-08-24T16:05:21 ERROR(200) Zope Could not import Products.Membership Traceback (innermost last): File C:\PROGRA~1\WebSite\lib\python\OFS\Application.py, line 552, in import_pr oduct File C:\Program Files\WebSite\lib\python\Products\Membership\__init__.py, line 3, in ? File C:\Program Files\WebSite\lib\python\Products\Membership\PersistentUserSou rce.py, line 15, in ? File C:\Program Files\WebSite\lib\python\Products\LoginManager\UserSources.py, line 5, in ? (Object: BasicUser) ImportError: No module named ZPatterns.Rack ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis Web Developer (SAIC) Defense Modeling & Simulation Office 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis(a)dmso.mil

3 3

Advice needed: load balancing wih ZEO and Apache on Solaris.
by Tony McDonald 25 Aug '01

25 Aug '01

Hi, I've followed the instructions at <http://www.zope.org/Members/dshaw/AdvancedSiteSetup> to set up a ZEO server and client (on the same machine). These instructions are very clear and I'd recommend them to people wanting to experiment with ZEO. We serve our content up through Apache (fast delivery of static content, CGI scripts and PHP4 served too). I'm using the VHM method of routing Apache requests through to my ZServer installation so (only a snippet shown, and this is an example); RewriteEngine on RewriteRule ^/cgi-bin - [L] RewriteRule ^/static - [L] RewriteRule ^/ltsn_images - [L] RewriteRule ^/(.*) http://localhost:18080/VirtualHostBase/http/myserver.ncl.ac.uk:80/VirtualHos tRoot/$1 [P] Following the instructions from Dave Shaws' page I have a ZEO server running on port 8080 and a client running on port 8081 One idea I've had from reading the Apache Rewrite rules page at <http://httpd.apache.org/docs/misc/rewriteguide.html> Is to use ProxyPassReverse (in some way), i.e. ProxyPassReverse / http://localhost:8080/ ProxyPassReverse / http://localhost:8081/ My question is this; What can I do to get requests from myserver.ncl.ac.uk farmed out to my ZEO server-client farm? Any pointers would be really appreciated. Cheers Tone. -- Dr Tony McDonald, Assistant Director, FMCC, http://www.fmcc.org.uk/ The Medical School, Newcastle University Tel: +44 191 243 6140 A Zope list for UK HE/FE http://www.fmcc.org.uk/mailman/listinfo/zope

2 1

Weird CatalogAware behavior re: metadata?
by sean.upton＠uniontrib.com 25 Aug '01

25 Aug '01

I have a python product that has a class derived from CatalogAware and SimpleItem. I programmatically add instances of these (1000s of them) on an automated basis every day in the early morning. My problem is that whenever I do this, the Catalog is updated with some problems: 1 - Metadata is skewed: DateTime objects are cataloged, and they end up with the wrong date ('2001/01/01') instead of today's date, even though the actual property. 2 - Text indexes only get a portion of their text stored in the metadata, not all of it. Using a bulk reindex solves this problem (subtransaction off, haven't tried it any other way). I'm using Zope 2.3.2 with ZEO 1.0b3. The automated process queries SQL for data, and uses those queries to create object instances of the previously mentioned catalog-aware class, and I create anywhere from 2000-7000 objects at a time. I'm not sure if this is due to the size of the transaction I am running. I haven't tried this in a smaller transaction yet; I was wondering if anyone else has seen this. Any thoughts? Sean ========================= Sean Upton Senior Programmer/Analyst SignOnSanDiego.com The San Diego Union-Tribune 619.718.5241 sean.upton(a)uniontrib.com =========================

1 0

OSX users looking to test a Mac GUI for Zope?
by David Shaw 25 Aug '01

25 Aug '01

I have been working on a Mac OS X package for Zope based off of the excellent binary distribution for MacOS X on zope.org. What makes mine different is (a) it includes ZEO, and (b) is has a native Mac GUI configuration tool front-end. You can see some screen shots here: http://homepage.mac.com/dshaw/ If you are a MacOS X user and are interested in helping me develop or test, just let me know via email. Since the distribution includes a full copy of Zope and python, it's not small, so bear that in mind.

2 1

Fw: gvib kinterbasdb firebird linux
by W. Robert Kellock 25 Aug '01

25 Aug '01

Hello again, Linux newbie problem resolved now (why are the Linux newbie books so silent about shell programming?) means I have successfully compiled gvibBase.so under Python 1.5.2. However this hasn't got me out of the woods yet, since Zope 2.4.1b uses Python2.1 and gvibBase.c code contains Py_Realloc which I think has become PyMem_Realloc. Unless somebody has already rewritten gvibBase.c to compile under Python 2.1 and would care to share it, I will Bash on and post the result when I am done. Cheers. ------------------------------------------------------------------------------------------------------------- W.Robert Kellock Ph: +64 3 326 6115 Sales Manager Fax: +64 3 326 6115 Credit Systems Control Ltd Web: www.creditscore.co.nz "making decisions easy" ------------------------------------------------------------------------------------------------------------- ----- Original Message ----- From: W. Robert Kellock To: zope(a)zope.org Sent: Friday, 24 August 2001 20:02 Subject: gvib kinterbasdb firebird linux I have for some months now been utilising, very successfully, gvibDA on Windows 2000 with Zope 2.3.2 and Firebird. Unfortunately I cannot say the same for RedHat 7.1 (very much a Linux newbie so be gentle ;- ). I have installed the latest Zope 2.4.1b (which uses Python2.1) and Firebird binaries and they are working fine. However when I compile gviBase.so and attempt to use it within Zope or Python (both 1.5 rpm and 2.1.1 compiled from source) I get Import error: undefined symbol isc_dsql_execute I assume this means that the compile process cannot see the Firebird shared library libgds.so, but I can't see why. I have tryed to edit the Setup.in file to import /usr/lib/libgds.so instead of the more usual -lgds but it makes no difference. Can anybody help me out? I have also tryed kinterbasdb, but when I import it I get Import error: undefined symbol crypt I know I'm supposed to editing kinterbasdb's Makefile to include -lcrypt but I'm not sure where. gvib is my main priority, but a copy of an appropriate Makefile for kinterbasdb would also be much appreciated. Thanks. ------------------------------------------------------------------------------------------------------------- W.Robert Kellock Ph: +64 3 326 6115 Sales Manager Fax: +64 3 326 6115 Credit Systems Control Ltd Web: www.creditscore.co.nz "making decisions easy" -------------------------------------------------------------------------------------------------------------

1 0