Secunia Research: webERP Multiple SQL Injection Vulnerabilities

====================================================================== 

                     Secunia Research 11/11/2010

          - webERP Multiple SQL Injection Vulnerabilities -

====================================================================== 
Table of Contents

Affected Software....................................................1
Severity.............................................................2
Vendor's Description of Software.....................................3
Description of Vulnerability.........................................4
Solution.............................................................5
Time Table...........................................................6
Credits..............................................................7
References...........................................................8
About Secunia........................................................9
Verification........................................................10

====================================================================== 
1) Affected Software 

* webERP 3.11.4

NOTE: Other versions may also be affected.

====================================================================== 
2) Severity 

Rating: Less critical
Impact: Manipulation of data
Where:  From remote

====================================================================== 
3) Vendor's Description of Software 

"webERP is a complete web based accounting/ERP system that requires 
only a web-browser and pdf reader to use. It has a wide range of 
features suitable for many businesses particularly distributed 
businesses in wholesale and distribution. It is developed as an 
open-source application and is available as a free download to use."

Product Link:
http://www.weberp.org/

====================================================================== 
4) Description of Vulnerability

Secunia Research has discovered multiple vulnerabilities in webERP,
which can be exploited by malicious users to conduct SQL injection
attacks.

1) Input passed via the "SelectedCustomer" and "SelectedStockItem"
parameters to SelectSalesOrder.php, the "SelectedStockItem" parameter
to SelectWorkOrder.php, the "WO" parameter to WorkOrderCosting.php,
the "WO" and "StockID" parameters to WorkOrderReceive.php and
WorkOrderIssue.php, the "OrderNumber" parameter to
SelectCompletedOrder.php, the "OrderNo" parameter to
PO_OrderDetails.php, the "SelectedReport" parameter to
SalesAnalRepts.php, the "ReportID" parameter to SalesAnalReptCols.php
and SalesAnalysis_UserDefined.php, the "TransType" parameter to
CustomerTransInquiry.php, the "BatchNo" parameter to
PDFBankingSummary.php, the "TransNo" and "TransType" parameters to
CustWhereAlloc.php, the "FromTransNo" parameter to PrintCustTrans.php,
and the "tag", "FromPeriod", and "ToPeriod" parameters to
GLTagProfit_Loss.php is not properly sanitised before being used in
SQL queries. This can be exploited to manipulate SQL queries by
injecting arbitrary SQL code.

2) Input passed via the "WO" parameter to WorkOrderEntry.php, the
"WO" and "StockID" parameters to WorkOrderStatus.php, and the
"Areas[]" and "SalesPeople[]" parameters in PDFCustomerList.php is
not properly sanitised before being used in SQL queries. This can be
exploited to manipulate SQL queries by injecting arbitrary SQL code.

Parameters in vulnerability #2 can further be exploited to conduct
cross-site scripting attacks via SQL error messages.

====================================================================== 
5) Solution 

Some of the vulnerabilities are fixed in version 4.00 RC1.

====================================================================== 
6) Time Table 

29/07/2010 - Vendor notified.
11/08/2010 - Second vendor notification.
11/08/2010 - Vendor response.
22/09/2010 - Sent status request.
30/09/2010 - Vendor response.
15/10/2010 - Sent status request.
11/11/2010 - Public disclosure.

====================================================================== 
7) Credits 

Discovered by Secunia Research.

====================================================================== 
8) References

The Common Vulnerabilities and Exposures (CVE) project has not
currently assigned a CVE identifier for the vulnerabilities.

====================================================================== 
9) About Secunia

Secunia offers vulnerability management solutions to corporate
customers with verified and reliable vulnerability intelligence
relevant to their specific system configuration:

http://secunia.com/advisories/business_solutions/

Secunia also provides a publicly accessible and comprehensive advisory
database as a service to the security community and private 
individuals, who are interested in or concerned about IT-security.

http://secunia.com/advisories/

Secunia believes that it is important to support the community and to
do active vulnerability research in order to aid improving the 
security and reliability of software in general:

http://secunia.com/secunia_research/

Secunia regularly hires new skilled team members. Check the URL below
to see currently vacant positions:

http://secunia.com/corporate/jobs/

Secunia offers a FREE mailing list called Secunia Security Advisories:

http://secunia.com/advisories/mailing_lists/

====================================================================== 
10) Verification 

Please verify this advisory by visiting the Secunia website:
http://secunia.com/secunia_research/2010-134/

Complete list of vulnerability reports published by Secunia Research:
http://secunia.com/secunia_research/

======================================================================