---
title: Security Bulletin NR18-02
source: https://docs.newrelic.com/docs/security/new-relic-security/security-bulletins/security-bulletin-nr18-02
---

## 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 [#affected]

The following New Relic agent versions are affected:

| **Name**     | **Affected version** | **Notes**          | **Remediated version**                                                                              |
| ------------ | -------------------- | ------------------ | --------------------------------------------------------------------------------------------------- |
| Python agent |                      | SQLite Obfuscation | [2.100.0.84](https://docs.newrelic.com/docs/release-notes/agent-release-notes/python-release-notes) |

## Vulnerability information [#vuln-info]

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 [#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](https://docs.newrelic.com/docs/agents/python-agent/configuration/python-agent-configuration#txn-tracer-settings) to `off`.

## Report security vulnerabilities to New Relic [#report]

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](https://docs.newrelic.com/docs/security/new-relic-security/data-privacy/reporting-security-vulnerabilities).

## For more help [#more_help]

Additional documentation resources include:.

-   [Upgrade the Python agent](https://docs.newrelic.com/docs/agents/python-agent/installation-configuration/upgrade-python-agent)
-   [NR Security](https://newrelic.com/security)