\u73af\u5883:CentOS Linux release 7.5.1804 (Core)<\/p>\n
\u672c\u5b9e\u9a8c\u7684\u5ba1\u8ba1\u63d2\u4ef6\u5747\u662f\u5b89\u88c5\u5728 mysql-community-server-5.7.24 \u7684mysql\u4e0a<\/p>\n
\u793e\u533a\u7248\u63d2\u4ef6\u4e0b\u8f7d\u5730\u5740:https:\/\/bintray.com\/mcafee\/mysql-audit-plugin\/release\/1.1.6-784?pkgPath=%2Fmcafee%2Fmysql-audit-plugin%2Frelease#files<\/p>\n
\u4e0b\u8f7d:audit-plugin-mysql-5.7-1.1.6-784-linux-x86_64.zip<\/p>\n
\u89e3\u538b\u5f97\u5230\u4e24\u4e2a\u6587\u4ef6:<\/p>\n
libaudit_plugin.so<\/p>\n
offset-extract.sh<\/p>\n
\u5c06libaudit_plugin.so\u62f7\u8d1d\u5230mysql\/lib\/plugin\/\u4e0b,chmod 755\u00a0libaudit_plugin.so<\/p>\n
\u4f7f\u7528offset-extract.sh\u83b7\u53d6\u672c\u673a\u4e0amysql\u7248\u672c\u5bf9\u5e94\u7684offsets,.\/offset-extract.sh mysqld<\/p>\n
\u5982\u679c\u4e0d\u540e\u9a71offsets\u503c\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u62a5\u9519<\/p>\n
mysql> install plugin audit soname ‘libaudit_plugin.so’;
\nERROR 1123 (HY000): Can’t initialize function ‘audit’; Plugin initialization function failed.<\/p>\n
\u5728my.cnf\u91cc\u589e\u52a0\u4ee5\u4e0b\u53c2\u6570<\/p>\n
audit_json_file = on
\nplugin-load = AUDIT=libaudit_plugin.so
\naudit_record_cmds = ‘insert,delete,update,create,drop,alter,grant,truncate’
\naudit_json_log_file = \/data\/mysql\/dblogs\/mysql-audit.json
\naudit_offsets = 7824, 7872, 3632, 4792, 456, 360, 0, 32, 64, 160, 536, 7988, 4360, 3648, 3656, 3660, 6072, 2072, 8, 7056, 7096, 7080, 13464, 148, 672<\/p>\n","protected":false},"excerpt":{"rendered":"
\u73af\u5883:CentOS Linux release 7.5.1804 (Core) … \u7ee7\u7eed\u9605\u8bfb