SB2020012804 - SQL injection in Geocoder geocoding solution for Ruby

Description

This security bulletin contains information about 1 security vulnerability.

1) SQL injection (CVE-ID: CVE-2020-7981)

The vulnerability allows a remote attacker to execute arbitrary SQL queries in database.

The vulnerability exists due to insufficient sanitization of user-supplied data in sql.rb when "within_bounding_box" is used in conjunction with "untrusted sw_lat", "sw_lng", "ne_lat", or "ne_lng" data. A remote attacker can send a specially crafted request to the affected application and execute arbitrary SQL commands within the application database.

Successful exploitation of this vulnerability may allow a remote attacker to read, delete, modify data in database and gain complete control over the affected application.

Remediation

Install update from vendor's website.

References

• https://github.com/alexreisner/geocoder/commit/dcdc3d8675411edce3965941a2ca7c441ca48613
• https://github.com/alexreisner/geocoder/compare/v1.6.0...v1.6.1