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
  • treatment for dry skin
  • weight loss doctor online
  • heart pain chest
  • clomid dosage
  • cymbalta dosages
  • my drug store
  • about levitra
  • flu vaccines
  • treating high cholesterol
  • drug phenergan
  • post pregnancy weight loss
  • free dog products
  • help with weight loss
  • cheapest levitra
  • breast cancer products
  • small dog products
  • online drug stores
  • stop smoking tablets
  • about levitra
  • sleep disorders drugs
  • fast weight loss tips
  • hydrochlorothiazide generic
  • cures for lung cancer
  • back pain
  • natural help sleeping
  • ulcers stomach
  • prostate cancer treatment
  • irritable bowel syndrome treatments
  • cymbalta anxiety
  • asthma treatment drugs
  • healthy pets
  • finasteride dosage
  • weight loss solutions
  • body building nutrition
  • perfect pet products
  • buy viagra internet
  • pneumonia vs bronchitis
  • latest diet pill
  • ordering meds without a prescription
  • increased heart rate drugs
  • face skin care
  • pain meds without prescription
  • celecoxib 200mg
  • obtaining pain killers
  • pain meds without prescriptions
  • hair loss treatment uk
  • cat health care
  • fat weight loss products
  • high blood pressure elderly
  • cancer drugs
  • dental antibiotics
  • strattera generic
  • removing dark spots from face
  • medicine drugs
  • new cancer drug
  • buy plan b
  • drug price
  • improve skin
  • diabetes type 2
  • buy pain pills on line
  • anti anxiety meds
  • dog products uk
  • weight loss how to
  • dogs health problems
  • high blood pressure medicines
  • drugs no prescription
  • online drugs without prescription
  • the new flu
  • buy meds no prescription
  • medications celebrex
  • no prescription online pharmacies
  • skin cell
  • controlling blood pressure
  • how does osteoporosis occur
  • quitting smoking
  • liver infection treatment
  • health med
  • cat care
  • buy viagra internet
  • body building product
  • blood pressure support
  • health vitamins
  • buy omega 3
  • smoking stop
  • viagra with out prescription
  • right side back pain
  • symptoms of congestive heart failure
  • celexa buy
  • over weight dog
  • diabetes drugs
  • build muscle
  • flu shot
  • depression therapy
  • dog health in mexico
  • best hair loss treatment
  • self help weight loss
  • buy cialis on line
  • high blood pressure cause
  • muscle spasm relief
  • drug stores
  • buy meds no prescription
  • discount anti-biotics
  • alcoholism information treatment
  • list of cancer treating drugs
  • lower leg pain
  • weight loss nutrition
  • dog health problems
  • drugs for energy
  • viagra and buy
  • drugs for sale
  • where to buy stop pain
  • medication for depression
  • pharmacies without prescriptions
  • cholesterol and health
  • alzheimers disease drugs
  • natures antibiotic
  • medicine for blood pressure
  • stopping smoking
  • diabetes treatment
  • reduce blood pressure
  • cat health info
  • treatments for throat infection
  • nolvadex dosage
  • dog health help
  • tamiflu flu
  • natural back pain relief
  • new heart attack drugs
  • dogs health problems
  • tips to help loss weight
  • vitamins store
  • wrinkle skin care
  • what causes throat infection
  • cialis 30
  • reason for high blood pressure
  • pet health care
  • blood pressure pills
  • how to stop the pain
  • newest approved drugs
  • hair loss treatments
  • hair loss remedy
  • treatment of breast cancer
  • us online pharmacy
  • medical treatment for diabetes
  • acomplia online
  • osteoporosis treating
  • claritin dose
  • free help to stop smoking
  • vitamin store
  • treatment for hypertension
  • bust increase
  • dog site health
  • buy tadalafil online
  • buy pain medicine online
  • health problems cats
  • cure for high blood pressure
  • low back pain
  • on-line pharmacies
  • treatment of asthma
  • on-line drugs
  • lower back pain
  • treating prostate cancer
  • cheap impotence drug generic cialis delivery
  • risperdal depression
  • best weight loss programs
  • medicine drugs
  • malaria medicines
  • plan b pregnancy
  • tips for weight loss
  • buy drugs prescription online
  • reducing high blood pressure
  • high blood pressure medicines
  • international pharmacy
  • anti smoking
  • anti depression
  • weight loss for women over 50
  • stop pain
  • chronic pain management
  • help to give up smoking
  • hair loss products for women
  • cold flu
  • online alcoholism treatment
  • medicine for dogs
  • breast cancer drugs
  • claritin 10mg
  • sleep disorders treatment
  • treatment of heart attacks
  • products diet
  • cheap drug pharmacies
  • reasons for high blood pressure
  • weight loss solution
  • blood pressure high
  • life after a heart attack
  • fda avandia
  • causes for high blood pressure
  • aspirin and pregnancy
  • natural breast enhancer
  • pharmacy zolpidem
  • how to get teeth white
  • back pain relief product
  • discount weight loss pill