- Zope - Zope lists

FW: [Zope] (116) unable to connect, fd=3
by Michel Pelletier 03 Jun '99

03 Jun '99

(forwarding to list, was not CC'ed accidentally) > -----Original Message----- > From: Michel Pelletier > Sent: Thursday, June 03, 1999 12:39 PM > To: 'Tim Hawes'; Michel Pelletier > Subject: RE: [Zope] (116) unable to connect, fd=3 > > > > > > -----Original Message----- > > From: Tim Hawes [mailto:tim.hawes@ncmail.net] > > Sent: Thursday, June 03, 1999 1:03 PM > > To: Michel Pelletier > > Subject: Re: [Zope] (116) unable to connect, fd=3 > > > > > > Michel Pelletier wrote: > > > > > > -----Original Message----- > > > > From: Tim Hawes [mailto:tim.hawes@ncmail.net] > > > > Sent: Thursday, June 03, 1999 11:32 AM > > > > To: Michel Pelletier; zope(a)zope.org > > > > Subject: Re: [Zope] (116) unable to connect, fd=3 > > > > > > > > > > > > > > > > This seems to be the bit of code it chokes on: > > > > > > > >  > > > > To: 9198343441.@pagenet.net > > > > From:  > > > >  > > > >  > > > > > > > > But isn't this up to spec? > > > > > > > > > > Nope. You need quotes around the expressions, as in > > expr="". It should > > > raise a syntax error, however. Why this bombs your python > > is unknown, > > > must be a bug of some kind. Put quotes around your > > expressions and try > > > it again. > > > > > > > Nope, didn't work. I wonder if I have stumbled accross a bug. > > I wish I knew > > more of its nature. :-/ > > > > Put just this bit of DTML into a method (lets it's called > 'themethod') somewhere in your root Zope folder. > > *Shut down Zope* > > go to 'Zopedir/lib/python' > > do this: > > [michel@aldous python]$ python > Python 1.5.1 (#2, Jan 26 1999, 10:47:10) [GCC 2.7.2.3] on linux2 > Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam > >>> import ZPublisher, Main > >>> > ZPublisher.Main('themethod?pin=blah&from=blah(a)blah.com&message > =blahblah') > > > 'themethod' should be the name of the method containing the > errant DTML code > > 'pin', 'from', and 'message' should be sensable values that > make your code fail through the web also. > > ZPublisher.Main has the effect of calling 'themethod' just > like a web request would. Something is happening to make > your pcgi connection fail with the Zope long running process, > and thus you cannot see the error that the python process is > giving you. Since pcgi is not involved in this little test, > you will see the error printed on your terminal. It could be > a syntax error, a core dump, an SMTP error that causes > something to get sent to stderr instead of raising an > exception, who knows. Sniff it out. > > -Michel > > > -- > > > > Tim Hawes > > tim.hawes(a)ncmail.net > > > > > > >

1 0

RE: [Zope] (116) unable to connect, fd=3
by Michel Pelletier 03 Jun '99

03 Jun '99

> -----Original Message----- > From: Tim Hawes [mailto:tim.hawes@ncmail.net] > Sent: Wednesday, June 02, 1999 10:26 AM > To: 'zope(a)zope.org' > Subject: [Zope] (116) unable to connect, fd=3 > > > I am using Zope 1.10.2 on Solaris 2.6 > I have had Zope running here flawlessly until recently. > > We have a web page called "Who's Who". It queries an Oracle > database to get > a list of people in our department, and hyperlinks pager pin number if > someone wanted to send an e-mail message to one of our pagers > (through Page > Net). Clinking on a pin number that coresponds to one of our > staff members > queries the database again to bring up the staff member name and pin > number, and > brings up a page where the user can then enter who the page > is from and the > message. Then the user hits submit and the data is sent to a > dtml document > with sendmail commands for a pager message to be sent to Page Net. > Sounds cool. > It has worked flawlessly until recently. Now when a user tries to send > their page, they get the following: > > ! Temporarily Unavailable > > The resource you requested is temporarily unavailable - > please try > again later. > (116) unable to connect, fd=3 > > And then pcgi dies. Yes this is a pcgi error. This can happen for a few reasons (Jeff do you know what this error means exactly?) I've had similar errors happen when there are syntax errors in ZPublisher, Python core dumps, and other strange happening. I would try to factor the problem down,  out sections of your code until you find the line that causes the error, and then investigate it's failure from the top down. -Michel > > -- > > Tim Hawes > tim.hawes(a)ncmail.net > >

3 2

RE: [Zope] (116) unable to connect, fd=3
by Michel Pelletier 03 Jun '99

03 Jun '99

> -----Original Message----- > From: Tim Hawes [mailto:tim.hawes@ncmail.net] > Sent: Thursday, June 03, 1999 11:32 AM > To: Michel Pelletier; zope(a)zope.org > Subject: Re: [Zope] (116) unable to connect, fd=3 > > > > This seems to be the bit of code it chokes on: > >  > To: 9198343441.@pagenet.net > From:  >  >  > > But isn't this up to spec? > Nope. You need quotes around the expressions, as in expr="". It should raise a syntax error, however. Why this bombs your python is unknown, must be a bug of some kind. Put quotes around your expressions and try it again. BTW,  is the same as  You don't need expr= anymore, it's use is depreciated. If your var argiment is in double quotes, it's an expression. -Michel > -- > > Tim Hawes > tim.hawes(a)ncmail.net > > >

1 0

Any way of entering data into TinyTable via DTML?
by Tony McDonald 03 Jun '99

03 Jun '99

Hi, I've looked through the source for TinyTable B2 and can't see anything obvious. My requirement is to do a one-time SQL query to a MySQL database (the database content is not very dynamic) and then populate a TinyTree table with the results and use that for lookups later. possible? sensible? TIA Tone

3 2

RE: [Zope] Info on Crash of ZopeHTTPserver
by Chris Petrilli 03 Jun '99

03 Jun '99

> > 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? > > Switch to ZServer. Really. ZopeHTTPServer is, um, a tad > flaky. ZServer is > very very nice, and has been rock solid for me for a few > weeks of solid(ish) > use now. This is basically the best answer... we're not planning to make any further changes/additions/fixes to ZopeHTTPServer (which was used instead of Apache in early releases), and it will most likely "go away" within a few releases. It's just a hacked up version of the BaseHTTPServer that comes with Python. It's very slow, though functional. ZServer is probably your best bet, unless you need something that Apache can provide---i.e. SSL, etc. Chris

1 0

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