GHSA-vf2r-cxg9-p7rf — The ADOdb sqlite3 driver allows SQL injection

The ADOdb sqlite3 driver allows SQL injection

The advisory, in context

Improper escaping of a query parameter may allow an attacker to execute arbitrary SQL statements when the code using ADOdb connects to a sqlite3 database and calls the metaColumns(), metaForeignKeys() or metaIndexes() methods with a crafted table name.

Note that the indicated Severity corresponds to a worst-case usage scenario, e.g. allowing user-supplied data to be sent as-is to the above-mentioned methods.

Impact

SQLite3 driver.

Patches

Vulnerability is fixed in ADOdb 5.22.10 (https://github.com/ADOdb/ADOdb/commit/5b8bd52cdcffefb4ecded1b399c98cfa516afe03).

Workarounds

Only pass controlled data to metaColumns(), metaForeignKeys() and metaIndexes() method's $table parameter.

Credits

Thanks to Marco Nappi (@mrcnpp) for reporting this vulnerability.

Affected packages

Start with the recorded fix for your release branch. Check your installed version and test compatibility before upgrading. Fixing this advisory does not rule out other vulnerabilities in the release.

adodb/adodb-php Packagist

Ecosystem versions

Earlier releases before 5.22.10

Fixed in 5.22.10

40 explicitly affected versions

v5.19, v5.20.0, v5.20.1, v5.20.10, v5.20.11, v5.20.12, v5.20.13, v5.20.14, v5.20.15, v5.20.16, v5.20.17, v5.20.18, v5.20.19, v5.20.2, v5.20.20, v5.20.21, v5.20.3, v5.20.4, v5.20.5, v5.20.6, v5.20.7, v5.20.8, v5.20.9, v5.21.0, v5.21.0-beta.1, v5.21.0-rc.1, v5.21.1, v5.21.2, v5.21.3, v5.21.4, v5.22.0, v5.22.1, v5.22.2, v5.22.3, v5.22.4, v5.22.5, v5.22.6, v5.22.7, v5.22.8, v5.22.9

View affected-version evidence

{
  "ranges": [
    {
      "events": [
        {
          "introduced": "0"
        },
        {
          "fixed": "5.22.10"
        }
      ],
      "type": "ECOSYSTEM"
    }
  ],
  "versions": [
    "v5.19",
    "v5.20.0",
    "v5.20.1",
    "v5.20.10",
    "v5.20.11",
    "v5.20.12",
    "v5.20.13",
    "v5.20.14",
    "v5.20.15",
    "v5.20.16",
    "v5.20.17",
    "v5.20.18",
    "v5.20.19",
    "v5.20.2",
    "v5.20.20",
    "v5.20.21",
    "v5.20.3",
    "v5.20.4",
    "v5.20.5",
    "v5.20.6",
    "v5.20.7",
    "v5.20.8",
    "v5.20.9",
    "v5.21.0",
    "v5.21.0-beta.1",
    "v5.21.0-rc.1",
    "v5.21.1",
    "v5.21.2",
    "v5.21.3",
    "v5.21.4",
    "v5.22.0",
    "v5.22.1",
    "v5.22.2",
    "v5.22.3",
    "v5.22.4",
    "v5.22.5",
    "v5.22.6",
    "v5.22.7",
    "v5.22.8",
    "v5.22.9"
  ]
}

Set up in your agent.

Investigate in your agent.