SQLi (SQL Injection) org.postgresql:postgresql Dependency in Confluence Data Center and Server

This Critical severity org.postgresql:postgresql Dependency vulnerability was introduced in versions 6.0.1 of Confluence Data Center and Server. Confluence Data Center is unaffected by this vulnerability as it does not use the {{PreferQueryMode=SIMPLE}} parameter required for this vulnerability in it’s SQL database connection settings. Whilst the default configuration is safe, the vulnerability remains in the driver that ships with Confluence.

This org.postgresql:postgresql Dependency vulnerability, with a CVSS Score of 9.8 and a CVSS Vector of CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H allows an unauthenticated attacker to expose assets in your environment susceptible to exploitation which has high impact to confidentiality, high impact to integrity, high impact to availability, and requires no user interaction.
h2. Data Center

Atlassian recommends that Confluence Data Center customers upgrade to the latest version. If you are unable to do so, upgrade your instance to one of the specified supported fixed versions:
||Affected versions||Fixed versions||
|8.9.0|8.9.1|
|from 8.8.0 to 8.8.1|8.9.1|
|from 8.7.0 to 8.7.2|8.9.1|
|from 8.6.0 to 8.6.2|8.9.1|
|from 8.5.0 to 8.5.7 LTS|8.9.1 or 8.5.9 LTS recommended|
|from 8.4.0 to 8.4.5|8.9.1 or 8.5.9 LTS recommended|
|from 8.3.0 to 8.3.4|8.9.1 or 8.5.9 LTS recommended|
|from 8.2.0 to 8.2.3|8.9.1 or 8.5.9 LTS recommended|
|from 8.1.0 to 8.1.4|8.9.1 or 8.5.9 LTS recommended|
|from 8.0.0 to 8.0.4|8.9.1 or 8.5.9 LTS recommended|
|from 7.20.0 to 7.20.3|8.9.1 or 8.5.9 LTS recommended|
|from 7.19.0 to 7.19.21 LTS|8.9.1 or 8.5.9 LTS recommended or 7.19.22 LTS|
|from 7.18.0 to 7.18.3|8.9.1 or 8.5.9 LTS recommended or 7.19.22 LTS|
|from 7.17.0 to 7.17.5|8.9.1 or 8.5.9 LTS recommended or 7.19.22 LTS|
|Any earlier versions|8.9.1 or 8.5.9 LTS recommended or 7.19.22 LTS|

h2. Server

Atlassian recommends that Confluence Server customers upgrade to the latest version. If you are unable to do so, upgrade your instance to one of the specified supported fixed versions:
||Affected versions||Fixed versions||
|from 8.5.0 to 8.5.8 LTS|8.5.9 LTS recommended|
|from 8.4.0 to 8.4.5|8.5.9 LTS recommended|
|from 8.3.0 to 8.3.4|8.5.9 LTS recommended|
|from 8.2.0 to 8.2.3|8.5.9 LTS recommended|
|from 8.1.0 to 8.1.4|8.5.9 LTS recommended|
|from 8.0.0 to 8.0.4|8.5.9 LTS recommended|
|from 7.20.0 to 7.20.3|8.5.9 LTS recommended|
|from 7.19.0 to 7.19.21 LTS|8.5.9 LTS recommended or 7.19.22 LTS|
|from 7.18.0 to 7.18.3|8.5.9 LTS recommended or 7.19.22 LTS|
|from 7.17.0 to 7.17.5|8.5.9 LTS recommended or 7.19.22 LTS|
|Any earlier versions|8.5.9 LTS recommended or 7.19.22 LTS|
h2.

See the release notes ([https://confluence.atlassian.com/doc/confluence-release-notes-327.html]). You can download the latest version of Confluence Data Center and Server from the download center ([https://www.atlassian.com/software/confluence/download-archives]).

The National Vulnerability Database provides the following description for this vulnerability: pgjdbc, the PostgreSQL JDBC Driver, allows attacker to inject SQL if using PreferQueryMode=SIMPLE. Note this is not the default. In the default mode there is no vulnerability. A placeholder for a numeric value must be immediately preceded by a minus. There must be a second placeholder for a string value after the first placeholder; both must be on the same line. By constructing a matching string payload, the attacker can inject SQL to alter the query,bypassing the protections that parameterized queries bring against SQL Injection attacks. Versions before 42.7.2, 42.6.1, 42.5.5, 42.4.4, 42.3.9, and 42.2.28 are affected.