Homer: Authenticated SQL Injection via Unvalidated rawquery Field in /api/v4/statistics/query

{
  "id": "79d633ebf66a9cea16dd4b13f305b3f96980b3e2c395eb1affd11239cea38e0b",
  "url": "https://osv.dev/vulnerability/GHSA-f46q-3v67-fmm4",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "Homer: Authenticated SQL Injection via Unvalidated rawquery Field in /api/v4/statistics/query",
    "summary": "### Summary The `V4StatisticsQuery` handler passes the user-supplied `rawquery` field directly to DuckDB without calling the `sqlvalidator.ValidateRawSQL` function used throughout the rest of the codebase. Any authenticated user can execute arbitrary SQL statements against all data accessible through the FlightSQL service. ### Details **`coordinator/handlers/statistics_v4.go` lines 74-107** — `V4StatisticsQuery`: ```go query := &model.V4StatisticsQuery{} if err = c.Bind(query); err != nil { ... } // No ValidateRawSQL call here — contrast with other handlers: results, err := h.flightService.Query(c.Request().Context(), query.RawQuery) ``` **Contrast with `coordinator/handlers/search.go` line 194** — secure pattern not followed: ```go if err := sqlvalidator.ValidateRawSQL(rawQuery); err != nil { return c.JSON(http.StatusBadRequest, ...) } ``` `query.RawQuery` is whatever the caller submitted; it is passed verbatim to the FlightSQL/DuckDB backend. The handler is registered under the `protected` group (requires JWT), but given that the default JWT secret is empty (see related advisory), this is effectively pre-authentication on a default deployment. ### PoC ```bash # With a valid JWT (or empty JWT secret bypass): curl -s -X POST http:///api/v4/statistics/query \\ -H \"Authorization: Bearer \" \\ -H \"Content-Type: application/json\" \\ -d '{ \"param\": { \"query\": [{\"rawquery\": \"SELECT * FROM information_schema.tables\"}] } }' # Returns all table names accessible to the DuckDB FlightSQL ser",
    "evidence": "osv:GHSA-f46q-3v67-fmm4",
    "products": [
      {
        "name": {
          "value": "github.com/sipcapture/homer-app",
          "evidence": "/affected/0/package/name"
        },
        "prerequisites": [],
        "fixed_versions": [
          {
            "value": "0.0.0-20260625085520-a7d027dc684b",
            "evidence": "/affected/0/ranges"
          }
        ],
        "affected_versions": []
      }
    ],
    "severity": "high",
    "structured": {
      "id": "GHSA-f46q-3v67-fmm4",
      "aliases": [
        "CVE-2026-62251",
        "GHSA-f46q-3v67-fmm4",
        "GO-2026-6672"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "type": "SEMVER",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "fixed": "0.0.0-20260625085520-a7d027dc684b"
                }
              ]
            }
          ],
          "package": {
            "name": "github.com/sipcapture/homer-app",
            "purl": "pkg:golang/github.com/sipcapture/homer-app",
            "ecosystem": "Go"
          },
          "database_specific": {
            "source": "https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2026/10/GHSA-f46q-3v67-fmm4/GHSA-f46q-3v67-fmm4.json"
          }
        }
      ],
      "modified": "2026-10-20T00:56:06.107700572Z",
      "provider": "osv",
      "references": [
        "https://github.com/sipcapture/homer/security/advisories/GHSA-f46q-3v67-fmm4",
        "https://github.com/sipcapture/homer/pull/837",
        "https://github.com/sipcapture/homer/commit/a7d027dc684b210b62285c49f555ac88d64f35f0",
        "https://github.com/sipcapture/homer",
        "https://github.com/sipcapture/homer/releases/tag/11.0.283"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "severity": "HIGH",
        "github_reviewed": true,
        "nvd_published_at": null,
        "github_reviewed_at": "2026-10-07T16:13:08Z"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-62251",
        "evidence": "/aliases"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/database_specific/severity"
  },
  "source_id": "core-osv",
  "document_id": 376884,
  "published_at": "2026-10-07T16:13:08+00:00"
}