March 2000 - Zope - Zope lists

which Linux ?
by Jason Cunliffe 14 Mar '00

14 Mar '00

Hello We are about to configure a brand new machine for a Zopesite. Q: Which Linux to install.. We are tilting to RedHat.. Welcome any comparisons, recommendations, or guides about this.. RedHat SUSE Caldera Debian Corel ??.. -Is there a recent table or article which lists the pros and cons which relate to Linux family & Zope? -What are the statstics among Zope users ? -Does Digital Creations know? -Does it matter and if so : why / whynot? I do _not_ want to start Linux vs. Linux thread.. but it seems to me that a useful public page should be on zope.org with links to the How-Tos per Linux for gotchas etc.. If you prefer reply to me off-list. Thanks in advance any help. - Jason Cunliffe __________________________________________________________________________ Jason CUNLIFFE = NOMADICS.(Interactive Art and Technology).Design Director

5 4

RE: [Zope] More Z SQL head bashing...
by Daniel.Weber＠SEMATECH.Org 14 Mar '00

14 Mar '00

I had a similar problem I just puzzled through, though I'm pretty new and don't know the right ways yet :-) What I did was create another DSQl query (sql_newID) that queried for the new ID (select max(ID+1) as newID from table) and another sql_exist( select count *....) then I used this result, but it had to be within a <dtml-in > tag... <dtml-in sql_exist> <dtml-if "exist > 0"> <dtml-in sql_newID> insert into table (ID, name) values (<dtml-var newID>, <dtml-sqlvar name...> </dtml-in> </dtml-if> </dtml-in> This worked because I knew the sql_newID and sql_exist will only return a single value, so the loop only iterates once. I've never seen the <dtml-var sqldelimiter>, though, so I don't know what it does.... Maybe this will help..... > > Well, further to my earlier SQL post, here's the code I'm > trying to encapsulate, but it doesn't work > ;-) > The problem is one of getting a unique, integer, id from > MySQL to use as a primary key for an > INSERT. And no, an AUTO_INCREMENT column won't help here 'cos > I need to know what the number is > before I do the insert (it generates a reference number, > which is used as the primary key, and needs > to be given back to the person doing the submission...) > > Anyway, here's the Z SQL Method Code which goes into a MySQL > DB connection: > > SELECT COUNT(*) as exist FROM sequences WHERE > sequence=<dtml-sqlvar name type=string> > <dtml-var sql_delimiter> > <dtml-if "exist==0"> > INSERT INTO sequences SET sequence=<dtml-sqlvar name > type=string>, n=0 > </dtml-if> > <dtml-var sql_delimiter> > UPDATE sequences SET n=LAST_INSERT_ID(n+1) WHERE > sequence=<dtml-sqlvar name type=string> > <dtml-var sql_delimiter> > SELECT LAST_INSERT_ID() as number > > When I try to test the method, I get a NameError for exists, > which I presume is coming from the > dtml-if. Any idea what I'm doing wrong or other ways of > solving this problem? > > cheers, > > Chris > > _______________________________________________ > 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 ) >

2 1

FYI: Potentially speaking at BALUG next Tuesday
by Paul Everitt 14 Mar '00

14 Mar '00

Howdy sports fans. If the San Francisco traffic doesn't double cross me, I'll be speaking at the Bay Area Linux User's Group meeting next Tue, Mar 21. The complication arises because I'm speaking down in San Jose at SDWest from 5PM-6PM, then have to hurry back to hopefully make the BALUG meeting. Unfortunately I don't have a URL handy for time, location, etc., but I'll try and post it when I'm back in the office. The subject of the talk is, well, Zope, plus a Big Announcement. --Paul

1 0

Re: [Zope] EAGAIN errors crashing ZServer Aiieeee!!!!
by Jon Prettyman 14 Mar '00

14 Mar '00

I'm pretty sure now that async_loop is not exiting in my child process so I'm guessing it is some other type of abort. I'll try the gdb avenue. I'm pretty handy with that, but I've never done much debugging python or threaded apps so.... I also grepped around the code and looked over every 11, sys.exit and SystemExit I could find. This is a real pain. -Jon Michel Pelletier <michel(a)digicool.com> writes: > Jon Prettyman wrote: > > > > I've been reading through code trying to figure out what is going on > > here, where this message might be coming from. My current train of > > thought is that the 11 exit code being seen is in z2.py is a result of > > sys.ZServerExitCode getting set somewhere and z2.py exiting with that > > code. > > > > So I've been trying to find where code sets sys.ZServerExitCode and > > what I've found is in ZServer.HTTPResponse.ChannelPipe.close. In this > > routine, the value of self._shutdown is assigned to r which then gets > > assigned to sys.ZServerExitCode. > > > > It looks like self._shutdown only gets assigned when > > ZServer.HTTPResponse.ChannelPipe.finish gets called and a response > > header contains an bobo-exception-type of exceptions.SystemExit. > > > > So I'm guessing now that somewhere this exception is getting set but I > > can't seem to figure out why. > > There is only one reason why I can think of, clicking on the Shutdown > button. > > A quick grep shows sys.exit being called in a few places however, most > specificly in xmllib and pyexpat. None of these calls set a value of 11 > though. > > Are you using any XML? XML-RPC calls? > > > Am I completely off base here? > > Perhaps, it's a good avenue to look down however. What I suspect is > that something is happening (like a SIGSEGV) that is causing the OS to > send a signal to the process whose default action is to kill the > process, setting the error code to 11 for some as-yet mysterious reason > (11 has *got* to be the clue however, I refuse to believe that it is > arbitrary, note also that SIGSEGV is signal 11, coincidence?). A good > exercise may be to run Zope in gdb and wait, when one of these events > happens use gdb to inspect what's going on. I'm no gdb expert however, > but I was under the idea that it could tell you when signals arrive (or > perhaps stop the process on the arival of a signal...) > > I wrote a test script that forked a parent and child just like Zope. > When I sent the child a SIGSEGV it returned an error code of 332. Maybe > my experiment is flawed. > > Have you enough time to look that deeply? > > -Michel > > > > -Jon > > > > Michel Pelletier <michel(a)digicool.com> writes: > > > > > Hmm, a simple test script seems to indicate that sending a child process > > > a signal 11 does not cause it to dump core. Of course, it also does not > > > seem to cause it to return a status code of 11 either. This might not > > > be a SIGSEGV, it might just be a coincidence that the return code of the > > > (crashed) child is 11. (FYI, there are two processing going on here, a > > > 'watcher' parent and a child, the parent prints the 'Aieee!' when the > > > child dies. > > > > > > Does anyone out there know what a python program returning 11 means? > > > > > > -Michel > > > > > > Jon Prettyman wrote: > > > > > > > > Nope. No core file. > > > > > > > > Aieeeee!!!! > > > > -Jon

1 0

More Z SQL head bashing...
by Chris Withers 14 Mar '00

14 Mar '00

Hi, Well, further to my earlier SQL post, here's the code I'm trying to encapsulate, but it doesn't work ;-) The problem is one of getting a unique, integer, id from MySQL to use as a primary key for an INSERT. And no, an AUTO_INCREMENT column won't help here 'cos I need to know what the number is before I do the insert (it generates a reference number, which is used as the primary key, and needs to be given back to the person doing the submission...) Anyway, here's the Z SQL Method Code which goes into a MySQL DB connection: SELECT COUNT(*) as exist FROM sequences WHERE sequence=<dtml-sqlvar name type=string> <dtml-var sql_delimiter> <dtml-if "exist==0"> INSERT INTO sequences SET sequence=<dtml-sqlvar name type=string>, n=0 </dtml-if> <dtml-var sql_delimiter> UPDATE sequences SET n=LAST_INSERT_ID(n+1) WHERE sequence=<dtml-sqlvar name type=string> <dtml-var sql_delimiter> SELECT LAST_INSERT_ID() as number When I try to test the method, I get a NameError for exists, which I presume is coming from the dtml-if. Any idea what I'm doing wrong or other ways of solving this problem? cheers, Chris

1 0

sub-transaction in DTML?
by Jay, Dylan 14 Mar '00

14 Mar '00

I have a method that takes a long time on a system that uses a level 2 DA, therefore it blocks the entire site (it also uses UserDB so everything uses the DB). How can I put sub-transactions in my DTML to give others a chance to use the site?

2 1

Re: [Zope] EAGAIN errors crashing ZServer Aiieeee!!!!
by Jon Prettyman 14 Mar '00

14 Mar '00

I've been reading through code trying to figure out what is going on here, where this message might be coming from. My current train of thought is that the 11 exit code being seen is in z2.py is a result of sys.ZServerExitCode getting set somewhere and z2.py exiting with that code. So I've been trying to find where code sets sys.ZServerExitCode and what I've found is in ZServer.HTTPResponse.ChannelPipe.close. In this routine, the value of self._shutdown is assigned to r which then gets assigned to sys.ZServerExitCode. It looks like self._shutdown only gets assigned when ZServer.HTTPResponse.ChannelPipe.finish gets called and a response header contains an bobo-exception-type of exceptions.SystemExit. So I'm guessing now that somewhere this exception is getting set but I can't seem to figure out why. Am I completely off base here? -Jon Michel Pelletier <michel(a)digicool.com> writes: > Hmm, a simple test script seems to indicate that sending a child process > a signal 11 does not cause it to dump core. Of course, it also does not > seem to cause it to return a status code of 11 either. This might not > be a SIGSEGV, it might just be a coincidence that the return code of the > (crashed) child is 11. (FYI, there are two processing going on here, a > 'watcher' parent and a child, the parent prints the 'Aieee!' when the > child dies. > > Does anyone out there know what a python program returning 11 means? > > -Michel > > Jon Prettyman wrote: > > > > Nope. No core file. > > > > Aieeeee!!!! > > -Jon > > > > > > Okay, this is what I'm getting consistently when my server crashes > > > > under moderate load: > > > > > > > > ------ > > > > 2000-03-13T18:53:02 INFO(0) GUF Successful authentication for user April (http://207.241.10.50/premium/acl_users) > > > > ------ > > > > 2000-03-13T19:01:40 INFO(0) GUF Successful authentication for user thomas (http://www.nationalmortgagenews.com/premium/acl_users) > > > > ------ > > > > 2000-03-13T19:02:24 INFO(0) GUF Successful authentication for user terrydpeters (http://207.241.10.50/premium/acl_users) > > > > ------ > > > > 2000-03-13T19:03:36 ERROR(200) zdaemon zdaemon: Mon Mar 13 13:03:36 2000: Aiieee! 17065 exited with error code: 11 > > > > ------ > > > > 2000-03-13T19:03:36 INFO(0) zdaemon zdaemon: Mon Mar 13 13:03:36 2000: Houston, we have forked > > > > ------ > > > > 2000-03-13T19:03:36 INFO(0) zdaemon zdaemon: Mon Mar 13 13:03:36 2000: Hi, I just forked off a kid: 17125 > > > > ------ > > > > 2000-03-13T19:03:36 INFO(0) zdaemon zdaemon: Mon Mar 13 13:03:36 2000: Houston, we have forked > > > > ------ > > > > 2000-03-13T19:03:58 PROBLEM(100) ZServer Cannot do reverse lookup > > > > ------ > > > > 2000-03-13T19:03:58 INFO(0) ZServer Medusa (V1.13) started at Mon Mar 13 13:03:58 2000 > > > > Hostname: 207.241.10.50 > > > > Port:80 > > > > > > > > ------ > > > > 2000-03-13T19:03:58 INFO(0) ZServer FTP server started at Mon Mar 13 13:03:58 2000 > > > > Authorizer:None > > > > Hostname: magmar > > > > Port: 8021 > > > > > > > > From the debug log: > > > > B 144485000 2000-03-13T19:03:02 GET /nmn/images/marketplacebutton.gif > > > > I 144485000 2000-03-13T19:03:02 0 > > > > A 144485000 2000-03-13T19:03:02 304 182 > > > > E 144485000 2000-03-13T19:03:02 > > > > B 144484496 2000-03-13T19:03:09 GET /id.htm > > > > I 144484496 2000-03-13T19:03:09 0 > > > > A 144484496 2000-03-13T19:03:09 200 3740 > > > > E 144484496 2000-03-13T19:03:09 > > > > B 143155832 2000-03-13T19:03:10 GET /newsubsid.gif > > > > I 143155832 2000-03-13T19:03:10 0 > > > > A 143155832 2000-03-13T19:03:10 200 45513 > > > > E 143155832 2000-03-13T19:03:10 > > > > B 145239016 2000-03-13T19:03:14 GET /nmn/images/marketplacebutton.gif > > > > I 145239016 2000-03-13T19:03:14 0 > > > > A 145239016 2000-03-13T19:03:14 304 163 > > > > E 145239016 2000-03-13T19:03:14 > > > > B 146772968 2000-03-13T19:03:32 GET /nmn/images/afstitle.gif > > > > I 146772968 2000-03-13T19:03:32 0 > > > > A 146772968 2000-03-13T19:03:32 304 182 > > > > E 146772968 2000-03-13T19:03:32 > > > > B 139605816 2000-03-13T19:03:59 GET /nmn/images/marketplacebutton.gif > > > > I 139605816 2000-03-13T19:03:59 0 > > > > A 139605816 2000-03-13T19:04:01 304 163 > > > > E 139605816 2000-03-13T19:04:01 > > > > B 139494360 2000-03-13T19:04:07 POST /premium/acl_users/register > > > > I 139494360 2000-03-13T19:04:07 518 > > > > A 139494360 2000-03-13T19:04:10 200 8704 > > > > E 139494360 2000-03-13T19:04:10 > > > > B 139787784 2000-03-13T19:04:28 GET /nmn/images/marketplacebutton.gif > > > > I 139787784 2000-03-13T19:04:28 0 > > > > A 139787784 2000-03-13T19:04:28 304 182 > > > > E 139787784 2000-03-13T19:04:28 > > > > > > > > I'm running Linux 2.2.12-20, Zope 2.1.4, currently with only ZServer > > > > (and FTP server.) Things get even flakier when I am running with > > > > PCGI. > > > > > > _______________________________________________ > 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 )

2 1

httpd.conf HELP! please
by Sachin Shah 14 Mar '00

14 Mar '00

Good evening. We are a student group here at University of California, Berkeley, and for the past couple of months we have been trying (unsuccessfully) to get Zope to work with Apache properly. (We are Residential Computing, a group which provides connectivity and support to the residence halls at the UC Berkeley.) The situation is as follows: Right now, apache has been configured to pass all requests to zope.cgi except for our personal pages (/about/staff), which a rewrite rule is directing to a static file system location. Our problem lies in an internal section of our site. We call it /internal/. What we are having problems with is getting Apache to authenticate the user BEFORE it redirects to /internal/ in Zope. The other snag: everything under /internal/ is under SSL. One area where we are not certain is if the require user authentication specs should be in LOCATION tags or DIRECTORY tags. In addition to advice, if you have a similar set-up we would really appreciate a snap-shot of your httpd.conf. I have included snippits of out httpd.conf file below. Thanks for your help, Sachin =================BEGIN================== <VirtualHost 169.229.70.158:80> ServerName www.rescomp.berkeley.edu ErrorLog /var/log/apache/error.www.rescomp.berkeley.edu TransferLog /var/log/apache/access.www.rescomp.berkeley.edu # Setup document root DocumentRoot "/servers/www/rescomp/docs" <Directory "/servers/www/rescomp/docs"> Options FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> # Added for conversion to Zope <Directory /servers/www/rescomp/cgi-bin> Options +ExecCGI +FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> # <Location ~ "*manage"> # AuthUserFile /opt/apache/etc/htpasswd # AuthGroupFile /opt/apache/etc/htgroup # AuthType Basic # AuthName Zope_is_my_friend # SSLRequireSSL # require valid-user # </Location> RewriteEngine on RewriteRule ^/internal(.*) /servers/www/rescomp/docs/internal$1 RewriteRule ^(.*)/manage https://www.rescomp.berkeley.edu$1/manage [L] RewriteRule ^/internal/(.*) https://www.rescomp.berkeley.edu/internal/$1 [L] RewriteRule ^/about/staff/(.*) /servers/www/rescomp/docs/about/staff/$1 [L] RewriteRule ^/~(.*) /servers/www/rescomp/docs/about/staff/$1 [L] RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^(.*) /servers/www/rescomp/cgi-bin/Zope$1 [e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] # End Zope additions ...continues.... <IfModule mod_ssl.c> <VirtualHost 169.229.70.158:443> ServerName www.rescomp.berkeley.edu ErrorLog /var/log/apache/error.www.rescomp.berkeley.edu TransferLog /var/log/apache/access.www.rescomp.berkeley.edu SSLEngine On # Setup document root DocumentRoot "/servers/www/rescomp/docs" <Directory "/servers/www/rescomp/docs"> Options FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> # Added for conversion to Zope <Directory /servers/www/rescomp/cgi-bin> Options +ExecCGI +FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory> # <Location ~ "*manage"> # AuthUserFile /opt/apache/etc/htpasswd # AuthGroupFile /opt/apache/etc/htgroup # AuthType Basic # AuthName Zope_is_my_friend # SSLRequireSSL # require valid-user # </Location> RewriteEngine on RewriteRule ^/internal(.*) https://www.rescomp.berkeley.edu/internal$1 RewriteCond %{HTTP:Authorization} ^(.*) RewriteRule ^(.*) /servers/www/rescomp/cgi-bin/Zope$1 [e=HTTP_CGI_AUTHORIZATION:%1,t=application/x-httpd-cgi,l] # End Zope additions ==============END=================== -- ------------------------------------------------ -= Sachin Shah :: Lead Marketing/Web Design =- -= sachin(a)rescomp.berkeley.edu =- https://www.rescomp.berkeley.edu/~sachin/ -----------------------------------------------

2 1

Time Stamp
by Tom Scheidt 14 Mar '00

14 Mar '00

How can I automatically stamp the date and time to a page when it is created? ************************* Tom Scheidt www.falsemirror.com tom(a)falsemirror.com *************************

1 0

RE: [Zope] dtml-in iteration over a string.split
by Daniel.Weber＠SEMATECH.Org 14 Mar '00

14 Mar '00

> > This is untested but it should do the trick:) > > <dtml-if "_.int(sequence-size) > 1"> This gives a key error as well. To summarize what I'm trying to do: <dtml-in "_.string.split(string_with_1_or_more_words)"> <dtml-if "we_have_>_1_items"> we have <dtml-var what_is_this_var?> items <dtml-else> we have only 1 item </dtml-if> I can do the > 1 check with <dtml-if "_.len(_.string.split(string)) > 1">, but it seems I should be able to get to a count-nnn var inside. Since I'm not using a SQL statement, I don't know what the variable is named. sequence-size give a name error wherever I use it (from the test screen of a SQL query). <dtml-var sequence-key> returns the fist digit of the word. So, the question is, in the statement: <dtml-in "_.string.split('item_1 item_2 item_3')> what will the count-nnn variable be named?

2 1