{"id":"GHSA-864j-6qpp-cmrr","summary":"SQL Injection in Geocoder","details":"sql.rb in Geocoder before 1.6.1 allows Boolean-based SQL injection when `within_bounding_box` is used in conjunction with untrusted `sw_lat`, `sw_lng`, `ne_lat`, or `ne_lng` data.","aliases":["CVE-2020-7981"],"modified":"2024-02-16T08:10:34.444161Z","published":"2020-06-10T20:03:02Z","database_specific":{"cwe_ids":["CWE-89"],"severity":"CRITICAL","github_reviewed":true,"github_reviewed_at":"2020-06-10T18:28:37Z","nvd_published_at":null},"references":[{"type":"ADVISORY","url":"https://nvd.nist.gov/vuln/detail/CVE-2020-7981"},{"type":"WEB","url":"https://github.com/alexreisner/geocoder/commit/dcdc3d8675411edce3965941a2ca7c441ca48613"},{"type":"WEB","url":"https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-7981"},{"type":"PACKAGE","url":"https://github.com/alexreisner/geocoder"},{"type":"WEB","url":"https://github.com/alexreisner/geocoder/blob/master/CHANGELOG.md#161-2020-jan-23"},{"type":"WEB","url":"https://github.com/alexreisner/geocoder/compare/v1.6.0...v1.6.1"},{"type":"WEB","url":"https://github.com/rubysec/ruby-advisory-db/blob/master/gems/geocoder/CVE-2020-7981.yml"}],"affected":[{"package":{"name":"geocoder","ecosystem":"RubyGems","purl":"pkg:gem/geocoder"},"ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"1.6.1"}]}],"versions":["0.1.0","0.1.1","0.9.10","0.9.11","0.9.12","0.9.13","0.9.8","0.9.9","1.0.0","1.0.1","1.0.2","1.0.3","1.0.4","1.0.5","1.1.0","1.1.1","1.1.2","1.1.3","1.1.4","1.1.5","1.1.6","1.1.7","1.1.8","1.1.9","1.2.0","1.2.1","1.2.10","1.2.11","1.2.12","1.2.13","1.2.14","1.2.2","1.2.3","1.2.4","1.2.5","1.2.6","1.2.7","1.2.8","1.2.9","1.3.0","1.3.1","1.3.2","1.3.3","1.3.4","1.3.5","1.3.6","1.3.7","1.4.0","1.4.1","1.4.2","1.4.3","1.4.4","1.4.5","1.4.6","1.4.7","1.4.8","1.4.9","1.5.0","1.5.1","1.5.2","1.6.0"],"database_specific":{"source":"https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2020/06/GHSA-864j-6qpp-cmrr/GHSA-864j-6qpp-cmrr.json"}}],"schema_version":"1.9.0","severity":[{"type":"CVSS_V3","score":"CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}]}