SQL Injection in rosariosis
The advisory, in context
An unauthenticated SQL Injection vulnerability in Rosario Student Information System (aka rosariosis) before 8.1.1 allows remote attackers to execute PostgreSQL statements (e.g., SELECT, INSERT, UPDATE, and DELETE) through /Side.php via the syear parameter.
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.
Earlier releases before 8.1.1
Fixed in 8.1.1
133 explicitly affected versions
v5.0, v5.0-beta3, v5.0-beta4, v5.0.1, v5.0.2, v5.0.3, v5.0.4, v5.0.5, v5.1, v5.1-beta, v5.1.1, v5.2, v5.2-beta, v5.3, v5.3-beta, v5.3.1, v5.3.2, v5.3.3, v5.3.4, v5.4, v5.4-beta, v5.4.1, v5.4.2, v5.4.3, v5.4.4, v5.4.5, v5.4.6, v5.4.7, v5.5, v5.5-beta, v5.5-beta2, v5.5-beta3, v5.5.1, v5.5.2, v5.5.3, v5.5.4, v5.6, v5.6-beta, v5.6.1, v5.6.2, v5.6.3, v5.6.4, v5.6.5, v5.7, v5.7.1, v5.7.2, v5.7.3, v5.7.4, v5.7.5, v5.7.6, v5.7.7, v5.8, v5.8-beta, v5.8-beta2, v5.8-beta3, v5.8-beta4, v5.8-beta5, v5.8.1, v5.9, v5.9-beta2, v5.9-beta3, v5.9.1, v5.9.2, v5.9.3, v5.9.4, v5.9.5, v5.9.6, v6.0, v6.0-beta, v6.1, v6.2, v6.2.1, v6.2.2, v6.2.3, v6.3, v6.4, v6.4.1, v6.4.2, v6.5, v6.5.1, v6.5.2, v6.6, v6.6.1, v6.7, v6.7.1, v6.7.2, v6.8, v6.8-beta, v6.8.1, v6.9, v6.9-beta, v6.9.1, v6.9.2, v6.9.3, v6.9.4, v7.0, v7.0-beta, v7.0.1, v7.0.2, v7.0.3, v7.0.4, v7.1, v7.1.1, v7.1.2, v7.1.3, v7.1.4, v7.2, v7.2.1, v7.2.2, v7.2.3, v7.2.4, v7.3, v7.3.1, v7.4, v7.5, v7.6, v7.6.1, v7.7, v7.8, v7.8.1, v7.8.2, v7.8.3, v7.8.4, v7.9, v7.9.1, v7.9.2, v7.9.3, v8.0, v8.0.1, v8.0.2, v8.0.3, v8.0.4, v8.1
View affected-version evidence
{
"ranges": [
{
"events": [
{
"introduced": "0"
},
{
"fixed": "8.1.1"
}
],
"type": "ECOSYSTEM"
}
],
"versions": [
"v5.0",
"v5.0-beta3",
"v5.0-beta4",
"v5.0.1",
"v5.0.2",
"v5.0.3",
"v5.0.4",
"v5.0.5",
"v5.1",
"v5.1-beta",
"v5.1.1",
"v5.2",
"v5.2-beta",
"v5.3",
"v5.3-beta",
"v5.3.1",
"v5.3.2",
"v5.3.3",
"v5.3.4",
"v5.4",
"v5.4-beta",
"v5.4.1",
"v5.4.2",
"v5.4.3",
"v5.4.4",
"v5.4.5",
"v5.4.6",
"v5.4.7",
"v5.5",
"v5.5-beta",
"v5.5-beta2",
"v5.5-beta3",
"v5.5.1",
"v5.5.2",
"v5.5.3",
"v5.5.4",
"v5.6",
"v5.6-beta",
"v5.6.1",
"v5.6.2",
"v5.6.3",
"v5.6.4",
"v5.6.5",
"v5.7",
"v5.7.1",
"v5.7.2",
"v5.7.3",
"v5.7.4",
"v5.7.5",
"v5.7.6",
"v5.7.7",
"v5.8",
"v5.8-beta",
"v5.8-beta2",
"v5.8-beta3",
"v5.8-beta4",
"v5.8-beta5",
"v5.8.1",
"v5.9",
"v5.9-beta2",
"v5.9-beta3",
"v5.9.1",
"v5.9.2",
"v5.9.3",
"v5.9.4",
"v5.9.5",
"v5.9.6",
"v6.0",
"v6.0-beta",
"v6.1",
"v6.2",
"v6.2.1",
"v6.2.2",
"v6.2.3",
"v6.3",
"v6.4",
"v6.4.1",
"v6.4.2",
"v6.5",
"v6.5.1",
"v6.5.2",
"v6.6",
"v6.6.1",
"v6.7",
"v6.7.1",
"v6.7.2",
"v6.8",
"v6.8-beta",
"v6.8.1",
"v6.9",
"v6.9-beta",
"v6.9.1",
"v6.9.2",
"v6.9.3",
"v6.9.4",
"v7.0",
"v7.0-beta",
"v7.0.1",
"v7.0.2",
"v7.0.3",
"v7.0.4",
"v7.1",
"v7.1.1",
"v7.1.2",
"v7.1.3",
"v7.1.4",
"v7.2",
"v7.2.1",
"v7.2.2",
"v7.2.3",
"v7.2.4",
"v7.3",
"v7.3.1",
"v7.4",
"v7.5",
"v7.6",
"v7.6.1",
"v7.7",
"v7.8",
"v7.8.1",
"v7.8.2",
"v7.8.3",
"v7.8.4",
"v7.9",
"v7.9.1",
"v7.9.2",
"v7.9.3",
"v8.0",
"v8.0.1",
"v8.0.2",
"v8.0.3",
"v8.0.4",
"v8.1"
]
}References
- https://nvd.nist.gov/vuln/detail/CVE-2021-44427
- https://github.com/francoisjacquet/rosariosis/commit/e001430aa9fb53d2502fb6f036f6c51c578d2016
- https://github.com/francoisjacquet/rosariosis
- https://gitlab.com/francoisjacquet/rosariosis/-/commit/e001430aa9fb53d2502fb6f036f6c51c578d2016
- https://gitlab.com/francoisjacquet/rosariosis/-/issues/328
- https://gitlab.com/francoisjacquet/rosariosis/blob/mobile/CHANGES.md#changes-in-811