Hello Faustin
On 20.11.18 19:35, Faustin Lammler wrote:
May I ask you which version of mariadb you where upgrading from?
10.1.26-0+deb9u1 (2018-07-31)
I enabled the plugin about three weeks ago.
And also please respond to the following:
I commented out the audit plugin relateted lines in the mariadb config
file.
Can you give me the path of this config file?
/etc/mysql/my.cnf
Did you uncommented the precedent line after upgrade?
Yes.
Please provide output of following SQL command:
SHOW GLOBAL VARIABLES LIKE '%server_audit%';
+-------------------------------+-----------------------------------------+
| Variable_name | Value |
+-------------------------------+-----------------------------------------+
| server_audit_events | CONNECT |
| server_audit_excl_users | |
| server_audit_file_path | /var/log/mysql/mariadb_server_audit.log |
| server_audit_file_rotate_now | OFF |
| server_audit_file_rotate_size | 1073741824 |
| server_audit_file_rotations | 9 |
| server_audit_incl_users | |
| server_audit_logging | ON |
| server_audit_mode | 0 |
| server_audit_output_type | file |
| server_audit_query_log_limit | 1024 |
| server_audit_syslog_facility | LOG_USER |
| server_audit_syslog_ident | mysql-server_auditing |
| server_audit_syslog_info | |
| server_audit_syslog_priority | LOG_INFO |
+-------------------------------+-----------------------------------------+
Kind regards
Marc
