[MDEV-12878] Audit Plugin Doesn't Output Table Events on MySQL 5.7 Created: 2017-05-23 Updated: 2017-05-24 Resolved: 2017-05-24 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Plugin - Audit |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Mike Jester | Assignee: | Alexey Botchkov |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Ubuntu 16.04LTS |
||
| Description |
|
I downloaded version 1.4.0 of the audit plugin from here and attempted to use it on MySQL v5.7.18. It will log query and connect events properly, but no table events. I swapped my test vm over to MariaDB 10.2 and it logs the table events properly. I tried the server_audit.so from the 10.2 installation and got the same result – no table events. MySQL 5.7 is listed as supported here, so I am assuming this should work. Any insight on this issue would be appreciated. |
| Comments |
| Comment by Sergei Golubchik [ 2017-05-24 ] |
|
This is expected behavior. Audit plugin (any MariaDB/MySQL audit plugin, not The Audit Plugin you're asking about) is only a listener — it receives audit events as generated by the server and records them into a file. MySQL 5.7 does not support table audit events. Even if the audit plugin can record them, it will not receive a single table event if the server does not generate them. |