Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Links SQL Crashing Server

Quote Reply
Links SQL Crashing Server
From my server log file:



195.195.20.199 - - [08/Nov/2002:11:41:39 +0000] "GET /search.cgi?query= HTTP/1.0" 200 - "http://www.mysite.tld/user.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)"
195.195.20.199 - - [08/Nov/2002:11:41:39 +0000] "GET /search.cgi?query= HTTP/1.0" 200 - "http://www.mysite.tld/user.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)"
195.195.20.199 - - [08/Nov/2002:11:41:44 +0000] "GET /search.cgi?query= HTTP/1.0" 200 10712 "http://www.mysite.tld/user.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)"
195.195.20.199 - - [08/Nov/2002:11:41:43 +0000] "GET /search.cgi?query= HTTP/1.0" 200 - "http://www.mysite.tld/user.cgi" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0)"
91I?7NDZn`sP%:2*D:2*%WJ>SF;PE9/ ' 9NCWJ>SF\n]NC  9/'@4K_Pd­x,e|yxtteX,% vsbSf7­q@3)'>RCWH;O@4H\K>RCWgv )   %1gq,F{



Binary continues for a few minutes. This is the second server on which this has happened.
Quote Reply
Re: [crashing] Links SQL Crashing Server In reply to
Somebody seems to have been sending over ten requests per second to search.cgi, solidly for about ten minutes.
Quote Reply
Re: [crashing] Links SQL Crashing Server In reply to
Well, you've got the IP where this comes from. Contact the admin of the domain and tell them to stop.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] Links SQL Crashing Server In reply to
Or block their IP, so they don't even get a chance to make a proper request to your site (could even be done at server level)...

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [crashing] Links SQL Crashing Server In reply to
Create a .htaccess file:

Code:
<Limit GET POST>
Order Deny,Allow
Deny From 195.195.20.199
Allow From All
</Limit>[/quote]

Last edited by:

Paul: Nov 8, 2002, 6:50 AM
Quote Reply
Re: [Paul] Links SQL Crashing Server In reply to
Thanks for your advice guys. Turns out he crashed it by constantly reloading the search page, up to ten times a second for about 5 minutes.

I contacted his institution (he wanted to sign up for the service, had entered his name and institutional email but had to pay, didn't and as such was probably frustrated), and they might take it further. Whether or not they do is immaterial.

Fact is that blocking a particular IP is futile. Many ISP's use a dynamic IP addressing system, so anyone using that system will be able to evade Htaccess IP blocks. Sure, I could block the entire range, but if he uses a major ISP it also means blocking about 10% of a given population, which is unacceptable.

As such, the solution lies in remedying the system. It would be advantageous if the script did not have this vulnerability. Perhaps it may not be a vulnerability of the script, but rather apache.