Summary
A security update for the Python agent to to improve SQL obfuscation with SQLite.
Release date: Jan 9, 2018
Vulnerability identifier: NR18-02
Priority: Medium
Affected software
The following New Relic agent versions are affected:
Name | Affected version | Notes | Remediated version |
---|---|---|---|
Python Agent | SQLite Obfuscation | 2.100.0.84 |
Vulnerability information
The New Relic Python agent should obfuscate SQL query parameters. This fixes an issue in SQLite transaction tracing. If the query parameters were passed with double quoted strings, the agent was not properly obfuscating these parameters.
Mitigating factors
-
Generally, all SQL query parameter strings should be string literals and passed in single quotes. However, the Python SQLite API allows developers to use double quoted strings in some cases.
Workarounds
If you are unable to upgrade the agent, you may be able to take the following actions to ensure you do not send any SQLite query parameters.
- Use single quote string literals with SQLite.
- Disable SQL collection by configuring transaction_tracer.record_sql to
off
.
Report vulnerabilities to New Relic
New Relic is committed to the security of our customers and their data. We believe that engaging with the security community is an important means of achieving our security goals, and we appreciate responsible disclosure of any vulnerabilities by security researchers.
If you believe you have found a security vulnerability in one of our products or websites, we welcome and greatly appreciate you reporting it to New Relic through one of these methods:
For more help
Additional documentation resources include:.