Inserting special characters in a table causes audit log to generate invalid json entries

Bug #1716844 reported by Jaime Sicam on 2017-09-13
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.6
Fix Released
High
Zsolt Parragi
5.7
Fix Released
High
Zsolt Parragi

Bug Description

The test case is customer's private data so without permission, I cannot attach it to this bug report.

Basically, install audit_log plugin:
INSTALL PLUGIN audit_log SONAME 'audit_log.so';

Then, import the data in the ticket to Percona Server:
mysql test < test.sql

Then, review the audit log and it contains the insert entry where the JSON format is invalid.

Jaime Sicam (jssicam) on 2017-09-13
description: updated
tags: added: audit
Jericho Rivera (jericho-rivera) wrote :

Please find attached file to use to reproduce the case.

audit_log_buffer_size 1048576
audit_log_exclude_accounts
audit_log_exclude_commands
audit_log_exclude_databases
audit_log_file /logs/mysql/audit.log
audit_log_flush OFF
audit_log_format JSON
audit_log_handler FILE
audit_log_include_accounts
audit_log_include_commands
audit_log_include_databases
audit_log_policy ALL
audit_log_rotate_on_size 1073741824
audit_log_rotations 5
audit_log_strategy ASYNCHRONOUS
audit_log_syslog_facility LOG_USER
audit_log_syslog_ident percona-audit
audit_log_syslog_priority LOG_INFO

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1115

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Bug attachments