PT-2011-21: SQL injection vulnerability in OneOrZero AIMS Vulnerable softwareOneOrZero AIMS Version: 2.7.0 and earlier (possibly)Application link: http://www.oneorzero.com/ Severity levelSeverity level: High Impact: SQL injection Access Vector: Network exploitable CVSS v2: Base Score: 7.5 Vector: (AV:N/AC:L/Au:N/C:P/I:P/A:P)CVE: not assignedSoftware descriptionOneOrZero AIMS is a powerful enterprise ready suite that includes a help desk, knowledge base, time manager and reporting system supported by a highly configurable and extensible Action & Information Management System that allows you to 'build your own system' on the fly. Vulnerability descriptionPositive Research Center has discovered multiply SQL injection vulnerabilities in OneOrZero AIMS. Application incorrectly validates input data. That allows attackers to conduct SQL injection attack."SQL Injection" is a way to bypass network protection and attack the database. Settings transferred to the database through Web applications are specially crafted to modify executable SQL query, for example, an attacker could execute additional query with the first one by adding different symbols to a setting.An attacker can use the vulnerability to obtain access to data which is normally unavailable or obtain system configuration data which can be used for further attacks. For example, modified query may return hashed user passwords which could be decrypted with brute force attack.For example, look at the lib\ooz_access.php source code:Line 136: $sql = "SELECT * FROM " . OOZ_SET_TABLE_PREFIX . "users WHERE user_name = '" . $cookieName . "'"; $userResult = DB::query($sql, DSN, OOZ_SET_SHOW_SQL);No filtering for $cookieName variable.How to fixPositive Technologies experts recommend to filter user input dataAdvisory status08.07.2011 - Vendor is notified 23.08.2011 - Vulnerability details were sent to CERT 19.10.2011 - Public disclosure CreditsThe vulnerability was detected by Yuri Goltsev, Positive Research Center (Positive Technologies Company)Referenceshttp://en.securitylab.ru/lab/PT-2011-21 http://www.kb.cert.org/vuls/id/800227Reports on the vulnerabilities previously discovered by Positive Research:http://www.ptsecurity.com/advisory1.aspx http://en.securitylab.ru/lab/