Advisory

GHSA-j259-6c58-9m58

Also known as: CVE-2022-35942

Summary

loopback-connector-postgresql Vulnerable to Improper Sanitization of contains Filter

Details

Improper input validation on the contains LoopBack filter may allow for arbitrary SQL injection.

Impact

When the extended filter property contains is permitted to be interpreted by the Postgres connector, it is possible to inject arbitrary SQL which may affect the confidentiality and integrity of data stored on the connected database.

This affects users who does any of the following:

  • Connect to the database via the DataSource with allowExtendedProperties: true setting OR
  • Uses the connector's CRUD methods directly OR
  • Uses the connector's other methods to interpret the LoopBack filter.

Patches

Patch release [email protected] has been published of which resolves this issue.

Workarounds

Users who are unable to upgrade should do the following if applicable:

  • Remove allowExtendedProperties: true DataSource setting
  • Add allowExtendedProperties: false DataSource setting
  • When passing directly to the connector functions, manually sanitize the user input for the contains LoopBack filter beforehand.

Severity

Critical Basis: The source's own band: CRITICAL

Dates

Published
2022-08-11 21:13 UTC
Modified
2023-11-08 04:09 UTC

Affected packages and fixes

loopback-connector-postgresql

npm · All systems

Affected

  • introduced 0, fixed 5.5.1 (semver)

Fixed versions

5.5.1

Fix

Fix commands are the export's own generic commands. Ojuju never runs them. Check them against your setup first.

Check your own computer: guard packages check

View this record on OSV.dev

Source

Source: GitHub Advisory Database (reviewed advisories) · CC BY 4.0

Sources & licences