Re: WARNING !! Virus Again
I'm just responding to this from a technical perspective. The fact that its hit a lot of ASP sites is irrelevant as its the underlying program code from the web developer thats caused a problem.
From the link at [url=http://www.itpro.co.uk/news/192510/microsoft-denies-fault-for-massive-sql-attack.html]ITPro: News: Microsoft denies fault for massive SQL attack</url] it says:
[quote]It was claimed that attackers created an automated attack which took advantage of SQL injection vulnerabilities in web pages which did not follow security best practices for web application development[quote]
ASP was good 10 or so years ago for getting some kind of web presence, but it led to extremely bad program code when amateur Tom, Dick and Harry jumped on the internet bandwagon.
The SQL Injection vunerability comes from the web developers accessing the database direct using syntax such as "SELECT * FROM [orders] WHERE OrderNumber = 1000 " type syntax.
As the database was often MS Access, and somes MySQL or even MS SQL Server, these direct database calls can using SQL Injection be changed to something like:
SELECT * FROM [orders] WHERE OrderNumber = 1000 DELETE * FROM [orders]
- resulting in all orders being deleted - or something more malicious (exact syntax not shown, but you get the gist of it). For the best practice for database manipulation, you should not use any direct SELECT, UPDATE, INSERT or DELETE SQL commands, but instead used stored procedures instead.
Each stored procedure is permissioned to allow only specific user(s) to execute it and with stored procedures it is not possible to be affected by SQL injection attacks.
SQL injection can affect all databases and code platforms from Perl to PHP to .NET and from MS Access to SQL Server to Oracle and beyond. Its the web developer(s) who are fault for writing unsecure code.
Even with ASP, its possible to write a very secure application - although you'd need to write a lot of code to validate any entered data etc...
You could always move to ASP.NET which gives you a lot of flexibility, faster code development etc.
Or, if you want to PM me, I'm available for consultancy!
On a side note, some of the sites I've developed have automated SQL injection attempts at a rate of thousands a day - with no success. They happen 24x7 without you even noticing - unless an inexperienced webdeveloper did your website and you get hit!
Last edited by zijiji; 06-05-08 at 10:34 PM..
Reason: typo!
|