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

SERVER_AUDIT plugin fails to load on Linux on MySQL 5.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.21
    • 5.5.55
    • Plugin - Audit
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.