Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008579Openbravo ERPA. Platformpublic2009-04-15 15:412009-06-04 00:00
shuehner 
shuehner 
urgentmajorhave not tried
closedfixed 
5
2.40 
 
Core
No
0008579: SQL injection in selectors
The selector code has issues where it is possible to inject code into the executed SQL statement via crafted parameters coming from the user.
No tags attached.
depends on backport 0009045 closed shuehner SQL injection in selectors 
related to defect 0005236 closed shuehner Sorting by more than one column is not working in at least Product Complete & Business Partner Selector 
related to defect 0009074 closed shuehner SQL injection in datagrid code 
Issue History
2009-04-15 15:41shuehnerNew Issue
2009-04-15 15:41shuehnerAssigned To => rafaroda
2009-04-15 15:41shuehnerRegression testing => No
2009-04-15 15:41shuehnerAssigned Torafaroda => shuehner
2009-04-22 20:04psarobeStatusnew => scheduled
2009-04-22 20:04psarobefix_in_branch => pi
2009-05-13 09:02shuehnerNote Added: 0016309
2009-05-13 09:02shuehnerPrioritynormal => urgent
2009-05-13 09:02shuehnerfix_in_branchpi =>
2009-05-15 10:57shuehnerStatusscheduled => acknowledged
2009-05-15 10:57shuehnerStatusacknowledged => scheduled
2009-05-15 10:57shuehnerfix_in_branch => pi
2009-05-15 12:13hgbotCheckin
2009-05-15 12:13hgbotNote Added: 0016381
2009-05-15 12:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d4fedb1b06c242856f0ae288fd2972f43c04eced [^]
2009-05-18 15:16hgbotCheckin
2009-05-18 15:16hgbotNote Added: 0016425
2009-05-18 15:16hgbotStatusscheduled => resolved
2009-05-18 15:16hgbotResolutionopen => fixed
2009-05-18 15:16hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/d4fedb1b06c242856f0ae288fd2972f43c04eced [^] => http://code.openbravo.com/erp/devel/pi/rev/68ba24ee1a88f95d7c2727454331f052809d9468 [^]
2009-05-18 15:24shuehnerRelationship addedrelated to 0005236
2009-05-18 15:34shuehnerRelationship addedrelated to 0009074
2009-06-03 12:00psarobeStatusresolved => closed
2009-06-04 00:00anonymoussf_bug_id0 => 2800770

Notes
(0016309)
shuehner   
2009-05-13 09:02   
Updated to urgent as discussed with iciordia
(0016381)
hgbot   
2009-05-15 12:13   
Repository: erp/devel/pi
Changeset: d4fedb1b06c242856f0ae288fd2972f43c04eced
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri May 15 12:13:10 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d4fedb1b06c242856f0ae288fd2972f43c04eced [^]

Issue 8579: Validate offset,pageSize to the numeric

---
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/AccountElementValue.java
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple.java
M src/org/openbravo/erpCommon/info/DebtPayment.java
M src/org/openbravo/erpCommon/info/Invoice.java
M src/org/openbravo/erpCommon/info/InvoiceLine.java
M src/org/openbravo/erpCommon/info/Locator.java
M src/org/openbravo/erpCommon/info/Product.java
M src/org/openbravo/erpCommon/info/ProductComplete.java
M src/org/openbravo/erpCommon/info/ProductMultiple.java
M src/org/openbravo/erpCommon/info/Project.java
M src/org/openbravo/erpCommon/info/SalesOrder.java
M src/org/openbravo/erpCommon/info/SalesOrderLine.java
M src/org/openbravo/erpCommon/info/ShipmentReceipt.java
M src/org/openbravo/erpCommon/info/ShipmentReceiptLine.java
---
(0016425)
hgbot   
2009-05-18 15:16   
Repository: erp/devel/pi
Changeset: 68ba24ee1a88f95d7c2727454331f052809d9468
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Mon May 18 15:16:36 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/68ba24ee1a88f95d7c2727454331f052809d9468 [^]

Fixed 8579: validate orderBy parameters, prepare ordering by multiple columns

---
M src/org/openbravo/erpCommon/info/Account.java
M src/org/openbravo/erpCommon/info/AccountElementValue.java
M src/org/openbravo/erpCommon/info/BusinessPartner.java
M src/org/openbravo/erpCommon/info/BusinessPartnerMultiple.java
M src/org/openbravo/erpCommon/info/DebtPayment.java
M src/org/openbravo/erpCommon/info/Invoice.java
M src/org/openbravo/erpCommon/info/InvoiceLine.java
M src/org/openbravo/erpCommon/info/Locator.java
M src/org/openbravo/erpCommon/info/Product.java
M src/org/openbravo/erpCommon/info/ProductComplete.java
M src/org/openbravo/erpCommon/info/ProductMultiple.java
M src/org/openbravo/erpCommon/info/Project.java
M src/org/openbravo/erpCommon/info/SalesOrder.java
M src/org/openbravo/erpCommon/info/SalesOrderLine.java
M src/org/openbravo/erpCommon/info/ShipmentReceipt.java
M src/org/openbravo/erpCommon/info/ShipmentReceiptLine.java
A src/org/openbravo/erpCommon/info/SelectorUtility.java
---