[debian-mysql] Bug#914188: Bug#914188: mariadb-server: Upgrade faild due to 'unknown variable': 'server_audit_file_path=/path/to/audit.log'

[Marc Lagies]

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