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
-
-
- Closed
-
Activity
I still see this happening with plugin from MariaDB 10.1.22. It works in MariaDB:
...
|
Version: '10.1.22-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
|
170303 13:51:51 server_audit: MariaDB Audit Plugin version 1.4.0 STARTED.
|
170303 13:51:51 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
|
but failes with 5.7.17:
...
|
2017-03-03T11:41:50.469872Z 0 [Note] ./bin/mysqld: ready for connections.
|
Version: '5.7.17' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL)
|
2017-03-03T11:41:51.459967Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170303 13:41:51
|
2017-03-03T11:43:42.819039Z 3 [ERROR] Unknown variable type code 0x8200 in plugin 'SERVER_AUDIT'.
|
2017-03-03T11:43:42.819066Z 3 [ERROR] Bad options for plugin 'SERVER_AUDIT'.
|
Does it mean that we should wait for next merge from 5.5.55 into newer versions?
This repeats the
MDEV-11919.