Re: SQL injection (or not?)

From: rr@neo.dtcom.lv
Date: Thu Aug 10 2006 - 09:16:44 EDT


None of these "exists" kind of queries work (not MSSQL,Oracle,MySQL,PostgreSQL).

I can tell a few more fingerprints to make it more interesting :)

queries are case sensitive (anyone remember sql queries being case sensitive?)

script.aspx?Parameter=' and 'a'='a
normal page

script.aspx?Parameter=' AND 'a'='a
error, invalid query

for now, all I can think of is some kind of filtering done by the script, and I
hope to get source code of that script soon

rr

>On 8/10/06, Tonnerre Lombard <tonnerre.lombard@sygroup.ch> wrote:
>Salut,
>
>On Wed, 2006-08-09 at 12:01 +0200, Isidro Ramon Labrador Rodriguez
>wrote:
>> Parameter=[valid value]' and exists(select * from sysobjects) and 'a'='a
>>
>> If it returns a valid value the database is SQL Server
>>
>>
>> Parameter=[valid value]' and exists(select * from user_tables) and
>> 'a'='a
>>
>> If it returns a valid value the database is Oracle
>>
>>
>> Parameter=[valid value]' and exists(select * from mysql.user) and 'a'='a
>>
>>
>> If it returns a valid value the database is MySQL
>
>Parameter=[valid value]' and exists(select * from pg_shadow) and 'a'='a
>
>should tell you it's PostgreSQL.
>
> Tonnerre
>--
>SyGroup GmbH
>Tonnerre Lombard
>
>Loesungen mit System
>Tel:+41 61 333 80 33 Roeschenzerstrasse 9
>Fax:+41 61 383 14 67 4153 Reinach BL
>Web:www.sygroup.ch tonnerre.lombard@sygroup.ch

------------------------------------------------------------------------------
This List Sponsored by: Cenzic

Concerned about Web Application Security?
Why not go with the #1 solution - Cenzic, the only one to win the Analyst's
Choice Award from eWeek. As attacks through web applications continue to rise,
you need to proactively protect your applications from hackers. Cenzic has the
most comprehensive solutions to meet your application security penetration
testing and vulnerability management needs. You have an option to go with a
managed service (Cenzic ClickToSecure) or an enterprise software
(Cenzic Hailstorm). Download FREE whitepaper on how a managed service can
help you: http://www.cenzic.com/news_events/wpappsec.php
And, now for a limited time we can do a FREE audit for you to confirm your
results from other product. Contact us at request@cenzic.com for details.
------------------------------------------------------------------------------



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:56:39 EDT