# Authenticated (user role) SQL injection in \`OrderAndPaginate\` (GHSL-2023-270)

Advisory record · `GHSA-h374-mm57-879c`

- **Identifiers:** `GHSA-h374-mm57-879c` · `CVE-2024-22196` · `GO-2024-2463`
- **State:** Confirmed
- **Severity:** CVSS 7.0 High
- **Critical:** No
- **Weakness (CWE):** [CWE-89](https://cwe.mitre.org/data/definitions/89.html)
- **Tags:** [SQL injection](https://agentprime.io/advisories/tag/sql-injection.md)
- **Published:** 11 Jan 2024
- **Updated:** 6 Jul 2026
- **Reviewed by a person:** No

Published by the GitHub Advisory Database at 11 Jan 2024, 16:27 UTC. agentprime has not analysed this yet, so whether it affects any app is not known.

## Affected packages

- `github.com/0xJacky/Nginx-UI` (Go): affected `<1.9.10-0.20231219195202-ec93ab05a3ec`; fixed in `1.9.10-0.20231219195202-ec93ab05a3ec`

## Machine-written summary

Summary written by Claude Haiku from the source advisory. Not reviewed by a person.

> GHSA-h374-mm57-879c: Nginx-UI (Go module github.com/0xJacky/Nginx-UI) versions before 1.9.10-0.20231219195202-ec93ab05a3ec are affected by an SQL injection in the OrderAndPaginate function. An authenticated user can inject SQL through the order and sort_by query parameters on the GET /api/dns_credentials endpoint, which can lead to information disclosure. Upgrade to 1.9.10-0.20231219195202-ec93ab05a3ec or later.

Written 6 Nov 2026.

## Not analysed yet

We haven’t published our analysis of this Advisory yet. Once a person has reviewed it, this page will say what’s vulnerable, what has to be true for your app to be affected, and how to check.

## Severity and exploitation

- 7.0 High, CVSS 3.1: `CVSS:3.1/AV:N/AC:H/PR:N/UI:N/S:U/C:H/I:L/A:L`, from CNA (GitHub_M)

- **CISA KEV:** Not listed.
- **EPSS:** 0.0058, the 48th percentile, on 21 Nov 2026: FIRST’s estimate of the chance of exploitation in the next 30 days.

## Timeline

- 31 Oct 2026, 15:06 UTC: First seen by agentprime
- 31 Oct 2026, 15:06 UTC: [Confirmed by OSV](https://osv.dev/vulnerability/GHSA-h374-mm57-879c)

## Sources

- [GitHub Advisory Database: GHSA-h374-mm57-879c](https://github.com/advisories/GHSA-h374-mm57-879c)
- [OSV: GHSA-h374-mm57-879c](https://osv.dev/vulnerability/GHSA-h374-mm57-879c)
- <https://github.com/0xJacky/nginx-ui/security/advisories/GHSA-h374-mm57-879c>
- <https://nvd.nist.gov/vuln/detail/CVE-2024-22196>
- <https://github.com/0xJacky/nginx-ui/commit/ec93ab05a3ecbb6bcf464d9dca48d74452df8a5b>
- <https://github.com/0xJacky/nginx-ui>
- <https://github.com/0xjacky/nginx-ui/blob/04bf8ec487f06ab17a9fb7f34a28766e5f53885e/model/model.go#L278-L287>
- <https://github.com/0xjacky/nginx-ui/blob/04bf8ec487f06ab17a9fb7f34a28766e5f53885e/model/model.go#L91>
- <https://github.com/0xjacky/nginx-ui/blob/04bf8ec487f06ab17a9fb7f34a28766e5f53885e/model/model.go#L99C4>

Facts on this page come from the GitHub Advisory Database (CC-BY 4.0), OSV and the other sources listed, as published. We don’t reproduce full advisory descriptions, which can contain exploit code.

## Check whether this affects you

A Match means an installed version is in the affected range above. Most don’t affect the app; agentprime hasn’t analysed this one yet.

- With the agentprime MCP server (<https://api.agentprime.io/mcp>), ask your agent to check the project: `check_lockfile` sends a lockfile, `check_packages` a list of installed packages, and both return the Matches and the upgrades that clear them. `get_advisory` returns this record. Setup: <https://agentprime.io/mcp.md>
- In a browser: <https://agentprime.io/check/> reads your lockfile in the browser, never uploading it.
- Whether it touches your code, with file and line: the Claude Code plugin, <https://agentprime.io/plugin.md>
- As JSON: <https://api.agentprime.io/v1/advisories/GHSA-h374-mm57-879c>, or `POST https://api.agentprime.io/v1/match` with your packages (<https://agentprime.io/api.md>)

---

The web page: <https://agentprime.io/advisories/GHSA-h374-mm57-879c/>. Everything for agents: <https://agentprime.io/llms.txt>.
