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

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

                               ESB-2021.3703
                        sqlalchemy security update
                              8 November 2021

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

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

Product:           sqlalchemy
Publisher:         Debian
Operating System:  Debian GNU/Linux
Impact/Access:     Execute Arbitrary Code/Commands -- Remote/Unauthenticated
Resolution:        Patch/Upgrade
CVE Names:         CVE-2019-7548 CVE-2019-7164 

Reference:         ESB-2019.3455
                   ESB-2019.1598
                   ESB-2019.0866

Original Bulletin: 
   http://www.debian.org/lts/security/2021/dla-2811

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

- -------------------------------------------------------------------------
Debian LTS Advisory DLA-2811-1                debian-lts@lists.debian.org
https://www.debian.org/lts/security/                      Markus Koschany
November 06, 2021                             https://wiki.debian.org/LTS
- -------------------------------------------------------------------------

Package        : sqlalchemy
Version        : 1.0.15+ds1-1+deb9u1
CVE ID         : CVE-2019-7164 CVE-2019-7548
Debian Bug     : 922669

Two SQL injection vulnerabilities were discovered in SQLAlchemy, a SQL
toolkit and Object Relational Mapper for Python, when the order_by or
group_by parameters can be controlled by an attacker.

Warning: The text coercion feature of SQLAlchemy is rarely used but the
warning that has been previously emitted is now an ArgumentError or in case
of the order_by() and group_by() parameters a CompileError.

For Debian 9 stretch, these problems have been fixed in version
1.0.15+ds1-1+deb9u1.

We recommend that you upgrade your sqlalchemy packages.

For the detailed security status of sqlalchemy please refer to
its security tracker page at:
https://security-tracker.debian.org/tracker/sqlalchemy

Further information about Debian LTS security advisories, how to apply
these updates to your system and frequently asked questions can be
found at: https://wiki.debian.org/LTS

- -----BEGIN PGP SIGNATURE-----

iQKTBAABCgB9FiEErPPQiO8y7e9qGoNf2a0UuVE7UeQFAmGHAUhfFIAAAAAALgAo
aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldEFD
RjNEMDg4RUYzMkVERUY2QTFBODM1RkQ5QUQxNEI5NTEzQjUxRTQACgkQ2a0UuVE7
UeRbsxAAxYV44CT7iY7XVWiqpVKeiESXQmJIg9EN8O8PZ7WKRZwmHM3CxuMqtBTD
O/Du72vBEiUXdbKdDp9c+UFmBmjPu5Pvy+z2KXHZseYdshBeTEjX+JG/q381pN9Z
hhSlYQLDx56+HgGc07Mebe2ViJ3jB+nRC9jiZIkoQsU4W8mLbpgLDjVfJM6ihHOc
mIAjxT3ZfyaqfL6+J69T9lfainVh8nFZLppLfipVVAC7Tito8NGQ3rWxLuPVi/Y3
v548niW2ZtaBc8OY0MB5hdOT+GyL/YquVradnT/TlaPI9j8TRM3A90PsTnm7jn1v
fr1GopmOXd9yKkKsx9XSjQjfwlHFej0HJ8t1moDfqy/+v3ZlGK4paFbynlTM0dTI
q7IuKKJh7MJ+l43CzeTR6XaND8nnipijCGHegPZe/ly6mNv/YjebNJpfTc67gdKA
19+C+tqdEVYkHB9E6HfGSKmTF2JYseN4eawkXpFp4J83MoqRzUV5eD+y0tADIf5h
IImhSvotp6FcRZoEoDr6n6427gwCCSx4znLz4qdlWpmsn/79hNrgqSpQ3rEVGcTR
j7KRkgKwh3wvDXbgvhlLXinl4V2ifPpzAqK1QHtfIZBEF+O7DUSWzRrSMCeMEMBq
5uC5rm+WZyJ/gblKDlLw4rECgAWE68rCsFyVu94rPiOqOEK4RS8=
=mED+
- -----END PGP SIGNATURE-----

- --------------------------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

iQIVAwUBYYhkPeNLKJtyKPYoAQj2iA/8CcZHqrxGcOTqX0fGHAGSqKjppO/mtTn8
GeSFAJ36ljN46+wM9BhXe4TornlpZqg/HsdnTEFF3zMW7nWkAfl1eKOLGVaWrH4b
ufw1osdlZ/qZzbGK9WY9cO3GiwkBTQih0TPV5paZRl2BvUhLccplnHUNhGObO0u2
Q8wAgVdbdmGMxILlzgGdiMBjdla0b1l8D0ceHux/uD6JKOL8VY78bVTFwBrYS9yx
4gm+WyuMjoLhw5/+D5hpSQiyBbcibXZH4HuBAu13Bg8YtnNTyi1Xi2w7vHsgBnhA
OwWJrMX2c8z5K7Dweo9zyvkm/XtlwvwHVIHABBYNxsAjW8A/u24YD3Y60lZEuM/k
CXH5CYtUfKUaV36qUdptM8esRvlV5GazU6gG5V5QtZZlb3y586HQLn6Po6rEKnpx
Kb1HN8Mjm/tu163ru1cHZBDwmpcw8b177VTGu03rUW25sUvHJH/9zEkuYxG6Nzze
jJDLHK/ov6J2I7gHPOdY5z4Fq5tbHCEYsyJffLFfXAoIprqRIdlAUxCR1fBfPHyD
bmH/MnRsyugZhlOP5Oh64rKG44k/WGd/I+ehiDH7WH2m5FIeTild7JFmO/ab9w83
OA5sBYdneAM5UTT44HbpbgMp3OBsk16CFGdNskQrsiiyYThefaAabxF2z4lVuGrL
l4/lKRupoUU=
=U9OM
-----END PGP SIGNATURE-----