Waraxe IT Security Portal
Login or Register
July 21, 2024
Menu
Home
Logout
Discussions
Forums
Members List
IRC chat
Tools
Base64 coder
MD5 hash
CRC32 checksum
ROT13 coder
SHA-1 hash
URL-decoder
Sql Char Encoder
Affiliates
y3dips ITsec
Md5 Cracker
User Manuals
AlbumNow
Content
Content
Sections
FAQ
Top
Info
Feedback
Recommend Us
Search
Journal
Your Account
User Info
Welcome, Anonymous
Nickname
Password
(Register)

Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144

People Online:
Visitors: 150
Members: 0
Total: 150
Full disclosure
[KIS-2024-06] XenForo <= 2.2.15 (Template System) Remote Code Execution Vulnerability
[KIS-2024-05] XenForo <= 2.2.15 (Widget::actionSave) Cross-Site Request Forgery Vulnerability
CVE-2024-33326
CVE-2024-33327
CVE-2024-33328
CVE-2024-33329
CyberDanube Security Research 20240703-0 | Authenticated Command Injection in Helmholz Industrial Router REX100
SEC Consult SA-20240627-0 :: Local Privilege Escalation via MSI installer in SoftMaker Office / FreeOffice
SEC Consult SA-20240626-0 :: Multiple Vulnerabilities in Siemens Power Automation Products
Novel DoS Vulnerability Affecting WebRTC Media Servers
APPLE-SA-06-25-2024-1 AirPods Firmware Update 6A326, AirPods Firmware Update 6F8, and Beats Firmware Update 6F8
40 vulnerabilities in Toshiba Multi-Function Printers
17 vulnerabilities in Sharp Multi-Function Printers
SEC Consult SA-20240624-0 :: Multiple Vulnerabilities allowing complete bypass in Faronics WINSelect (Standard + Enterprise)
SEC Consult SA-20240620-0 :: Arbitrary File Upload in edu-sharing (metaVentis GmbH)
Log in Register Forum FAQ Memberlist Search
IT Security and Insecurity Portal

www.waraxe.us Forum Index -> Sql injection -> Question UNION... 1,2,3,4,5
Post new topicReply to topic View previous topic :: View next topic
Question UNION... 1,2,3,4,5
PostPosted: Wed Mar 15, 2006 8:05 am Reply with quote
panzerstar
Beginner
Beginner
Joined: Mar 15, 2006
Posts: 2




Hello,

Here http://www.waraxe.us/advisory-47.html I've found this:

http://localhost/nuke78/?kala=p0hh+UNION+ALL+SELECT+1,2,3,pwd,5+FROM+nuke_authors/%2a

I cannot understand why or what happens when you enter 1,2,3,4,5 or even 1,2,3,pwd,5 instead of * or ascii. I think realnames arent called like this.

A small example to following what happens would be very nice.

Thank you for spending time to answer my question

greetings panzer
View user's profile Send private message
PostPosted: Fri Mar 17, 2006 3:05 am Reply with quote
panzerstar
Beginner
Beginner
Joined: Mar 15, 2006
Posts: 2




Re,

Nobody can help? Here is an additional part, sometimes the 1's are replaces with 0's, why?

greetings
View user's profile Send private message
PostPosted: Thu Mar 23, 2006 10:12 am Reply with quote
Classics
Regular user
Regular user
Joined: Mar 23, 2006
Posts: 6
Location: Nederland/Venlo




to make this request in the Search field... of vuln Page!

as a result of MD5 Hash Wink

greetz
View user's profile Send private message
PostPosted: Mon Apr 24, 2006 2:42 pm Reply with quote
Slodave
Beginner
Beginner
Joined: Apr 20, 2006
Posts: 3




Using 1,2,3 is only way to execute UNION statement because union all need's to have same fields as select statement (if you use * it seclect all). Using numbers is good because you don't need to wory about field type.
Hope it helps.
View user's profile Send private message
PostPosted: Fri Apr 28, 2006 11:27 am Reply with quote
waraxe
Site admin
Site admin
Joined: May 11, 2004
Posts: 2407
Location: Estonia, Tartu




There are many reasons and any pentester or software security auditor has some personalized habbits in sql injection testing and exploiting area.
Yep, the classical UNION exploiting scheme --> "count of columns does not match", and when it will finally will match, then all the fields must be same type. Sql injection whitepapers suggest to use "UNION ALL SELECT null,null", but if we use "UNION ALL SELECT 1,2,3,4,5,6,7", then we can see by feedback, what sql fields are rendered in what position in html code. So it is faster than "null, null, null" and then "1,null,null" and then "null, 2, null" etc.
Of course, there can be many problems in real life exploiting.
One example:

Code:

http://www.ra***ar.ee/index.php?lang=pp"%20UNION%20ALL
%20SELECT%201,2,3,@@version,5,6,7,8,9,10,11,12,13,14,15,
16,17,18,19,20/*


and we get

Code:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION'


Heh, of course this problem can be solved, but this is the real life - you must be creative and learn new methods all the time Very Happy
View user's profile Send private message Send e-mail Visit poster's website
Question UNION... 1,2,3,4,5
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

Post new topicReply to topic


Powered by phpBB 2001-2008 phpBB Group



Space Raider game for Android, free download - Space Raider gameplay video - Zone Raider mobile games
All logos and trademarks in this site are property of their respective owner. The comments and posts are property of their posters, all the rest (c) 2004-2024 Janek Vind "waraxe"
Page Generation: 0.126 Seconds