ConnX SQL Injection

`aushack.com - Vulnerability Advisory  
-----------------------------------------------  
Release Date:  
03-Apr-2009  
  
Software:  
Q2 Solutions - ConnX  
http://www.q2solutions.com.au/  
  
"ConnX is a ready built internet/intranet solution that empowers employees and  
management to view and update HR and Payroll information. Internal  
communications  
are improved by providing easy access to Company and personal information for  
all employees."  
  
Versions tested:  
Version 4.0.20080606 has been confirmed as vulnerable. Other versions untested.  
  
Vulnerability discovered:  
  
SQL Injection  
  
Vulnerability impact:  
  
High - SQL Injection in backend database. Impact depends on the  
security and configuration of the database. It may be possible  
to execute code using functons such as xp_cmdshell in poorly  
configured hosts. Other attacks possible include obtaining read  
or write access to employee data or payroll.  
  
Vulnerability information:  
  
The 'txtEmail' HTML form input POST parameter of password reminder form  
'frmLoginPwdReminderPopup.aspx' is vulnerable to SQL injection.  
  
Example:  
  
Submitting:  
  
' union select @@version;--  
  
To:  
  
http://connx.[victim].com/frmLoginPwdReminderPopup.aspx  
  
Returns:  
  
"Error retrieving password reminder. Syntax error converting the nvarchar  
value 'Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53  
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2  
(Build 3790: Service Pack 2) ' to a column of data type int."  
  
Recommendation:  
  
Vendor refused to comment on whether they would develop a patch or even notify  
existing client base.  
  
Workaround: Remove ConnX server from public Internet access and protect behind  
corporate firewalls, SSL-VPN, web application firewall etc.  
  
References:  
aushack.com advisory  
http://www.aushack.com/200904-q2solutions.txt  
  
Credit:  
Patrick Webster ( [email protected] )  
  
Disclosure timeline:  
30-Oct-2008 - Discovered during audit.  
05-Nov-2008 - Notified vendor. Vendor declined to comment.  
01-Dec-2008 - Submitted full details to vendor.  
18-Dec-2008 - Attempted to contact vendor again for a patch release date.  
18-Dec-2008 - And again...  
18-Dec-2008 - Vendor response, no patch - "We support our clients,  
not independent contractors."  
03-Apr-2009 - Disclosure.  
  
EOF  
`