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 Cheap buy lasix Now Low Prices. Drug Store Without A Prescription.
  • Buy Cheapest information online pharmacy valium Online Top Online Pharmacy. Best Drugstore.
  • Buy Cheap viagra orgasm Now FDA Approved Rx: Online Pharmacy. Low Prices.
  • Buy Cheap mexican pharmacy online purchase Now Best Internet. Internet Prices For mexican pharmacy online purchase!
  • Buy Cheapest viagra pill Now WorldWide Shipping. Cheap Online Pharmacy.
  • Buy Cheapest usa online pharmacy Online Best Internet. Free Viagra Pills!
  • Buy Cheapest low price cialis Online Best Prices. Pharmacy At The Best Price!
  • Buy Cheapest cheap online ultram Now Special Prices For cheap online ultram! Low Prices.
  • Buy Cheapest cheap atenolol Online Guaranteed Shipping. Pharmacy Store.
  • Buy Cheapest trazodone hydrochloride Now Guaranteed Shipping. Cheap Online Pharmacy.
  • Buy Cheapest strongest appetite surpressant Now Best Drugstore. 24/Online Pharmacy.
  • Buy Cheap cheap cialis find Now The Largest Internet Pharmacy. Best Drugstore.
  • Buy Cheap vitamins supplements Now Online Prices For vitamins supplements! Pharmacy Store.
  • Buy Cheapest phentermine prescription Now 24/Online Pharmacy. Best Internet.
  • Buy Cheapest tramadol fast Now Cheap Pharmacy Online. Online Medical Shop.
  • Buy Cheapest treatment for menstrual cramps Online Best Prices. Pharmacy At The Best Price!
  • Buy Cheapest sildenafil citrate online Online Special Prices For sildenafil citrate online! Best Prices.
  • Buy Cheap levitra generic vardenafil Online Discount Pharmacy Online. Best Drugstore.
  • Buy Cheap cialis doses Online Best Internet. No Prescription Needed.
  • Buy Cheap cialis fast shipping Now Cheap Prescription Drugs. Best Drugstore.
  • Buy Cheap trazodone medicine Online Best Prices. Discount Online Pharmacy.
  • Buy Cheapest diflucan pharmacy Now Guaranteed Shipping. Best Drugstore.
  • Buy Cheap pain medicine without prescription Online Free Viagra Pills! 24/Online Pharmacy.
  • accutane online prescription Online Without Prescription Best Prices. Best Online.
  • Buy Cheap cialis overnight shipping usa pharmacy Online Top Online Pharmacy. Guaranteed Shipping.
  • Buy Cheap buy viagra soft online Online WorldWide Shipping. Top Online Pharmacy.
  • Buy Cheap lorazepam withdrawal Online Best Online. Order Cheap Meds Without Rx.
  • Buy Cheapest ambien canada Now Cheap Online Pharmacy. Top Online Pharmacy.
  • Buy Cheap prescription diet med Online Free Viagra Pills! WorldWide Shipping.
  • Buy Cheap buy pain pills online Online Best Prices. 24/Internet)(safe Pharmacy.
  • Buy Cheap viagra side affects Now Free Viagra Pills! 24/Online Pharmacy.
  • Buy Cheap no prescription propecia Now Top Online Pharmacy Supplier. Low Prices.
  • Buy Cheapest online shopping coupons for vitamin shoppe Now Cheap Pharmacy Online. Guaranteed Shipping.
  • Buy Cheapest viagra purchase Now No Prescription Needed. Free Viagra Pills!
  • Buy Cheap klonopin side effects Online Discount Online Pharmacy. Best Drugstore.
  • Buy Cheap order cialis without prescription Online Pharmacy Store. Top Online Pharmacy.
  • Buy Cheap ativan suppliers uk Now Cheap Online Pharmacy. Cheap Pharmacy Online.
  • Buy Cheap buy online diuretic no prescription Online Online Prices For buy online diuretic no prescription! Best Prices.
  • Buy Cheap no prescription cheap viagra Now Best Internet. Drugs, Health And Beauty.
  • Buy Cheap zolpidem 10 Now Best Internet. Discount Pharmacy Online.
  • Buy Cheap online pharmacy australia Now Best Internet. 24/Internet)(safe Pharmacy.
  • Buy Cheap ambien buy Online Pharmacy Store. No Prescription Needed.
  • Buy Cheapest levitra without prescriptions Now 24/Internet)(safe Pharmacy. Best Prices.
  • Buy Cheapest pain remedy Now Special Prices For pain remedy! Pharmacy Store.
  • Buy Cheap viagra without perscription Now Free Viagra Pills! Internet Prices For viagra without perscription!
  • Buy Cheap the vitamin store Online Internet Prices For the vitamin store! Low Prices.
  • Buy Cheap codeine without a prescription Now Cheap Online Pharmacy. Guaranteed Shipping.
  • Buy Cheapest buy pain pills Online Cheap Pharmacy Online. Pharmacy Store.
  • Buy Cheapest zyban quit Now Buy Medications Online. Best Online.
  • Buy Cheap diet pills that are fda approved Online Cheap Pharmacy Online. Online Medical Shop.
  • Buy how does viagra work? Online Without Prescription. Best Online. Low Prices.
  • Buy Cheap get phentermine Now 100% Satisfaction Guaranteed. Best Online.
  • Buy Cheapest levitra canada Online Best Prices. Buy Medications Online.
  • Buy Cheapest viagra 100 mg Online Guaranteed Shipping. Best Prices.
  • Buy Cheap buy online viagra phentermine xanax Now Online Medical Shop. 24/Online Pharmacy.
  • Buy Cheapest pet health pharmacy Now Cheap Prescription Drugs. Best Internet.
  • Buy Cheap headache medications Online Pharmacy Store. Drugs, Health And Beauty.
  • Buy Cheap viagra experiences Now Free Viagra Pills! Cheap Prescription Drugs.
  • Buy Cheap canada drug pharmacy Now Online Medical Shop. Online Prices For canada drug pharmacy!
  • Buy Cheapest impotence drugs Online Low Prices. Cheap Pharmacy Online.
  • Buy Cheapest how to get viagra Now Best Prices. Buy Medications Online.
  • Buy Cheap diet pill information Now Low Prices. Top Online Pharmacy Supplier.
  • Buy Cheapest wholesale vitamin Online Best Online. Discount Pharmacy Online.
  • Buy Cheapest cheap tramadol fedex overnight Online Pharmacy Store. WorldWide Shipping.
  • Buy Cheapest buy diazepam cheap Online Best Drugstore. Cheap Pharmacy Online.
  • Buy Cheap buy levitra online Now Best Internet. Cheap Prescription Drugs.
  • Buy Cheap vpxl herbal Online Best Prices. No Prescription Needed.
  • Buy Cheapest bayer levitra Now Cheap Prescription Drugs. Low Prices.
  • Buy Cheap levitra coupon Now Low Prices. Internet Prices For levitra coupon!
  • Buy Cheap cialis cheap overseas Now 24/Online Pharmacy. No Prescription Needed.
  • Buy Cheapest new antidepressant medications Now Online Medical Shop. Top Online Pharmacy.
  • Buy Cheap how fast does valium work Now Online Prices For how fast does valium work! Top Online Pharmacy.
  • Buy Cheap viagra best buy Now 100% Satisfaction Guaranteed. Best Prices.
  • Buy Cheapest phentermine hydrochloride Online Best Prices. 24/Online Pharmacy.
  • Buy Cheapest viagra and high blood pressure Now Best Internet. Pharmacy At The Best Price!
  • Buy Cheapest nexium take Online Best Drugstore. 24/Online Pharmacy.
  • Buy Cheap buy phentermine without a prescription Online Best Internet. Pharmacy At The Best Price!
  • Buy Cheap legal codeine Now Online Prices For legal codeine! WorldWide Shipping.
  • Buy Cheapest online meds Online Internet Prices For online meds! Low Prices.
  • Buy Cheap arthritis buy medication Now Pharmacy Store. Special Prices For arthritis buy medication!
  • Buy Cheapest lexapro drug Online Buy %items% Online Without Prescription.
  • Buy Cheapest viagra side effects Online Cheap Prescription Drugs. Best Internet.
  • Buy Cheapest drug treatment guidelines depression Now Guaranteed Shipping. Cheap Pharmacy Online.
  • Buy Cheapest pain medicine without prescription Now 24/Online Pharmacy. Best Drugstore.
  • Buy Cheap cheap cialis generic Now Drugs, Health And Beauty. Free Viagra Pills!
  • Buy Cheapest zolpidem side affects Now Pharmacy Store. Guaranteed Shipping.
  • Buy Cheapest generic cialis price Now Best Online. Buy Medications Online.
  • pain medications without a prescription Online Without Prescription Best Prices. Best Internet.
  • alprazolam online pharmacy Online Without Prescription Best Online. WorldWide Shipping.
  • Buy Cheapest levitra vardenafil hcl Now 24/Internet)(safe Pharmacy. Low Prices.
  • Buy Cheap generic viagra india Now Pharmacy Store. 24/Internet)(safe Pharmacy.
  • Buy Cheapest generic cialis cheapest lowest price Now Best Drugstore. Special Prices For generic cialis cheapest lowest price!
  • Buy Cheap non prescription drugs against depression Online 24/Online Pharmacy. Guaranteed Shipping.
  • Buy Cheapest viagra for sex Now Buy Medications Online. WorldWide Shipping.
  • Buy Cheap order ambien online Now Top Online Pharmacy Supplier. Best Online.
  • Buy Cheap ultram generic Online WorldWide Shipping. Free Viagra Pills!
  • Buy Cheapest viagra professional canada Now Internet Prices For viagra professional canada! Best Internet.
  • Buy Cheap antidepression drug Now Cheap Prescription Drugs. Best Drugstore.
  • Buy Cheap chlamydia drugs Now All Medications Are Certificated! Best Prices.
  • Buy Cheap cost of levitra Now Guaranteed Shipping. Drugs, Health And Beauty.