Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.21
-
Red Hat Enterprise Linux Server release 7.2 (Maipo)
Server version: 5.7.17 MySQL Community Server (GPL)
Description
SERVER_AUDIT plugin is installed by this way;
# sudo install mariadb-10.1.21-linux-x86_64/lib/plugin/server_audit.so /usr/lib64/mysql/plugin/
|
Welcome to the MySQL monitor. Commands end with ; or \g.
|
Your MySQL connection id is 5
|
Server version: 5.7.17 MySQL Community Server (GPL)
|
|
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
|
|
Oracle is a registered trademark of Oracle Corporation and/or its
|
affiliates. Other names may be trademarks of their respective
|
owners.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
mysql> INSTALL PLUGIN server_audit SONAME 'server_audit.so';
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|
|
mysql> show plugins;
|
+----------------------------+----------+--------------------+----------------------+---------+
|
| Name | Status | Type | Library | License |
|
+----------------------------+----------+--------------------+----------------------+---------+
|
| SERVER_AUDIT | DISABLED | AUDIT | server_audit.so | GPL |
|
/etc/my.cnf configured as;
[mysqld]
|
|
server_audit_events=connect,query
|
server_audit_logging=ON
|
then restarted the mysqld with;
# systemctl stop mysqld
|
# systemctl start mysqld
|
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
|
error log;
2017-02-17T08:03:40.531804Z 0 [ERROR] Unknown variable type code 0x8200 in plugin 'SERVER_AUDIT'.
|
2017-02-17T08:03:40.531822Z 0 [ERROR] Bad options for plugin 'SERVER_AUDIT'.
|
Attachments
Issue Links
- relates to
-
MDEV-11919 SERVER_AUDIT plugin 1.4 fails to load on Windows
- Closed