[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 22.11.18 20:06, Faustin Lammler wrote:
[..]
> Can you give me the content of you /etc/mysql/my.cnf file?

#### /etc/mysql/my.cnf

[mysqld]

### Plugins
## Audit Plugin
plugin_load = server_audit          = server_audit.so
server_audit_file_path              = /var/log/mysql/mariadb_server_audit.log
server_audit_file_rotate_size       = 1024M
server_audit_events                 = connect
server_audit_logging                = 1

## Query Response Time Plugin
plugin-load = query_response_time
query_response_time_range_base      = 10
query_response_time_stats           = 1


### General
bind-address            = *
port                    = 3306
max_connections	        = 5000
max_connect_errors      = 99999999

user                    = mysql
basedir                 = /usr
datadir                 = /var/lib/mysql
tmpdir                  = /tmp
lc-messages-dir         = /usr/share/mysql
pid-file                = /var/run/mysqld/mysqld.pid
socket                  = /var/run/mysqld/mysqld.sock


### Char Set / Collation
character-set-server    = utf8mb4
collation-server        = utf8mb4_general_ci


### Logging
log_output              = FILE,TABLE
log_warnings            = 2
slow_query_log          = 1
slow_query_log_file     = /var/log/mysql/mariadb-slow.log


### DB Tuning
innodb_buffer_pool_size     = 4G
innodb_checksum_algorithm   = crc32
innodb_file_format          = Barracuda
innodb_log_file_size        = 256M
key_buffer_size             = 16M
max_allowed_packet          = 64M
max_heap_table_size         = 32M
myisam_recover_options      = BACKUP
open_files_limit            = 32768
query_cache_size            = 192M
query_cache_limit           = 8M
table_open_cache            = 8192
table_definition_cache      = 4496
thread_cache_size           = 256
tmp_table_size              = 32M


### SSL Options
ssl-cert	= /etc/mysql/ssl_certificate.crt
ssl-key		= /etc/mysql/ssl_key.key
ssl-cipher	= 
DHE-RSA-AES256-SHA:AES256-SHA:DHE-RSA-AES128-SHA:AES128-SHA:DHE-RSA-AES256-RMD:DHE-RSA-AES128-RMD:AES256-RMD:AES128-RMD


### Replication Options
## Master Settings
binlog_format                   = row
expire_logs_days                = 3
log_bin                         = /var/log/mysql/mysql-bin.log
log_bin_trust_function_creators = 1
max_binlog_size                 = 1024M
server-id                       = 11

## Replicant Settings:
gtid_strict_mode                = 1
log_slave_updates               = 1
relay-log                       = /var/log/mysql/mysqld-relay-bin


[mysqldump]
max_allowed_packet  = 16M
quick
quote-names


!includedir /etc/mysql/conf.d/




#### Configuration options in /etc/mysql/conf.d/*:

[mysqld_safe]
skip_log_error
syslog



> Is it possible that on your system a previous version of mariadb/mysql
> was installed (before 10.1.26)?

Yes, the initially installed version was 10.0.20 which then was continuously 
kept up to date.

Kind regards