October 2002 - Zope - Zope lists

RE: [Zope] Zope 2.6.0 errors -- Win32 service start
by Adam Getchell 22 Oct '02

22 Oct '02

All Here's the error message from pythonservice.exe C:\PROD\bin\lib\win32>pythonservice.exe -register Registering the Python Service Manager... C:\PROD\bin\lib\win32>pythonservice.exe -debug -debug requires a service name C:\PROD\bin\lib\win32>pythonservice.exe pythonservice.exe - Python Service Manager Options: -register - register the EXE - this must be done at least once. -debug servicename [parms] - debug the Python service. Starting service - this may take several seconds - please wait... Could not start the service - error 203 Registering the Python Service Manager... Thanks, -----Original Message----- From: Adam Getchell [mailto:AdamG@hrrm.ucdavis.edu] Sent: Tuesday, October 22, 2002 12:43 AM To: 'Toby Dickenson'; 'zope(a)zope.org' Subject: RE: [Zope] Zope 2.6.0 errors Hmmm ... If I start Zope as a Windows service, it immediately dies. If I start it as start.bat, it runs .... Thanks, -----Original Message----- From: Toby Dickenson [mailto:tdickenson@geminidataloggers.com] Sent: Tuesday, October 22, 2002 12:28 AM To: Adam Getchell; 'zope(a)zope.org' Subject: Re: [Zope] Zope 2.6.0 errors On Tuesday 22 Oct 2002 8:19 am, Adam Getchell wrote: > Hi all, > > After upgrading to Zope 2.6.0 (trying to fix Zsync) on Windows 2K, I notice > that the python process dies after awhile. Thats bad...... > Using the start.bat script I see > the following errors: .....but all of those are normal, and show no sign of zope dying _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Re: [Zope] Zsync errors
by Jaroslav Lukesh 22 Oct '02

22 Oct '02

| Odesílatel: Adam Getchell <AdamG(a)hrrm.ucdavis.edu> | Error: | ProtocolError | <ProtocolError for zopetest.hr.ucdavis.edu/STAGING: 500 Internal Server | Error> | Things to check: | Your destination ZSyncer is where it is meant to be. | The destination server is running and accessible. | The user "zopeadmin" has the right to access ZSyncer. | The password for "zopeadmin" is correct. | | I know the accounts in question have access rights, as I just logged on | using them. | | So, your comment means that when I try to sync Zopedevel --> Zopetest, which | end is failing? | I was get similar error, so you could check Override User with managers Username and Password. Thats working for me, W95 <=> W2k both with Zope 2.5.1 and latest (possibly) Zsyncer. Regards J. Lukesh

1 0

RE: [Zope] Zope 2.6.0 errors
by Adam Getchell 22 Oct '02

22 Oct '02

Hmmm ... If I start Zope as a Windows service, it immediately dies. If I start it as start.bat, it runs .... Thanks, -----Original Message----- From: Toby Dickenson [mailto:tdickenson@geminidataloggers.com] Sent: Tuesday, October 22, 2002 12:28 AM To: Adam Getchell; 'zope(a)zope.org' Subject: Re: [Zope] Zope 2.6.0 errors On Tuesday 22 Oct 2002 8:19 am, Adam Getchell wrote: > Hi all, > > After upgrading to Zope 2.6.0 (trying to fix Zsync) on Windows 2K, I notice > that the python process dies after awhile. Thats bad...... > Using the start.bat script I see > the following errors: .....but all of those are normal, and show no sign of zope dying

1 0

RE: [Zope] Zope 2.6.0 errors -- stress test results
by Adam Getchell 22 Oct '02

22 Oct '02

Hi all, Here's the stresstest results if they help, C:\PROD\lib\python\Products\Sessions\stresstests>python stresstestMultiThread.py testNonOverlappingBrowserIds (__main__.TestMultiThread) ... 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 general conflict 0 1 ok testOverlappingBrowserIds (__main__.TestMultiThread) ... 0 0 0 0 0 0 0 general conflict general conflict general conflict 0 general conflict general conflict 0 0 1 general conflict general conflict general conflict general conflict general conflict 1 2 1 0 3 0 1 0 1 0 0 0 0 0 ok ---------------------------------------------------------------------- Ran 2 tests in 175.156s OK C:\PROD\lib\python\Products\Sessions\stresstests> -----Original Message----- From: Adam Getchell [mailto:AdamG@hrrm.ucdavis.edu] Sent: Tuesday, October 22, 2002 12:20 AM To: 'zope(a)zope.org' Subject: [Zope] Zope 2.6.0 errors Hi all, After upgrading to Zope 2.6.0 (trying to fix Zsync) on Windows 2K, I notice that the python process dies after awhile. Using the start.bat script I see the following errors: C:\PROD>start.bat C:\PROD>"C:\PROD\bin\python.exe" "C:\PROD\z2.py" -D ------ 2002-10-22T00:12:14 INFO(0) ZODB Opening database for mounting: '17707104_102515 3182.844000' ------ 2002-10-22T00:12:14 INFO(0) ZODB Mounted database '17707104_1025153182.844000' a t /temp_folder C:\PROD\lib\python\SearchIndex\__init__.py:19: DeprecationWarning: The usage of the SearchIndex package is deprecated since Zope 2.4. This package is only kept for backwards compatibility for a while and will go away in a future release. Please use instead the re-factored modules in Products/PluginIndexes. warnings.warn("The usage of the SearchIndex package is deprecated since \ ------ 2002-10-22T00:12:15 ERROR(200) Zope Couldn't install OFSP Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: OFSP Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x08=', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 000000000000083d, serial was 0345b63 e781179ee, now 0000000000000000) ------ 2002-10-22T00:12:15 ERROR(200) Zope Couldn't install ZCatalog Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: ZCatalog Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x0e\xb 3', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 0000000000000eb3, serial was 033f282 0f4467380, now 0000000000000000) ------ 2002-10-22T00:12:16 INFO(0) ZServer HTTP server started at Tue Oct 22 00:12:16 2 002 Hostname: mlking Port: 80 ------ 2002-10-22T00:12:16 INFO(0) ZServer FTP server started at Tue Oct 22 00:12:16 20 02 Hostname: mlking Port: 8021 ------ 2002-10-22T00:12:16 INFO(0) ZServer PCGI Server started at Tue Oct 22 00:12:16 2 002 Inet socket port: 8090 ------ 2002-10-22T00:13:10 PROBLEM(100) ZServer unhandled connect event Thanks for any advice, *************************** * Adam Getchell AdamG(a)hrrm.ucdavis.edu * System Architect/Programmer (530) 752-1584 * Human Resources Information Systems http://www.hr.ucdavis.edu/ *************************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Zope 2.6.0 errors
by Adam Getchell 22 Oct '02

22 Oct '02

Hi all, After upgrading to Zope 2.6.0 (trying to fix Zsync) on Windows 2K, I notice that the python process dies after awhile. Using the start.bat script I see the following errors: C:\PROD>start.bat C:\PROD>"C:\PROD\bin\python.exe" "C:\PROD\z2.py" -D ------ 2002-10-22T00:12:14 INFO(0) ZODB Opening database for mounting: '17707104_102515 3182.844000' ------ 2002-10-22T00:12:14 INFO(0) ZODB Mounted database '17707104_1025153182.844000' a t /temp_folder C:\PROD\lib\python\SearchIndex\__init__.py:19: DeprecationWarning: The usage of the SearchIndex package is deprecated since Zope 2.4. This package is only kept for backwards compatibility for a while and will go away in a future release. Please use instead the re-factored modules in Products/PluginIndexes. warnings.warn("The usage of the SearchIndex package is deprecated since \ ------ 2002-10-22T00:12:15 ERROR(200) Zope Couldn't install OFSP Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: OFSP Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x08=', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 000000000000083d, serial was 0345b63 e781179ee, now 0000000000000000) ------ 2002-10-22T00:12:15 ERROR(200) Zope Couldn't install ZCatalog Traceback (innermost last): Module OFS.Application, line 700, in install_product - __traceback_info__: ZCatalog Module ZODB.Transaction, line 222, in commit Module ZODB.Transaction, line 195, in commit Module ZODB.Transaction, line 256, in _commit_objects Module ZODB.Connection, line 389, in commit - __traceback_info__: (('intSet', 'intSet'), '\x00\x00\x00\x00\x00\x00\x0e\xb 3', '') Module ZODB.FileStorage, line 705, in store ConflictError: database conflict error (oid 0000000000000eb3, serial was 033f282 0f4467380, now 0000000000000000) ------ 2002-10-22T00:12:16 INFO(0) ZServer HTTP server started at Tue Oct 22 00:12:16 2 002 Hostname: mlking Port: 80 ------ 2002-10-22T00:12:16 INFO(0) ZServer FTP server started at Tue Oct 22 00:12:16 20 02 Hostname: mlking Port: 8021 ------ 2002-10-22T00:12:16 INFO(0) ZServer PCGI Server started at Tue Oct 22 00:12:16 2 002 Inet socket port: 8090 ------ 2002-10-22T00:13:10 PROBLEM(100) ZServer unhandled connect event Thanks for any advice, *************************** * Adam Getchell AdamG(a)hrrm.ucdavis.edu * System Architect/Programmer (530) 752-1584 * Human Resources Information Systems http://www.hr.ucdavis.edu/ *************************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu

2 1

bug: ZODB Couldn't load state
by cyrille 22 Oct '02

22 Oct '02

hello, when asking for a 'Pack' in at /Control_Panel/Database Zope say (on console ) : 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' ------ 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a ------ 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' ------ 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a ------ 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' ------ 2002-10-22T00:21:40 ERROR(200) ZODB Couldn't load state for '\x00\x00\x00\x00\x00\x00\x10\n' Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a Traceback (innermost last): Module ZODB.Connection, line 507, in setstate Module ZODB.FileStorage, line 619, in load Module ZODB.FileStorage, line 593, in _load POSKeyError: 000000000000100a

2 1

ExternalEditor and inconsistent line-endings
by Jean Jordaan 22 Oct '02

22 Oct '02

Hi Casey I noticed that ExternalEditor's use of line-endings sometimes becomes inconsistent .. When opening a new CMF Document, which I edited via Mozilla, Vim tells me [noeol][dos]: the last line lacks an EOL, and the file is in dos format (lines end <cr><nl>). When opening the 'index_html' CMF Document, which I also edited via Mozilla, the fileformat is unix (lines end <nl>), but only the ExternalEditor header section (i.e. up to the line after the SafetyBelt) shows extra <cr> characters at the ends of lines. I guess this has to do with the format of the text in the form field which is being edited: it looks like ExternalEditor assumes that to be Dos format. -- Jean Jordaan http://www.upfrontsystems.co.za

2 2

CSV (Was: Perl scripts)
by Andreas Tille 22 Oct '02

22 Oct '02

On Wed, 9 Oct 2002, Charlie Reiman wrote: > Yes, this is pretty easy. Some python script to get you going: > --------------- > rs = some_sql_query() > > for item in rs: > result_str += (str(item.DATE) + ',' + > str(item.STUFF) + ',' + > str(item.MORESTUFF) + '\n') > > response.setHeader('Content-type', 'application/vnd.ms-excel') > response.setHeader('Content-Length', len(result_str)) > response.setHeader('Content-Disposition', > 'attachment;filename=filename.csv') > return result_str > ---------------- > > Be warned that mozilla doesn't handle this quite right. It launches excel > and hands it the data but seems to translate the EOL characters in the > process so excel refuses to split the columns. Ironically, Excel 2000 only > accepts the unix EOL character for csv data. So: it works fine from IE but > not so fine from Mozilla. If anyone has a dual browser solution I'd like to > see it. This hint wass quite helpful - at least I get reasonable effects under Linux with Galeon - this handles the resulting file with Gnumeric as default. But strangely enough it works not in every case with the very same URL returning the very same result. Sometimes Gnumeric can't handle the response and fails to interpret it. This is really strange because saving the result as file and loading it afterwards with Gnumeric works perfectly. I've got my hands on an Excel 97 installation running under NT. Here loading of the response failed because the whole table was interpreted as a single column of a string with several comma delimited entries. I tried to create a table in this Excel version and save it as cvs. The observation was that it is not comma (',') separated but semicolon (';') separated. When I tried this the effect in Gnumeric was unchanged (working *sometimes* directly - loading after saving was always perfect). But the situation in Excel did not change at all. I just tried to write a Python script which exactly produced what I've got from Excel saving as csv - Excel failed to load it correctly. The only way to get it right into Excel was to produce a file which has each field value enclosed into '"' (no there are no ',' in any of the values), to save the file with Netscape and then Excel was able to read the file which was not possible directly. IE version 5.5 is not even able to save uch kind of file as Excel file. Resume: If there is no solid way to export robust CSV which Excel is able to cope with I have to come back to my first question: How to use Perl in Zope. (And yes, I know Excel sucks - but this does not help.) Kind regards Andreas.

7 15

RE: [Zope] Zsync errors
by Adam Getchell 22 Oct '02

22 Oct '02

Andy, Hmmm, I changed it back to not using port 80. If you go to http://zopetest.hr.ucdavis.edu/STAGING you get "Zope staging synchronizer" which is the comment for my Zsync defined as: ZSyncer at /STAGING Edit ZSyncer Title: Zope staging synchronizer So I'm looking right at it. Still getting (from Zopedevel): "There was a problem with that comparison. Error: ProtocolError <ProtocolError for zopetest.hr.ucdavis.edu/STAGING: 500 Internal Server Error> Things to check: Your destination ZSyncer is where it is meant to be. The destination server is running and accessible. The user "zopeadmin" has the right to access ZSyncer. The password for "zopeadmin" is correct. I know the accounts in question have access rights, as I just logged on using them. So, your comment means that when I try to sync Zopedevel --> Zopetest, which end is failing? Thanks for your help, --Adam -----Original Message----- From: Andy McKay [mailto:andy@agmweb.ca] Sent: Monday, October 21, 2002 9:18 PM To: Adam Getchell; zope(a)zope.org Subject: Re: [Zope] Zsync errors > * ProtocolError > * <ProtocolError for zopetest.hr.ucdavis.edu:80/STAGING: 500 Internal > Server Error> Are you sure you have the right url? When ZSyncer is doing the request the destination server is encountering a 500 Error on the server, not ZSyncer. -- Andy McKay www.agmweb.ca ----- Original Message ----- From: "Adam Getchell" <AdamG(a)hrrm.ucdavis.edu> To: <zope(a)zope.org> Sent: Monday, October 21, 2002 8:29 PM Subject: [Zope] Zsync errors > Hello all, > > I moved Zope from an old box to a new one. I installed Zope 2.5.1 (same as > previous version), copied all of the products in the lib/python/Products, > and copied data.fs to /var/data.fs > > There are 3 boxes: zopetest, zopedevel, and production, with ZSyncs of > DEVEL, STAGING, and PROD respectively. > > Zsyncer seems to have broken between migrations, even though parameters are > the same: > > There was a problem with that comparison. > > Error: > > * ProtocolError > * <ProtocolError for zopetest.hr.ucdavis.edu:80/STAGING: 500 Internal > Server Error> > > Things to check: > > * Your destination ZSyncer is where it is meant to be. > * The destination server is running and accessible. > * The user "zopeadmin" has the right to access ZSyncer. > * The password for "zopeadmin" is correct. > > My destination has the same old Zsync instance. Zope is running and > accessible. My account and permissions haven't changed, as they're drawn > from the same data.fs. > > Any clues? > > Thanks, > > *************************** > * Adam Getchell > AdamG(a)hrrm.ucdavis.edu > * System Architect/Programmer (530) 752-1584 > * Human Resources Information Systems http://www.hr.ucdavis.edu/ > *************************** > "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu > > _______________________________________________ > Zope maillist - Zope(a)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 ) >

1 0

Zsync errors
by Adam Getchell 22 Oct '02

22 Oct '02

Hello all, I moved Zope from an old box to a new one. I installed Zope 2.5.1 (same as previous version), copied all of the products in the lib/python/Products, and copied data.fs to /var/data.fs There are 3 boxes: zopetest, zopedevel, and production, with ZSyncs of DEVEL, STAGING, and PROD respectively. Zsyncer seems to have broken between migrations, even though parameters are the same: There was a problem with that comparison. Error: * ProtocolError * <ProtocolError for zopetest.hr.ucdavis.edu:80/STAGING: 500 Internal Server Error> Things to check: * Your destination ZSyncer is where it is meant to be. * The destination server is running and accessible. * The user "zopeadmin" has the right to access ZSyncer. * The password for "zopeadmin" is correct. My destination has the same old Zsync instance. Zope is running and accessible. My account and permissions haven't changed, as they're drawn from the same data.fs. Any clues? Thanks, *************************** * Adam Getchell AdamG(a)hrrm.ucdavis.edu * System Architect/Programmer (530) 752-1584 * Human Resources Information Systems http://www.hr.ucdavis.edu/ *************************** "Invincibility is in oneself, vulnerability in the opponent." -- Sun Tzu

2 1