January 2005 - Zope - Zope lists

documentation defacement
by Mike Culbertson 26 Jan '05

26 Jan '05

Could someone with adequate access please remove at least some of the garbage posts from the zope docs, the thousands of lines of spam/vandal nonsense make it really annoying to read. example: http://zope.org/Documentation/Books/ZopeBook/2_6Edition/AppendixD.stx -Mike Culbertson

8 23

Recursively comparing 2 folders' objects
by Pascal Peregrina 25 Jan '05

25 Jan '05

Hi, I would like to know if anyone has some advice to give me on this. Inside one Zope instance, I have 2 folders, representing a live site and a development site. People copy objects from dev to live when they are ready. I would like to know if there are things to avoid (in order to speed up overall comparison time). I was thinking about a recursive function that would follow the development site folders structure, and on each folder, compare contents with live content, using comparison methods by meta type. Thanks a lot. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

2 1

OFS.History (question 2)
by Pascal Peregrina 25 Jan '05

25 Jan '05

First of all, thanks Dieter, that answered my question 1. Now I've got a more serious problem. I have a CMF Document that wraps a PageTemplate object (it does not extend PageTemplate, but internally stores a PageTemplate instance). It looks like when some revision of my object is retreived from ZODB, this does not include the wraped persistent objects that my object may contain. For example, rev1._get_pt.read() and rev2._get_pt.read() always return the HTML of the current revision's wraped PageTemplate. (_get_pt() returns the wraped PageTemplate object) Is there a workaround for this ? The only thing I can think of is storing the PageTemplate HTML at my object level each time it is changed, but that means storing the HTML twice in ZODB... I tried it, and of course it works. Pascal ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************

3 5

sql_delimiter broken?
by hpinson＠indepthl.com 25 Jan '05

25 Jan '05

The ability to pass multiple sql calls in one ZSQL method using sql_delimiter seems to be broken in 2.7.4. This no longer works in a single ZSQL method: INSERT INTO ...; <dtml-var sql_delimiter> INSERT INTO ...; <dtml-var sql_delimiter> Crashes the sql on encountering the sql_delimiter. Does anyone know of any workaround outside of using separate ZSQL methods for each statement? I know... convert it to Python. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

3 3

ZODB storage errors ...during object abort
by iroro 25 Jan '05

25 Jan '05

Hi, I'm investigating some nasty hangs/freezes that seem to occur every 2-3 days. Usually, i just "service zope restart" and I'm back in business. So I turned on event logging on the last restart to help figure this out and Zope hasn't hung yet, but I've been seeing these nasty looking errors (esp. "This shouldn't happen") any ideas, hints, debugging paths that might shed some light on this error would be greatly appreciated!!! thanks, io --- <snip from Zope event log> ------ 2005-01-24T01:00:33 ERROR(200) ZODB A storage error occured during object abort. This shouldn't happen. Traceback (innermost last): File /var/local/zope-2.6.4/lib/python/ZODB/Transaction.py, line 401, in _commit_error File /var/local/zope-2.6.4/lib/python/Shared/DC/ZRDB/TM.py, line 60, in abort File /var/local/zope/lib/python/Products/ZMySQLDA/db.py, line 405, in _abort

3 2

epoz and zpt
by Milos Prudek 25 Jan '05

25 Jan '05

Could someone please post the simplest working example of Epoz in ZPT? An example that would edit a file called 'text'. The following code I figured out works but it does not save to a file: ZPT method /epoz/a: <form action="/epoz/a" method="post"> <span tal:define="text here/text|string:" tal:replace="structure python: here.Epoz('text', data=text, toolbox='/', lang='en', style='width: 620px; height: 250px; border: 1px solid #000000;')" /> <input type="submit" name="submit" value=" Save Changes " > </form> What's wrong with my example? -- Milos Prudek

2 1

Re: [Zope] ZServer uncaptured python exception
by Ken Ara 25 Jan '05

25 Jan '05

I'm back in business. A list post from 1999 (by Amos) tipped me to the likely cause: something must have changed with the dns server specified in my zope.conf (start.py at the time). I reverted to the default (unset). Cheers Ken __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

Re: [Zope] ZServer uncaptured python exception
by Ken Ara 25 Jan '05

25 Jan '05

Yes, thanks, I have backups. And I forgot to mention, I am running Zope 2.7.3/FreeBSD 4.9. Actually, I suspect it is not strictly a Zope problem. Squid (which I stopped) was running fine, and I was able to reboot the machine (remotely) with no effect. My ISP-friend, who gets to work in about 6 hours, may (or may not) be able to help with any admin-type issues, so any help from the list will be much appreciated. Ken --- Marco Bizzarri <m.bizzarri@i...> wrote: > Did you tried to move away the old Data.fs* (backup first!) so that you > can check if it is a sysadmin problem or a Zope problem? > > Also, I see a strange message stating 'no address associated with > hostname'... not sure if it can cause problems. > > Regards > Marco > Ken Ara wrote: > > Hi, > > > > Something went wrong with my Zope overnight. > > > > I attempted to restart this morning, but Zope dies > > after serving a single page. Strangely, although I can > > retrieve one page, there is no entry for it in Z2.log. > > > > > > How shall I interpret this message from my Error.log: > > > > ------ > > 2005-01-25T05:35:56 INFO(0) ZServer HTTP server > > started at Tue Jan 25 05:35:56 2005 > > Hostname: my.server.com > > Port: 81 > > ------ > > 2005-01-25T05:35:56 INFO(0) Zope Set effective user to > > "ken" > > ------ > > 2005-01-25T05:36:00 INFO(0) Zope Ready to handle > > requests > > ------ > > 2005-01-25T05:36:00 ERROR(200) ZServer uncaptured > > python exception, closing channel > > <ZServer.HTTPServer.zhttp_channel connected 83.7 > > 9.118.168:10373 at 0x91066ac channel#: 0 requests:> > > (socket.gaierror:(7, 'No address associated with > > hostname') [/usr/local/lib/pyth > > on2.3/asyncore.py|write|77] > > [/usr/local/lib/python2.3/asyncore.py|handle_write_event|397] > > [/usr/local/lib/python2.3/asynchat.py|hand > > le_write|152] > > [/usr/local/lib/python2.3/asynchat.py|initiate_send|213] > > [/usr/local/lib/python2.3/asynchat.py|refill_buffer|200] > > [/us > > r/local/www/zope/lib/python/ZServer/Producers.py|more|34] > > [/usr/local/www/zope/lib/python/ZServer/medusa/http_server.py|log|292] > > [/u > > sr/local/www/zope/lib/python/ZServer/medusa/logger.py|log|246] > > [/usr/local/www/zope/lib/python/ZServer/medusa/resolver.py|resolve_pt > > r|349] > > [/usr/local/www/zope/lib/python/ZServer/medusa/resolver.py|resolve_ptr|260]) > > > > Any ideas? Thanks! > > > > Ken Ara > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

1 0

ZServer uncaptured python exception
by Ken Ara 25 Jan '05

25 Jan '05

Hi, Something went wrong with my Zope overnight. I attempted to restart this morning, but Zope dies after serving a single page. Strangely, although I can retrieve one page, there is no entry for it in Z2.log. How shall I interpret this message from my Error.log: ------ 2005-01-25T05:35:56 INFO(0) ZServer HTTP server started at Tue Jan 25 05:35:56 2005 Hostname: my.server.com Port: 81 ------ 2005-01-25T05:35:56 INFO(0) Zope Set effective user to "ken" ------ 2005-01-25T05:36:00 INFO(0) Zope Ready to handle requests ------ 2005-01-25T05:36:00 ERROR(200) ZServer uncaptured python exception, closing channel <ZServer.HTTPServer.zhttp_channel connected 83.7 9.118.168:10373 at 0x91066ac channel#: 0 requests:> (socket.gaierror:(7, 'No address associated with hostname') [/usr/local/lib/pyth on2.3/asyncore.py|write|77] [/usr/local/lib/python2.3/asyncore.py|handle_write_event|397] [/usr/local/lib/python2.3/asynchat.py|hand le_write|152] [/usr/local/lib/python2.3/asynchat.py|initiate_send|213] [/usr/local/lib/python2.3/asynchat.py|refill_buffer|200] [/us r/local/www/zope/lib/python/ZServer/Producers.py|more|34] [/usr/local/www/zope/lib/python/ZServer/medusa/http_server.py|log|292] [/u sr/local/www/zope/lib/python/ZServer/medusa/logger.py|log|246] [/usr/local/www/zope/lib/python/ZServer/medusa/resolver.py|resolve_pt r|349] [/usr/local/www/zope/lib/python/ZServer/medusa/resolver.py|resolve_ptr|260]) Any ideas? Thanks! Ken Ara __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail

2 1

MySQL Windows Driver Updates
by hpinson＠indepthl.com 25 Jan '05

25 Jan '05

Have Zope MySQL database drivers (ZMySQLDA and DB) and ODBC (ZODBCDA) development been abandoned for the Windows platform? Most of what I can find is very out of date (no longer works with the current release), experimental (with major problems), or commercial. My need is to hook Zope 2.7.4 up to MySQL 4.0.16. on a W2K server. My preference would be the native driver. At this point, it looks like the eGenix commercial solution may be ony viable option, and I really have no idea how good it is. If anyone has gotten this MySQLDA mess working in such an environment, I would be grateful to know how you did it. Harlow Pinson Indepth Learning Email: hpinson(a)indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678

3 2