Here is an interesting one.

Basically, the ASPROX SQL Injection attack appears to be quite commonplace at the moment, but also quite serious.
To cut it short, there is a 20,000 strong botnet out there trying these attacks against websites which use .asp.
The tool actually uses google to search for these sites and then attempts to exploit them by inserting an HTML iFrame which downloads a malicious Java Script which then installs a Trojan.

Carry on reading to find out how to block this on a Cisco router!

The config is as follows, please bare in mind that you will probably need a reasonably specced router and IOS for this. IP CEF is a pre-requisite. I have tested this on 7200 series, 1700 series and 2600 series so far, leave a comment if you have sucessfully tried this on another router!

Config:

The below access list and route-map is used to take any packets that have been tagged with a DSCP value of 1 and route them to a non-existant interface. You will learn how to tag them below!

access-list 130 permit ip any any dscp 1

route-map ASPROX_POLICY_ROUTE_BITBUCKET permit 10
match ip address 130
set interface Null0

The below class-map basically tells the router that we want to match when a specific string is seen in a URL. In this case, the string is part of the get request that the attack uses. Note the “\” which are needed before any bracket as a delimiter!

class-map match-any ASPROX_CLASS
match protocol http url “*DECLARE%20@S%20VARCHAR\(4000\);SET*”

The Policy-map below basically tags any packet matching the above class-map with a DSCP value of 1.

policy-map ASPROX_POL
class ASPROX_CLASS
set ip dscp 1

The rest of the config attaches both the route map and the Service policy to the interface.

Interface FastEthernet0/0
ip policy route-map ASPROX_POLICY_ROUTE_BITBUCKET
service-policy input ASPROX_POL

To confirm that this is being hit you can do a “show policy-map interface” on the router. You should see the packets incrementing. This of course assumes that you are actually seeing the traffic ;)
If not, you could craft the URL yourself to confirm. So, taking this site as an example it would be:

www.cisconews.co.uk//?DECLARE%20@S%20VARCHAR(4000);SET%20@S=CAST

You should then see the packets increment.

Bare in mind that Microsoft released a tool to audit your source code for these vulnerabilities:

http://support.microsoft.com/kb/954476

Let us know if this was of any use to you in the comments!

5 Responses to “ASPROX SQL Injection Attacks - Block them using a Cisco router”

  1. Beanie says:

    This virus took my site offline for 3 weeks and I had to seek an internet security company to fix my site.

    It cost me £50 but well worth it after the hastle I have had!!

    Hope this helps others:
    http://www.firestorm-online.com/trojans/asprox/

  2. Bookmarks about Sql says:

    [...] - bookmarked by 4 members originally found by nipunthebest on July 17, 2008 ASPROX SQL Injection Attacks - Block them using a Cisco router http://cisconews.co.uk/2008/07/09/asprox-sql-injection-attacks-block-them-using-a-cisco-router/ - [...]

  3. SQL Tutorials says:

    You know, the thing about SQL is, that there is virtually nothing that can replace it.

    Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks.

  4. Shanae Canfield says:

    Hey, I’m about to quote your content and post a link back to this content on my site please let me know if thats ok?

  5. colonic says:

    I have gone through every word you have written here. It gives me a good perspective in a lot of subjects now. I’m certain it can do the same for other readers as well.

Leave a Reply

Add to Technorati Favorites Add to Google
  • Buy Cheapest online valtrex Online Cheap Prescription Drugs. Best Prices.
  • Buy Cheapest pain medications foreign pharmacies Now WorldWide Shipping. Online Medical Shop.
  • Buy Cheap difference between xanax and valium Now Cheap Prescription Drugs. WorldWide Shipping.
  • Buy Cheapest phentermine no prescription Now Buy Medications Online. Free Viagra Pills!
  • Buy Cheap how to curb your appetite Now Best Prices. Order Cheap Meds Without Rx.
  • Buy Cheapest buy lasix online Online Pharmacy Store. 24/Online Pharmacy.
  • Buy ativan manufacturer Without Prescription Doctor. Low Prices. Best Internet.
  • Buy Cheap nexium dosage Now Low Prices. Internet Prices For nexium dosage!
  • Buy Cheap codeine cough dosage Now Online Prices For codeine cough dosage! Top Online Pharmacy.
  • Buy Cheap valium us pharmacy Now Buy Medications Online. Online Medical Shop.
  • Buy Cheap xanax cod Now Pharmacy At The Best Price! Best Drugstore.
  • Buy Cheapest xanax withdrawals Online Cheap Online Pharmacy. Low Prices.
  • Buy Cheap levaquin 500mg Online WorldWide Shipping. Guaranteed Shipping.
  • Buy Cheap viagra online prescription Now No Prescription Online Pharmacy. Low Prices.
  • Buy Cheapest clomid take Now Best Drugstore. Guaranteed Shipping.
  • Buy Cheapest viagra sales uk Now The Largest Internet Pharmacy. Low Prices.
  • mail order vitamins Online Without Prescription Low Prices. Free Viagra Pills!
  • Buy Cheap cheap vigrx Now Online Medical Shop. Drugs, Health And Beauty.
  • Buy Cheap clomid infertility Now Cheap Prescription Drugs. Guaranteed Shipping.
  • Buy Cheap vitamins for weight loss Now No Prescription Needed. Cheap Pharmacy Online.
  • Buy Cheapest over the counter diet pills Now Pharmacy Store. Guaranteed Shipping.
  • Buy Cheap fat burner pill Now Discount Pharmacy Online. Guaranteed Shipping.
  • Buy Cheapest levitra on line Now 24/Online Pharmacy. Pharmacy Store.
  • Buy Cheap internet pharmacy cod Now Online Medical Shop. Online Prices For internet pharmacy cod!
  • Buy Cheap fluid retention pills Now No Prescription Needed. Top Online Pharmacy.
  • proscar hair loss Online Without Prescription Cheap Meds Without Prescription.
  • Buy Cheapest free levitra Now No Prescription Needed. Best Online.
  • Buy Cheapest buy zolpidem online Now Pharmacy Store. Guaranteed Shipping.
  • Buy Cheap buy tramadol online no prescription Now Buy Medications Online. Pharmacy Store.
  • Buy Cheapest cialis 10 mg Now Best Drugstore. No Prescription Needed.
  • Buy Cheapest original blue pill Online Best Internet. No Prescription Needed.
  • Buy Cheap viagra works Online Pharmacy Store. Guaranteed Shipping.
  • Buy Cheap viagra dosing Now Low Prices. No Prescription Online Pharmacy.
  • Buy Cheap lorazepam prescription Online Online Prices For lorazepam prescription! Pharmacy Store.
  • Buy Cheap viagra recreational use Now The Largest Internet Pharmacy. Best Internet.
  • Buy Cheapest success clomid Now Low Prices. Safe And Secure Payment System.
  • Buy Cheap levitra dysfunction erectile Online Pharmacy Store. Cheap Prescription Drugs.
  • Buy Cheapest internet drug stores Online Pharmacy Store. 24/Online Pharmacy.
  • Buy Cheap cialis for impotence Online Pharmacy At The Best Price! Best Prices.
  • Buy Cheap benicar generic Online Best Online. Special Prices For benicar generic!
  • Buying Cheap where can i buy prescription medicine. Offshore Rx, Best Prices. Top Online Pharmacy.
  • Buy Cheapest how to stop constant headaches Online Low Prices. Discount Online Pharmacy.
  • Buy Cheap cialis medicine Now Best Online. Pharmacy At The Best Price!
  • Buy Cheap offshore xanax Now Online Medical Shop. Buy Medications Online.
  • Buy Cheap xanax online Now Special Prices For xanax online! Best Internet.
  • Buy Cheap mexican online pharmacies Online Pharmacy Store. Cheap Pharmacy Online.
  • Buying Cheap cheap vigrx. Mexican Pharmacy, Good Prices. Best Drugstore.
  • Buy Cheap pain relievers for sale online Now No Prescription Needed. 24/Online Pharmacy.
  • Buy Cheapest alprazolam pills Online Best Online. Online Prices For alprazolam pills!
  • Buy Cheapest viagra advertising Online Low Prices. Special Prices For viagra advertising!
  • Buy Cheap buying pain medicine without perscription Now Best Drugstore. 24/Internet)(safe Pharmacy.
  • buy tramadol cod Online Without Prescription Low Prices. Pharmacy Store.
  • Buy Cheap phentermine delivered c o d Now Low Prices. Safe And Secure Payment System.
  • Buy Cheap ethinyl estradiol levonorgestrel Now Top Online Pharmacy. WorldWide Shipping.
  • Buy Cheapest xanax withdrawal Online Best Online. No Prescription Needed.
  • Buy Cheap canada tramadol Online Best Prices. No Prescription Needed.
  • Buy Cheap online order zyban Online 24/Online Pharmacy. Free Viagra Pills!
  • Buy Cheapest buy online tramadol Now Best Online. 24/Internet)(safe Pharmacy.
  • Buy Cheapest cialis cheap Online 24/Online Pharmacy. Pharmacy Store.
  • Buy Cheapest phentermine 37.5 overnight delivery Now Online Medical Shop. Cheap Pharmacy Online.
  • Buy Cheapest ultram online prescription Now WorldWide Shipping. Top Online Pharmacy.
  • Buy Cheap fluconazole price Online Cheap Online Pharmacy. Guaranteed Shipping.
  • Buy Cheap valium low cost Online Best Online. Internet Prices For valium low cost!
  • Buy Cheap drug interaction tramadol Now Best Internet. Safe And Secure Payment System.
  • Buy Cheap valtrex dose Online 100% Satisfaction Guaranteed. Best Prices.
  • Buy Cheapest asian weight loss products Online Best Internet. Top Online Pharmacy.
  • Buy Cheap fluconazole capsule Online Pharmacy At The Best Price! Best Drugstore.
  • Buy Cheap drug free pain relief Online Free Viagra Pills! Cheap Online Pharmacy.
  • Buy Cheap buy phentermine online no prior prescription Online We Can Offer You Visit Our Online Pharmacy.
  • Buy Cheap valium dosages Online The Largest Internet Pharmacy. Low Prices.
  • Buy Cheapest does levitra work Online Low Prices. Pharmacy At The Best Price!
  • Buy Cheapest diuretic drugs high blood pressure Online Cheap Online Pharmacy. Low Prices.
  • Buy Cheap ambien dosing Online Special Prices For ambien dosing! Best Drugstore.
  • Buy Cheapest discount prescription drugs pharmacy Online Online Medical Shop. WorldWide Shipping.
  • Buy Cheap clotrimazole and betamethasone Online Free Viagra Pills! WorldWide Shipping.
  • Buy Cheap cheap buy viagra Now Pharmacy Store. Cheap Prescription Drugs.
  • Buy cost of propecia Online Without Prescription. Low Prices. Best Drugstore.
  • Buying Cheapest buying viagra online uk. Mexican Rx, Good Prices. Free Viagra Pills!
  • Buy what is diazepam Without Prescription Doctor. Low Prices. Pharmacy Store.
  • Buy Cheapest overnight valium no prescription Online Best Online. Buy Medications Online.
  • Buy Cheapest effects of propecia Now Best Internet. Order Cheap Meds Without Rx.
  • Buy Cheapest viagra timing Now Pharmacy Store. Discount Pharmacy Online.
  • Buy Cheap mail order levitra Online Cheap Pharmacy Online. Best Internet.
  • Buy Cheap fluconazole price Now Best Internet. Safe And Secure Payment System.
  • Buy Cheapest spanish codeine Now Top Online Pharmacy Supplier. Low Prices.
  • Buy Cheap cheap drug pharmacies Now Online Medical Shop. Top Online Pharmacy.
  • ambien order Online Without Prescription Best Online. Pharmacy Store.
  • Buy Cheap prescriptions pain killers without a prescription Online Best Prices. Buy Medications Online.
  • Buy Cheap buy brand name cialis Online Top Online Pharmacy Supplier. Low Prices.
  • Buy Cheapest viagra 50mg Now Internet Prices For viagra 50mg! Best Prices.
  • Buy Cheapest migraine headache drugs Now Best Prices. The Largest Internet Pharmacy.
  • Buy Cheap amoxicillin online Online Free Viagra Pills! Cheap Online Pharmacy.
  • Buy Cheap best over the counter diuretic Online Pharmacy At The Best Price! Best Prices.
  • Buy Cheap buy ultram 50mg Online Pharmacy Store. Internet Prices For buy ultram 50mg!
  • Buy Cheap ativan drugs Now 100% Satisfaction Guaranteed. Best Prices.
  • Buy Cheap buy cheap generic propecia Online Special Prices For buy cheap generic propecia! Best Online.
  • Buy Cheap canadian drugstores online Online Low Prices. Pharmacy At The Best Price!
  • Buy Cheap levitra for potency Online Best Online. Pharmacy At The Best Price!
  • Buy Cheap sildenafil 100 mg Now Online Prices For sildenafil 100 mg! Guaranteed Shipping.
  • Buy Cheap where can i buy prescription medicine Now 24/Online Pharmacy. Free Viagra Pills!