-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

===========================================================================
             AUSCERT External Security Bulletin Redistribution

                               ESB-2021.3221
                        Security update for sqlite3
                             27 September 2021

===========================================================================

        AusCERT Security Bulletin Summary
        ---------------------------------

Product:           sqlite3
Publisher:         SUSE
Operating System:  SUSE
Impact/Access:     Execute Arbitrary Code/Commands -- Remote/Unauthenticated
                   Denial of Service               -- Remote/Unauthenticated
                   Access Confidential Data        -- Remote/Unauthenticated
                   Reduced Security                -- Remote/Unauthenticated
Resolution:        Patch/Upgrade
CVE Names:         CVE-2020-15358 CVE-2020-13632 CVE-2020-13631
                   CVE-2020-13630 CVE-2020-13435 CVE-2020-13434
                   CVE-2020-9327 CVE-2019-20218 CVE-2019-19959
                   CVE-2019-19926 CVE-2019-19925 CVE-2019-19924
                   CVE-2019-19923 CVE-2019-19880 CVE-2019-19646
                   CVE-2019-19645 CVE-2019-19603 CVE-2019-19317
                   CVE-2019-19244 CVE-2019-16168 CVE-2019-8457
                   CVE-2018-20346 CVE-2018-8740 CVE-2017-10989
                   CVE-2017-2518 CVE-2016-6153 CVE-2015-3415
                   CVE-2015-3414  

Reference:         ESB-2021.2412
                   ESB-2021.1689
                   ESB-2021.0692

Original Bulletin: 
   https://www.suse.com/support/update/announcement/2021/suse-su-20213215-1

- --------------------------BEGIN INCLUDED TEXT--------------------

SUSE Security Update: Security update for sqlite3

______________________________________________________________________________

Announcement ID:   SUSE-SU-2021:3215-1
Rating:            important
References:        #1157818 #1158812 #1158958 #1158959 #1158960 #1159491
                   #1159715 #1159847 #1159850 #1160309 #1160438 #1160439
                   #1164719 #1172091 #1172115 #1172234 #1172236 #1172240
                   #1173641 #928700 #928701
Cross-References:  CVE-2015-3414 CVE-2015-3415 CVE-2016-6153 CVE-2017-10989
                   CVE-2017-2518 CVE-2018-20346 CVE-2018-8740 CVE-2019-16168
                   CVE-2019-19244 CVE-2019-19317 CVE-2019-19603 CVE-2019-19645
                   CVE-2019-19646 CVE-2019-19880 CVE-2019-19923 CVE-2019-19924
                   CVE-2019-19925 CVE-2019-19926 CVE-2019-19959 CVE-2019-20218
                   CVE-2019-8457 CVE-2020-13434 CVE-2020-13435 CVE-2020-13630
                   CVE-2020-13631 CVE-2020-13632 CVE-2020-15358 CVE-2020-9327
Affected Products:
                   SUSE OpenStack Cloud Crowbar 9
                   SUSE OpenStack Cloud Crowbar 8
                   SUSE OpenStack Cloud 9
                   SUSE OpenStack Cloud 8
                   SUSE Linux Enterprise Software Development Kit 12-SP5
                   SUSE Linux Enterprise Server for SAP 12-SP4
                   SUSE Linux Enterprise Server for SAP 12-SP3
                   SUSE Linux Enterprise Server 12-SP5
                   SUSE Linux Enterprise Server 12-SP4-LTSS
                   SUSE Linux Enterprise Server 12-SP3-LTSS
                   SUSE Linux Enterprise Server 12-SP3-BCL
                   SUSE Linux Enterprise Server 12-SP2-BCL
                   HPE Helion Openstack 8
______________________________________________________________________________

An update that fixes 28 vulnerabilities, contains one feature is now available.

Description:

This update for sqlite3 fixes the following issues:
sqlite3 is sync version 3.36.0 from Factory (jsc#SLE-16032).
The following CVEs have been fixed in upstream releases up to this point, but
were not mentioned in the change log so far:

  o bsc#1173641, CVE-2020-15358: heap-based buffer overflow in
    multiSelectOrderBy due to mishandling of query-flattener optimization
  o bsc#1164719, CVE-2020-9327: NULL pointer dereference and segmentation fault
    because of generated column optimizations in isAuxiliaryVtabOperator
  o bsc#1160439, CVE-2019-20218: selectExpander in select.c proceeds with WITH
    stack unwinding even after a parsing error
  o bsc#1160438, CVE-2019-19959: memory-management error via ext/misc/zipfile.c
    involving embedded '\0' input
  o bsc#1160309, CVE-2019-19923: improper handling of certain uses of SELECT
    DISTINCT in flattenSubquery may lead to null pointer dereference
  o bsc#1159850, CVE-2019-19924: improper error handling in
    sqlite3WindowRewrite()
  o bsc#1159847, CVE-2019-19925: improper handling of NULL pathname during an
    update of a ZIP archive
  o bsc#1159715, CVE-2019-19926: improper handling of certain errors during
    parsing multiSelect in select.c
  o bsc#1159491, CVE-2019-19880: exprListAppendList in window.c allows
    attackers to trigger an invalid pointer dereference
  o bsc#1158960, CVE-2019-19603: during handling of CREATE TABLE and CREATE
    VIEW statements, does not consider confusion with a shadow table name
  o bsc#1158959, CVE-2019-19646: pragma.c mishandles NOT NULL in an
    integrity_check PRAGMA command in certain cases of generated columns
  o bsc#1158958, CVE-2019-19645: alter.c allows attackers to trigger infinite
    recursion via certain types of self-referential views in conjunction with
    ALTER TABLE statements
  o bsc#1158812, CVE-2019-19317: lookupName in resolve.c omits bits from the
    colUsed bitmask in the case of a generated column, which allows attackers
    to cause a denial of service
  o bsc#1157818, CVE-2019-19244: sqlite3,sqlite2,sqlite: The function
    sqlite3Select in select.c allows a crash if a sub-select uses both DISTINCT
    and window functions, and also has certain ORDER BY usage
  o bsc#928701, CVE-2015-3415: sqlite3VdbeExec comparison operator
    vulnerability
  o bsc#928700, CVE-2015-3414: sqlite3,sqlite2: dequoting of collation-sequence
    names
  o CVE-2020-13434 bsc#1172115: integer overflow in sqlite3_str_vappendf
  o CVE-2020-13630 bsc#1172234: use-after-free in fts3EvalNextRow
  o CVE-2020-13631 bsc#1172236: virtual table allowed to be renamed to one of
    its shadow tables
  o CVE-2020-13632 bsc#1172240: NULL pointer dereference via crafted matchinfo
    () query
  o CVE-2020-13435: Malicious SQL statements could have crashed the process
    that is running SQLite (bsc#1172091)

Patch Instructions:

To install this SUSE Security Update use the SUSE recommended installation
methods like YaST online_update or "zypper patch".
Alternatively you can run the command listed for your product:

  o SUSE OpenStack Cloud Crowbar 9:
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2021-3215=1
  o SUSE OpenStack Cloud Crowbar 8:
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-8-2021-3215=1
  o SUSE OpenStack Cloud 9:
    zypper in -t patch SUSE-OpenStack-Cloud-9-2021-3215=1
  o SUSE OpenStack Cloud 8:
    zypper in -t patch SUSE-OpenStack-Cloud-8-2021-3215=1
  o SUSE Linux Enterprise Software Development Kit 12-SP5:
    zypper in -t patch SUSE-SLE-SDK-12-SP5-2021-3215=1
  o SUSE Linux Enterprise Server for SAP 12-SP4:
    zypper in -t patch SUSE-SLE-SAP-12-SP4-2021-3215=1
  o SUSE Linux Enterprise Server for SAP 12-SP3:
    zypper in -t patch SUSE-SLE-SAP-12-SP3-2021-3215=1
  o SUSE Linux Enterprise Server 12-SP5:
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2021-3215=1
  o SUSE Linux Enterprise Server 12-SP4-LTSS:
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2021-3215=1
  o SUSE Linux Enterprise Server 12-SP3-LTSS:
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-2021-3215=1
  o SUSE Linux Enterprise Server 12-SP3-BCL:
    zypper in -t patch SUSE-SLE-SERVER-12-SP3-BCL-2021-3215=1
  o SUSE Linux Enterprise Server 12-SP2-BCL:
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2021-3215=1
  o HPE Helion Openstack 8:
    zypper in -t patch HPE-Helion-OpenStack-8-2021-3215=1

Package List:

  o SUSE OpenStack Cloud Crowbar 9 (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE OpenStack Cloud Crowbar 8 (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE OpenStack Cloud 9 (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE OpenStack Cloud 8 (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Software Development Kit 12-SP5 (aarch64 ppc64le
    s390x x86_64):
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server for SAP 12-SP4 (ppc64le x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server for SAP 12-SP4 (x86_64):
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
  o SUSE Linux Enterprise Server for SAP 12-SP3 (ppc64le x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server for SAP 12-SP3 (x86_64):
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP5 (aarch64 ppc64le s390x x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP5 (s390x x86_64):
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP4-LTSS (aarch64 ppc64le s390x x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP4-LTSS (s390x x86_64):
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP3-LTSS (aarch64 ppc64le s390x x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP3-LTSS (s390x x86_64):
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP3-BCL (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o SUSE Linux Enterprise Server 12-SP2-BCL (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1
  o HPE Helion Openstack 8 (x86_64):
       libsqlite3-0-3.36.0-9.18.1
       libsqlite3-0-32bit-3.36.0-9.18.1
       libsqlite3-0-debuginfo-3.36.0-9.18.1
       libsqlite3-0-debuginfo-32bit-3.36.0-9.18.1
       sqlite3-3.36.0-9.18.1
       sqlite3-debuginfo-3.36.0-9.18.1
       sqlite3-debugsource-3.36.0-9.18.1
       sqlite3-devel-3.36.0-9.18.1


References:

  o https://www.suse.com/security/cve/CVE-2015-3414.html
  o https://www.suse.com/security/cve/CVE-2015-3415.html
  o https://www.suse.com/security/cve/CVE-2016-6153.html
  o https://www.suse.com/security/cve/CVE-2017-10989.html
  o https://www.suse.com/security/cve/CVE-2017-2518.html
  o https://www.suse.com/security/cve/CVE-2018-20346.html
  o https://www.suse.com/security/cve/CVE-2018-8740.html
  o https://www.suse.com/security/cve/CVE-2019-16168.html
  o https://www.suse.com/security/cve/CVE-2019-19244.html
  o https://www.suse.com/security/cve/CVE-2019-19317.html
  o https://www.suse.com/security/cve/CVE-2019-19603.html
  o https://www.suse.com/security/cve/CVE-2019-19645.html
  o https://www.suse.com/security/cve/CVE-2019-19646.html
  o https://www.suse.com/security/cve/CVE-2019-19880.html
  o https://www.suse.com/security/cve/CVE-2019-19923.html
  o https://www.suse.com/security/cve/CVE-2019-19924.html
  o https://www.suse.com/security/cve/CVE-2019-19925.html
  o https://www.suse.com/security/cve/CVE-2019-19926.html
  o https://www.suse.com/security/cve/CVE-2019-19959.html
  o https://www.suse.com/security/cve/CVE-2019-20218.html
  o https://www.suse.com/security/cve/CVE-2019-8457.html
  o https://www.suse.com/security/cve/CVE-2020-13434.html
  o https://www.suse.com/security/cve/CVE-2020-13435.html
  o https://www.suse.com/security/cve/CVE-2020-13630.html
  o https://www.suse.com/security/cve/CVE-2020-13631.html
  o https://www.suse.com/security/cve/CVE-2020-13632.html
  o https://www.suse.com/security/cve/CVE-2020-15358.html
  o https://www.suse.com/security/cve/CVE-2020-9327.html
  o https://bugzilla.suse.com/1157818
  o https://bugzilla.suse.com/1158812
  o https://bugzilla.suse.com/1158958
  o https://bugzilla.suse.com/1158959
  o https://bugzilla.suse.com/1158960
  o https://bugzilla.suse.com/1159491
  o https://bugzilla.suse.com/1159715
  o https://bugzilla.suse.com/1159847
  o https://bugzilla.suse.com/1159850
  o https://bugzilla.suse.com/1160309
  o https://bugzilla.suse.com/1160438
  o https://bugzilla.suse.com/1160439
  o https://bugzilla.suse.com/1164719
  o https://bugzilla.suse.com/1172091
  o https://bugzilla.suse.com/1172115
  o https://bugzilla.suse.com/1172234
  o https://bugzilla.suse.com/1172236
  o https://bugzilla.suse.com/1172240
  o https://bugzilla.suse.com/1173641
  o https://bugzilla.suse.com/928700
  o https://bugzilla.suse.com/928701

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

NOTE: Third Party Rights
This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content. The decision to follow or act on information or advice
contained in this security bulletin is the responsibility of each user or
organisation, and should be considered in accordance with your organisation's
site policies and procedures. AusCERT takes no responsibility for consequences
which may arise from following or acting on information or advice contained in
this security bulletin.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the author's website to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:

        https://www.auscert.org.au/bulletins/

===========================================================================
Australian Computer Emergency Response Team
The University of Queensland
Brisbane
Qld 4072

Internet Email: auscert@auscert.org.au
Facsimile:      (07) 3365 7031
Telephone:      (07) 3365 4417 (International: +61 7 3365 4417)
                AusCERT personnel answer during Queensland business hours
                which are GMT+10:00 (AEST).
                On call after hours for member emergencies only.
===========================================================================
-----BEGIN PGP SIGNATURE-----
Comment: http://www.auscert.org.au/render.html?it=1967

iQIVAwUBYVERhuNLKJtyKPYoAQipxRAAh4p2ZlwQ6yVEgE/pF8QJr3LhSccZ6fQ/
EUgjDsvGBov/F48CjphiqXqwQH7UOpxMQ1S8gRK5eQF4NmBRuBxQAn/SBQJfNp/F
HpggI4DPeuwQBtBBKrTAixAuRvUR96yv5yJDLCH8PdJdzNXzkaUvf0Nagp8wsEqz
1WBOqkXyr9FJgNL3wJmH2iYAH4wXgCgqBwW2pAI+Z1jYhrNKYPpQ7QwFRZlPVqWV
MwoSdMqc3Icz094+sPwZ7546Crj+SwHVPOy99HhYlJZ3HdaNvoJpcVQOjm9j+Mw8
OtsJ/0QCMOvDe6bbchxTrnXcvtyF0x57/7q1ODtFq+Y/naaM7EHSyOwnMD9oEwUW
10rZBuYhynewUxP8J4URO4ZbCjtPSd/BGbtT18GQVhsjeuMQ2oS+ufqL4LfrKGHu
dVcn2cmWA9qnBqv1zcsREaZfV9NHOCyhSayyxBHNBzzFFSz9DXdk9ZQSFwmQnPu7
5qoTZuQfBb991OD7PcmSyGweRbe5hzH+rWAS4IWvZqIXd2QsEWs0b4SLDzIYJhMC
vqMo/BYIhFCICGGTvYySw/ixYJQ68A/xTrxibY6r+z6nGEMoI6a9to7SfciOnK3R
q3ahjREOrNDfo7oPyqf0MeMIs1WR6Oedt3WPRpknrE7lnkUAzdYZrEkO52fqNTb1
OLSnp4NQFcs=
=H5qi
-----END PGP SIGNATURE-----