PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using standard, database independent Java code. The PGJDBC implementation of the `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to executing additional SQL commands as the application's JDBC user. User applications that do not invoke the `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted if the underlying database that they are querying via their JDBC application may be under the control of an attacker. The attack requires the attacker to trick the user into executing SQL against a table name who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC application that executes as a privileged user querying database schemas owned by potentially malicious less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to craft a schema that causes the application to execute commands as the privileged user. Patched versions will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds for this issue.

The remote Debian 11 host has packages installed that are affected by multiple vulnerabilities as referenced in the dla-3995 advisory.

    - -------------------------------------------------------------------------     Debian LTS Advisory DLA-3995-1                debian-lts@lists.debian.org     https://www.debian.org/lts/security/                          Adrian Bunk     December 16, 2024                             https://wiki.debian.org/LTS
    - -------------------------------------------------------------------------

    Package        : libpgjava     Version        : 42.2.15-1+deb11u2     CVE ID         : CVE-2022-31197 CVE-2022-41946 CVE-2024-1597     Debian Bug     : 1016662

    Multiple vulnerabilities have been fixed in the PostgreSQL JDBC Driver.

    CVE-2022-31197

        SQL Injection in ResultSet.refreshRow()

    CVE-2022-41946

        temporary files can be read by other users

    CVE-2024-1597

        SQL Injection via line comment generation

    For Debian 11 bullseye, these problems have been fixed in version     42.2.15-1+deb11u2.

    We recommend that you upgrade your libpgjava packages.

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

    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

Tenable has extracted the preceding description block directly from the Debian security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 8 host has one or more packages installed that are affected by a vulnerability that has been acknowledged by the vendor but will not be patched.

  - postgresql: SQL Injection in ResultSet.refreshRow() with malicious column names (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied on the package manager's report that the package is installed.

The remote CentOS Linux 9 host has packages installed that are affected by a vulnerability as referenced in the postgresql-jdbc-42.2.18-6.el9 build changelog.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Rocky Linux 9 host has a package installed that is affected by a vulnerability as referenced in the RLSA-2023:0318 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote AlmaLinux 9 host has a package installed that is affected by a vulnerability as referenced in the ALSA-2023:0318 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Oracle Linux 9 host has a package installed that is affected by a vulnerability as referenced in the ELSA-2023-0318 advisory.

    - fix for CVE-2022-31197

    * Tue Aug 10 2021 Mohan Boddu <mboddu@redhat.com>

Tenable has extracted the preceding description block directly from the Oracle Linux security advisory.

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Redhat Enterprise Linux 9 host has a package installed that is affected by a vulnerability as referenced in the RHSA-2023:0318 advisory.

    PostgreSQL is an advanced object-relational database management system. The postgresql-jdbc package     includes the .jar files needed for Java programs to access a PostgreSQL database.

    Security Fix(es):

    * postgresql: SQL Injection in ResultSet.refreshRow() with malicious column names (CVE-2022-31197)

    For more details about the security issue(s), including the impact, a CVSS score, acknowledgments, and     other related information, refer to the CVE page(s) listed in the References section.

Tenable has extracted the preceding description block directly from the Red Hat Enterprise Linux security advisory.

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Fedora 35 host has a package installed that is affected by multiple vulnerabilities as referenced in the FEDORA-2022-cdeabe1bc0 advisory.

    Security fix for CVE-2022-31197.

Tenable has extracted the preceding description block directly from the Fedora security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

The remote Fedora 36 host has a package installed that is affected by multiple vulnerabilities as referenced in the FEDORA-2022-d7d49b2fac advisory.

    Security fix for CVE-2022-31197

Tenable has extracted the preceding description block directly from the Fedora security advisory.

Note that Nessus has not tested for these issues but has instead relied only on the application's self-reported version number.

According to the versions of the postgresql-jdbc package installed, the EulerOS installation on the remote host is affected by the following vulnerabilities :

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Tenable Network Security has extracted the preceding description block directly from the EulerOS security advisory. Tenable has attempted to automatically clean and format it as much as possible without introducing additional issues.

The remote SUSE Linux SLES15 / SLES_SAP15 host has a package installed that is affected by a vulnerability as referenced in the SUSE-SU-2022:3613-1 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote Debian 10 host has packages installed that are affected by a vulnerability as referenced in the dla-3140 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote SUSE Linux SLES12 / SLES_SAP12 host has a package installed that is affected by a vulnerability as referenced in the SUSE-SU-2022:3541-1 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The remote SUSE Linux SLES15 / SLES_SAP15 host has a package installed that is affected by a vulnerability as referenced in the SUSE-SU-2022:3537-1 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

The version of FreeBSD installed on the remote host is prior to tested version. It is, therefore, affected by a vulnerability as referenced in the aeb4c85b-3600-11ed-b52d-589cfc007716 advisory.

  - PostgreSQL JDBC Driver (PgJDBC for short) allows Java programs to connect to a PostgreSQL database using     standard, database independent Java code. The PGJDBC implementation of the     `java.sql.ResultRow.refreshRow()` method is not performing escaping of column names so a malicious column     name that contains a statement terminator, e.g. `;`, could lead to SQL injection. This could lead to     executing additional SQL commands as the application's JDBC user. User applications that do not invoke the     `ResultSet.refreshRow()` method are not impacted. User application that do invoke that method are impacted     if the underlying database that they are querying via their JDBC application may be under the control of     an attacker. The attack requires the attacker to trick the user into executing SQL against a table name     who's column names would contain the malicious SQL and subsequently invoke the `refreshRow()` method on     the ResultSet. Note that the application's JDBC user and the schema owner need not be the same. A JDBC     application that executes as a privileged user querying database schemas owned by potentially malicious     less-privileged users would be vulnerable. In that situation it may be possible for the malicious user to     craft a schema that causes the application to execute commands as the privileged user. Patched versions     will be released as `42.2.26` and `42.4.1`. Users are advised to upgrade. There are no known workarounds     for this issue. (CVE-2022-31197)

Note that Nessus has not tested for this issue but has instead relied only on the application's self-reported version number.

ID	Name	Product	Family	Severity
213039	Debian dla-3995 : libpostgresql-jdbc-java - security update	Nessus	Debian Local Security Checks	critical
198853	RHEL 8 : jdbc-postgresql (Unpatched Vulnerability)	Nessus	Red Hat Local Security Checks	high
191194	CentOS 9 : postgresql-jdbc-42.2.18-6.el9	Nessus	CentOS Local Security Checks	high
184951	Rocky Linux 9 : postgresql-jdbc (RLSA-2023:0318)	Nessus	Rocky Linux Local Security Checks	high
170571	AlmaLinux 9 : postgresql-jdbc (ALSA-2023:0318)	Nessus	Alma Linux Local Security Checks	high
170537	Oracle Linux 9 : postgresql-jdbc (ELSA-2023-0318)	Nessus	Oracle Linux Local Security Checks	high
170407	RHEL 9 : postgresql-jdbc (RHSA-2023:0318)	Nessus	Red Hat Local Security Checks	high
169227	Fedora 35 : postgresql-jdbc (2022-cdeabe1bc0)	Nessus	Fedora Local Security Checks	high
169095	Fedora 36 : postgresql-jdbc (2022-d7d49b2fac)	Nessus	Fedora Local Security Checks	high
168515	EulerOS 2.0 SP8 : postgresql-jdbc (EulerOS-SA-2022-2803)	Nessus	Huawei Local Security Checks	high
166248	SUSE SLES15 Security Update : postgresql-jdbc (SUSE-SU-2022:3613-1)	Nessus	SuSE Local Security Checks	high
165784	Debian DLA-3140-1 : libpgjava - LTS security update	Nessus	Debian Local Security Checks	high
165755	SUSE SLES12 Security Update : postgresql-jdbc (SUSE-SU-2022:3541-1)	Nessus	SuSE Local Security Checks	high
165750	SUSE SLES15 Security Update : postgresql-jdbc (SUSE-SU-2022:3537-1)	Nessus	SuSE Local Security Checks	high
165223	FreeBSD : puppetdb -- Potential SQL injection (aeb4c85b-3600-11ed-b52d-589cfc007716)	Nessus	FreeBSD Local Security Checks	high

Detections

Analytics

CVE-2022-31197

high

Tenable Plugins

critical

high

high

high

high

high

high

high

high

high

high

high

high

high

high