Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Given the comment above, I assume it can be closed as fixed. Please comment to re-open if there is still something to do here.
Just grabbed the 1.1.5 version. Its loading and logging correctly to SYSLOG now with the settings defined in the my.cnf file.