Andy Dawkins writes: Thanks you for your prompt reply. I knew someone had to have a solution. Would you be willing to send me the script? Better yet, put it up as content on the Zope.org site. I have a feeling a list of solutions to this would help the community. All my best,

I have a python script which uses XMLRPC to call an External Method that packs the database.

Not ideal, but it does allow me to pack the database a) From Zope b) From the command line c) Whilst the server is running d) During very large imports which make ZCatalog Explode (I wish CatalogAware supported Sub Transactions)

-Andy

...

-----Original Message----- From: jason@zope.org [mailto:jason@zope.org]On Behalf Of Jason Spisak Sent: 03 August 2000 16:37 To: zope@zope.org Subject: [Zope] Packing with cron

Zopists,

I am attemtping to use cron to pack my ZODB. I am using lalo's cron how-to and lynx. However when I visit http://myhost:8080/Control_Panel/Database/manage_pack nothing happens. Here is the command I am using in Zope 2.1.6:

lynx -auth superuser:superuserpasswd -source http://myhost:8080/Control_Panel/Database/manage_pack

Is there anything obviously skewed about this? Has anyone else tried it with success?

Thanks in advance,

Jason Spisak

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

Jason Spisak CIO HireTechs.com 6151 West Century Boulevard Suite 900 Los Angeles, CA 90045 P. 310.665.3444 F. 310.665.3544 Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.

Andy Dawkins writes: Thank you Andy. That was generous. Have you ever used this from cron? Just so I know before I try it. All my best,

Jason

I'm not sure if it is worthy of putting up on Zope. Although I'm sure people will correct me if I am wrong.

But I have no problems in letting you have it

<packDb.py> is the main python script. You will need to change the line that reads s=xmlrpclib.Server('http://myserver:8080/', transport=None, username='username', password='password') To reflect your correct server details.

<xmlrpclib.py> xmlrpc Library for python. Place this in your python/libs directory, or the same directory as packDb.py

<packExtension.py> This contains the code for the external Method. Place this in your zope/Extensions directory. Create it if it doesn't exist.

You will need to add an external method to the root of your ZODB that points to packExtensions.py script

If you have any problem then please let me know.

-Andy

Jason Spisak CIO HireTechs.com 6151 West Century Boulevard Suite 900 Los Angeles, CA 90045 P. 310.665.3444 F. 310.665.3544 Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.