Relentless Web Attack Hard To Kill 218
ancientribe writes "The thousands of Web sites infected by a new widespread SQL injection attack during the past few days aren't necessarily in the clear after they remove the malicious code from their sites. Researchers from Kaspersky Lab have witnessed the attackers quickly reinfecting those same sites all over again. Meanwhile, researchers at SecureWorks have infiltrated the Chinese underground in an attempt to procure a copy of the stealthy new automated tool being used in the attacks."
Whatever happened (Score:5, Insightful)
It's the plugins... (Score:3, Insightful)
At the end of the day it's the problem of plugins...I mean, besides the fact that the website is being infected, it's the flaws and vulnerabilities of the ActiveX/Browser plugins that allow this kind of activity to be profitable.
Just yet another reason, besides bandwidth, to get Flashblock.
And install as few as browsers plugins/ActiveX as possible.
This disgusts me (Score:4, Insightful)
I develop web applications for a living right now and as someone who's only been in this game for a few months, this disgusts me. I already know how to prevent SQL injection with prepared statements. It's easy to do and requires no extra knowledge, so why doesn't everyone do this?
Re:Kaspersky (Score:4, Insightful)
...AVG...
<mechanic>Well there's your problem.</mechanic>
Re:This disgusts me (Score:1, Insightful)
Re:This disgusts me (Score:4, Insightful)
The problem is a frightening amount of training material on the web uses concatenated SQL strings to teach SQL. Pull up your average PHP/.Net/Java SQL tutorial and odds are that it will be concatenating strings. Throw that in with the fact that roughly half of the programmers reading that are going to be below average, and there you go.
yet another ugly side of DRM (Score:3, Insightful)
"The toolkit is protected with a layer of digital rights management and appears to be sold mainly in China. "
this is why I don't believe in "Tusted" computing.
When software or hardware are used to take control of a computer away from that computer's owner bad things will happen.
Re:Kaspersky (Score:5, Insightful)
It's a bloody SQL injection attack. I'd like to see your virus checker automatically rewrite your web application to use input filtering.
What these people need is a real web application instead of some self-built PHP script - not a virus scanner, whether free or expensive.
Re:This disgusts me (Score:4, Insightful)
Um for anything that is approximately normally distributed,... half of the X are going to be below average. (Especially if it is a continuous variable and you use the median)
Re:This disgusts me (Score:1, Insightful)
I say that fully half of programmers will be below median assuming theres an even number of programmers.
All bets are off if theres an Odd number of programmers.
Re:This disgusts me (Score:5, Insightful)
The idea of a SQL Injection attack is to pass a parameter in such a way that it changes the structure of the query itself. Typical beginner's SQL query:
This uses 'String Concatenation' to build a line of text from several smaller parts. The completed string is then, in this example executed by a database. A new query is dynamically created and executed based on the text passed to it. Thus, we are able to at this point change what query will be run. Form data:
So when the string is being put together, we get:
Certainly, even with no programming experience, one can see that the letter E will always be equivalent to the letter E. Thus, any validation of the password will return a false positive.
Prepared statements avoid this whole deal by only allowing you to pass parameters. The query is already set in stone. You cannot change how it basically works, only its criteria / filtering / etc. A prepared statement would execute basically:
Since the query does not change dynamically when it's executed as a prepared statement, you can't add your logical 'OR' operator after having broken out of your parameter. You just get no rows returned, as should be the case.
Re:This disgusts me (Score:4, Insightful)
Kaspersky can't figure it out because a virus scanner can't fix a web application. Fixing SQL injections is beyond their realm.
Travelocity can't figure it out because their developers must suck. Travelocity is well-known because they have a decent service, not because the software that runs the service is really great software.
Re:This disgusts me (Score:3, Insightful)
Re:This disgusts me (Score:5, Insightful)
You're working off of the false assumption that security is about knowledge.
We know abundantly well exactly how SQL injection attacks occur, and we also have many tools at our disposal to -absolutely- prevent them. What we don't have is the cooperation or effort from programmers on a widespread basis. Many are simply too lazy to research and implement reasonable security measures. It's easier to pretend that there are no ways whatsoever that anything can go wrong with your code because when you tested it it worked right. This willfull turning a blind eye to well-established security caveats is what has given us this terrible and prevalent security problem. It's easier to write code that checks nothing, it's quicker to do so, and it requires less think-juice on the part of the lazy programmer.
Re:This disgusts me (Score:3, Insightful)
Throw that in with the fact that roughly half of the programmers reading that are going to be below average, and there you go.
That is what comes of outsourcing and offshoring especially, but there are still managers out there who refuse to acknowledge what I like to call the Iron Law of Software Development or more generally the Project Triangle [wikipedia.org] (good, fast, cheap...pick two).
Trust (Score:2, Insightful)
Okay keep using Noscript. I don't have a problem with that, but be warned that you are not fully protected by Noscript when the website you TRUST is attacked by an exploit like SQL injection, because YOU TRUST THAT WEBSITE.
White-lists are better than no-lists, but they aren't perfect.
McColo? (Score:3, Insightful)
I wonder how many of the malicious servers the injected SQL dumped the users into were hosted on McColo - and are thus now not available?
Don't rely on FlashBlock for security... (Score:3, Insightful)
Re:noscript (Score:3, Insightful)
Yes, we should stick to the old tried and true "overload the server and piss off the user" method of the 1990's.
Name: Dave
Country : Thailand
Telephone : 12345678
Date of Birth : 29/02/2000
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
Please supply your Firstname AND Surname ...
Name : Dave Mullen
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
You are from Thailand, where people don't always HAVE surnames - please just supply your Name ...
Name : Dave
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
Please supply a full telephone number with area code ...
Telephone : 0066 12345678
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
Country code should start with + ...
Telephone : +66 12345678
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
Please supply an area code ...
Telephone : +66 99 12345678
[SUBMIT]
Oops' looks like some problems with your submission - please correct the following :-
February 29th is not a valid date because 2000 is not a leap year.
BY WHICH TIME, *IF* THE USER IS STILL HERE, YOU HAVE THOROUGHLY PISSED HIM OFF, AND MADE NO LESS THAN 6 SUBMISSIONS TO THE SERVER FOR SOME CRAPPY VALIDATION THAT COULD HAVE ALL BEEN TRAPPED ON THE CLIENT SIDE.
If that's the web you want, then it's your choice I suppose.