CVE-2023-22626: Pghero PgHero Allows Information Disclosure Through Vulnerability

HIGH
Advisory Identifier: GHSA-vf99-xw26-86g5
Share
CVSS 7.5
CWE-209
Published
Advisory Summary

CVE-2023-22626 is a HIGH (CVSS 7.5) pghero allows information disclosure through vulnerability (CWE-209: Generation of Error Message Containing Sensitive Information) affecting Pghero libraries in the RubyGems ecosystem. The issue involves pghero allows information disclosure through explain feature. Remediation is available by upgrading affected packages to version 3.1.0.

CVE-2023-22626 at a Glance

CVE Identifier CVE-2023-22626
GHSA Identifier GHSA-vf99-xw26-86g5
Severity HIGH
CVSS v3.1 Base Score 7.5
CWE Classification CWE-209: Generation of Error Message Containing Sensitive Information
Affected Product Pghero
Package Ecosystem RubyGems
Published Date
Last Updated

Security Impact

CVSS: 7.5

The security impact metrics below are parsed directly from the CVSS v3.1 vector string (CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N).

Attack Vector Network (AV:N)
Attack Complexity Low (AC:L)
Privileges Required None (PR:N)
User Interaction None (UI:N)
Scope Unchanged (S:U)
Confidentiality High (C:H)
Integrity None (I:N)
Availability None (A:N)

How to Fix CVE-2023-22626

To remediate this vulnerability, upgrade all affected Pghero dependencies to a patched release. Both direct and transitive dependencies should be checked, as frameworks or security libraries may pull in vulnerable versions transitively.

pghero fixed: 3.1.0 
Upgrade pghero to 3.1.0
Verify Direct and Transitive Dependencies

Run the following command in your project directory to verify that all resolved dependencies use the patched release: 

inspect dependencies for pghero

How to Check if You Are Affected

To determine whether your application is affected by CVE-2023-22626, inspect your project dependencies for Pghero:

inspect dependencies for pghero

Analyze the terminal output to locate any version of Pghero in your dependency tree. If any resolved version matches the vulnerable ranges listed in the table below (for example, versions earlier than 3.1.0), your application is affected.

Note: Verify declared build manifests and deployed runtime container environments.

Technical Details

Vulnerability Mechanism & Technical Analysis

This vulnerability is classified under CWE-209: Generation of Error Message Containing Sensitive Information, where the product generates an error message that includes sensitive information about its environment, users, or associated data. In Pghero, software state validation or input boundaries are circumvented during processing. Review the official source advisory statement below for specific affected components, classes, and reproduction details.

Source Advisory Statement

PgHero before 3.1.0 allows Information Disclosure via EXPLAIN because query results may be present in an error message. (Depending on database user privileges, this may only be information from the database, or may be information from file contents on the database server.)

CVE-2023-22626 Affected Pghero Versions

1 component(s)
Fixed Versions:
3.1.0
Product / Package Ecosystem Affected Versions Fixed Version
pghero
gem/pghero
RubyGems
< 3.1.0
3.1.0

References

NVD — CVE-2023-22626 NVD
https://nvd.nist.gov/vuln/detail/CVE-2023-22626
Pghero Source Repository REPOSITORY
https://github.com/ankane/pghero/issues/439
Pghero Source Repository REPOSITORY
https://github.com/ankane/pghero
Pghero Source Repository REPOSITORY
https://github.com/rubysec/ruby-advisory-db/blob/master/gems/pghero/CVE-2023-22626.yml

Frequently Asked Questions

What is CVE-2023-22626?
CVE-2023-22626 is a security vulnerability in Pghero involving PgHero Allows Information Disclosure Through EXPLAIN Feature under CWE-209: Generation of Error Message Containing Sensitive Information.
Which Pghero versions are affected?
Affected versions include releases prior to 3.1.0 across affected packages: pghero.
What version fixes CVE-2023-22626?
Upgrading to 3.1.0 (or the latest patched release for your respective branch) resolves the vulnerability.
Is pghero affected?
Yes, pghero is affected in releases prior to 3.1.0. Upgrade your dependency to 3.1.0 or later.
What is the CVSS score of CVE-2023-22626?
CVE-2023-22626 has a CVSS v3.1 base score of 7.5 (HIGH) with vector string CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N.
What CWE is associated with CVE-2023-22626?
CVE-2023-22626 is classified under CWE-209: Generation of Error Message Containing Sensitive Information (The product generates an error message that includes sensitive information about its environment, users, or associated data.).
How can I check RubyGems dependencies for CVE-2023-22626?
Run the dependency tree command: 'inspect dependencies for pghero'. This command lists direct and transitive dependencies in your build configuration so you can verify if a vulnerable version is resolved.
Machine-readable OSV JSON OSV v1.5 Schema
Normalized schema output
View Raw JSON 
{
  "schema_version" : "1.4.0",
  "id" : "GHSA-vf99-xw26-86g5",
  "modified" : "2023-01-11T20:54:21Z",
  "published" : "2023-01-05T09:30:28Z",
  "aliases" : [ "CVE-2023-22626" ],
  "summary" : "PgHero Allows Information Disclosure Through EXPLAIN Feature",
  "details" : "PgHero before 3.1.0 allows Information Disclosure via EXPLAIN because query results may be present in an error message. (Depending on database user privileges, this may only be information from the database, or may be information from file contents on the database server.)",
  "severity" : [ {
    "type" : "CVSS_V3",
    "score" : "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N"
  } ],
  "affected" : [ {
    "package" : {
      "ecosystem" : "RubyGems",
      "name" : "pghero"
    },
    "ranges" : [ {
      "type" : "ECOSYSTEM",
      "events" : [ {
        "introduced" : "0"
      }, {
        "fixed" : "3.1.0"
      } ]
    } ]
  } ],
  "references" : [ {
    "type" : "ADVISORY",
    "url" : "https://nvd.nist.gov/vuln/detail/CVE-2023-22626"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/ankane/pghero/issues/439"
  }, {
    "type" : "PACKAGE",
    "url" : "https://github.com/ankane/pghero"
  }, {
    "type" : "WEB",
    "url" : "https://github.com/rubysec/ruby-advisory-db/blob/master/gems/pghero/CVE-2023-22626.yml"
  } ],
  "database_specific" : {
    "cwe_ids" : [ "CWE-209" ],
    "severity" : "HIGH",
    "github_reviewed" : true,
    "github_reviewed_at" : "2023-01-09T20:03:14Z",
    "nvd_published_at" : "2023-01-05T08:15:00Z"
  }
}