2

When not having priveleges on the session user you're using with sqlmap this warning appears when trying to retrieve table/column names, offering you to brute force names using a dictionary file,

do you want to use common column existence check? [y/N/q] y
[03:37:06] [WARNING] it's not recommended to use 'AND/OR time-based blind' and/or 'stacked queries' for common column existence check
are you sure you want to continue? [y/N] 

Why isn't it recommended?

2
  • Could you please tag with the software you're using? / explicate the context of the question? This question makes little sense to people not into pentesting. Sep 17, 2014 at 20:29
  • Isn't that true of most the questions on this site? Sep 17, 2014 at 21:00

1 Answer 1

0

This is the condition that causes the warning to be shown:

if kb.columnExistsChoice is None and not any(_ for _ in kb.injection.data if _ not in (PAYLOAD.TECHNIQUE.TIME, PAYLOAD.TECHNIQUE.STACKED)) and not conf.direct:

The individual conditions mean:

  • kb.columnExistsChoice is None – previous answer to the subsequent question "are you sure you want to continue?"
  • not any(_ for _ in kb.injection.data if _ not in (PAYLOAD.TECHNIQUE.TIME, PAYLOAD.TECHNIQUE.STACKED)) – whether there is no other injection using a technique other than time-based or stacked
  • not conf.direct – whether it’s not a direct connection

So in conclusion, the warning is shown if

  • it hasn’t been shown yet, and
  • there is no other injection using a technique other than time-based or stacked, and
  • it is not a direct connection.

The reason for that is probably because the time-based and stacked techniques are time consuming and may take quite a time to finish.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .