# CVE-2021-43851: SQL injection vulnerability in anuko timetracker

> Attackers can execute arbitrary SQL commands via unvalidated group and status parameters in Anuko Time Tracker, potentially accessing or modifying data.

- **Severity:** High 8.1 (`CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:N`)
- **Exploited in the wild:** Not known
- **Login needed:** Any signed-in user
- **Attackable:** Over the internet
- **Victim action needed:** Not needed
- **Fix available:** No
- **Published:** 21 Dec 2021
- **Updated:** 4 Aug 2024

## What is CVE-2021-43851?

CVE-2021-43851 is a high-severity SQL injection vulnerability in anuko timetracker, published on 21 Dec 2021. Any signed-in user can exploit it over the network, with no action from the victim.

### Official description

Anuko Time Tracker is an open source, web-based time tracking application written in PHP. SQL injection vulnerability exist in multiple files in Time Tracker version 1.19.33.5606 and prior due to not properly checking of the "group" and "status" parameters in POST requests. Group parameter is posted along when navigating between organizational subgroups (groups.php file). Status parameter is used in multiple files to change a status of an entity such as making a project, task, or user inactive. This issue has been patched in version 1.19.33.5607. An upgrade is highly recommended. If an upgrade is not practical, introduce ttValidStatus function as in the latest version and start using it user input check blocks wherever status field is used. For groups.php fix, introduce ttValidInteger function as in the latest version and use it in the access check block in the file.

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

## Which versions are affected by CVE-2021-43851?

It affects 1 product.


Products: Anuko Time Tracker.

## How do I fix CVE-2021-43851?

No fix has been published for CVE-2021-43851 yet. Limit exposure of the affected software until one is available.

## Is CVE-2021-43851 being exploited?

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

## Other vulnerabilities in anuko timetracker

- [CVE-2020-27422](https://insights.sbomify.com/CVE-2020-27422/): Business logic in n/a (critical 9.8)
- [CVE-2023-32306](https://insights.sbomify.com/CVE-2023-32306/): Time Tracker has Blind SQL Injection Vulnerability in Reports (high 8.8)
- [CVE-2020-15255](https://insights.sbomify.com/CVE-2020-15255/): CSV injection in Anuko Time Tracker (high 8.7)
- [CVE-2023-32308](https://insights.sbomify.com/CVE-2023-32308/): SQL Injection Vulnerability in anuko timetracker (high 8.2)
- [CVE-2021-41139](https://insights.sbomify.com/CVE-2021-41139/): Reflected XSS vulnerability in time.php (high 8.1)

## Fix prompt for AI coding agents

```text
Check this codebase for CVE-2021-43851 and fix it if it is affected.

What it is: CVE-2021-43851 is a high-severity SQL injection vulnerability in anuko timetracker, published on 21 Dec 2021. Any signed-in user can exploit it over the network, with no action from the victim.
Exploitation: There is no known exploitation of CVE-2021-43851 in the wild and no public exploit code.

Affected product: anuko timetracker. No package-level version data is available, so check the vendor advisory linked from the reference page.

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-2021-43851/ (Markdown: https://insights.sbomify.com/CVE-2021-43851/index.md)
```

## Sources

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

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