GHSA-7g5f-wrx8-5ccf

Suggest an improvement
Source
https://github.com/advisories/GHSA-7g5f-wrx8-5ccf
Import Source
https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2023/02/GHSA-7g5f-wrx8-5ccf/GHSA-7g5f-wrx8-5ccf.json
JSON Data
https://api.osv.dev/v1/vulns/GHSA-7g5f-wrx8-5ccf
Aliases
Published
2023-02-22T19:15:56Z
Modified
2023-11-08T04:11:50.579861Z
Severity
  • 9.8 (Critical) CVSS_V3 - CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H CVSS Calculator
Summary
GeoServer OGC Filter SQL Injection Vulnerabilities
Details

Impact

GeoServer includes support for the OGC Filter expression language and the OGC Common Query Language (CQL) as part of the Web Feature Service (WFS) and Web Map Service (WMS) protocols. CQL is also supported through the Web Coverage Service (WCS) protocol for ImageMosaic coverages.

SQL Injection Vulnerabilities have been found with:

  • PropertyIsLike filter, when used with a String field and any database DataStore, or with a PostGIS DataStore with encode functions enabled
  • strEndsWith function, when used with a PostGIS DataStore with encode functions enabled
  • strStartsWith function, when used with a PostGIS DataStore with encode functions enabled
  • FeatureId filter, when used with any database table having a String primary key column and when prepared statements are disabled
  • jsonArrayContains function, when used with a String or JSON field and with a PostGIS or Oracle DataStore (GeoServer 2.22.0+ only)
  • DWithin filter, when used with an Oracle DataStore

Patches

  • GeoSever 2.21.4
  • GeoServer 2.22.2
  • GeoServer 2.20.7
  • GeoServer 2.19.7
  • GeoServer 2.18.7

Workarounds

  1. Disabling the PostGIS Datastore encode functions setting to mitigate strEndsWith, strStartsWith vulnerabilities (Like filters have no mitigation, if there is a string field in the feature type published).
  2. Enabling the PostGIS DataStore preparedStatements setting to mitigate the FeatureId vulnerability.

References

Database specific 
{
    "github_reviewed": true,
    "severity": "CRITICAL",
    "cwe_ids": [
        "CWE-89"
    ],
    "nvd_published_at": "2023-02-21T22:15:00Z",
    "github_reviewed_at": "2023-02-22T19:15:56Z"
}
References

Affected packages

Maven / org.geoserver.community:gs-jdbcconfig

Package

Name
org.geoserver.community:gs-jdbcconfig
View open source insights on deps.dev
Purl
pkg:maven/org.geoserver.community/gs-jdbcconfig

Affected ranges

Type
ECOSYSTEM
Events
Introduced
0Unknown introduced version / All previous versions are affected
Fixed
2.21.4

Maven / org.geoserver.community:gs-jdbcconfig

Package

Name
org.geoserver.community:gs-jdbcconfig
View open source insights on deps.dev
Purl
pkg:maven/org.geoserver.community/gs-jdbcconfig

Affected ranges

Type
ECOSYSTEM
Events
Introduced
2.22.0
Fixed
2.22.2