[Full-disclosure] Enterprise Connector v.1.02 Multiple SQL Vulnerabilities and Login Bypass

[Attila Gerendi <darkz.gsa@xxxxxxxxx>]

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 from 2004/4/27.
You may edit the source code to ensure that input is properly sanitised.

_______________________________________________
Full-Disclosure - We believe in it.
Charter: http://lists.grok.org.uk/full-disclosure-charter.html
Hosted and sponsored by Secunia - http://secunia.com/