Two types of messages:

First in its death throws: [Wed Sep 27 16:54:08 2000] [error] [client 192.168.2.52] FastCGI: comm with server "apache_server_path/htdocs/zope" aborted: idle timeout (30 sec)

And later when its all over: [Thu Sep 28 08:07:11 2000] [error] [client 192.168.2.52] (111)Connection refused

: FastCGI: failed to connect to server "apache_server_path/htdocs/zope":

connect() failed

It will run fine for quite some time but then it dies. There are no other refereces to zope in the error logs. I am looking into possible network issues. I will likely try daemontools this weekend.

i've seen this problem only when there's a lot of connection;s usually more than 100 connections at any one time. to test this out, maybe you can use apache ab and step up until something breaks. also, try setting fastcgiexternalserver with -appConnTimeout 0 tell us how it goes.

Thanks for your help.

Ron...

...

...

_______________________________________________

_______________________________________________ Zope maillist - Zope@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 )

-- http://www.kedai.com.my/kk http://www.kedai.com.my/eZine if you SMELLLLLLL ... what the Rock is cookin

----- Original Message ----- From: <technews@egsx.com> To: <zope@zope.org> Sent: Friday, September 29, 2000 5:17 AM Subject: [Zope] Deleting data using ZSQL

Hi,

I am writing a dtml method that deletes data from a database, and I found myself unable to do this. It seems that ZSQL is used to insert, update and query a database. but can not use "delete from table where var=<dtml-var foo>"

delete from table where var= <dtml-sqlvar foo type=string> in your Z SQL method will do the trick, at least it does for me cb

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of technews@egsx.com Sent: Thursday, September 28, 2000 10:17 PM To: zope@zope.org Subject: [Zope] Deleting data using ZSQL

Hi,

I am writing a dtml method that deletes data from a database, and I found myself unable to do this. It seems that ZSQL is used to insert, update and query a database. but can not use "delete from table where var=<dtml-var foo>"

delete from this_table where var=<dtml-sqlvar foo type=string> is what I use (Changing type accordingly of course).

On Thu, Sep 28, 2000 at 11:17:03PM -0400, technews@egsx.com wrote:

Hi,

I am writing a dtml method that deletes data from a database, and I found myself unable to do this. It seems that ZSQL is used to insert, update and query a database. but can not use "delete from table where var=<dtml-var foo>"

Two things, both previusly said, but both worth expanding on: 1) What you are doing is not type-safe and not data-safe. If var is a string, for example, that contains "this; delete from table;" You would probably not like the result. (Most SQLs would delete everything in the table!). At least, you have to do "delete from table where var='<dtml-var foo>'"` (if var is string). This is still not data-safe. A string like "this'; delete from table; update table where var=NAME set var='" is just as nasty as the previous one, although it is a bit harder for a drooling idiot to think of. delete from table where var=<dtml-sqlvar foo type=string> is perfectly data-safe. Dtml-sqlvar does two things for you: It embeds the item in the type of quotes appropriate for the TYPE= construct, AND it quotes (escapes) any characters passed to it. This makes sure that any strings are strings, and cannot contain hidden live commands. (It would make the second example expand to something like delete from table where var='this\'; delete from table; update table where var=NAME set var=\'' And this is a perfectly legal SQL statement that probably does no deletion, but does no harm either! 2) You may be seeing a DB-admin problem, rather than a ZSQL problem, make sure your Zope DB-user account has delete permission. Jim Penny

...

Two types of messages:

First in its death throws: [Wed Sep 27 16:54:08 2000] [error] [client 192.168.2.52] FastCGI: comm with server "apache_server_path/htdocs/zope" aborted: idle timeout (30 sec)

And later when its all over: [Thu Sep 28 08:07:11 2000] [error] [client 192.168.2.52] (111)Connection refused

: FastCGI: failed to connect to server "apache_server_path/htdocs/zope":

connect() failed

It will run fine for quite some time but then it dies. There are no other refereces to zope in the error logs. I am looking into possible network issues. I will likely try daemontools this weekend.

i've seen this problem only when there's a lot of connection;s usually more than 100 connections at any one time. to test this out, maybe you can use apache ab and step up until something breaks.

I can't seem to break it... ab -n 1500 -c 300 I get the same errors as in my original posting but Zope doesn't die. I left it alone after these tests and it died about 25 minutes later with noone using it. (its behind a firewall) This weekend I installed daemontools and can keep it running or at least restart it. The problem is most definitely not with load. I probably has to do with the way I have (mis)configured it. But for the life of me I can't see what it would be. Another odd thing with this set up is that some page requests from Netscape 4.x clients are very slow for what they are doing. IE and the new Mozilla engine are lightening fast...same page. Doesn't matter what platform of Netscape(*nix, Windows,Mac). The EventFolder product is the most obvious case. It locks Netscape for minutes while IE and Moz browsers load the page just fine. I will try some other things. Thanks for the ideas.

also, try setting fastcgiexternalserver with -appConnTimeout 0

Did this, doesn't seem to make a difference...

tell us how it goes.

...

Thanks for your help.

Ron...

...

...

_______________________________________________

_______________________________________________ Zope maillist - Zope@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 )

--

http://www.kedai.com.my/kk http://www.kedai.com.my/eZine

if you SMELLLLLLL ... what the Rock is cookin