GSD-2023-22626

Vulnerability from gsd - Updated: 2023-01-04 00:00
Details
A malicious PgHero user can use the EXPLAIN functionality to extract data from the database. With certain inputs, a user can get the results of a query to appear in an error message. If the PgHero database user has superuser privileges (not recommended), the user can use file access functions to read files on the database server.
Aliases
Aliases
CVE-2023-22626
To clipboard 

{
  "GSD": {
    "alias": "CVE-2023-22626",
    "id": "GSD-2023-22626"
  },
  "gsd": {
    "metadata": {
      "exploitCode": "unknown",
      "remediation": "unknown",
      "reportConfidence": "confirmed",
      "type": "vulnerability"
    },
    "osvSchema": {
      "affected": [
        {
          "package": {
            "ecosystem": "RubyGems",
            "name": "pghero",
            "purl": "pkg:gem/pghero"
          }
        }
      ],
      "aliases": [
        "CVE-2023-22626",
        "GHSA-vf99-xw26-86g5"
      ],
      "details": "A malicious PgHero user can use the EXPLAIN functionality to extract data from\nthe database. With certain inputs, a user can get the results of a query to\nappear in an error message. If the PgHero database user has superuser privileges\n(not recommended), the user can use file access functions to read files on the\ndatabase server.\n",
      "id": "GSD-2023-22626",
      "modified": "2023-01-04T00:00:00.000Z",
      "published": "2023-01-04T00:00:00.000Z",
      "references": [
        {
          "type": "WEB",
          "url": "https://github.com/ankane/pghero/issues/439"
        }
      ],
      "schema_version": "1.4.0",
      "severity": [
        {
          "score": 7.5,
          "type": "CVSS_V3"
        }
      ],
      "summary": "Information Disclosure Through EXPLAIN Feature"
    }
  },
  "namespaces": {
    "cve.org": {
      "CVE_data_meta": {
        "ASSIGNER": "cve@mitre.org",
        "ID": "CVE-2023-22626",
        "STATE": "PUBLIC"
      },
      "affects": {
        "vendor": {
          "vendor_data": [
            {
              "product": {
                "product_data": [
                  {
                    "product_name": "n/a",
                    "version": {
                      "version_data": [
                        {
                          "version_value": "n/a"
                        }
                      ]
                    }
                  }
                ]
              },
              "vendor_name": "n/a"
            }
          ]
        }
      },
      "data_format": "MITRE",
      "data_type": "CVE",
      "data_version": "4.0",
      "description": {
        "description_data": [
          {
            "lang": "eng",
            "value": "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.)"
          }
        ]
      },
      "problemtype": {
        "problemtype_data": [
          {
            "description": [
              {
                "lang": "eng",
                "value": "n/a"
              }
            ]
          }
        ]
      },
      "references": {
        "reference_data": [
          {
            "name": "https://github.com/ankane/pghero/issues/439",
            "refsource": "CONFIRM",
            "url": "https://github.com/ankane/pghero/issues/439"
          }
        ]
      }
    },
    "github.com/rubysec/ruby-advisory-db": {
      "cve": "2023-22626",
      "cvss_v3": 7.5,
      "date": "2023-01-04",
      "description": "A malicious PgHero user can use the EXPLAIN functionality to extract data from\nthe database. With certain inputs, a user can get the results of a query to\nappear in an error message. If the PgHero database user has superuser privileges\n(not recommended), the user can use file access functions to read files on the\ndatabase server.\n",
      "gem": "pghero",
      "ghsa": "vf99-xw26-86g5",
      "patched_versions": [
        "\u003e= 3.1.0"
      ],
      "title": "Information Disclosure Through EXPLAIN Feature",
      "url": "https://github.com/ankane/pghero/issues/439"
    },
    "gitlab.com": {
      "advisories": [
        {
          "affected_range": "\u003e=0.1.1 \u003c3.1.0",
          "affected_versions": "All versions starting from 0.1.1 before 3.1.0",
          "cvss_v3": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N",
          "cwe_ids": [
            "CWE-1035",
            "CWE-209",
            "CWE-937"
          ],
          "date": "2023-01-11",
          "description": "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.)",
          "fixed_versions": [
            "3.1.0"
          ],
          "identifier": "CVE-2023-22626",
          "identifiers": [
            "CVE-2023-22626",
            "GHSA-vf99-xw26-86g5"
          ],
          "not_impacted": "All versions before 0.1.1, all versions starting from 3.1.0",
          "package_slug": "gem/pghero",
          "pubdate": "2023-01-05",
          "solution": "Upgrade to version 3.1.0 or above.",
          "title": "PgHero Allows Information Disclosure Through EXPLAIN Feature",
          "urls": [
            "https://nvd.nist.gov/vuln/detail/CVE-2023-22626",
            "https://github.com/ankane/pghero/issues/439",
            "https://github.com/rubysec/ruby-advisory-db/blob/master/gems/pghero/CVE-2023-22626.yml",
            "https://github.com/advisories/GHSA-vf99-xw26-86g5"
          ],
          "uuid": "3b0c07b4-9e8f-4c95-90d8-86a3f2306c67"
        }
      ]
    },
    "nvd.nist.gov": {
      "configurations": {
        "CVE_data_version": "4.0",
        "nodes": [
          {
            "children": [],
            "cpe_match": [
              {
                "cpe23Uri": "cpe:2.3:a:pghero_project:pghero:*:*:*:*:*:ruby:*:*",
                "cpe_name": [],
                "versionEndExcluding": "3.1.0",
                "versionStartIncluding": "0.1.1",
                "vulnerable": true
              }
            ],
            "operator": "OR"
          }
        ]
      },
      "cve": {
        "CVE_data_meta": {
          "ASSIGNER": "cve@mitre.org",
          "ID": "CVE-2023-22626"
        },
        "data_format": "MITRE",
        "data_type": "CVE",
        "data_version": "4.0",
        "description": {
          "description_data": [
            {
              "lang": "en",
              "value": "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.)"
            }
          ]
        },
        "problemtype": {
          "problemtype_data": [
            {
              "description": [
                {
                  "lang": "en",
                  "value": "CWE-209"
                }
              ]
            }
          ]
        },
        "references": {
          "reference_data": [
            {
              "name": "https://github.com/ankane/pghero/issues/439",
              "refsource": "CONFIRM",
              "tags": [
                "Exploit",
                "Third Party Advisory"
              ],
              "url": "https://github.com/ankane/pghero/issues/439"
            }
          ]
        }
      },
      "impact": {
        "baseMetricV3": {
          "cvssV3": {
            "attackComplexity": "LOW",
            "attackVector": "NETWORK",
            "availabilityImpact": "NONE",
            "baseScore": 7.5,
            "baseSeverity": "HIGH",
            "confidentialityImpact": "HIGH",
            "integrityImpact": "NONE",
            "privilegesRequired": "NONE",
            "scope": "UNCHANGED",
            "userInteraction": "NONE",
            "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N",
            "version": "3.1"
          },
          "exploitabilityScore": 3.9,
          "impactScore": 3.6
        }
      },
      "lastModifiedDate": "2023-01-11T18:00Z",
      "publishedDate": "2023-01-05T08:15Z"
    }
  }
}


Log in or create an account to share your comment.




Tags
Taxonomy of the tags.




Sightings

Author Source Type Date

Nomenclature

  • Seen: The vulnerability was mentioned, discussed, or observed by the user.
  • Confirmed: The vulnerability has been validated from an analyst's perspective.
  • Published Proof of Concept: A public proof of concept is available for this vulnerability.
  • Exploited: The vulnerability was observed as exploited by the user who reported the sighting.
  • Patched: The vulnerability was observed as successfully patched by the user who reported the sighting.
  • Not exploited: The vulnerability was not observed as exploited by the user who reported the sighting.
  • Not confirmed: The user expressed doubt about the validity of the vulnerability.
  • Not patched: The vulnerability was not observed as successfully patched by the user who reported the sighting.



Detection rules are retrieved from Rulezet.