July 2003 - Zope - Zope lists

No module named BTree when using standalone zodb
by Sukhwinder Singh 01 Jul '03

01 Jul '03

Now I trying to work directly with zodb. I am using python 2.2.3 and have downloaded theses versions of standalone zodb: ZODB3-3.1.win32-py2.1.exe ZODB3-3.1.win32-py2.2.exe ZODB3-3.2b2.win32-py2.2.exe But when I try this script: ////////////////////// from ZODB import FileStorage, DB storage = FileStorage.FileStorage('c:\\database\\var\\data.fs') db = DB(storage) connection = db.open() root = connection.root() employees = root['employees'] for employee in employees: print employee.name ////////////////////////////////// This error message "No module named BTree" is displayed: Traceback (most recent call last): File "zodb.py", line 7, in ? employees = root['employees'] File "D:\APP\PYTHON\lib\UserDict.py", line 14, in __getitem__ def __getitem__(self, key): return self.data[key] File "D:\APP\PYTHON\Lib\site-packages\ZODB\Connection.py", line 566, in setstate self._set_ghost_state(obj, p) File "D:\APP\PYTHON\Lib\site-packages\ZODB\Connection.py", line 605, in _set_ghost_state state = unpickler.load() File "D:\APP\PYTHON\Lib\site-packages\ZODB\Connection.py", line 203, in _persistent_load return self[oid] File "D:\APP\PYTHON\Lib\site-packages\ZODB\Connection.py", line 163, in __getitem__ klass=self._db._classFactory(self, module, name) File "D:\APP\PYTHON\lib\site-packages\ZODB\DB.py", line 126, in _classFactory return getattr(__import__(location, _globals, _globals, _silly),name) ImportError: No module named BTree Which version of standalone zodb I need to install for this BTree module to be available. --Sukhwinder Singh

1 0

RE: [Zope] Urgent - Database has consumed all possible space
by sean.upton＠uniontrib.com 01 Jul '03

01 Jul '03

1 - Hard drive space is cheap, at least for servers you control, and as I understand you do not control this server... I don't envy you if your DBAs consider <2gb to be a lot of space - don't they let you account for temp files, logs, etc??? 2 - Explain that the spaces is taken up by transaction logging that isn't properly rotated. This is the truth (FileStorage is a logging storage), and this is something that RDBMS admins, for example, would understand. Explain that after packing, the storage will take up less space. 3 - Pack regularly, and monitor your storage space; prune and delete unnecessary/old content. > -----Original Message----- > From: Michael Havard [mailto:nhavar@hotmail.com] > Sent: Tuesday, July 01, 2003 1:24 PM > To: zope(a)zope.org > Cc: plattem(a)inetnebr.com > Subject: Re: [Zope] Urgent - Database has consumed all possible space > > > If it were only so easy. This is a shared box with many other > applications > and databases on it. Our database was only supposed to take > up 200-300mb NOT > 1.8gb big difference. The DBA's have scrounged for extra > space and given me > all they could. Hard drive space for these machines is > expensive and not > something I can just ask for. Plus I still need to explain > why 200-300mb > worth of text files exploded in ZOPE to 1.8gb of information. > > > >From: Matthew Platte <plattem(a)inetnebr.com> > >To: Michael Havard <nhavar(a)hotmail.com> > >Subject: Re: [Zope] Urgent - Database has consumed all possible space > >Date: Tue, 01 Jul 2003 13:45:09 -0500 > >MIME-Version: 1.0 > >Received: from duck.inebraska.com ([199.184.119.13]) by > >mc10-f41.bay6.hotmail.com with Microsoft > SMTPSVC(5.0.2195.5600); Tue, 1 Jul > >2003 11:44:19 -0700 > >Received: from lin-dsl-static-206-222-213-206.inetnebr.com > >(lin-dsl-static-206-222-213-206.inetnebr.com [206.222.213.206])by > >duck.inebraska.com (8.12.7/8.12.7) with ESMTP id h61IiHMv021926for > ><nhavar(a)hotmail.com>; Tue, 1 Jul 2003 13:44:17 -0500 (CDT) > >Received: from inetnebr.com > (lin-dsl-static-206-222-213-205.inetnebr.com > >[206.222.213.205])by > lin-dsl-static-206-222-213-206.inetnebr.com (Postfix) > >with ESMTP id C25BA105344for <nhavar(a)hotmail.com>; Tue, 1 Jul 2003 > >13:43:47 -0500 (CDT) > >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP > >Message-ID: <3F01D6B5.3030602(a)inetnebr.com> > >User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) > >Gecko/20020826 > >X-Accept-Language: en-us, en > >References: <Law9-F477yeZNCKWnXp0001219d(a)hotmail.com> > >Return-Path: plattem(a)inetnebr.com > >X-OriginalArrivalTime: 01 Jul 2003 18:44:19.0491 (UTC) > >FILETIME=[C7ED6F30:01C34000] > > > >Michael Havard wrote: > >>We've already tried packing. It keeps failing because of > insufficient > >>space in the DB. When it fails I get the distinct feeling > that we're > >>orphaning records and not really removing them from the DB > which makes the > >>pack an even larger process next time. > > > >>>>We are migrating data from an IIS server - approximately > 200mb via FTP > >>>>today I am told that the ZOPE tables now consume more > than 1.8gb. How is > >>>>it possible for 200mb of data to consume 1.8gb of > database space and > >>>>what can I do to correct it. > > > > > >Get a bigger drive. If 1.8GB is filling up the drive it was way too > >small/full in the first place. > > > >Then, when panic/things have settled down a bit, investigate > and fix the > >bloat problem. > > > >-- > >-------^.^-- > > > > > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) >

1 0

Re: [Zope] Urgent - Database has consumed all possible space
by Michael Havard 01 Jul '03

01 Jul '03

If it were only so easy. This is a shared box with many other applications and databases on it. Our database was only supposed to take up 200-300mb NOT 1.8gb big difference. The DBA's have scrounged for extra space and given me all they could. Hard drive space for these machines is expensive and not something I can just ask for. Plus I still need to explain why 200-300mb worth of text files exploded in ZOPE to 1.8gb of information. >From: Matthew Platte <plattem(a)inetnebr.com> >To: Michael Havard <nhavar(a)hotmail.com> >Subject: Re: [Zope] Urgent - Database has consumed all possible space >Date: Tue, 01 Jul 2003 13:45:09 -0500 >MIME-Version: 1.0 >Received: from duck.inebraska.com ([199.184.119.13]) by >mc10-f41.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Tue, 1 Jul >2003 11:44:19 -0700 >Received: from lin-dsl-static-206-222-213-206.inetnebr.com >(lin-dsl-static-206-222-213-206.inetnebr.com [206.222.213.206])by >duck.inebraska.com (8.12.7/8.12.7) with ESMTP id h61IiHMv021926for ><nhavar(a)hotmail.com>; Tue, 1 Jul 2003 13:44:17 -0500 (CDT) >Received: from inetnebr.com (lin-dsl-static-206-222-213-205.inetnebr.com >[206.222.213.205])by lin-dsl-static-206-222-213-206.inetnebr.com (Postfix) >with ESMTP id C25BA105344for <nhavar(a)hotmail.com>; Tue, 1 Jul 2003 >13:43:47 -0500 (CDT) >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP >Message-ID: <3F01D6B5.3030602(a)inetnebr.com> >User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) >Gecko/20020826 >X-Accept-Language: en-us, en >References: <Law9-F477yeZNCKWnXp0001219d(a)hotmail.com> >Return-Path: plattem(a)inetnebr.com >X-OriginalArrivalTime: 01 Jul 2003 18:44:19.0491 (UTC) >FILETIME=[C7ED6F30:01C34000] > >Michael Havard wrote: >>We've already tried packing. It keeps failing because of insufficient >>space in the DB. When it fails I get the distinct feeling that we're >>orphaning records and not really removing them from the DB which makes the >>pack an even larger process next time. > >>>>We are migrating data from an IIS server - approximately 200mb via FTP >>>>today I am told that the ZOPE tables now consume more than 1.8gb. How is >>>>it possible for 200mb of data to consume 1.8gb of database space and >>>>what can I do to correct it. > > >Get a bigger drive. If 1.8GB is filling up the drive it was way too >small/full in the first place. > >Then, when panic/things have settled down a bit, investigate and fix the >bloat problem. > >-- >-------^.^-- > > _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

1 0

Re: [Zope] Urgent - Database has consumed all possible space
by Michael Havard 01 Jul '03

01 Jul '03

We've already tried packing. It keeps failing because of insufficient space in the DB. When it fails I get the distinct feeling that we're orphaning records and not really removing them from the DB which makes the pack an even larger process next time. >From: Jens Vagelpohl <jens(a)zope.com> >To: "Michael Havard" <nhavar(a)hotmail.com> >CC: zope(a)zope.org >Subject: Re: [Zope] Urgent - Database has consumed all possible space >Date: Tue, 1 Jul 2003 12:18:26 -0400 >MIME-Version: 1.0 (Apple Message framework v552) >Received: from smtp.zope.com ([63.100.190.10]) by mc4-f30.law16.hotmail.com >with Microsoft SMTPSVC(5.0.2195.5600); Tue, 1 Jul 2003 09:18:36 -0700 >Received: from zope.com (piggy.zope.com [192.168.23.9])(authenticated >bits=0)by smtp.zope.com (8.12.5/8.12.5) with ESMTP id h61GL8v2023629;Tue, 1 >Jul 2003 12:21:08 -0400 >X-Message-Info: JGTYoYF78jEHjJx36Oi8+Q1OJDRSDidP >In-Reply-To: <Law9-F75Px33E1ioWwr0001965f(a)hotmail.com> >Message-Id: <A4FD0B48-ABDF-11D7-9F63-000393D58818(a)zope.com> >X-Mailer: Apple Mail (2.552) >X-MailScanner: Found to be clean >Return-Path: jens(a)zope.com >X-OriginalArrivalTime: 01 Jul 2003 16:18:36.0999 (UTC) >FILETIME=[6CFF0570:01C33FEC] > >you need to pack your database. this is a normal maintenance step. log into >the ZMI and click on Control_Panel and then Database Management. you should >see a form that allows you to pack the database. > >jens > > >On Tuesday, Jul 1, 2003, at 11:13 US/Eastern, Michael Havard wrote: > >>We are migrating data from an IIS server - approximately 200mb via FTP >>today I am told that the ZOPE tables now consume more than 1.8gb. How is >>it possible for 200mb of data to consume 1.8gb of database space and what >>can I do to correct it. >> >>Can anyone help with this issue? >> >>We are running DCOracle2/OracleStorage on ZOPE 2.5.1 with CMF 1.3. >> >>_________________________________________________________________ >>Help STOP SPAM with the new MSN 8 and get 2 months FREE* >>http://join.msn.com/?page=features/junkmail >> >> >>_______________________________________________ >>Zope maillist - Zope(a)zope.org >>http://mail.zope.org/mailman/listinfo/zope >>** No cross posts or HTML encoding! ** >>(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce >>http://mail.zope.org/mailman/listinfo/zope-dev ) > _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail

1 0

ParsedXML Documentation / Examples?
by zoper＠disturbance.dhs.org 01 Jul '03

01 Jul '03

Hello, After searching all afternoon, I have found a ton of periphery 'about' type information re: ParsedXML, but I am having trouble locating any substantive documentation, or in particular, examples. I'm interested in DTML examples, PythonScript examples, anything. Any pointers appreciated. -Bryan

3 4

Urgent - Database has consumed all possible space
by Michael Havard 01 Jul '03

01 Jul '03

We are migrating data from an IIS server - approximately 200mb via FTP today I am told that the ZOPE tables now consume more than 1.8gb. How is it possible for 200mb of data to consume 1.8gb of database space and what can I do to correct it. Can anyone help with this issue? We are running DCOracle2/OracleStorage on ZOPE 2.5.1 with CMF 1.3. _________________________________________________________________ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

2 1

RE: [Zope] ParsedXML Documentation / Examples?
by sean.upton＠uniontrib.com 01 Jul '03

01 Jul '03

ParsedXML is just a persistent DOM. Just get the ParsedXML document object and use the DOM API to target it (traverse, read, modify). The appendix in the back of the book _Python & XML_ is a good DOM reference. Simple Example: doc = myFolder.someXMLDoc headnode = doc.getElementsByTagName('head')[0] titlenode = headnoce.getElementsByTagName('title')[0] title = titlenode.firstChild.nodeValue print title #change title title = 'New title' bytes = titlenode.firstChild.length #len of current title titlennode.firstChild.replaceData(0,bytes,title) Sean > -----Original Message----- > From: zoper(a)disturbance.dhs.org [mailto:zoper@disturbance.dhs.org] > Sent: Saturday, June 28, 2003 4:18 PM > To: Zope > Subject: [Zope] ParsedXML Documentation / Examples? > > > Hello, > > After searching all afternoon, I have found a ton of periphery 'about' > type information re: ParsedXML, but I am having trouble locating any > substantive documentation, or in particular, examples. I'm > interested in > DTML examples, PythonScript examples, anything. > > Any pointers appreciated. > > -Bryan > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) >

1 0

Error, _mysql_exceptions. 'ON DUPLICATE KEY
by Wayne Connolly 01 Jul '03

01 Jul '03

Hi, i have been playing round with this insert/update script on zope/mysql and keep recieving the following error...any idea's on how to get rid of this would be muchly appreciated? -------------------------------------------------------------------- Error, _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax near 'ON DUPLICATE KEY update charts set \n plays=plays + 1\n\twhere title='wayne'' at line 14") -------------------------------------------------------------------- the ZSQL used is below -------------------------------------------------------------------- insert into charts (title, artist, genre, album, plays) VALUES ( ,  ,  ,  , plays=1 ) ON DUPLICATE KEY update charts set plays=plays + 1 where title=<dtml-sqlvar title type=nb> and artist=<dtml-sqlvar artist type=nb>

2 2

Retrieving zope management password.
by Sukhwinder Singh 01 Jul '03

01 Jul '03

Now I have updated data.fs file and old username and password for ZMI don't work. Username password provided by client also don't work. Are username passwords stored in inituser file in zope install directory or inside data.fs file. I think these are stored in data.fs file becuase I only replaced data.fs file in old installation. I have used zpasswd.py to create new user, following the procedure written in admin guide and zope book, but that new user is not allowed to login. Is there any other way to create new user? -- Sukhwinder Singh

3 2

zbabel tower ?
by Júlio Silva 01 Jul '03

01 Jul '03

Hi, I'm testing ZBabel Product (http://www.zope.org/Members/srichter/Products/ZBabel) I think I understand how the tags work, but I cant see how can I create my zbabel tower where I can put my translations. Wasnt suppose to one be able to choose a ZBabel Tower object from the add objects drop box in zope ZMI? I'm using zope 2.6 on windows without postgresql, i.e, I want to have my translations on a ZODBBabelTower but I dont see how to create one. Any help? Best Regards, Julio Silva --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com) Version: 6.0.489 / Virus Database: 288 - Release Date: 10-06-2003

1 0