I've got zope running on an intranet NT server and its ODBC connection keeps a number of database files open at all times which my backup system can't handle. Hitting the zope control panel restart button closes those files long enough to get them backed up, but I'd like to do this later at night and automatically because the files get opened again as soon as someone hits the site (all the picklists, etc come out of the ODBC database files). So far I can't figure out how to do this. It looks like just hitting the URL http://superuser:password@myserver/Control_Panel/manage_restart? should work (I'm using wget on a linux box to do this) should work, and it DOES work from IE, but it doesn't work from wget - here's what happens with wget doing this with that exact same url: I guess wget tries without authorization first: Server: Zope/Zope 2.1.4 (binary release, python 1.5.2, win32-x86) ZServer/1.1b1 Date: Thu, 27 Apr 2000 20:47:13 GMT Www-Authenticate: basic realm="Zope" Bobo-Exception-File: C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\HTTPResponse.py Bobo-Exception-Type: Unauthorized Content-Type: text/html Connection: close Bobo-Exception-Value: <strong>You are not authorized to access this resource.</s trong> Content-Length: 1376 Bobo-Exception-Line: 551 then wget says this: Closing fd 4 Connecting to 128.1.1.200:8080... Created fd 4. connected! ---request begin--- GET /Control_Panel/manage_restart? HTTP/1.0 User-Agent: Mozilla/4.0 Host: 128.1.1.200:8080 Accept: */* Authorization: Basic c3VwZXJ1c2VyOnRob21hcw== ---request end--- HTTP request sent, awaiting response... HTTP/1.0 500 Internal Server Error Server: Zope/Zope 2.1.4 (binary release, python 1.5.2, win32-x86) ZServer/1.1b1 Date: Thu, 27 Apr 2000 20:47:13 GMT Bobo-Exception-File: C:\PROGRA~1\WEBSITE3\lib\python\App\ApplicationManager.py Content-Type: text/html Bobo-Exception-Type: exceptions.SystemExit Connection: close Bobo-Exception-Value: bobo exception Content-Length: 875 Bobo-Exception-Line: 320 Closing fd 4 16:48:29 ERROR 500: Internal Server Error. Then, from that point on, trying to access anything on that site gives me this: Error: Error Type: ValueError Error Value: I/O operation on closed file Traceback: Traceback (innermost last): File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\Publish.py, line 165, in publish File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\mapply.py, line 160, in mapply (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\ZPublisher\Publish.py, line 102, in call_object (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\App\special_dtml.py, line 120, in __call__ (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\DocumentTemplate\DT_String.py, line 502, in __call__ (Object: manage_main) File C:\PROGRA~1\WEBSITE3\lib\python\DocumentTemplate\DT_In.py, line 691, in renderwob (Object: objectItems) File C:\PROGRA~1\WEBSITE3\lib\python\App\PersistentExtra.py, line 114, in locked_in_version (Object: MailHost) File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\Connection.py, line 380, in modifiedInVersion File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\DB.py, line 356, in modifiedInVersion File C:\PROGRA~1\WEBSITE3\lib\python\ZODB\FileStorage.py, line 593, in modifiedInVersion (Object: C:\PROGRA~1\WEBSITE3/var/Data.fs) ValueError: I/O operation on closed file and the only way to get zope going again is to manually restart it in NT Control Panel using the Services dialog box. Anybody see what I'm doing wrong here?
On Thu, 27 Apr 2000 16:50:05 -0400, "Gustin Kiffney" <Gustin_Kiffney@fd.org> wrote:
and the only way to get zope going again is to manually restart it in NT Control Panel using the Services dialog box.
Why not control the service directly using "net stop zope" and "net start zope"? Toby Dickenson tdickenson@geminidataloggers.com
participants (2)
-
Gustin Kiffney -
Toby Dickenson