audit_log_include_accounts does not work using IP addresses

Asked by alessandra bilardi

The problem of https://bugs.mysql.com/bug.php?id=77553 is still present.
If I try to set audit_log_include_accounts or audit_log_exclude_accounts variables, they work with user@localhost but they don't work with user@127.0.0.1.

When
set global audit_log_include_accounts = 'user@localhost';

There was the audit for each action depending audit_log_policy
"Connect","6078172_2017-02-09T17:06:19","2017-02-10T08:17:20 UTC","1699",0,"user","user","","''@''","localhost","",""
"Quit","6078173_2017-02-09T17:06:19","2017-02-10T08:17:22 UTC","1699",0,"user","user","","''@''","localhost","",""

When I've tried one of the set below
set global audit_log_include_accounts = 'user@127.0.0.1';
set global audit_log_include_accounts = "'user'@'127.0.0.1'";
set global audit_log_include_accounts = '\'user\'@\'127.0.0.1\'';

There was nothing the audit.

Vice versa, when
set global audit_log_exclude_accounts = 'user@localhost';

There was nothing the audit.

When I've tried one of the set below
set global audit_log_exclude_accounts = 'user@127.0.0.1';
set global audit_log_exclude_accounts = "'user'@'127.0.0.1'";
set global audit_log_exclude_accounts = '\'user\'@\'127.0.0.1\'';

There was the audit for each action depending audit_log_policy
"Connect","6078184_2017-02-09T17:06:19","2017-02-10T08:59:09 UTC","1803",0,"user","user","","","","127.0.0.1",""
"Query","6078185_2017-02-09T17:06:19","2017-02-10T08:59:09 UTC","select","1803",0,"select @@version_comment limit 1","user[user] @ [127.0.0.1]","","","127.0.0.1",""
"Quit","6078186_2017-02-09T17:06:19","2017-02-10T08:59:14 UTC","1803",0,"user","user","","","","127.0.0.1",""

Version
- Percona Server 5.6.33-79.0 2084bdb
- Centos 7.3.1611

Question information

Language:
English Edit question
Status:
Expired
For:
Percona Server moved to https://jira.percona.com/projects/PS Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.