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

MariaDB Audit Plugin for MySQL 5.5.16 and Percona XtraDB Cluster 5.5.34-23.7.6.565

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      MariaDB Audit Plugin version 1.1.3

      /etc/my.cnf

      # Settings for Server Audit Plugin
      plugin-load=server_audit=server_audit.so
      server_audit_logging=ON
      server_audit_output_type=SYSLOG
      server_audit_events=CONNECT
      server_audit_syslog_ident=mysql-server_auditing

      Plugin starts, but is not logging anywhere:

      mysql> show global variables like 'server_aud%';
      +-------------------------------+-----------------------+
      | Variable_name                 | Value                 |
      +-------------------------------+-----------------------+
      | server_audit_events           | CONNECT               |
      | server_audit_excl_users       |                       |
      | server_audit_file_path        | server_audit.log      |
      | server_audit_file_rotate_now  | OFF                   |
      | server_audit_file_rotate_size | 1000000               |
      | server_audit_file_rotations   | 9                     |
      | server_audit_incl_users       |                       |
      | server_audit_logging          | ON                    |
      | server_audit_mode             | 1                     |
      | server_audit_output_type      | ?                     |
      | server_audit_syslog_facility  | LOG_USER              |
      | server_audit_syslog_ident     | mysql-server_auditing |
      | server_audit_syslog_info      |                       |
      | server_audit_syslog_priority  | LOG_INFO              |
      +-------------------------------+-----------------------+
      14 rows in set (0.00 sec)

      I can load the plugin from sql and logging works great.

      set global server_audit_output_type=SYSLOG;

      Need to be able to set logging output type from the my.cnf file.

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            xcntry Clete Penrod
            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.