<<< Date Index >>>     <<< Thread Index >>>

Enterprise Connector v.1.02 Multiple SQL Vulnerabilities and Login Bypass



Enterprise Connector v.1.02 Multiple SQL Vulnerabilities and Login Bypass

Author: Attila Gerendi (Darkz)
Date: December 20, 2005
Package: Enterprise Connector 
(http://www.enterpriseheart.com/site/modules/mydownloads/)
Versions Affected: 1.02 (Other versions may also be affected.)
Severity: SQL Injection, Login Bypass

Description:

Some of this SQL injection vulnerabilities are already reported at: 
        http://secunia.com/advisories/17743/ 
        
A new SQL vulnerability not listed in the previous report:

Input passed to the "loginid" parameter in "main.php" isn't properly sanitised 
before being used in 
a SQL query. This can be exploited to manipulate SQL queries by injecting 
arbitrary SQL code and 
bypass login sequence.

Login Bypass Example: 
        username 'or isnull(1/0) /*
        password (no password required)
        
or just simply call main.php with POST_PARAMETER loginid='or isnull(1/0) /*

Vulnerable code piece:

$sql = "SELECT userid, companyid, departmentid, status, languagefile FROM 
connector_user WHERE ";
        $sql .= "userid = '" . $_POST['loginid'] . "' ";
        $sql .= " AND password = '" . $_POST['password'] . "'";
        $result = sql_execute($sql);

There may be more SQL injection vulnerabilities there.

The Author was contacted via home page "contact us" module at December 8 2005, 
no response given.

Solution:
Enterprise Connector  development seen to be suspended by now. No new release 
2004/4/27.
You may edit the source code to ensure that input is properly sanitised.