- Zope - Zope lists

Odd problem updating a PostgreSQL DB
by Tim Wilson 14 Sep '02

14 Sep '02

Hi everyone, I've been working on a project off and on for a while now and I've run into a bug that has me stumped. The project is a PostgreSQL-driven event database for my school district. I've built a user interface to the database, but there's a problem when I try to update the results of an athletic event. When I attempt to update an event score, it works perfectly unless one of the scores is 0. The SQL update completely ignores the zero value and leaves it as NULL. If I go back and enter two non-zero numbers, things work fine. If I then go back and change one of the scores to a 0, that change is ignored and the old non-zero score remains. Any ideas? I've looked carefully at the code and don't see anything obvious. I can certainly post it if anyone is interested in looking more closely, but I wonder if this little problem is a common one and I'm just missing something between my ears. -Tim -- Tim Wilson | Visit Sibley online: | Check out: Henry Sibley HS | http://www.isd197.org | http://www.zope.com W. St. Paul, MN | | http://slashdot.org wilson(a)visi.com | <dtml-var pithy_quote> | http://linux.com

4 6

RE: ZODB/ZSS High Availablity, was: RE: [Zope] Zope Myths?
by sean.upton＠uniontrib.com 14 Sep '02

14 Sep '02

I can't remember who all is doing it, but I think network-replicated block devices are pretty popular for this kind of thing; I distinctly remember someone on a mailing list mentioning they were doing this with Zope and/or ZEO (might be worth a search of archives, perhaps on ZODB-dev?). I think that in some circles, DRBD is preferred to NBD, but I don't claim to be an expert on that (check out links on the Linux-HA.org site, perhaps). The downside to doing this is that you can't keep two distinct copies of the storage (the last good known copy, and the last replicated copy), since you are replicating at a much lower level. In this sense, you will need to rely on consistency checks alone to get a partially messed-up storage working on the failure of the primary node, and startup of the secondary node resources and IP takeover. Sean -----Original Message----- From: Oliver Bleutgen [mailto:myzope@gmx.net] Sent: Friday, September 13, 2002 1:00 AM To: sean.upton(a)uniontrib.com Cc: pw_lists(a)slinkp.com; zope(a)zope.org Subject: Re: ZODB/ZSS High Availablity, was: RE: [Zope] Zope Myths? sean.upton(a)uniontrib.com wrote: > Thought about this using Intermezzo - basically the same idea. I think the > problem is that these are on-demand replication mechanisms that get the file > when they need it instead of push-to-other-node-on-write sort of deals. I'm > not posive about that. The other problem is how these filesystems handle > changes to large files (like FileStorage). > > There, might, in theory, be a way to integrate this with something like > DirectoryStorage, but I think you would need to do some heavy scripting to > get things to work just right (perhaps to the point that you might as well > manually set up scripts to low-tech replicate files?). Hmm, has someone taken a look a ndb (network block device) for linux? This might be a cheap (low tech) solution for doing "push-to-other-node-on-write". I'm asking, because I have not tried it, but always wanted to. http://nbd.sourceforge.net/ http://www.it.uc3m.es/~ptb/nbd/ """The intended use is for RAID over the net. You can make an NBD device part of a RAID mirror in order to get real time mirroring to a distant (and safe!) backup. To make it clear: start up an NBD connection to a distant ENBD server, and use its local device (probably /dev/nda) where you would normally use a local partition in a RAID setup. The original kernel device has been hardened in many ways: The ENBD uses block-journaled multichannel communications; there is internal failover and automatic balancing between the channels; the client and server daemons restart, authenticate and reconnect after dying or loss of contact; the code can be compiled to take the networking transparantly over SSL channels (see the Makefile for the compilation options). """ cheers, oliver

2 1

Deleted virtual host monster - no access to account
by Scott Brown 14 Sep '02

14 Sep '02

I added and deleted a virtual host monster in my root folder, and now I don't have access to manage my zope. When I go to manage, I get a zope error screen: Resource not found Sorry, the requested resource does not exist. Check the URL and try again. Resource: VirtualHostBase GET arrrggg! Any Ideas? Thanks, Scott

3 2

Zope and TSQL
by Adam Getchell 13 Sep '02

13 Sep '02

Has anyone gotten TSQL to work with Zope's ZSQLDA? Google and www.zope.org <www.zope.org> searches don't turn up much. Thanks, *************************** * Adam Getchell AdamG(a)hrrm.ucdavis.edu * System Architect/Programmer (530) 752-1584 * Human Resources Information Systems http://www.hr.ucdavis.edu/ <http://www.hr.ucdavis.edu/> *************************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu

1 0

Cookies
by Charlie Reiman 13 Sep '02

13 Sep '02

I've got a little cookie tool I set up. It lets me view, set and clear cookies. The problem is cookie values have quotes around them that I never asked for. The tool is one page with a form for setting cookies. The form uses the GET method to send the cookie name, value, path, and expiration date. The top of the page has a little dtml-if and this call: <dtml-call "RESPONSE.setCookie(REQUEST.form['cname'], REQUEST.form['cvalue'], expires=REQUEST.form['cexpire'], path=REQUEST.form['cpath'], domain='kefta.com')"> This works marvelously and the cookie values that zope pulls out via dtml look fine. But for other applications and within Mozilla's cookie manager, I see the cookie value has double quotes around it. Is this something I did or is zope trying to help me out more than I want it to?

2 1

Zope vs. MS Sharepoint
by Verscharen, Joe 13 Sep '02

13 Sep '02

I'm about to start a small content management project (newbie). Does anyone have a sense of the major differences? Licensing is probably not a issue for us, I have not used either, but I've done a good bit of Python. Thanks in advance.

2 1

ZMySQLDA errors
by Bas van Ombergen 13 Sep '02

13 Sep '02

Hi, I have installed zope en mysql correctly, and i want to install ZMySQLDA. I have read the Howto's but i cant find anything. The things i have installed: Zope 2.5.1 Python 2.1.3 Mysql 3.23.51 Mysql-Python (Include MySQLDB) MySQLDA Then i got this error that Zope can't find a file (see below for the error) i have tried putting the files in the directory, and in the product directory, but all these attempts fail. It just won't work. I also have set the MYSQLDB variable on other paths and checked the rights but it still won't work. Traceback (most recent call last): File "/temp/Zope-2.5.1-src/lib/python/OFS/Application.py", line 531, in import_product product=__import__(pname, global_dict, global_dict, silly) File "/temp/Zope-2.5.1-src/lib/python/Products/ZMySQLDA/__init__.py", line 91, in ? import DA File "/temp/Zope-2.5.1-src/lib/python/Products/ZMySQLDA/DA.py", line 92, in ? from db import DB File "/temp/Zope-2.5.1-src/lib/python/Products/ZMySQLDA/db.py", line 89, in ? import _mysql ImportError: libmysqlclient_r.so.10: cannot open shared object file: No such file or directory Cheers.

3 2

ZPT: building to column table
by Jochen Haeberle 13 Sep '02

13 Sep '02

Hi list, is there a way to build a table holding two columns of results??? My first try was like this: 1 <table border="1"> 2 <metal:block tal:repeat="result batch" > 3 <metal:block tal:define="resultObject result/getObject"> 4 <metal:block tal:condition="repeat/result/odd"> 5 <tr> 6 <td> 7 left object 8 </td> 9 </metal:block> 10 11 <metal:block tal:condition="repeat/result/even"> 12 <td> 13 right object 14 </td> 15 </tr> 16 </metal:block> 17 </metal:block> 18 </metal:block> 19 </table> Bute TALES does not like the </tr> at line 15 because of illegal nesting. Another try would be to save the odd object in a variable and build the total row in the even run. I could not get this to work, either... i would get errors or duplicate entries on both sides. I guess python works with pointers the same like Java does??? I guess I am stuck (again)... anyone has an idea for me please??? Jochen

4 5

Heads up! (OpenSSL worm in the wild)
by Adam Manock 13 Sep '02

13 Sep '02

More info at: http://online.securityfocus.com/bid/5363/discussion/ Also see below... Adam >Date: Fri, 13 Sep 2002 18:16:33 +0100 >From: Ben Laurie <ben(a)algroup.co.uk> >To: Bugtraq <BUGTRAQ(a)SECURITYFOCUS.COM>, > Cryptography <cryptography(a)wasabisystems.com>, > cypherpunks <cypherpunks(a)einstein.ssz.com>, > Apache SSL <apache-ssl(a)lists.aldigital.co.uk> >Subject: OpenSSL worm in the wild > > >I have now seen a worm for the OpenSSL problems I reported a few weeks >back in the wild. Anyone who has not patched/upgraded to 0.9.6e+ should be >_seriously worried_. > >It appears to be exclusively targeted at Linux systems, but I wouldn't >count on variants for other systems not existing. > >Cheers, > >Ben. > >-- >http://www.apache-ssl.org/ben.html http://www.thebunker.net/ > >"There is no limit to what a man can do or how far he can go if he >doesn't mind who gets the credit." - Robert Woodruff

1 0

ZCatalog bobobase_modification_time searching
by Jaroslav Lukesh 13 Sep '02

13 Sep '02

Hi all, I want to search documents that are older than specified date and mail results So I add Zcatalog, at Index I was set bobobase_modification_time and do process with Add Zsearch interface. But I dont know right question for bobobase_mod_time. Would you like to kick me, point into some product or howto, please? Many thanks, J. Lukesh

2 1