Bug 886029 (CVE-2022-46908) – <dev-db/sqlite-3.40.1: insufficient sandboxing of "safe" script execution

• Product: Gentoo Security
• Status: RESOLVED FIXED

[Description John Helmert III 2022-12-15 06:20:29 UTC]

CVE-2022-46908 (https://news.ycombinator.com/item?id=33948588):
https://sqlite.org/forum/forumpost/07beac8056151b2f
https://sqlite.org/src/info/cefc032473ac5ad2

SQLite through 3.40.0, when relying on --safe for execution of an untrusted CLI script, does not properly implement the azProhibitedFunctions protection mechanism, and instead allows UDF functions such as WRITEFILE.

Not sure how to find if there's a fix for this in any release.

[Comment 1 Larry the Git Cow 2022-12-30 07:32:28 UTC]

The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=81925c4c2fceb321215d029fe13b30aa1336e164

commit 81925c4c2fceb321215d029fe13b30aa1336e164
Author:     Sam James <[e-mail]>
AuthorDate: 2022-12-30 07:25:25 +0000
Commit:     Sam James <[e-mail]>
CommitDate: 2022-12-30 07:31:53 +0000

    dev-db/sqlite: add 3.40.1
    
    Bug: https://bugs.gentoo.org/886029
    Signed-off-by: Sam James <[e-mail]>

 dev-db/sqlite/Manifest             |   2 +
 dev-db/sqlite/sqlite-3.40.1.ebuild | 432 +++++++++++++++++++++++++++++++++++++
 2 files changed, 434 insertions(+)

[Comment 2 John Helmert III 2023-01-08 17:05:09 UTC]

Please cleanup

[Comment 3 Larry the Git Cow 2023-01-08 17:06:52 UTC]

The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=5a8b55018320bbd9a59d4d88354bae1a9f227832

commit 5a8b55018320bbd9a59d4d88354bae1a9f227832
Author:     Jakov Smolić <[e-mail]>
AuthorDate: 2023-01-08 12:49:35 +0000
Commit:     Jakov Smolić <[e-mail]>
CommitDate: 2023-01-08 17:06:25 +0000

    dev-db/sqlite: drop 3.39.4, 3.40.0
    
    Bug: https://bugs.gentoo.org/886029
    Signed-off-by: Jakov Smolić <[e-mail]>

 dev-db/sqlite/Manifest             |   4 -
 dev-db/sqlite/sqlite-3.39.4.ebuild | 440 -------------------------------------
 dev-db/sqlite/sqlite-3.40.0.ebuild | 432 ------------------------------------
 3 files changed, 876 deletions(-)

[Comment 4 John Helmert III 2023-01-08 17:08:09 UTC]

Thanks!

[Comment 5 Larry the Git Cow 2023-11-24 12:30:51 UTC]

The bug has been referenced in the following commit(s):

https://gitweb.gentoo.org/data/glsa.git/commit/?id=dad04282cd66732607077c1c4754ea9912114d12

commit dad04282cd66732607077c1c4754ea9912114d12
Author:     GLSAMaker <[e-mail]>
AuthorDate: 2023-11-24 12:29:15 +0000
Commit:     Hans de Graaff <[e-mail]>
CommitDate: 2023-11-24 12:30:37 +0000

    [ GLSA 202311-03 ] SQLite: Multiple Vulnerabilities
    
    Bug: https://bugs.gentoo.org/886029
    Bug: https://bugs.gentoo.org/906114
    Signed-off-by: GLSAMaker <[e-mail]>
    Signed-off-by: Hans de Graaff <[e-mail]>

 glsa-202311-03.xml | 44 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 44 insertions(+)