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 |
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 security vulnerabilities to New Relic
New Relic is committed to the security of our customers and their data. 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's coordinated disclosure program. For more information, see Reporting security vulnerabilities.
For more help
Additional documentation resources include:.