trellix-enterprise / mysql-audit

AUDIT Plugin for MySQL. See wiki and readme for description. If you find the plugin useful, please star us on GitHub. We love stars and it's a great way to show your feedback.
Other
239 stars 57 forks source link

can not use in mysql 5.7.26 #212

Closed wwwwwwchun closed 5 years ago

wwwwwwchun commented 5 years ago

when i install libaudit_plugin.so the mysql report err: mysql> INSTALL PLUGIN AUDIT SONAME 'libaudit_plugin.so'; ERROR 1123 (HY000): Can't initialize function 'AUDIT'; Plugin initialization function failed.

while i find the mysql_error.log display log: 2019-07-19T09:26:25.617039Z 2 [Warning] option 'audit-json-file-bufsize': signed value 0 adjusted to 1 2019-07-19T09:26:25.617064Z 2 [Warning] option 'plugin-audit-json-file-bufsize': signed value 0 adjusted to 1 2019-07-19T09:26:25.617270Z 2 [Note] McAfee Audit Plugin: starting up. Version: 1.0.0 , Revision: 99999 (64bit). MySQL AUDIT plugin interface version: 1025 (0x401). MySQL Server version: 5.7.26-log. 2019-07-19T09:26:25.617281Z 2 [Note] McAfee Audit Plugin: setup_offsets audit_offsets: (null) validate_checksum: 1 offsets_by_version: 1 2019-07-19T09:26:26.451448Z 2 [Note] McAfee Audit Plugin: mysqld: /usr/local/mysql/bin/mysqld (6ff872b7ab068d5af15630dd9bc93032) 2019-07-19T09:26:26.451483Z 2 [Note] McAfee Audit Plugin: Couldn't find proper THD offsets for: 5.7.26-log 2019-07-19T09:26:26.451488Z 2 [ERROR] Plugin 'AUDIT' init function returned error. 2019-07-19T09:26:26.451492Z 2 [ERROR] Plugin 'AUDIT' registration as a AUDIT failed. 2019-07-19T09:26:26.451510Z 2 [Note] Shutting down plugin 'AUDIT' 2019-07-19T09:26:26.451523Z 2 [Note] McAfee Audit Plugin: deinit

how can i do ? thanks

blackfirekit commented 5 years ago

Was there a solution to this? I have the same problem. I have tried to manually set the offsets as directed in https://github.com/mcafee/mysql-audit/issues/166 but it isn't working with that either