Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12079

SERVER_AUDIT plugin fails to load on Linux on MySQL 5.7

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.1.21
    • Fix Version/s: 5.5.55
    • Component/s: Plugin - Audit
    • Labels:
    • Environment:
      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

            Activity

              People

              • Assignee:
                holyfoot Alexey Botchkov
                Reporter:
                ekocmar Emrullah Kocmar
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: