Bug 31868 - sqlite3 new security issues CVE-2023-2137 and CVE-2023-7104
Summary: sqlite3 new security issues CVE-2023-2137 and CVE-2023-7104
Status: RESOLVED FIXED
Alias: None
Product: Mageia
Classification: Unclassified
Component: Security (show other bugs)
Version: 9
Hardware: All Linux
Priority: Normal critical
Target Milestone: ---
Assignee: QA Team
QA Contact: Sec team
URL:
Whiteboard: MGA9-64-OK
Keywords: advisory, validated_update
Depends on:
Blocks:
 
Reported: 2023-05-04 17:26 CEST by David Walser
Modified: 2024-03-20 04:36 CET (History)
5 users (show)

See Also:
Source RPM: sqlite3-3.40.1-1.mga9.src.rpm
CVE: CVE-2023-2137, CVE-2023-7104
Status comment:


Attachments

Description David Walser 2023-05-04 17:26:28 CEST
The chromium update from April 18 also includes an sqlite security fix:
https://chromereleases.googleblog.com/2023/04/stable-channel-update-for-desktop_18.html
David Walser 2023-05-04 17:26:36 CEST

Whiteboard: (none) => MGA8TOO

Comment 1 Lewis Smith 2023-05-04 20:19:25 CEST
Assigning to Stig, the current packager looking after sqlite3.

Assignee: bugsquad => smelror

Comment 2 Nicolas Salguero 2024-01-08 17:07:30 CET
Ubuntu has issued an advisory on January 3:
https://ubuntu.com/security/notices/USN-6566-1

CC: (none) => nicolas.salguero
Summary: sqlite3 new security issue CVE-2023-2137 => sqlite3 new security issues CVE-2023-2137 and CVE-2023-7104
CVE: (none) => CVE-2023-2137, CVE-2023-7104
Severity: normal => critical
Whiteboard: MGA8TOO => MGA9TOO

Comment 3 Nicolas Salguero 2024-03-14 17:03:23 CET
Suggested advisory:
========================

The updated packages fix security vulnerabilities:

Heap buffer overflow in sqlite. (CVE-2023-2137)

A vulnerability was found in SQLite SQLite3 up to 3.43.0 and classified as critical. This issue affects the function sessionReadRecord of the file ext/session/sqlite3session.c of the component make alltest Handler. The manipulation leads to heap-based buffer overflow. (CVE-2023-7104)

References:
https://chromereleases.googleblog.com/2023/04/stable-channel-update-for-desktop_18.html
https://ubuntu.com/security/notices/USN-6566-1
========================

Updated packages in core/updates_testing:
========================
lemon-3.40.1-1.1.mga9
lib(64)sqlite3_0-3.40.1-1.1.mga9
lib(64)sqlite3-devel-3.40.1-1.1.mga9
lib(64)sqlite3-static-devel-3.40.1-1.1.mga9
sqlite3-tcl-3.40.1-1.1.mga9
sqlite3-tools-3.40.1-1.1.mga9

from SRPM:
sqlite3-3.40.1-1.1.mga9.src.rpm

Assignee: smelror => qa-bugs
Whiteboard: MGA9TOO => (none)
Version: Cauldron => 9
Status: NEW => ASSIGNED

PC LX 2024-03-14 18:14:13 CET

CC: (none) => mageia

katnatek 2024-03-14 20:18:09 CET

Keywords: (none) => advisory

katnatek 2024-03-16 18:27:08 CET

CC: (none) => herman.viaene

Comment 4 katnatek 2024-03-16 18:28:11 CET
Herman Viaene can you please do the same test that in previous rounds? 
Thank you
katnatek 2024-03-17 00:22:35 CET

CC: (none) => andrewsfarm

Comment 5 katnatek 2024-03-17 00:28:05 CET
RH mageia 9 x86_64

Install all the packages, uninstall devel and extra packages, keep the updated lib64sqlite3_0

LC_ALL=C urpmi /home/katnatek/qa-testing/x86_64/*.rpm


installing lib64sqlite3-static-devel-3.40.1-1.1.mga9.x86_64.rpm sqlite3-tools-3.40.1-1.1.mga9.x86_64.rpm lib64sqlite3-devel-3.40.1-1.1.mga9.x86_64.rpm lib64sqlite3_0-3.40.1-1.1.mga9.x86_64.rpm sqlite3-tcl-3.40.1-1.1.mga9.x86_64.rpm lemon-3.40.1-1.1.mga9.x86_64.rpm from /home/katnatek/qa-testing/x86_64
Preparing...                     ######################################################################################
      1/6: lib64sqlite3_0        ######################################################################################
      2/6: sqlite3-tools         ######################################################################################
      3/6: lib64sqlite3-devel    ######################################################################################
      4/6: lib64sqlite3-static-devel
                                 ######################################################################################
      5/6: sqlite3-tcl           ######################################################################################
      6/6: lemon                 ######################################################################################
      1/1: removing lib64sqlite3_0-3.40.1-1.mga9.x86_64
                                 ######################################################################################

urpme $(rpm -qa|grep sqlite3|grep devel) lemon
quitando lemon-3.40.1-1.1.mga9.x86_64 lib64sqlite3-devel-3.40.1-1.1.mga9.x86_64 lib64sqlite3-static-devel-3.40.1-1.1.mga9.x86_64
quitando paquete lib64sqlite3-static-devel-3.40.1-1.1.mga9.x86_64
      1/3: quitando lib64sqlite3-static-devel-3.40.1-1.1.mga9.x86_64
                                 ######################################################################################
quitando paquete lib64sqlite3-devel-3.40.1-1.1.mga9.x86_64
      2/3: quitando lib64sqlite3-devel-3.40.1-1.1.mga9.x86_64
                                 ######################################################################################
quitando paquete lemon-3.40.1-1.1.mga9.x86_64
      3/3: quitando lemon-3.40.1-1.1.mga9.x86_64
                                 ######################################################################################

LC_ALL=C urpme sqlite3-tools sqlite3-tcl
removing sqlite3-tcl-3.40.1-1.1.mga9.x86_64 sqlite3-tools-3.40.1-1.1.mga9.x86_64
removing package sqlite3-tcl-3.40.1-1.1.mga9.x86_64
      1/2: removing sqlite3-tcl-3.40.1-1.1.mga9.x86_64
                                 ######################################################################################
removing package sqlite3-tools-3.40.1-1.1.mga9.x86_64
      2/2: removing sqlite3-tools-3.40.1-1.1.mga9.x86_64
                                 ######################################################################################
Comment 6 Herman Viaene 2024-03-18 15:25:06 CET
@Comment 4: your wish is my command.
Installed sqlitestudio and repeated test as in bug 31312 : table with autoincrement primary key, unique text field, other text field without rules and a timestamp.
Works OK.

Whiteboard: (none) => MGA9-64-OK

Comment 7 katnatek 2024-03-18 18:43:51 CET
Herman test (thank you for that) was enough in previous rounds

CC: (none) => sysadmin-bugs
Keywords: (none) => validated_update

Comment 8 Mageia Robot 2024-03-20 04:36:29 CET
An update for this issue has been pushed to the Mageia Updates repository.

https://advisories.mageia.org/MGASA-2024-0073.html

Status: ASSIGNED => RESOLVED
Resolution: (none) => FIXED


Note You need to log in before you can comment on or make changes to this bug.