----------------------------------------------------------------------

     (PT-2011-21) Positive Technologies Security Advisory 

             SQL injection vulnerability in OneOrZero AIMS

----------------------------------------------------------------------

---[Vulnerable software]

OneOrZero AIMS 
Version: 2.7.0 and earlier (possibly)

Application link: 
http://www.oneorzero.com/

---[Severity level]

Severity level: High 
Impact: SQL injection 
Access Vector: Network exploitable 
CVSS v2: 
Base Score: 7.5 
Temporal Score: 5.9 
Vector: (AV:N/AC:L/Au:N/C:P/I:P/A:P/E:P/RL:O/RC:C)

CVE: not assigned

---[Software description]

OneOrZero 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 description]

Positive 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 fix]

Positive Technologies experts recommend to filter user input data

---[Advisory status]

08.07.2011 - Vendor is notified 
23.08.2011 - Vulnerability details were sent to CERT 
19.10.2011 - Public disclosure 
Credits

The vulnerability was detected by Yuri Goltsev, Positive Research Center (Positive Technologies Company)

---[References]

http://en.securitylab.ru/lab/PT-2011-21 
http://www.kb.cert.org/vuls/id/800227

Reports on the vulnerabilities previously discovered by Positive Research:

http://www.ptsecurity.com/advisory1.aspx 
http://en.securitylab.ru/lab/

---[About Positive Technologies]

Positive Technologies www.ptsecurity.com is among the key players in the IT security market in Russia.

The principal activities of the company include the development of integrated tools for information security monitoring (MaxPatrol); providing IT security consulting services and technical support; development of the Securitylab leading Russian information security portal.

Among the clients of Positive Technologies, there are more than 40 state enterprises, more than 50 banks and financial organizations, 
20 telecommunication companies, more than 40 plant facilities, as well as IT, service and retail companies from Russia, the CIS countries, the Baltic States, China, Ecuador, Germany, Great Britain, Holland, Iran, Israel, Japan, Mexico, the Republic of South Africa, Thailand, Turkey, and the USA.

Positive Technologies is a team of highly skilled developers, advisers and experts with years of vast hands-on experience. The company specialists possess professional titles and certificates; they are the members of various international societies and are actively involved in the IT security field development.