# CVE-2023-37924: Apache Submarine: SQL injection from unauthorized login


- **Severity:** Critical 9.8 (`CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H`)
- **Exploited in the wild:** Not known
- **Fix available:** Yes
- **Published:** 22 Nov 2023
- **Updated:** 2 Aug 2024
- **Also known as:** GHSA-v5gj-fx3g-hcpw, PYSEC-2023-244

## What is CVE-2023-37924?

CVE-2023-37924 is a critical vulnerability in Apache Submarine, published on 22 Nov 2023. 

### Official description

Apache Software Foundation Apache Submarine has an SQL injection vulnerability when a user logs in. This issue can result in unauthorized login.
Now we have fixed this issue and now user must have the correct login to access workbench.
This issue affects Apache Submarine: from 0.7.0 before 0.8.0. We recommend that all submarine users with 0.7.0 upgrade to 0.8.0, which not only fixes the issue, supports the oidc authentication mode, but also removes the case of unauthenticated logins.
If using the version lower than 0.8.0 and not want to upgrade, you can try cherry-pick PR  https://github.com/apache/submarine/pull/1037 https://github.com/apache/submarine/pull/1054  and rebuild the submarine-server image to fix this.

Weakness: CWE-89 (Improper Neutralization of Special Elements used in an SQL Command)

## Which versions are affected by CVE-2023-37924?

3 open source packages ship an affected version, including apache-submarine. It affects 1 product.


| Package | Ecosystem | Affected | Fixed in |
| --- | --- | --- | --- |
| `apache-submarine` | PyPI | From 0.7.0 | 0.8.0 |
| `apache-submarine` | PyPI | From 0.7.0 | 0.8.0 |
| `apache-submarine` | PyPI | From 0.7.0 | 0.8.0 |

Products: Apache Submarine.

## How do I fix CVE-2023-37924?

Upgrade apache-submarine to 0.8.0 or later.

## Is CVE-2023-37924 being exploited?

There is no known exploitation of CVE-2023-37924 in the wild and no public exploit code.

## Other vulnerabilities in Apache Submarine

- [CVE-2024-36264](https://insights.sbomify.com/CVE-2024-36264/): Apache Submarine Commons Utils: default secret (critical 9.8)
- [CVE-2024-36265](https://insights.sbomify.com/CVE-2024-36265/): Apache Submarine Server Core: authorization bypass (critical 9.8)
- [CVE-2023-46302](https://insights.sbomify.com/CVE-2023-46302/): Apache Submarine: Fix CVE-2022-1471 SnakeYaml unsafe deserialization (critical 9.8)
- [CVE-2024-36263](https://insights.sbomify.com/CVE-2024-36263/): Apache Submarine Server Core: SQL injection (high 8.1)

## Fix prompt for AI coding agents

```text
Check this codebase for CVE-2023-37924 and fix it if it is affected.

What it is: CVE-2023-37924 is a critical vulnerability in Apache Submarine, published on 22 Nov 2023. 
Exploitation: There is no known exploitation of CVE-2023-37924 in the wild and no public exploit code.

Affected packages and fixed versions:
- apache-submarine (PyPI): affected from 0.7.0; fixed in 0.8.0
- apache-submarine (PyPI): affected from 0.7.0; fixed in 0.8.0
- apache-submarine (PyPI): affected from 0.7.0; fixed in 0.8.0

Task:
1. Search the dependency manifests and lockfiles (for example package.json, package-lock.json, requirements.txt, poetry.lock, uv.lock, pom.xml, build.gradle, go.mod, Cargo.lock, Gemfile.lock) and any Dockerfiles for the affected packages, including transitive dependencies.
2. If an affected version is in use, upgrade it to the fixed version for its release line with the project's package manager, so the lockfile is regenerated. Prefer the smallest upgrade that fixes it.
3. If there is no fix, or the upgrade would break the build, do not guess: explain the risk and the safest workaround instead.
4. Run the tests and summarise what changed and why.
5. If nothing in the project is affected, say so and change nothing.

Reference: https://insights.sbomify.com/CVE-2023-37924/ (Markdown: https://insights.sbomify.com/CVE-2023-37924/index.md)
```

## Sources

- CVE record: https://www.cve.org/CVERecord?id=CVE-2023-37924
- NVD: https://nvd.nist.gov/vuln/detail/CVE-2023-37924
- OSV: https://osv.dev/vulnerability/CVE-2023-37924

---
From sbomify Insights: https://insights.sbomify.com/CVE-2023-37924/
Summaries are generated and may contain mistakes; the official description above is the record.