HIGH7.7
GHSA-2p5p-m353-833w
Sort order SQL injection in Administrate
Quick fix
GHSA-2p5p-m353-833w — administrate: upgrade to the fixed version with the command below.
bundle update administrateDetails
In Administrate (rubygem) before version 0.13.0, when sorting by attributes on a dashboard, the direction parameter was not validated before being interpolated into the SQL query. This could present a SQL injection if the attacker were able to modify the `direction` parameter and bypass ActiveRecord SQL protections.
Whilst this does have a high-impact, to exploit this you need access to the Administrate dashboards, which we would expect to be behind authentication.
This is patched in wersion 0.13.0.
Are you affected?
Enter the version of the package you're using.
Affected packages
References
- https://github.com/thoughtbot/administrate/security/advisories/GHSA-2p5p-m353-833w[WEB]
- https://nvd.nist.gov/vuln/detail/CVE-2020-5257[ADVISORY]
- https://github.com/thoughtbot/administrate/commit/3ab838b83c5f565fba50e0c6f66fe4517f98eed3[WEB]
- https://github.com/advisories/GHSA-2p5p-m353-833w[ADVISORY]
- https://github.com/rubysec/ruby-advisory-db/blob/master/gems/administrate/CVE-2020-5257.yml[WEB]