June 1999 - Zope - Zope lists

Info on Crash of ZopeHTTPserver
by Francois-Regis CHALAOUX 03 Jun '99

03 Jun '99

Hi All, I am using web applications in production with 1.10.2+ZHTTPserver under RH Linux 5.2 What can I do to have Zope s own server work continuously, without manual re-starts every day? At the begining I did not broke this server but now the delais before crash is growing :( Is the zope db corrupt? Hope your help, FR. PS : I am testing 2.0a but not in production .... Error === 204.140.91.89 - - [02/Jun/1999 14:31:49] "GET /Formation/index_html HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:49] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:49] "GET /Formation/bgrose HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:49] "GET /Formation/Images/fleched HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:49] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:50] "GET /Formation/sblogo HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:56] "GET /Formation/publier/index_html HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:56] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:56] "GET /Formation/bgrose HTTP/1.1" 200 - Traceback (innermost last): File "ZopeHTTPServer/ZopeHTTPServer.py", line 388, in handle_request self.process_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 239, in process_request self.finish_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 243, in finish_request self.RequestHandlerClass(request, client_address, self) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 362, in __init__ self.handle() File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 258, in handle method() File "ZopeHTTPServer/ZopeHTTPServer.py", line 292, in do_GET self.publish_module() File "ZopeHTTPServer/ZopeHTTPServer.py", line 305, in publish_module publish_module( File "/opt/digicool/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py", line 893, in publish_module if response: stdout.write(response) File "ZopeHTTPServer/ZopeHTTPServer.py", line 239, in write self.handler.send_response(string.atoi(code),message) File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 304, in send_response self.wfile.write("%s %s %s\r\n" % IOError: (32, 'Broken pipe') 204.140.91.89 - - [02/Jun/1999 14:31:56] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:57] "GET /Formation/Images/fleched HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:31:57] "GET /Formation/sblogo HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:00] "GET /Formation/publier/outils/ HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:00] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:00] "GET /Formation/bgrose HTTP/1.1" 200 - Traceback (innermost last): File "ZopeHTTPServer/ZopeHTTPServer.py", line 388, in handle_request self.process_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 239, in process_request self.finish_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 243, in finish_request self.RequestHandlerClass(request, client_address, self) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 362, in __init__ self.handle() File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 258, in handle method() File "ZopeHTTPServer/ZopeHTTPServer.py", line 292, in do_GET self.publish_module() File "ZopeHTTPServer/ZopeHTTPServer.py", line 305, in publish_module publish_module( File "/opt/digicool/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py", line 893, in publish_module if response: stdout.write(response) File "ZopeHTTPServer/ZopeHTTPServer.py", line 239, in write self.handler.send_response(string.atoi(code),message) File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 304, in send_response self.wfile.write("%s %s %s\r\n" % IOError: (32, 'Broken pipe') 204.140.91.89 - - [02/Jun/1999 14:32:00] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:00] "GET /Formation/sblogo HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:02] "GET /Formation/publier/outils/frontpage HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:02] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:02] "GET /Formation/bgrose HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:02] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:02] "GET /Formation/sblogo HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:06] "GET /Formation/publier/outils/ HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:06] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:07] "GET /Formation/bgrose HTTP/1.1" 200 - Traceback (innermost last): File "ZopeHTTPServer/ZopeHTTPServer.py", line 388, in handle_request self.process_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 239, in process_request self.finish_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 243, in finish_request self.RequestHandlerClass(request, client_address, self) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 362, in __init__ self.handle() File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 258, in handle method() File "ZopeHTTPServer/ZopeHTTPServer.py", line 292, in do_GET self.publish_module() File "ZopeHTTPServer/ZopeHTTPServer.py", line 305, in publish_module publish_module( File "/opt/digicool/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py", line 893, in publish_module if response: stdout.write(response) File "ZopeHTTPServer/ZopeHTTPServer.py", line 239, in write self.handler.send_response(string.atoi(code),message) File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 304, in send_response self.wfile.write("%s %s %s\r\n" % IOError: (32, 'Broken pipe') 204.140.91.89 - - [02/Jun/1999 14:32:07] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:07] "GET /Formation/sblogo HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:07] "GET /Formation/publier/index_html HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:07] "GET /Formation/default.css HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:08] "GET /Formation/bgrose HTTP/1.1" 200 - Traceback (innermost last): File "ZopeHTTPServer/ZopeHTTPServer.py", line 388, in handle_request self.process_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 239, in process_request self.finish_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 243, in finish_request self.RequestHandlerClass(request, client_address, self) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 362, in __init__ self.handle() File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 258, in handle method() File "ZopeHTTPServer/ZopeHTTPServer.py", line 292, in do_GET self.publish_module() File "ZopeHTTPServer/ZopeHTTPServer.py", line 305, in publish_module publish_module( File "/opt/digicool/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py", line 893, in publish_module if response: stdout.write(response) File "ZopeHTTPServer/ZopeHTTPServer.py", line 239, in write self.handler.send_response(string.atoi(code),message) File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 304, in send_response self.wfile.write("%s %s %s\r\n" % IOError: (32, 'Broken pipe') 204.140.91.89 - - [02/Jun/1999 14:32:08] "GET /Formation/Images/blank HTTP/1.1" 200 - 204.140.91.89 - - [02/Jun/1999 14:32:08] "GET /Formation/Images/fleched HTTP/1.1" 200 - Traceback (innermost last): File "ZopeHTTPServer/ZopeHTTPServer.py", line 388, in handle_request self.process_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 239, in process_request self.finish_request(request, client_address) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 243, in finish_request self.RequestHandlerClass(request, client_address, self) File "/var/tmp/python-root/usr/lib/python1.5/SocketServer.py", line 362, in __init__ self.handle() File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 258, in handle method() File "ZopeHTTPServer/ZopeHTTPServer.py", line 292, in do_GET self.publish_module() File "ZopeHTTPServer/ZopeHTTPServer.py", line 305, in publish_module publish_module( File "/opt/digicool/zope/Zope-1.10.2-src/lib/python/ZPublisher/Publish.py", line 893, in publish_module if response: stdout.write(response) File "ZopeHTTPServer/ZopeHTTPServer.py", line 239, in write self.handler.send_response(string.atoi(code),message) File "/var/tmp/python-root/usr/lib/python1.5/BaseHTTPServer.py", line 304, in send_response self.wfile.write("%s %s %s\r\n" % IOError: (32, 'Broken pipe')

2 1

RE: [Zope] non-zope users
by Michel Pelletier 03 Jun '99

03 Jun '99

> -----Original Message----- > From: Paul Everitt [mailto:paul@digicool.com] > Sent: Thursday, June 03, 1999 7:40 PM > To: Daniel M. Drucker > Cc: Zope List > Subject: Re: [Zope] non-zope users > > > > Daniel-- > > How about an Apache rewrite rule? (Don't remember if you are using > Apache or not...) > > --Paul > I was going to suggest this also. On our site, for example, we want /mailman to go to the mailman CGI scripts. So, before the RewriteRule that hoses everything into Zope, we have another RewriteRule that 'catches' anything that starts with /mailman and sends it to mailman before it can hit the main RewriteRule. We actually have a couple of these catches, and they work quite well. -Michel

1 0

RE: [Zope] Info on Crash of ZopeHTTPserver
by Michel Pelletier 03 Jun '99

03 Jun '99

> -----Original Message----- > From: Francois-Regis CHALAOUX > [mailto:fchalaou@strasbourg.synthelabo.fr] > Sent: Thursday, June 03, 1999 6:41 AM > To: zope(a)zope.org > Subject: [Zope] Info on Crash of ZopeHTTPserver > > > > Hi All, > > I am using web applications in production with > 1.10.2+ZHTTPserver under RH Linux 5.2 > > What can I do to have Zope s own server work > continuously, without manual re-starts every day? > > At the begining I did not broke this server but now the > delais before crash is growing :( > Is the zope db corrupt? > > Hope your help, FR. > > PS : I am testing 2.0a but not in production .... > > Error > === > <snip> Thanks for sending tracebacks, they are helpful. It looks to me like Zope is not crashing at all, but the actually ZopeHTTPServer is. Since we no longer develop ZopeHTTPServer, I suspect your problem will go away if you switch to either ZServer or Apache. Unfourtunatly, it wouldn't be worth our time researching this problem as we don't plan on continuing development on ZHTTPServer anyway. -Michel

1 0

RE: [Zope] Testing for NULL values in TinyTable
by Miller, John M. 03 Jun '99

03 Jun '99

Are you doing  _before_ the ? Sorry, that's probably a silly question for me to ask, but I want to be sure I have my bases covered. I have had a similar sounding problem working with an Access database connected to Zope using the ZODBC connector. The problem seems to have gone away after I started using the following test:  [Do something here]  This is likely more than verbose than it needs to be, but it does the trick. It looks like you are doing almost the exact same thing, except you aren't as explicit as I am being in my #if statement. My hunch is that difference is important.  just checks to see if sql-var-name exists, which it does since your ZSQL method defined it in accessing your DB. Doing  checks the _value_ of sql-var-name, which is probably what you really what. Oh great Zope masters, did I get that right? I will so happy if that is so... I'm new to the game so you should to take anything I say with a bit more than a grain of salt. That said I hope this is of some use to you, Zope on brave comrade! John Miller > -----Original Message----- > From: Itai Tavor [SMTP:itavor@vic.bigpond.net.au] > Sent: Thursday, June 03, 1999 5:43 AM > To: zope(a)zope.org > Subject: [Zope] Testing for NULL values in TinyTable > > Hi, > > I have a problem accessing TinyTable cells having NULL values. > > In the following table: > > Columns: name r1 r2 r3 > > Data: > aaa, 1, 2, 3 > bbb, 1, 2, NULL (the NULL is added by TinyTable when no value is specified > for a cell) > > When iterating over the table rows: > >  > > Each cell is added to the namespace, so I can access it with , or  > > The problem is that I can't deal with r3 in the 2nd row. Everything I try > to do with it (like , ) ends in a "You are not > authorized to access r3" error! > > Any ideas? > > Thanks, > Itai Tavor > -- > Itai Tavor -- "Je sautille, donc je suis." -- > itavor(a)vic.bigpond.net.au -- - Kermit the Frog -- > -- "What he needs now is understanding... and a confederate victory" -- > -- Dr. Jacobi, Twin Peaks -- > > > _______________________________________________ > Zope maillist - Zope(a)zope.org > http://www.zope.org/mailman/listinfo/zope > > (For developer-specific issues, use the companion list, > zope-dev(a)zope.org - http://www.zope.org/mailman/listinfo/zope-dev )

2 1

RE: [Zope] Pb with Zope-1_11_0pr1 and extra acl user folder.
by Brian Lloyd 03 Jun '99

03 Jun '99

> Hello > > I have a new problem using Zope-1_11_0pr1: > > - The added user-folder seams to have no effect. Inside the > CVS I found that > this is a know bug: User.py V1.79:'Changed to use this to fix > a problem that > caused all added user folders to be ineffective.' > So I got the lastest Role.py(1.79) -> same result. > I got all the new AccessControl python files-> same > > My extra user-folders are still ineffective. After putting > some debuging > print arround User.py, it look to me that the validate method > look inside a > user folder which contain a list of user = []. Except if I > put my user in > the top acl-folder. > > > Has someone a solution? Gilles, You need to delete and then re-create your extra user folders, unfortunately. The nature of the bug is such that user folders created while the bug was present will not be automatically fixed by the code update. If this is an extreme problem for you, you can shutdown your Zope process, cd to your installation's lib/python directory, start Python and do something like the following for each of your extra user folders: # for each of your broken user folders, you need to # assign it to the __allow_groups__ variable of its # container object import Main myuserfolder=Main.app.foobar.acl_users Main.app.foobar.__allow_groups__=myuserfolder get_transaction().commit() Hope this helps! Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

1 0

Testing for NULL values in TinyTable
by Itai Tavor 03 Jun '99

03 Jun '99

Hi, I have a problem accessing TinyTable cells having NULL values. In the following table: Columns: name r1 r2 r3 Data: aaa, 1, 2, 3 bbb, 1, 2, NULL (the NULL is added by TinyTable when no value is specified for a cell) When iterating over the table rows:  Each cell is added to the namespace, so I can access it with , or  The problem is that I can't deal with r3 in the 2nd row. Everything I try to do with it (like , ) ends in a "You are not authorized to access r3" error! Any ideas? Thanks, Itai Tavor -- Itai Tavor -- "Je sautille, donc je suis." -- itavor(a)vic.bigpond.net.au -- - Kermit the Frog -- -- "What he needs now is understanding... and a confederate victory" -- -- Dr. Jacobi, Twin Peaks --

1 0

FYI: Nice Zope article in Troubleshooters
by Paul Everitt 03 Jun '99

03 Jun '99

>From the page at: http://www.zope.org/Information/Media "Digital Creations", http://www.troubleshooters.com/tpromag/199906/_digcreate.htm. Steve Litt seems to be everywhere, including our booth at Linux Expo. This article is one of the best, most concise reports of what we did, why we did it, and why it will work. *Steve Litt, Troubleshooters Magazine, June 1999.* (Isn't structured text cool!) --Paul

1 0

Pb with Zope-1_11_0pr1 and extra acl user folder.
by Gilles lavaux 03 Jun '99

03 Jun '99

Hello I have a new problem using Zope-1_11_0pr1: - The added user-folder seams to have no effect. Inside the CVS I found that this is a know bug: User.py V1.79:'Changed to use this to fix a problem that caused all added user folders to be ineffective.' So I got the lastest Role.py(1.79) -> same result. I got all the new AccessControl python files-> same My extra user-folders are still ineffective. After putting some debuging print arround User.py, it look to me that the validate method look inside a user folder which contain a list of user = []. Except if I put my user in the top acl-folder. Has someone a solution? (Jim?) Thanks Gilles Lavaux

1 0

Fully render dtml object from external method - solved !
by Dr. Ross Lazarus 03 Jun '99

03 Jun '99

At last. With some help from Kent Polk, I stumbled across a way to do what I needed. This little external method will spit back a fully rendered html version of every dtml document (methods work too) in the folder you call it from. Looks like the calling of the dtml object with self, request and globals as parameters is the way forward....I'm sure there's a more elegant way to do this but at least it works. You need this if you want to (for example) save a fully rendered html version of your zope pages to a disk file... #publish test #rml june 1999 import Globals,DocumentTemplate,string def rehtml(s=''): ''' strip out and replace quoted html tags str(o) seems to return quoted html not sure what the right call is - but this fixes it... rml may 1999 ''' rep = [('<','<'),('>','>'),('"','"'),('&','&')] for rold,nnew in rep: s = string.join(string.split(s,rold),nnew) return s def render_dtml_docs_to_html(self,REQUEST): s = [] for t in ('DTML Method','DTML Document'): for docid,doc in self.objectItems([t]): try: r = rehtml(doc(self,REQUEST,globals())) s.append(r) except: pass # methods which need request form vars will fail ! return string.join(s,'\n') -- Dr Ross Lazarus Associate Professor and Sub-Dean for Information Technology Faculty of Medicine, Room 126A, A27, University of Sydney, Camperdown, NSW 2006, Australia Tel: (+61 2) 93514429 Mobile: +61414872482 Fax: (+61 2) 93516646 Email: rossl(a)med.usyd.edu.au http://www.health.usyd.edu.au/people/rossl.htm

1 0

Re: [Zope] Date Problem of ODBC DA
by Jay, Dylan 03 Jun '99

03 Jun '99

>Date: Wed, 02 Jun 1999 16:17:32 +0800 >From: "T. C. Huang" <a00tch00(a)nchc.gov.tw> >To: zope(a)zope.org, mj(a)antraciet.nl >Subject: [Zope] Date Problem of ODBC DA >Hi, > I access the data in Oracle 7.3(AIX server) through ODBC DA on NT >platform. Things work well unitl the table has column with DATE type. >When my SQL method is "select start_date from project_table", and test >it in Zope 1.10.2, I get only "Sorry, an error occurred.". > Is it a problem of Zope or ODBC DA? How to fix it? > >T. C. Huang Your problem is with the implimentation of DateTime. It doesn't support the timezone your in properly. You will need to discover the text label for the timezone that python is reporting to DateTime and put something like this in the DateTime class. _zmap={'aest':'GMT+1000', 'aedt':'GMT+1100', 'aus eastern standard time':'GMT+1000', The datetime code should be changed to find the current timezone as its offset rather than its text label. This way this problem would never happen!!!

1 0