SQL injection in SQLAlchemy - CVE-2019-7548

Vulnerability details

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data passed via the "group_by" parameter. A remote attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Successful exploitation of this vulnerability may allow a remote attacker to read, delete, modify data in database and gain complete control over the affected application.

Affected software

How to mitigate CVE-2019-7548

External References

• https://github.com/no-security/sqlalchemy_test
• https://github.com/sqlalchemy/sqlalchemy/issues/4481#issuecomment-461204518

Related Security Bulletins

• OpenSUSE Linux update for python-SQLAlchemy
• OpenSUSE Linux update for python-SQLAlchemy
• OpenSUSE Linux update for python-SQLAlchemy
• Red Hat update for python36:3.6
• Red Hat update for python27:2.7
• openEuler 20.03 LTS SP1 update for python-sqlalchemy