[MDEV-12079] SERVER_AUDIT plugin fails to load on Linux on MySQL 5.7 Created: 2017-02-17  Updated: 2017-03-03  Resolved: 2017-02-21

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit
Affects Version/s: 10.1.21
Fix Version/s: 5.5.55

Type: Bug Priority: Major
Reporter: Emrullah Kocmar Assignee: Alexey Botchkov
Resolution: Duplicate Votes: 0
Labels: plugins
Environment:

Red Hat Enterprise Linux Server release 7.2 (Maipo)
Server version: 5.7.17 MySQL Community Server (GPL)

Issue Links:
Relates
relates to MDEV-11919 SERVER_AUDIT plugin 1.4 fails to load... Closed

 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'.



 Comments   
Comment by Alexey Botchkov [ 2017-02-21 ]

This repeats the MDEV-11919.

Comment by Valerii Kravchuk [ 2017-03-03 ]

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?

Generated at Thu Feb 08 07:54:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.